View Issue Details

IDProjectCategoryView StatusLast Update
0001660Módulo 2Labels[All Projects] Bugpublic2024-07-18 09:40
ReporterjmenentAssigned Tohpuig 
PrioritynormalSeveritycrashReproducibilityalways
Status resolvedResolutionfixed 
Product Version16.0.1 
Target Version17.0.1Fixed in Version17.0.1 
Summary0001660: Etiquetas de contacto
DescriptionAl intentar realizar etiquetas desde el listado de contactos, explota. Esto es porque intenta leer el campo skype, que ya hace tiempo que no existe en dolibarr:

 SELECT s.rowid as socid, s.nom as name, p.rowid as cidp, p.lastname as lastname, p.statut, p.firstname, p.zip, p.town, p.poste, p.email, p.skype, p.phone as phone_pro, p.phone_mobile, p.phone_perso, p.fax, p.fk_pays, p.priv, p.datec as date_creation, p.tms as date_update, co.code as country_code FROM llx_socpeople as p LEFT JOIN llx_c_country as co ON co.rowid = p.fk_pays LEFT JOIN llx_societe as s ON s.rowid = p.fk_soc WHERE p.entity IN (1) AND (p.priv='0' OR (p.priv='1' AND p.fk_user_creat=1)) AND p.statut = 1 ORDER BY p.lastname ASC LIMIT 26
Code retour dernier accès en base en erreur: DB_ERROR_NOSUCHFIELD
Information sur le dernier accès en base en erreur: Unknown column 'p.skype' in 'field list'

Habrá que ver en que versión de dolibarr se produjo el cambio y aplicar el correspondiente version_compare.
Additional InformationLa versión a partir de la cual las redes sociales pasan a ser una sola columna con un array es la 15
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2023-01-09 15:35 jmenent New Issue
2023-01-09 15:35 jmenent Status new => assigned
2023-01-09 15:35 jmenent Assigned To => hpuig
2023-05-08 11:37 hpuig Status assigned => resolved
2023-05-08 11:37 hpuig Fixed in Version => next
2023-05-08 11:37 hpuig Additional Information Updated View Revisions
2023-08-21 11:33 hpuig Fixed in Version next => 17.0.1
2023-08-21 11:33 hpuig Target Version next => 17.0.1
2024-07-18 09:40 fmarcet Resolution open => fixed