L’erreur : Unknown column ‹ fd.description › in ‹ where clause ›
La requête complète : SELECT f.ref, f.rowid, f.fk_statut, f.description, f.datec as date_creation, f.tms as date_update, f.note_private, s.nom as name, s.rowid as socid, s.client, c.rowid as contrat_id, c.ref as contrat_ref, c.ref_customer as contrat_ref_supplier, c.ref_supplier as contrat_ref_supplier, ef.nom as options_nom, ef.email as options_email, ef.mobile as options_mobile, ef.codepostal as options_codepostal, ef.client as options_client, ef.travail as options_travail, ef.coupdepouce_dossier as options_coupdepouce_dossier, ef.mardi as options_mardi, ef.mercredi as options_mercredi, ef.jeudi as options_jeudi, ef.vendredi as options_vendredi, ef.samedi as options_samedi, ef.velotype as options_velotype, ef.model as options_model, ef.nserie as options_nserie, ef.roues as options_roues, ef.pneus as options_pneus, ef.penus_type as options_penus_type, ef.freins as options_freins, ef.freins_type as options_freins_type, ef.transmission as options_transmission, ef.transmission_nb_vitesses as options_transmission_nb_vitesses, ef.cables as options_cables, ef.derailleur as options_derailleur, ef.derailleur_probleme as options_derailleur_probleme, ef.chaine as options_chaine, ef.chaine_nb_vitesses as options_chaine_nb_vitesses, ef.selle as options_selle, ef.commentaire_client as options_commentaire_client, ef.coupdepouce as options_coupdepouce, ef.datenaissance as options_datenaissance, ef.lieunaissance as options_lieunaissance, ef.cgu as options_cgu, ef.commentaire_atelier as options_commentaire_atelier FROM hido_fichinter as f LEFT JOIN hido_contrat as c on f.fk_contrat = c.rowid LEFT JOIN hido_fichinter_extrafields as ef on (f.rowid = ef.fk_object), hido_societe as s WHERE f.entity IN (1) AND f.fk_soc = s.rowid AND ((f.description LIKE ‹ %tes% › OR fd.description LIKE ‹ %tes% ›)) ORDER BY f.ref DESC LIMIT 26
En regardant le code de la page, je vois qu’en déclarant une constante FICHINTER_DISABLE_DETAILS à 1 dans Configuration > Divers, la recherche ne se fera plus sur fd.description mais uniquement sur f.description.
Ce qui corrige le problème
Est-ce un reste d’une ancienne version ?
