Bonjour,
Effectivement ça semble être multicompany qui fou le bazard :
2023-09-06 20:36:07 DEBUG ****** HookManager::initHooks Loading hooks: context=commonobject-path=/multicompany/class/actions_multicompany.class.php
2023-09-06 20:36:07 DEBUG ****** sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref, t.ref_client, t.total_ht FROM llxif_societe as s, llxif_commande as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (493) AND t.entity IN (2,3,4,5,6,7,8,10,11,1)
2023-09-06 20:36:07 DEBUG ****** sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref, t.ref_client, t.total as total_ht FROM llxif_societe as s, llxif_facture as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (493) AND t.entity IN (2,3,11,1)
2023-09-06 20:36:07 ERR ****** DoliDBMysqli::query SQL Error message: DB_ERROR_NOSUCHFIELD Unknown column 't.total' in 'field list'
2023-09-06 20:36:07 ERR ****** Error url=/comm/propal/card.php?id=2938&save_lastsearch_values=1, query_string=id=2938&save_lastsearch_values=1, sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref, t.ref_client, t.total as total_ht FROM llxif_societe as s, llxif_facture as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (493) AND t.entity IN (2,3,11,1), db_error=Unknown column 't.total' in 'field list'
2023-09-06 20:36:11 DEBUG ****** HookManager::initHooks Loading hooks: context=main-path=/multicompany/class/actions_multicompany.class.php
2023-09-06 20:36:11 DEBUG ****** sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.fk_warehouse, s.price_level, s.tms as date_modification, s.fk_user_creat, s.fk_user_modif, s.phone, s.fax, s.email, s.socialnetworks, s.url, s.zip, s.town, s.note_private, s.note_public, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.model_pdf, s.last_main_doc, s.code_compta, s.code_compta_fournisseur, s.accountancy_code_buy, s.accountancy_code_sell, s.vat_reverse_charge as soc_vat_reverse_charge, s.code_client, s.code_fournisseur, s.parent, s.barcode, s.fk_departement as state_id, s.fk_pays as country_id, s.fk_stcomm, s.mode_reglement, s.cond_reglement, s.deposit_percent, s.transport_mode, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.transport_mode_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, r.rowid as region_id, r.code_region as region_code, st.libelle as stcomm, st.picto as stcomm_picto, te.code as typent_code, i.libelle as label_incoterms, sr.remise_client, sr2.remise_supplier FROM llxif_societe as s LEFT JOIN llxif_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llxif_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llxif_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llxif_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llxif_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llxif_c_regions as r ON d.fk_region = r.code_region LEFT JOIN llxif_c_typent as te ON s.fk_typent = te.id LEFT JOIN llxif_c_incoterms as i ON s.fk_incoterms = i.rowid LEFT JOIN llxif_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM llxif_societe_remise WHERE fk_soc = s.rowid AND entity IN (1)) LEFT JOIN llxif_societe_remise_supplier as sr2 ON sr2.rowid = (SELECT MAX(rowid) FROM llxif_societe_remise_supplier WHERE fk_soc = s.rowid AND entity IN (1)) WHERE s.entity IN (2,3,4,5,6,7,8,10,11,1) AND s.rowid = 493
2023-09-06 20:36:11 DEBUG ****** Propal::liste_contact
2023-09-06 20:36:11 DEBUG ****** sql=SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, '-1' as socid, t.statut as statuscontact, t.login, t.photo, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle FROM llxif_c_type_contact tc, llxif_element_contact ec LEFT JOIN llxif_user t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 2938 AND ec.fk_c_type_contact = tc.rowid AND tc.element = 'propal' AND tc.source = 'internal' AND tc.active = 1 ORDER BY t.lastname ASC
2023-09-06 20:36:11 DEBUG ****** Propal::liste_contact
2023-09-06 20:36:11 DEBUG ****** sql=SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, t.fk_soc as socid, t.statut as statuscontact, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle FROM llxif_c_type_contact tc, llxif_element_contact ec LEFT JOIN llxif_socpeople t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 2938 AND ec.fk_c_type_contact = tc.rowid AND tc.element = 'propal' AND tc.source = 'external' AND tc.active = 1 ORDER BY t.lastname ASC
2023-09-06 20:36:11 INFO ****** files.lib.php::dol_dir_list path=/home/esdmmzfe/dolibarrdata/7/propale/DEVIS-ZC-2303-00043 types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$"
2023-09-06 20:36:11 DEBUG ****** sql=SELECT COUNT(rowid) as nb FROM llxif_links WHERE objecttype = 'propal' AND objectid = 2938 AND entity = 1
2023-09-06 20:36:11 DEBUG ****** sql=SELECT COUNT(id) as nb FROM llxif_actioncomm WHERE fk_element = 2938 AND elementtype = 'propal'
2023-09-06 20:36:11 DEBUG ****** Form::select_thirdparty_list
2023-09-06 20:36:11 DEBUG ****** sql=SELECT s.rowid, s.nom as name, s.name_alias, s.tva_intra, s.client, s.fournisseur, s.code_client, s.code_fournisseur FROM llxif_societe as s WHERE s.entity IN (2,3,4,5,6,7,8,10,11,1) AND (((s.client IN (1,2,3)))) ORDER BY nom ASC
2023-09-06 20:36:11 DEBUG ****** Form::select_thirdparty_list
2023-09-06 20:36:11 DEBUG ****** sql=SELECT s.rowid, s.nom as name, s.name_alias, s.tva_intra, s.client, s.fournisseur, s.code_client, s.code_fournisseur FROM llxif_societe as s WHERE s.entity IN (2,3,4,5,6,7,8,10,11,1) AND (Filter syntax error - Bad syntax of the search string) ORDER BY nom ASC
2023-09-06 20:36:11 ERR ****** DoliDBMysqli::query SQL Error message: DB_ERROR_SYNTAX You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'syntax error - Bad syntax of the search string) ORDER BY nom ASC' at line 1
2023-09-06 20:36:11 ERR ****** Error url=/comm/propal/card.php?id=2938&socid=493&action=clone&token=7d3d0f6c051c20f1f830f3d7ed977778&object=propal, query_string=id=2938&socid=493&action=clone&token=7d3d0f6c051c20f1f830f3d7ed977778&object=propal, sql=SELECT s.rowid, s.nom as name, s.name_alias, s.tva_intra, s.client, s.fournisseur, s.code_client, s.code_fournisseur FROM llxif_societe as s WHERE s.entity IN (2,3,4,5,6,7,8,10,11,1) AND (Filter syntax error - Bad syntax of the search string) ORDER BY nom ASC, db_error=You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'syntax error - Bad syntax of the search string) ORDER BY nom ASC' at line 1
)
