Hi, i am using dolibarr and enjoying with it, today some of my users in the company face the problem when they click the commercial proposal list it shows the below message, anyone can guide me how to solve this problem.
Thanks in advance.
Dolibarr has detected a technical error.
This information can be useful for diagnostic purposes (you can set option $dolibarr_main_prod to ‘1’ to remove such notices):
Date: 20190730143617
Dolibarr: 10.0.0
Level of features: 0
PHP: 7.2.16
Server: Apache/2.4.39 (cPanel) OpenSSL/1.0.2r mod_bwlimited/1.4 Phusion_Passenger/5.3.7
OS: Linux md-hk-13.webhostbox.net 2.6.32-954.3.5.lve1.4.63.el6.x86_64 #1 SMP Sun Apr 7 10:18:40 EDT 2019 x86_64
UserAgent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.101 Safari/537.36
Requested URL: /erp/comm/propal/list.php?leftmenu=propals&viewstatut=1
Referer: https://www.butterflyled.com/erp/comm/propal/card.php?action=create&leftmenu=propals
Menu manager: eldy_menu.php
Modules/Applications: user, accounting, cron, commande, ecm, facture, fournisseur, salaries, societe, emailcollector, workflow, expensereport, propal, expedition, multicurrency, bookmark, export, tax, banque, product, stock, factory, categorie, import, notification, mailing, socialnetworks
Database type manager: mysqli
Latest database access request error: SELECT s.rowid as socid, s.nom as name, s.email, s.town, s.zip, s.fk_pays, s.client, s.code_client, typent.code as typent_code, ava.rowid as availability, state.code_departement as state_code, state.nom as state_name, p.rowid, p.entity, p.note_private, p.total_ht, p.tva as total_vat, p.total as total_ttc, p.localtax1, p.localtax2, p.ref, p.ref_client, p.fk_statut, p.fk_user_author, p.datep as dp, p.fin_validite as dfv,p.date_livraison as ddelivery, p.datec as date_creation, p.tms as date_update, pr.rowid as project_id, pr.ref as project_ref, pr.title as project_label, u.login, sc.fk_soc, sc.fk_user, ef.at01 as options_at01 FROM llxwi_societe as s LEFT JOIN llxwi_c_country as country on (country.rowid = s.fk_pays) LEFT JOIN llxwi_c_typent as typent on (typent.id = s.fk_typent) LEFT JOIN llxwi_c_departements as state on (state.rowid = s.fk_departement), llxwi_propal as p LEFT JOIN llxwi_propal_extrafields as ef on (p.rowid = ef.fk_object) LEFT JOIN llxwi_user as u ON p.fk_user_author = u.rowid LEFT JOIN llxwi_projet as pr ON pr.rowid = p.fk_projet LEFT JOIN llxwi_c_availability as ava on (ava.rowid = p.fk_availability), llxwi_societe_commerciaux as sc WHERE p.fk_soc = s.rowid AND p.entity IN (1) AND s.rowid = sc.fk_soc AND sc.fk_user = 8 AND p.fk_statut IN (1) ORDER BY p.ref DESC, p.ref DESC LIMIT 26
Return code for latest database access request error: DB_ERROR_SYNTAX
Information for latest database access request error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ’ ef.at01 as options_at01 FROM llxwi_societe as s LEFT JOIN llxwi_c_country as co’ at line 1
