I'm using version 23.0.1, which has a BUG

TuHao · March 30, 2026, 3:48am

The following is the content of dolibarr.log

May I ask how I should solve these problems?

2026-03-30 03:23:20 DEBUG   2018503   1000 NEW TOKEN generated by : /index.php
2026-03-30 03:23:20 NOTICE  2018503   1000 --- Access to GET /index.php - action= - actionlogin= - showing the login form and exit
2026-03-30 03:23:20 DEBUG   2018503   1000 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where (lang='en_US' OR lang IS NULL) AND entity IN (0, 0,1) ORDER BY lang DESC
2026-03-30 03:23:20 DEBUG   2018503   1000 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'CN' AND t.active = 1 AND t.entity IN (1) AND (t.localtax1_type <> '0' OR t.localtax2_type <> '0')
2026-03-30 03:23:20 INFO    2018503   1000 --- End access to /index.php
2026-03-30 03:23:20 DEBUG   2018504   1000 DefaultValues::fetchAll
2026-03-30 03:23:20 DEBUG   2018504   1000 sql=SELECT rowid, type, user_id, page, param, value FROM llx_default_values as t WHERE 1 = 1 AND ((t.user_id IN (0,0)) AND (entity IN (1,1)))
2026-03-30 03:23:20 NOTICE  2018504   1000 --- Access to GET /theme/eldy/style.css.php - action=, massaction= NOTOKENRENEWAL=1
2026-03-30 03:23:20 DEBUG   2018504   1000 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where (lang='en_US' OR lang IS NULL) AND entity IN (0, 0,1) ORDER BY lang DESC
2026-03-30 03:23:20 DEBUG   2018504   1000 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.prefix, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position, m.showtopmenuinframe FROM llx_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.type DESC, m.position, m.rowid
2026-03-30 03:23:20 INFO    2018504   1000 --- End access to /theme/eldy/style.css.php
2026-03-30 03:23:20 DEBUG   2018510   1000 DefaultValues::fetchAll
2026-03-30 03:23:20 DEBUG   2018510   1000 sql=SELECT rowid, type, user_id, page, param, value FROM llx_default_values as t WHERE 1 = 1 AND ((t.user_id IN (0,0)) AND (entity IN (1,1)))
2026-03-30 03:23:20 NOTICE  2018510   1000 --- Access to GET /core/js/lib_head.js.php - action=, massaction= NOTOKENRENEWAL=1
2026-03-30 03:23:20 DEBUG   2018510   1000 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where (lang='en_US' OR lang IS NULL) AND entity IN (0, 0,1) ORDER BY lang DESC
2026-03-30 03:23:20 INFO    2018510   1000 --- End access to /core/js/lib_head.js.php
2026-03-30 03:23:20 DEBUG   2018505   1000 DefaultValues::fetchAll
2026-03-30 03:23:20 DEBUG   2018505   1000 sql=SELECT rowid, type, user_id, page, param, value FROM llx_default_values as t WHERE 1 = 1 AND ((t.user_id IN (0,0)) AND (entity IN (1,1)))
2026-03-30 03:23:20 NOTICE  2018505   1000 --- Access to GET /viewimage.php - action=, massaction= NOTOKENRENEWAL=1
2026-03-30 03:23:20 INFO    2018505   1000 dol_check_secure_access_document modulepart=mycompany original_file=logos/thumbs/LOGO_small.jpg entity=1
2026-03-30 03:23:20 INFO    2018505   1000 viewimage.php return file /www/wwwroot/doli.xxx.com/documents/mycompany/logos/thumbs/LOGO_small.jpg filename=LOGO_small.jpg content-type=image/jpeg
2026-03-30 03:23:20 INFO    2018505   1000 --- End access to /viewimage.php
2026-03-30 03:23:20 NOTICE  2018523   1000 --- Access to GET /theme/eldy/manifest.json.php - action=, massaction= NOTOKENRENEWAL=1
2026-03-30 03:23:20 INFO    2018523   1000 --- End access to /theme/eldy/manifest.json.php
2026-03-30 03:23:20 DEBUG   2018502   1000 DefaultValues::fetchAll
2026-03-30 03:23:20 DEBUG   2018502   1000 sql=SELECT rowid, type, user_id, page, param, value FROM llx_default_values as t WHERE 1 = 1 AND ((t.user_id IN (0,0)) AND (entity IN (1,1)))
2026-03-30 03:23:20 NOTICE  2018502   1000 --- Access to GET /viewimage.php - action=, massaction= NOTOKENRENEWAL=1
2026-03-30 03:23:20 INFO    2018502   1000 dol_check_secure_access_document modulepart=mycompany original_file=logos/thumbs/LOGO_small.jpg entity=1
2026-03-30 03:23:20 INFO    2018502   1000 viewimage.php return file /www/wwwroot/doli.xxx.com/documents/mycompany/logos/thumbs/LOGO_small.jpg filename=LOGO_small.jpg content-type=image/jpeg
2026-03-30 03:23:20 INFO    2018502   1000 --- End access to /viewimage.php
2026-03-30 03:23:35 INFO    2018495   1000 checkLoginPassEntity usertotest=ds012 entitytotest=1 authmode=dolibarr
2026-03-30 03:23:35 INFO    2018495   1000 functions_dolibarr::check_user_password_dolibarr usertotest=ds012 passwordtotest=************ entitytotest=1
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT COUNT(e.rowid) as nbevent FROM llx_events as e WHERE e.type = 'USER_LOGIN_FAILED' AND e.ip = '119.139.34.168' AND e.dateevent > '2026-03-29 11:23:35'
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT rowid, login, entity, pass, pass_crypted, datestartvalidity, dateendvalidity, flagdelsessionsbefore FROM llx_user WHERE (login = 'ds012') AND entity IN (0,1) AND statut = 1 ORDER BY entity DESC
2026-03-30 03:23:35 INFO    2018495   1000 functions_dolibarr::check_user_password_dolibarr Authentication ok - hash auto of pass is ok
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.civility as civility_code, u.birth, u.job, u.email, u.email_oauth2, u.personal_email, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, fk_user_creat as user_creation_id, fk_user_modif as user_modification_id, u.statut as status, u.lang, u.entity, u.datec as datec, GREATEST(u.tms, uef.tms) as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.flagdelsessionsbefore, u.iplastlogin, u.ippreviouslogin, u.datelastpassvalidation, u.datestartvalidity, u.dateendvalidity, u.photo as photo, u.openid as openid, u.accountancy_code_user_general, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, u.national_registration_number, u.ref_employee, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, s.label as label_establishment, u.fk_establishment FROM llx_user as u LEFT JOIN llx_user_extrafields as uef ON uef.fk_object = u.rowid LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid LEFT JOIN llx_establishment as s ON u.fk_establishment = s.rowid WHERE u.entity IN (0, 1) AND u.login = 'DS012' ORDER BY u.entity ASC
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, emptyonclone, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, aiprompt, css, cssview, csslist FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 40 AND entity = 1
2026-03-30 03:23:35 DEBUG   2018495   1000 DefaultValues::fetchAll
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT rowid, type, user_id, page, param, value FROM llx_default_values as t WHERE 1 = 1 AND ((t.user_id IN (0,40)) AND (entity IN (1,1)))
2026-03-30 03:23:35 INFO    2018495   1000 This is a new started user session. _SESSION['dol_login']=DS012 Session id=2m0vl8f8aecun4fl3eg0ig0tbb
2026-03-30 03:23:35 DEBUG   2018495   1000 BEGIN Transaction
2026-03-30 03:23:35 DEBUG   2018495   1000  User::update_last_login_date user->id=40 UPDATE llx_user SET datepreviouslogin = datelastlogin, ippreviouslogin = iplastlogin, datelastlogin = '2026-03-30 11:23:35', iplastlogin = '119.139.34.168', tms = tms WHERE rowid = 40
2026-03-30 03:23:35 DEBUG   2018495   1000  sql=UPDATE llx_user SET datepreviouslogin = datelastlogin, ippreviouslogin = iplastlogin, datelastlogin = '2026-03-30 11:23:35', iplastlogin = '119.139.34.168', tms = tms WHERE rowid = 40
2026-03-30 03:23:35 DEBUG   2018495   1000 COMMIT Transaction
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND r.entity = 1 AND ur.entity = 1 AND ur.fk_user = 40 AND r.perms IS NOT NULL
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT DISTINCT r.module, r.perms, r.subperms, r.entity FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity IN (0,1) AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 40 AND r.perms IS NOT NULL
2026-03-30 03:23:35 NOTICE  2018495   1000 --- Access to POST /index.php - action=, massaction=
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where (lang='en_US' OR lang IS NULL) AND entity IN (0, 0,1) ORDER BY lang DESC
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.prefix, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position, m.showtopmenuinframe FROM llx_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.type DESC, m.position, m.rowid
2026-03-30 03:23:35 DEBUG   2018495   1000 InfoBox::listBoxes get default box list for mode=activated userid=40
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT b.rowid, b.position, b.box_order, b.fk_user, d.rowid as box_id, d.file, d.note, d.tms FROM llx_boxes as b, llx_boxes_def as d WHERE b.box_id = d.rowid AND b.entity IN (0,1) AND b.position = 0 AND b.fk_user IN (0,40) ORDER BY b.box_order
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT p.ref as product_ref, p.rowid as productid, p.tosell, p.tobuy, p.tobatch, c.rowid, c.date_creation, c.tms, c.ref, c.status, c.fk_user_valid FROM llx_product as p, llx_bom_bom as c WHERE c.fk_product = p.rowid AND c.entity = 1 ORDER BY c.tms DESC, c.ref DESC LIMIT 3
2026-03-30 03:23:35 INFO    2018495   1000 box_boms::showBox
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT s.rowid as socid, s.nom as name, s.name_alias, s.code_fournisseur, s.code_compta_fournisseur, s.fournisseur, s.logo, s.email, s.entity, c.rowid, c.ref, c.tms, c.date_commande, c.total_ht, c.total_tva, c.total_ttc, c.fk_statut as status FROM llx_societe as s, llx_commande_fournisseur as c WHERE c.fk_soc = s.rowid AND c.entity IN (1) ORDER BY c.tms DESC, c.ref DESC  LIMIT 3
2026-03-30 03:23:35 DEBUG   2018495   1000 Translate::loadCacheCurrencies
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = 'CNY'
2026-03-30 03:23:35 INFO    2018495   1000 box_supplier_orders::showBox
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT s.rowid as socid, s.nom as name, s.name_alias, s.code_fournisseur, s.code_compta_fournisseur, s.fournisseur, s.logo, s.email, s.entity, c.rowid, c.ref, c.tms, c.date_commande, c.date_livraison as delivery_date, c.total_ht, c.total_tva, c.total_ttc, c.fk_statut as status FROM llx_societe as s, llx_commande_fournisseur as c WHERE c.fk_soc = s.rowid AND c.entity IN (1) AND c.date_livraison IS NOT NULL AND c.fk_statut IN (3, 4) ORDER BY c.date_livraison ASC, c.fk_statut ASC LIMIT 3
2026-03-30 03:23:35 INFO    2018495   1000 box_supplier_orders_awaiting_reception::showBox
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT s.rowid as socid, s.nom as name, s.name_alias, s.code_client, s.client, s.code_compta as code_compta_client, s.logo, s.email, s.entity, s.tva_intra, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, f.ref, f.date_lim_reglement as datelimit, f.type, f.datef as date, f.total_ht, f.total_tva, f.total_ttc, f.paye, f.fk_statut as status, f.rowid as facid, SUM(pf.amount) as am FROM llx_societe as s, llx_facture as f LEFT JOIN llx_paiement_facture as pf ON f.rowid = pf.fk_facture WHERE f.fk_soc = s.rowid AND f.entity IN (1) AND f.paye = 0 AND fk_statut = 1 GROUP BY s.rowid, s.nom, s.name_alias, s.code_client, s.client, s.logo, s.email, s.entity, s.tva_intra, s.siren, s.siret, s.ape, s.idprof4, s.idprof5, s.idprof6, s.code_compta, f.rowid, f.ref, f.date_lim_reglement, f.type, f.datef, f.total_ht, f.total_tva, f.total_ttc, f.paye, f.fk_statut ORDER BY date_lim_reglement ASC, f.ref ASC LIMIT 4
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT SUM(f.total_ht) as total_ht  FROM llx_societe as s, llx_facture as f LEFT JOIN llx_paiement_facture as pf ON f.rowid = pf.fk_facture WHERE f.fk_soc = s.rowid AND f.entity IN (1) AND f.paye = 0 AND fk_statut = 1
2026-03-30 03:23:35 INFO    2018495   1000 box_factures_imp::showBox
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT f.rowid as facid, f.ref, f.type, f.total_ht, f.total_tva, f.total_ttc, f.datef as date, f.paye, f.fk_statut as status, f.datec, f.tms, f.date_lim_reglement as datelimite, s.rowid as socid, s.nom as name, s.name_alias, s.code_client, s.code_compta, s.client, s.logo, s.email, s.entity, s.tva_intra, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, SUM(pf.amount) as am FROM llx_facture as f LEFT JOIN llx_paiement_facture as pf ON f.rowid = pf.fk_facture, llx_societe as s WHERE f.fk_soc = s.rowid AND f.fk_statut > 0 AND f.entity IN (1) GROUP BY s.rowid, s.nom, s.name_alias, s.code_client, s.code_compta, s.client, s.logo, s.email, s.entity, s.tva_intra, s.siren, s.siret, s.ape, s.idprof4, s.idprof5, s.idprof6, f.rowid, f.ref, f.type, f.total_ht, f.total_tva, f.total_ttc, f.datef, f.paye, f.fk_statut, f.datec, f.tms, f.date_lim_reglement ORDER BY f.tms DESC, f.ref DESC  LIMIT 3
2026-03-30 03:23:35 INFO    2018495   1000 box_factures::showBox
2026-03-30 03:23:35 INFO    2018495   1000 FactureStats::getNbByMonthWithPrevYear cache file /www/wwwroot/doli.xxx.com/documents/users/temp/FactureStats_getNbByMonthWithPrevYear_customer_en_US_entity.1_user40.cache is not found or older than now - cachedelay (1774841015 - 86400) so we can't use it.
2026-03-30 03:23:35 DEBUG   2018495   1000 FactureStats::_getNbByMonth
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT date_format(f.datef,'%m') as dm, COUNT(*) as nb FROM llx_facture as f WHERE f.datef BETWEEN '2024-01-01 00:00:00' AND '2024-12-31 23:59:59' AND f.entity IN (1) AND f.fk_statut > 0 GROUP BY dm ORDER BY dm DESC
2026-03-30 03:23:35 DEBUG   2018495   1000 FactureStats::_getNbByMonth
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT date_format(f.datef,'%m') as dm, COUNT(*) as nb FROM llx_facture as f WHERE f.datef BETWEEN '2025-01-01 00:00:00' AND '2025-12-31 23:59:59' AND f.entity IN (1) AND f.fk_statut > 0 GROUP BY dm ORDER BY dm DESC
2026-03-30 03:23:35 DEBUG   2018495   1000 FactureStats::_getNbByMonth
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT date_format(f.datef,'%m') as dm, COUNT(*) as nb FROM llx_facture as f WHERE f.datef BETWEEN '2026-01-01 00:00:00' AND '2026-12-31 23:59:59' AND f.entity IN (1) AND f.fk_statut > 0 GROUP BY dm ORDER BY dm DESC
2026-03-30 03:23:35 INFO    2018495   1000 FactureStats::getNbByMonthWithPrevYear save cache file /www/wwwroot/doli.xxx.com/documents/users/temp/FactureStats_getNbByMonthWithPrevYear_customer_en_US_entity.1_user40.cache onto disk.
2026-03-30 03:23:35 INFO    2018495   1000 DolGraph::draw_chart this->type= this->MaxValue=70
2026-03-30 03:23:35 INFO    2018495   1000 FactureStats::getAmountByMonthWithPrevYear cache file /www/wwwroot/doli.xxx.com/documents/users/temp/FactureStats_getAmountByMonthWithPrevYear_customer_en_US_entity.1_user40.cache is not found or older than now - cachedelay (1774841015 - 86400) so we can't use it.
2026-03-30 03:23:35 DEBUG   2018495   1000 FactureStats::_getAmountByMonth
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT date_format(datef,'%m') as dm, SUM(f.total_ht) FROM llx_facture as f WHERE f.datef BETWEEN '2024-01-01 00:00:00' AND '2024-12-31 23:59:59' AND f.entity IN (1) AND f.fk_statut > 0 GROUP BY dm ORDER BY dm DESC
2026-03-30 03:23:35 DEBUG   2018495   1000 FactureStats::_getAmountByMonth
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT date_format(datef,'%m') as dm, SUM(f.total_ht) FROM llx_facture as f WHERE f.datef BETWEEN '2025-01-01 00:00:00' AND '2025-12-31 23:59:59' AND f.entity IN (1) AND f.fk_statut > 0 GROUP BY dm ORDER BY dm DESC
2026-03-30 03:23:35 DEBUG   2018495   1000 FactureStats::_getAmountByMonth
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT date_format(datef,'%m') as dm, SUM(f.total_ht) FROM llx_facture as f WHERE f.datef BETWEEN '2026-01-01 00:00:00' AND '2026-12-31 23:59:59' AND f.entity IN (1) AND f.fk_statut > 0 GROUP BY dm ORDER BY dm DESC
2026-03-30 03:23:35 INFO    2018495   1000 FactureStats::getAmountByMonthWithPrevYear save cache file /www/wwwroot/doli.xxx.com/documents/users/temp/FactureStats_getAmountByMonthWithPrevYear_customer_en_US_entity.1_user40.cache onto disk.
2026-03-30 03:23:35 INFO    2018495   1000 DolGraph::draw_chart this->type= this->MaxValue=700000
2026-03-30 03:23:35 INFO    2018495   1000 box_graph_invoices_permonth::showBox
2026-03-30 03:23:35 DEBUG   2018495   1000 box_customers_outstanding_bill_reached::loadBox
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT s.rowid as socid, s.nom as name, s.name_alias, s.code_client, s.code_compta, s.client, s.logo, s.email, s.entity, s.outstanding_limit, s.datec, s.tms, s.status FROM llx_societe as s WHERE s.client IN (1, 3) AND s.entity IN (1) AND s.outstanding_limit > 0 AND s.rowid IN (SELECT fk_soc from llx_facture as f WHERE f.fk_statut = 1 and f.fk_soc = s.rowid) ORDER BY s.tms DESC
2026-03-30 03:23:35 INFO    2018495   1000 box_customers_outstanding_bill_reached::showBox
2026-03-30 03:23:35 DEBUG   2018495   1000 box_comptes::loadBox
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT b.rowid, b.ref, b.label, b.bank, b.number, b.courant, b.clos, b.rappro, b.url, b.code_banque, b.code_guichet, b.cle_rib, b.bic, b.iban_prefix as iban, b.domiciliation as address, b.proprio, b.owner_address, b.account_number, b.currency_code, b.min_allowed, b.min_desired, comment, b.fk_accountancy_journal, aj.code as accountancy_journal FROM llx_bank_account as b LEFT JOIN llx_accounting_journal as aj ON aj.rowid = b.fk_accountancy_journal WHERE b.entity = 1 AND clos = 0 ORDER BY label LIMIT 3
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT sum(amount) as amount FROM llx_bank WHERE fk_account = 10
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT sum(amount) as amount FROM llx_bank WHERE fk_account = 2
2026-03-30 03:23:35 DEBUG   2018495   1000 Translate::loadCacheCurrencies
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = 'USD'
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT sum(amount) as amount FROM llx_bank WHERE fk_account = 14
2026-03-30 03:23:35 INFO    2018495   1000 box_comptes::showBox
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT p.rowid, p.label, p.ref, p.price, p.price_base_type, p.price_ttc, p.fk_product_type, p.tms, p.tosell, p.tobuy, p.fk_price_expression, p.entity, p.accountancy_code_sell, p.accountancy_code_sell_intra, p.accountancy_code_sell_export, p.accountancy_code_buy, p.accountancy_code_buy_intra, p.accountancy_code_buy_export, p.barcode FROM llx_product as p WHERE p.entity IN (1) ORDER BY p.tms DESC LIMIT 3
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT label FROM llx_product_lang WHERE fk_product = 5436 AND lang = 'en_US' LIMIT 1
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT label FROM llx_product_lang WHERE fk_product = 5437 AND lang = 'en_US' LIMIT 1
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT label FROM llx_product_lang WHERE fk_product = 5438 AND lang = 'en_US' LIMIT 1
2026-03-30 03:23:35 INFO    2018495   1000 box_produits::showBox
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT p.rowid, p.label, p.price, p.ref, p.price_base_type, p.price_ttc, p.fk_product_type, p.tms, p.tosell, p.tobuy, p.barcode, p.seuil_stock_alerte, p.entity, p.accountancy_code_sell, p.accountancy_code_sell_intra, p.accountancy_code_sell_export, p.accountancy_code_buy, p.accountancy_code_buy_intra, p.accountancy_code_buy_export, SUM((CASE WHEN s.reel IS NULL THEN 0 ELSE s.reel END)) as total_stock FROM llx_product as p LEFT JOIN llx_product_stock as s on p.rowid = s.fk_product WHERE p.entity IN (1) AND p.seuil_stock_alerte > 0 GROUP BY p.rowid, p.ref, p.label, p.price, p.price_base_type, p.price_ttc, p.fk_product_type, p.tms, p.tosell, p.tobuy, p.barcode, p.seuil_stock_alerte, p.entity, p.accountancy_code_sell, p.accountancy_code_sell_intra, p.accountancy_code_sell_export, p.accountancy_code_buy, p.accountancy_code_buy_intra, p.accountancy_code_buy_export HAVING SUM((CASE WHEN s.reel IS NULL THEN 0 ELSE s.reel END)) < p.seuil_stock_alerte ORDER BY p.seuil_stock_alerte DESC LIMIT 3
2026-03-30 03:23:35 INFO    2018495   1000 box_produits_alerte_stock::showBox
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT s.rowid as socid, s.nom as name, s.name_alias, s.code_fournisseur, s.code_compta_fournisseur, s.fournisseur, s.logo, s.email, s.entity, f.rowid as facid, f.ref, f.ref_supplier, f.total_ht, f.total_tva, f.total_ttc, f.paye, f.fk_statut as status, f.datef as date, f.datec as datec, f.date_lim_reglement as datelimite, f.tms, f.type FROM llx_societe as s, llx_facture_fourn as f WHERE f.fk_soc = s.rowid AND f.entity = 1 ORDER BY f.tms DESC, f.ref DESC  LIMIT 3
2026-03-30 03:23:35 DEBUG   2018495   1000 FactureFournisseur::getSommePaiement
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 4113
2026-03-30 03:23:35 DEBUG   2018495   1000 FactureFournisseur::getSommePaiement
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 4088
2026-03-30 03:23:35 DEBUG   2018495   1000 FactureFournisseur::getSommePaiement
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 4084
2026-03-30 03:23:35 INFO    2018495   1000 box_factures_fourn::showBox
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT p.ref as product_ref, p.rowid as productid, p.tosell, p.tobuy, p.tobatch, c.rowid, c.date_creation, c.tms, c.ref, c.status FROM llx_product as p, llx_mrp_mo as c WHERE c.fk_product = p.rowid AND c.entity = 1 ORDER BY c.tms DESC, c.ref DESC LIMIT 3
2026-03-30 03:23:35 INFO    2018495   1000 box_mos::showBox
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT ctc.rowid, ctc.code FROM llx_c_type_contact as ctc WHERE ctc.element = 'project' AND ctc.source = 'internal'
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT p.rowid, p.ref FROM llx_projet as p WHERE p.entity IN (1) AND (p.public = 1 OR EXISTS (SELECT ec.rowid FROM llx_element_contact as ec WHERE ec.element_id = p.rowid AND ec.fk_c_type_contact IN (51,50) AND ec.fk_socpeople = 40))
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT p.rowid, p.ref, p.title, p.fk_statut as status, p.public, p.fk_soc, s.nom as name, s.name_alias FROM llx_projet as p LEFT JOIN llx_societe as s on p.fk_soc = s.rowid WHERE p.entity IN (1) AND p.fk_statut = 1 AND p.rowid IN (36) ORDER BY p.datec DESC
2026-03-30 03:23:35 INFO    2018495   1000 box_project::showBox
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT ctc.rowid, ctc.code FROM llx_c_type_contact as ctc WHERE ctc.element = 'project' AND ctc.source = 'internal'
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT p.rowid, p.ref FROM llx_projet as p WHERE p.entity IN (1) AND (p.public = 1 OR EXISTS (SELECT ec.rowid FROM llx_element_contact as ec WHERE ec.element_id = p.rowid AND ec.fk_c_type_contact IN (51,50) AND ec.fk_socpeople = 40))
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT p.rowid, p.ref, p.title, p.fk_soc, p.fk_statut as status, p.fk_opp_status as opp_status, p.opp_percent, p.opp_amount, p.public, s.nom as name, s.name_alias, cls.code as opp_status_code FROM llx_projet as p LEFT JOIN llx_societe as s on p.fk_soc = s.rowid LEFT JOIN llx_c_lead_status as cls on p.fk_opp_status = cls.rowid WHERE p.entity IN (1) AND p.usage_opportunity = 1 AND p.fk_opp_status > 0 AND p.fk_statut IN (0,1) AND p.rowid IN (36) ORDER BY p.datec DESC
2026-03-30 03:23:35 INFO    2018495   1000 box_project_opportunities::showBox
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT ctc.rowid, ctc.code FROM llx_c_type_contact as ctc WHERE ctc.element = 'project' AND ctc.source = 'internal'
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT p.rowid, p.ref FROM llx_projet as p WHERE p.entity IN (1) AND (p.public = 1 OR EXISTS (SELECT ec.rowid FROM llx_element_contact as ec WHERE ec.element_id = p.rowid AND ec.fk_c_type_contact IN (51,50) AND ec.fk_socpeople = 40))
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT pt.rowid, pt.ref, pt.fk_projet, pt.fk_task_parent, pt.datec, pt.dateo, pt.datee, pt.datev, pt.label, pt.description, pt.duration_effective, pt.planned_workload, pt.progress, p.rowid project_id, p.ref project_ref, p.title project_title, p.fk_statut FROM llx_projet_task as pt JOIN llx_projet as p ON (pt.fk_projet = p.rowid) WHERE  pt.entity = 1 AND p.fk_statut = 1 AND (pt.progress < 100 OR pt.progress IS NULL )  AND p.usage_task = 1  AND p.rowid IN (36) ORDER BY pt.datee ASC, pt.dateo ASC LIMIT 3
2026-03-30 03:23:35 INFO    2018495   1000 box_task::showBox
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT cls.rowid, cls.code, cls.percent, cls.label, cls.position FROM llx_c_lead_status as cls WHERE active = 1 AND cls.code NOT IN ('LOST', 'WON') ORDER BY cls.position ASC, cls.rowid ASC
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT p.fk_opp_status as opp_status, cls.code, cls.position, COUNT(p.rowid) as nb, SUM(p.opp_amount) as opp_amount, SUM(p.opp_amount * p.opp_percent) as ponderated_opp_amount FROM llx_projet as p, llx_c_lead_status as cls WHERE p.entity IN (1) AND p.fk_opp_status = cls.rowid AND p.fk_statut = 1 AND cls.active = 1 AND cls.code NOT IN ('LOST', 'WON') GROUP BY p.fk_opp_status, cls.code, cls.position ORDER BY cls.position, p.fk_opp_status, cls.code
2026-03-30 03:23:35 DEBUG   2018495   1000 dol_getIdFromCode (value for field code from key 1 not found into cache)
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT code as valuetoget FROM llx_c_lead_status WHERE rowid = 1
2026-03-30 03:23:35 DEBUG   2018495   1000 dol_getIdFromCode (value for field code from key 2 not found into cache)
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT code as valuetoget FROM llx_c_lead_status WHERE rowid = 2
2026-03-30 03:23:35 DEBUG   2018495   1000 dol_getIdFromCode (value for field code from key 3 not found into cache)
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT code as valuetoget FROM llx_c_lead_status WHERE rowid = 3
2026-03-30 03:23:35 DEBUG   2018495   1000 dol_getIdFromCode (value for field code from key 4 not found into cache)
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT code as valuetoget FROM llx_c_lead_status WHERE rowid = 4
2026-03-30 03:23:35 INFO    2018495   1000 DolGraph::draw_chart this->type=horizontalbars this->MaxValue=0
2026-03-30 03:23:35 INFO    2018495   1000 box_funnel_of_prospection::showBox
2026-03-30 03:23:35 INFO    2018495   1000 ModeleBoxes::showBox
2026-03-30 03:23:35 DEBUG   2018495   1000 box_actions::loadBox
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT a.id, a.label, a.datep as dp, a.percent as percentage, ta.code, ta.libelle as type_label, s.rowid as socid, s.nom as name, s.name_alias, s.code_client, s.code_compta as code_compta_client, s.client, s.logo, s.email, s.entity FROM llx_c_actioncomm AS ta, llx_actioncomm AS a LEFT JOIN llx_societe as s ON a.fk_soc = s.rowid WHERE a.fk_action = ta.id AND a.entity IN (1) AND a.percent >= 0 AND a.percent < 100 AND (a.fk_user_author = 40 OR a.fk_user_action = 40) ORDER BY a.datep ASC LIMIT 3
2026-03-30 03:23:35 INFO    2018495   1000 box_actions::showBox
2026-03-30 03:23:35 DEBUG   2018495   1000 box_birthdays::loadBox
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT u.rowid, u.firstname, u.lastname, u.birth as datea, date_format(u.birth, '%d') as daya, 'birth' as typea, u.email, u.statut as status FROM llx_user as u WHERE u.entity IN (0,1) AND u.statut = 1 AND  date_format( u.birth, '%c') = '3' AND u.birth < '2026-01-01 00:00:00' UNION SELECT u.rowid, u.firstname, u.lastname, u.dateemployment as datea, date_format(u.dateemployment, '%d') as daya, 'employment' as typea, u.email, u.statut as status FROM llx_user as u WHERE u.entity IN (0,1) AND u.statut = 1 AND  date_format( u.dateemployment, '%c') = '3' AND u.dateemployment < '2026-01-01 00:00:00' ORDER BY daya ASC LIMIT 3
2026-03-30 03:23:35 INFO    2018495   1000 box_birthdays::showBox
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT COUNT(DISTINCT u.rowid) as nb FROM llx_user as u WHERE u.entity IN (0,1) AND u.statut > 0
2026-03-30 03:23:35 DEBUG   2018495   1000 User::loadParentOf
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT fk_user as id_parent, rowid as id_son FROM llx_user WHERE fk_user <> 0 AND entity IN (0,1)
2026-03-30 03:23:35 DEBUG   2018495   1000 User::get_full_tree get user list
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT DISTINCT u.rowid, u.firstname, u.lastname, u.fk_user, u.fk_soc, u.login, u.email, u.gender, u.admin, u.statut, u.photo, u.entity FROM llx_user as u WHERE u.entity IN (0,1)
2026-03-30 03:23:35 DEBUG   2018495   1000 User::get_full_tree call to build_path_from_id_user
2026-03-30 03:23:35 DEBUG   2018495   1000 User::get_full_tree dol_sort_array
2026-03-30 03:23:35 INFO    2018495   1000 Build childid for id = 40

TuHao · March 30, 2026, 3:48am

2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT count(ex.rowid) as nb FROM llx_expensereport as ex WHERE ex.fk_statut > 0 AND ex.entity IN (1) AND (ex.fk_user_author IN (40) OR ex.fk_user_validator IN (40))
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT count(h.rowid) as nb FROM llx_holiday as h WHERE h.statut > 1 AND h.entity IN (1)
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT count(s.rowid) as nb, s.client FROM llx_societe as s WHERE s.client IN (1,2,3) AND s.entity IN (1) GROUP BY s.client
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT count(s.rowid) as nb FROM llx_societe as s WHERE s.fournisseur = 1 AND s.entity IN (1)
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT count(sp.rowid) as nb FROM llx_socpeople as sp WHERE sp.entity IN (1) AND (sp.priv='0' OR (sp.priv='1' AND sp.fk_user_creat = 40))
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT count(p.rowid) as nb, fk_product_type FROM llx_product as p WHERE p.entity IN (1) GROUP BY fk_product_type
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT ctc.rowid, ctc.code FROM llx_c_type_contact as ctc WHERE ctc.element = 'project' AND ctc.source = 'internal'
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT p.rowid, p.ref FROM llx_projet as p WHERE p.entity IN (1) AND (p.public = 1 OR EXISTS (SELECT ec.rowid FROM llx_element_contact as ec WHERE ec.element_id = p.rowid AND ec.fk_c_type_contact IN (51,50) AND ec.fk_socpeople = 40))
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT count(p.rowid) as nb FROM llx_projet as p WHERE p.entity IN (1)AND p.rowid IN (36)
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT count(c.rowid) as nb FROM llx_commande as c LEFT JOIN llx_societe as s ON c.fk_soc = s.rowid WHERE c.entity IN (1)
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT count(f.rowid) as nb FROM llx_facture as f LEFT JOIN llx_societe as s ON f.fk_soc = s.rowid WHERE f.entity IN (1)
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT count(p.rowid) as nb FROM llx_supplier_proposal as p LEFT JOIN llx_societe as s ON p.fk_soc = s.rowid WHERE p.entity IN (1)
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT count(co.rowid) as nb FROM llx_commande_fournisseur as co LEFT JOIN llx_societe as s ON co.fk_soc = s.rowid WHERE co.entity IN (1)
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT count(f.rowid) as nb FROM llx_facture_fourn as f LEFT JOIN llx_societe as s ON f.fk_soc = s.rowid WHERE f.entity = 1
2026-03-30 03:23:35 INFO    2018495   1000 box_dolibarr_state_board::showBox
2026-03-30 03:23:35 INFO    2018495   1000 CommandeStats::getAllByProductEntry cache file /www/wwwroot/doli.xxx.com/documents/users/temp/CommandeStats_getAllByProductEntry_customer_en_US_entity.1_user40.cache is not found or older than now - cachedelay (1774841015 - 86400) so we can't use it.
2026-03-30 03:23:35 DEBUG   2018495   1000 CommandeStats::_getAllByProduct
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT product.ref, COUNT(product.ref) as nb, SUM(tl.total_ht) as total, AVG(tl.total_ht) as avg FROM llx_commande as c INNER JOIN llx_commandedet as tl ON c.rowid = tl.fk_commande INNER JOIN llx_product as product ON tl.fk_product = product.rowid WHERE c.entity IN (1) AND c.date_commande BETWEEN '2026-01-01 00:00:00' AND '2026-12-31 23:59:59' GROUP BY product.ref ORDER BY nb DESC
2026-03-30 03:23:35 INFO    2018495   1000 CommandeStats::getAllByProductEntry save cache file /www/wwwroot/doli.xxx.com/documents/users/temp/CommandeStats_getAllByProductEntry_customer_en_US_entity.1_user40.cache onto disk.
2026-03-30 03:23:35 INFO    2018495   1000 DolGraph::draw_chart this->type=pie this->MaxValue=200
2026-03-30 03:23:35 INFO    2018495   1000 FactureStats::getAllByProductEntry cache file /www/wwwroot/doli.xxx.com/documents/users/temp/FactureStats_getAllByProductEntry_customer_en_US_entity.1_user40.cache is not found or older than now - cachedelay (1774841015 - 86400) so we can't use it.
2026-03-30 03:23:35 DEBUG   2018495   1000 FactureStats::_getAllByProduct
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT product.ref, COUNT(product.ref) as nb, SUM(tl.total_ht) as total, AVG(tl.total_ht) as avg FROM llx_facture as f INNER JOIN llx_facturedet as tl ON f.rowid = tl.fk_facture INNER JOIN llx_product as product ON tl.fk_product = product.rowid WHERE  f.fk_statut >= 0 AND f.entity IN (1) AND (f.fk_statut <> 3 OR f.close_code <> 'replaced') AND f.type IN (0,1,2,3,5) AND f.datef BETWEEN '2026-01-01 00:00:00' AND '2026-12-31 23:59:59' GROUP BY product.ref ORDER BY nb DESC
2026-03-30 03:23:35 INFO    2018495   1000 FactureStats::getAllByProductEntry save cache file /www/wwwroot/doli.xxx.com/documents/users/temp/FactureStats_getAllByProductEntry_customer_en_US_entity.1_user40.cache onto disk.
2026-03-30 03:23:35 INFO    2018495   1000 DolGraph::draw_chart this->type=pie this->MaxValue=200
2026-03-30 03:23:35 INFO    2018495   1000 box_graph_product_distribution::showBox
2026-03-30 03:23:35 DEBUG   2018495   1000 box_clients::loadBox
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT s.rowid as socid, s.nom as name, s.name_alias, s.code_client, s.code_compta as code_compta_client, s.client, s.logo, s.email, s.entity, s.datec, s.tms, s.status FROM llx_societe as s WHERE s.client IN (1, 3) AND s.entity IN (1) ORDER BY s.tms DESC LIMIT 3
2026-03-30 03:23:35 INFO    2018495   1000 box_clients::showBox
2026-03-30 03:23:35 DEBUG   2018495   1000 box_prospect::loadBox
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT s.rowid as socid, s.nom as name, s.name_alias, s.code_client, s.code_compta, s.client, s.logo, s.email, s.entity, s.fk_stcomm, s.datec, s.tms, s.status FROM llx_societe as s WHERE s.client IN (2, 3) AND s.entity IN (1) ORDER BY s.tms DESC LIMIT 3
2026-03-30 03:23:35 INFO    2018495   1000 box_prospect::showBox
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT sp.rowid as id, sp.lastname, sp.firstname, sp.civility as civility_id, sp.datec, sp.tms, sp.fk_soc, sp.statut as status, sp.address, sp.zip, sp.town, sp.phone, sp.phone_perso, sp.phone_mobile, sp.email as spemail, s.rowid as socid, s.nom as name, s.name_alias, s.code_client, s.client, s.code_fournisseur, s.code_compta_fournisseur, s.fournisseur, s.code_compta as code_compta_client, s.code_compta_fournisseur, s.logo, s.email, s.entity, co.label as country, co.code as country_code FROM llx_socpeople as sp LEFT JOIN llx_c_country as co ON sp.fk_pays = co.rowid LEFT JOIN llx_societe as s ON sp.fk_soc = s.rowid WHERE sp.entity IN (1) AND ((sp.fk_user_creat = 40 AND sp.priv = 1) OR sp.priv = 0) ORDER BY sp.tms DESC LIMIT 3
2026-03-30 03:23:35 INFO    2018495   1000 box_contacts::showBox
2026-03-30 03:23:35 WARNIN  2018495   1000 Functions.lib::dol_print_date function called with a bad value From /www/wwwroot/doli.xxx.com/htdocs/core/boxes/box_lastlogin.php:101.
2026-03-30 03:23:35 INFO    2018495   1000 box_lastlogin::showBox
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT s.rowid as socid, s.nom as name, s.name_alias, s.code_client, s.code_compta as code_compta_client, s.client, s.logo, s.email, s.entity, c.ref, c.tms, c.rowid, c.date_commande, c.ref_client, c.fk_statut, c.fk_user_valid, c.facture, c.total_ht, c.total_tva, c.total_ttc FROM llx_commande as c, llx_societe as s WHERE c.fk_soc = s.rowid AND c.entity IN (1) ORDER BY c.tms DESC, c.ref DESC  LIMIT 3
2026-03-30 03:23:35 INFO    2018495   1000 box_commandes::showBox
2026-03-30 03:23:35 INFO    2018495   1000 CommandeStats::getNbByMonthWithPrevYear cache file /www/wwwroot/doli.xxx.com/documents/users/temp/CommandeStats_getNbByMonthWithPrevYear_customer_en_US_entity.1_user40.cache is not found or older than now - cachedelay (1774841015 - 86400) so we can't use it.
2026-03-30 03:23:35 DEBUG   2018495   1000 CommandeStats::_getNbByMonth
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT date_format(c.date_commande,'%m') as dm, COUNT(*) as nb FROM llx_commande as c WHERE c.date_commande BETWEEN '2024-01-01 00:00:00' AND '2024-12-31 23:59:59' AND c.entity IN (1) GROUP BY dm ORDER BY dm DESC
2026-03-30 03:23:35 DEBUG   2018495   1000 CommandeStats::_getNbByMonth
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT date_format(c.date_commande,'%m') as dm, COUNT(*) as nb FROM llx_commande as c WHERE c.date_commande BETWEEN '2025-01-01 00:00:00' AND '2025-12-31 23:59:59' AND c.entity IN (1) GROUP BY dm ORDER BY dm DESC
2026-03-30 03:23:35 DEBUG   2018495   1000 CommandeStats::_getNbByMonth
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT date_format(c.date_commande,'%m') as dm, COUNT(*) as nb FROM llx_commande as c WHERE c.date_commande BETWEEN '2026-01-01 00:00:00' AND '2026-12-31 23:59:59' AND c.entity IN (1) GROUP BY dm ORDER BY dm DESC
2026-03-30 03:23:35 INFO    2018495   1000 CommandeStats::getNbByMonthWithPrevYear save cache file /www/wwwroot/doli.xxx.com/documents/users/temp/CommandeStats_getNbByMonthWithPrevYear_customer_en_US_entity.1_user40.cache onto disk.
2026-03-30 03:23:35 INFO    2018495   1000 DolGraph::draw_chart this->type= this->MaxValue=40
2026-03-30 03:23:35 INFO    2018495   1000 CommandeStats::getAmountByMonthWithPrevYear cache file /www/wwwroot/doli.xxx.com/documents/users/temp/CommandeStats_getAmountByMonthWithPrevYear_customer_en_US_entity.1_user40.cache is not found or older than now - cachedelay (1774841015 - 86400) so we can't use it.
2026-03-30 03:23:35 DEBUG   2018495   1000 CommandeStats::_getAmountByMonth
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT date_format(c.date_commande,'%m') as dm, SUM(c.total_ht) FROM llx_commande as c WHERE c.date_commande BETWEEN '2024-01-01 00:00:00' AND '2024-12-31 23:59:59' AND c.entity IN (1) GROUP BY dm ORDER BY dm DESC
2026-03-30 03:23:35 DEBUG   2018495   1000 CommandeStats::_getAmountByMonth
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT date_format(c.date_commande,'%m') as dm, SUM(c.total_ht) FROM llx_commande as c WHERE c.date_commande BETWEEN '2025-01-01 00:00:00' AND '2025-12-31 23:59:59' AND c.entity IN (1) GROUP BY dm ORDER BY dm DESC
2026-03-30 03:23:35 DEBUG   2018495   1000 CommandeStats::_getAmountByMonth
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT date_format(c.date_commande,'%m') as dm, SUM(c.total_ht) FROM llx_commande as c WHERE c.date_commande BETWEEN '2026-01-01 00:00:00' AND '2026-12-31 23:59:59' AND c.entity IN (1) GROUP BY dm ORDER BY dm DESC
2026-03-30 03:23:35 INFO    2018495   1000 CommandeStats::getAmountByMonthWithPrevYear save cache file /www/wwwroot/doli.xxx.com/documents/users/temp/CommandeStats_getAmountByMonthWithPrevYear_customer_en_US_entity.1_user40.cache onto disk.
2026-03-30 03:23:35 INFO    2018495   1000 DolGraph::draw_chart this->type= this->MaxValue=2000000
2026-03-30 03:23:35 INFO    2018495   1000 box_graph_orders_permonth::showBox
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT s.rowid as socid, s.nom as name, s.name_alias, s.code_client, s.code_compta, s.client, s.logo, s.email, s.entity, e.ref, e.tms, e.rowid, e.ref_customer, e.fk_statut, e.fk_user_valid, c.ref as commande_ref, c.rowid as commande_id FROM llx_expedition as e LEFT JOIN llx_element_element as el ON e.rowid = el.fk_target AND el.targettype = 'shipping' AND el.sourcetype IN ('commande') LEFT JOIN llx_commande as c ON el.fk_source = c.rowid AND el.sourcetype IN ('commande') AND el.targettype = 'shipping' LEFT JOIN llx_societe as s ON s.rowid = e.fk_soc WHERE e.entity IN (1) ORDER BY e.tms DESC, e.date_delivery DESC, e.ref DESC LIMIT 3
2026-03-30 03:23:35 INFO    2018495   1000 box_shipments::showBox
2026-03-30 03:23:35 INFO    2018495   1000 FactureStats::getNbByMonthWithPrevYear cache file /www/wwwroot/doli.xxx.com/documents/users/temp/FactureStats_getNbByMonthWithPrevYear_supplier_en_US_entity.1_user40.cache is not found or older than now - cachedelay (1774841015 - 86400) so we can't use it.
2026-03-30 03:23:35 DEBUG   2018495   1000 FactureStats::_getNbByMonth
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT date_format(f.datef,'%m') as dm, COUNT(*) as nb FROM llx_facture_fourn as f WHERE f.datef BETWEEN '2024-01-01 00:00:00' AND '2024-12-31 23:59:59' AND f.entity IN (1) AND f.fk_statut > 0 GROUP BY dm ORDER BY dm DESC
2026-03-30 03:23:35 DEBUG   2018495   1000 FactureStats::_getNbByMonth
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT date_format(f.datef,'%m') as dm, COUNT(*) as nb FROM llx_facture_fourn as f WHERE f.datef BETWEEN '2025-01-01 00:00:00' AND '2025-12-31 23:59:59' AND f.entity IN (1) AND f.fk_statut > 0 GROUP BY dm ORDER BY dm DESC
2026-03-30 03:23:35 DEBUG   2018495   1000 FactureStats::_getNbByMonth
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT date_format(f.datef,'%m') as dm, COUNT(*) as nb FROM llx_facture_fourn as f WHERE f.datef BETWEEN '2026-01-01 00:00:00' AND '2026-12-31 23:59:59' AND f.entity IN (1) AND f.fk_statut > 0 GROUP BY dm ORDER BY dm DESC
2026-03-30 03:23:35 INFO    2018495   1000 FactureStats::getNbByMonthWithPrevYear save cache file /www/wwwroot/doli.xxx.com/documents/users/temp/FactureStats_getNbByMonthWithPrevYear_supplier_en_US_entity.1_user40.cache onto disk.
2026-03-30 03:23:35 INFO    2018495   1000 DolGraph::draw_chart this->type= this->MaxValue=200
2026-03-30 03:23:35 INFO    2018495   1000 FactureStats::getAmountByMonthWithPrevYear cache file /www/wwwroot/doli.xxx.com/documents/users/temp/FactureStats_getAmountByMonthWithPrevYear_supplier_en_US_entity.1_user40.cache is not found or older than now - cachedelay (1774841015 - 86400) so we can't use it.
2026-03-30 03:23:35 DEBUG   2018495   1000 FactureStats::_getAmountByMonth
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT date_format(datef,'%m') as dm, SUM(f.total_ht) FROM llx_facture_fourn as f WHERE f.datef BETWEEN '2024-01-01 00:00:00' AND '2024-12-31 23:59:59' AND f.entity IN (1) AND f.fk_statut > 0 GROUP BY dm ORDER BY dm DESC
2026-03-30 03:23:35 DEBUG   2018495   1000 FactureStats::_getAmountByMonth
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT date_format(datef,'%m') as dm, SUM(f.total_ht) FROM llx_facture_fourn as f WHERE f.datef BETWEEN '2025-01-01 00:00:00' AND '2025-12-31 23:59:59' AND f.entity IN (1) AND f.fk_statut > 0 GROUP BY dm ORDER BY dm DESC
2026-03-30 03:23:35 DEBUG   2018495   1000 FactureStats::_getAmountByMonth
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT date_format(datef,'%m') as dm, SUM(f.total_ht) FROM llx_facture_fourn as f WHERE f.datef BETWEEN '2026-01-01 00:00:00' AND '2026-12-31 23:59:59' AND f.entity IN (1) AND f.fk_statut > 0 GROUP BY dm ORDER BY dm DESC
2026-03-30 03:23:35 INFO    2018495   1000 FactureStats::getAmountByMonthWithPrevYear save cache file /www/wwwroot/doli.xxx.com/documents/users/temp/FactureStats_getAmountByMonthWithPrevYear_supplier_en_US_entity.1_user40.cache onto disk.
2026-03-30 03:23:35 INFO    2018495   1000 DolGraph::draw_chart this->type= this->MaxValue=600000
2026-03-30 03:23:35 INFO    2018495   1000 box_graph_invoices_supplier_permonth::showBox
2026-03-30 03:23:35 INFO    2018495   1000 CommandeStats::getNbByMonthWithPrevYear cache file /www/wwwroot/doli.xxx.com/documents/users/temp/CommandeStats_getNbByMonthWithPrevYear_supplier_en_US_entity.1_user40.cache is not found or older than now - cachedelay (1774841015 - 86400) so we can't use it.
2026-03-30 03:23:35 DEBUG   2018495   1000 CommandeStats::_getNbByMonth
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT date_format(c.date_commande,'%m') as dm, COUNT(*) as nb FROM llx_commande_fournisseur as c WHERE c.date_commande BETWEEN '2024-01-01 00:00:00' AND '2024-12-31 23:59:59' AND c.entity IN (1) GROUP BY dm ORDER BY dm DESC
2026-03-30 03:23:35 DEBUG   2018495   1000 CommandeStats::_getNbByMonth
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT date_format(c.date_commande,'%m') as dm, COUNT(*) as nb FROM llx_commande_fournisseur as c WHERE c.date_commande BETWEEN '2025-01-01 00:00:00' AND '2025-12-31 23:59:59' AND c.entity IN (1) GROUP BY dm ORDER BY dm DESC
2026-03-30 03:23:35 DEBUG   2018495   1000 CommandeStats::_getNbByMonth
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT date_format(c.date_commande,'%m') as dm, COUNT(*) as nb FROM llx_commande_fournisseur as c WHERE c.date_commande BETWEEN '2026-01-01 00:00:00' AND '2026-12-31 23:59:59' AND c.entity IN (1) GROUP BY dm ORDER BY dm DESC
2026-03-30 03:23:35 INFO    2018495   1000 CommandeStats::getNbByMonthWithPrevYear save cache file /www/wwwroot/doli.xxx.com/documents/users/temp/CommandeStats_getNbByMonthWithPrevYear_supplier_en_US_entity.1_user40.cache onto disk.
2026-03-30 03:23:35 INFO    2018495   1000 DolGraph::draw_chart this->type= this->MaxValue=100
2026-03-30 03:23:35 INFO    2018495   1000 CommandeStats::getAmountByMonthWithPrevYear cache file /www/wwwroot/doli.xxx.com/documents/users/temp/CommandeStats_getAmountByMonthWithPrevYear_supplier_en_US_entity.1_user40.cache is not found or older than now - cachedelay (1774841015 - 86400) so we can't use it.
2026-03-30 03:23:35 DEBUG   2018495   1000 CommandeStats::_getAmountByMonth
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT date_format(c.date_commande,'%m') as dm, SUM(c.total_ht) FROM llx_commande_fournisseur as c WHERE c.date_commande BETWEEN '2024-01-01 00:00:00' AND '2024-12-31 23:59:59' AND c.entity IN (1) GROUP BY dm ORDER BY dm DESC
2026-03-30 03:23:35 DEBUG   2018495   1000 CommandeStats::_getAmountByMonth
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT date_format(c.date_commande,'%m') as dm, SUM(c.total_ht) FROM llx_commande_fournisseur as c WHERE c.date_commande BETWEEN '2025-01-01 00:00:00' AND '2025-12-31 23:59:59' AND c.entity IN (1) GROUP BY dm ORDER BY dm DESC
2026-03-30 03:23:35 DEBUG   2018495   1000 CommandeStats::_getAmountByMonth
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT date_format(c.date_commande,'%m') as dm, SUM(c.total_ht) FROM llx_commande_fournisseur as c WHERE c.date_commande BETWEEN '2026-01-01 00:00:00' AND '2026-12-31 23:59:59' AND c.entity IN (1) GROUP BY dm ORDER BY dm DESC
2026-03-30 03:23:35 INFO    2018495   1000 CommandeStats::getAmountByMonthWithPrevYear save cache file /www/wwwroot/doli.xxx.com/documents/users/temp/CommandeStats_getAmountByMonthWithPrevYear_supplier_en_US_entity.1_user40.cache onto disk.
2026-03-30 03:23:35 INFO    2018495   1000 DolGraph::draw_chart this->type= this->MaxValue=500000
2026-03-30 03:23:35 INFO    2018495   1000 box_graph_orders_supplier_permonth::showBox
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT s.rowid as socid, s.nom as name, s.name_alias, s.code_fournisseur, s.code_compta_fournisseur, s.fournisseur, s.logo, s.email, s.entity, s.datec, s.tms, s.status FROM llx_societe as s WHERE s.fournisseur = 1 AND s.entity IN (1) ORDER BY s.tms DESC  LIMIT 3
2026-03-30 03:23:35 INFO    2018495   1000 box_fournisseurs::showBox
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT s.rowid as socid, s.nom as name, s.name_alias, s.code_fournisseur, s.code_compta_fournisseur, s.fournisseur, s.logo, s.email, s.entity, s.tva_intra, s.siren, s.siret, s.ape, s.idprof4, s.idprof5, s.idprof6, f.rowid as facid, f.ref, f.ref_supplier, f.date_lim_reglement as datelimite, f.datef as df, f.total_ht, f.total_tva, f.total_ttc, f.paye, f.fk_statut as status, f.type, f.tms, SUM(pf.amount) as am FROM llx_societe as s,llx_facture_fourn as f LEFT JOIN llx_paiementfourn_facturefourn as pf ON f.rowid = pf.fk_facturefourn WHERE f.fk_soc = s.rowid AND f.entity IN (1) AND f.paye = 0 AND fk_statut = 1 GROUP BY s.rowid, s.nom, s.name_alias, s.code_fournisseur, s.code_compta_fournisseur, s.fournisseur, s.logo, s.email, s.entity, s.tva_intra, s.siren, s.siret, s.ape, s.idprof4, s.idprof5, s.idprof6, f.rowid, f.ref, f.ref_supplier, f.date_lim_reglement, f.type, f.datef, f.total_ht, f.total_tva, f.total_ttc, f.paye, f.fk_statut, f.tms ORDER BY datelimite ASC, f.ref_supplier ASC LIMIT 4
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT SUM(f.total_ht) as total_ht  FROM llx_societe as s,llx_facture_fourn as f LEFT JOIN llx_paiementfourn_facturefourn as pf ON f.rowid = pf.fk_facturefourn WHERE f.fk_soc = s.rowid AND f.entity IN (1) AND f.paye = 0 AND fk_statut = 1
2026-03-30 03:23:35 INFO    2018495   1000 box_factures_fourn_imp::showBox
2026-03-30 03:23:35 INFO    2018495   1000 ModeleBoxes::showBox
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT a.id, a.datep as dp FROM llx_actioncomm as a LEFT JOIN llx_actioncomm_resources AS ar ON a.id = ar.fk_actioncomm AND ar.element_type ='user' AND ar.fk_element = 40 WHERE 1 = 1 AND a.percent >= 0 AND a.percent < 100 AND a.entity IN (1) AND (a.fk_user_author = 40 OR a.fk_user_action = 40 OR ar.fk_element = 40)
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT ctc.rowid, ctc.code FROM llx_c_type_contact as ctc WHERE ctc.element = 'project' AND ctc.source = 'internal'
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT p.rowid, p.ref FROM llx_projet as p WHERE p.entity IN (1) AND (p.public = 1 OR EXISTS (SELECT ec.rowid FROM llx_element_contact as ec WHERE ec.element_id = p.rowid AND ec.fk_c_type_contact IN (51,50) AND ec.fk_socpeople = 40))
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT p.rowid, p.fk_statut as status, p.fk_opp_status, p.datee as datee FROM (llx_projet as p) LEFT JOIN llx_societe as s on p.fk_soc = s.rowid WHERE p.fk_statut = 1 AND p.entity IN (1) AND p.rowid IN (36)
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT ctc.rowid, ctc.code FROM llx_c_type_contact as ctc WHERE ctc.element = 'project' AND ctc.source = 'internal'
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT p.rowid, p.ref FROM llx_projet as p WHERE p.entity IN (1) AND (p.public = 1 OR EXISTS (SELECT ec.rowid FROM llx_element_contact as ec WHERE ec.element_id = p.rowid AND ec.fk_c_type_contact IN (51,50) AND ec.fk_socpeople = 40))
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT p.rowid as projectid, p.fk_statut as projectstatus, t.rowid as taskid, t.progress as progress, t.fk_statut as status, t.dateo as date_start, t.datee as date_end FROM llx_projet as p, llx_projet_task as t WHERE p.entity IN (1) AND p.fk_statut = 1 AND t.fk_projet = p.rowid AND (t.progress IS NULL OR t.progress < 100) AND p.rowid IN (36)
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT p.rowid, p.ref, p.datec as datec, p.date_cloture as datefin FROM llx_supplier_proposal as p WHERE p.entity IN (1) AND p.fk_statut = 1
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT p.rowid, p.ref, p.datec as datec, p.date_cloture as datefin FROM llx_supplier_proposal as p WHERE p.entity IN (1) AND p.fk_statut = 2
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT c.rowid, c.date_creation as datec, c.date_commande, c.date_livraison as delivery_date, c.fk_statut, c.total_ht FROM llx_commande as c WHERE c.entity IN (1) AND c.fk_statut IN (1,2)
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT c.rowid, c.date_creation as datec, c.date_commande, c.date_livraison as delivery_date, c.fk_statut, c.total_ht FROM llx_commande as c WHERE c.entity IN (1) AND c.fk_statut IN (3) AND c.facture = 0
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT c.rowid, c.date_creation as datec, c.date_commande, c.fk_statut, c.date_livraison as delivery_date, c.total_ht FROM llx_commande_fournisseur as c WHERE c.entity = 1 AND c.fk_statut IN (1, 2)
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT c.rowid, c.date_creation as datec, c.date_commande, c.fk_statut, c.date_livraison as delivery_date, c.total_ht FROM llx_commande_fournisseur as c WHERE c.entity = 1 AND c.fk_statut IN (3, 4)
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT f.rowid, f.date_lim_reglement as datefin, f.fk_statut as status, f.total_ht FROM llx_facture as f WHERE f.paye=0 AND f.entity IN (1) AND f.fk_statut = 1
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT ff.rowid, ff.date_lim_reglement as datefin, ff.fk_statut as status, ff.total_ht, ff.total_ttc FROM llx_facture_fourn as ff WHERE ff.paye = 0 AND ff.fk_statut IN (1) AND ff.entity = 1
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT COUNT(ba.rowid) as nb FROM llx_bank_account as ba WHERE ba.rappro > 0 and ba.clos = 0 AND ba.entity IN (1) AND ba.courant != 2
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT b.rowid, b.datev as datefin FROM llx_bank as b, llx_bank_account as ba WHERE b.rappro=0 AND b.fk_account = ba.rowid AND ba.entity IN (1) AND (ba.rappro = 1 AND ba.courant != 2) AND clos = 0
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT b.rowid, b.datev as datefin FROM llx_bank as b, llx_bank_account as ba WHERE b.fk_account = ba.rowid AND ba.entity IN (1) AND b.fk_type = 'CHQ' AND b.fk_bordereau = 0 AND b.amount > 0
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT h.rowid, h.date_debut FROM llx_holiday as h WHERE h.statut = 2 AND h.entity IN (1) AND (h.fk_user IN (40) OR h.fk_validator IN (40))
2026-03-30 03:23:35 DEBUG   2018495   1000 sql=SELECT rowid, date_end_planned FROM llx_mrp_mo WHERE status IN (1, 2) AND entity IN (1)
2026-03-30 03:23:35 INFO    2018495   1000 --- End access to /index.php

jonbendtsen · March 30, 2026, 7:13am

What Problems? I only see DEBUG, INFO and NOTICE lines. I do not see any lines with ERR or WARNING.

WARNING example line

jonbendtsen@Jons-MacBook-Pro a % grep WARN xx*
xx07_index.php:2026-03-29 15:08:18 WARNING 102.128.173.9    692247     33 functions::dol_include_once Tried to load unexisting file: /core/boxes/box_members.php
xx07_index.php:2026-03-29 15:08:18 WARNING 102.128.173.9    692247     33 Failed to load box 'box_members' into file '/core/boxes/box_members.php'
xx07_index.php:2026-03-29 15:08:18 WARNING 102.128.173.9    692247     33 Functions.lib::dol_print_date function called with a bad value from page /index.php

ERR line example

jonbendtsen@Jons-MacBook-Pro a % grep ERR xx*                               
xx02_adherents_list.php:2026-03-29 15:08:04 ERR     102.128.173.9    689083     33 DoliDBMysqli::query Exception in query instead of returning an error: Incorrect integer value: '' for column `dolibarr`.`llx_extrafields`.`printable` at row 1
xx02_adherents_list.php:2026-03-29 15:08:04 ERR     102.128.173.9    689083     33 DoliDBMysqli::query SQL Error message: DB_ERROR_1366 Incorrect integer value: '' for column `dolibarr`.`llx_extrafields`.`printable` at row 1 From /var/www/html/dolibarr/htdocs/debugbar/class/TraceableDB.php:362.
xx04_adherents_card.php:2026-03-29 15:08:07 ERR     102.128.173.9    689083     33 DoliDBMysqli::query Exception in query instead of returning an error: Incorrect integer value: '' for column `dolibarr`.`llx_extrafields`.`printable` at row 1
xx04_adherents_card.php:2026-03-29 15:08:07 ERR     102.128.173.9    689083     33 DoliDBMysqli::query SQL Error message: DB_ERROR_1366 Incorrect integer value: '' for column `dolibarr`.`llx_extrafields`.`printable` at row 1 From /var/www/html/dolibarr/htdocs/debugbar/class/TraceableDB.php:362.

TuHao · March 30, 2026, 7:53am

DEBUG ，Isn’t that a problem? @jonbendtsen

Now, the Dolibar.log file grows by 1GB every day

This file was just deleted and within a few minutes it had grown to 37.15MB

jonbendtsen · March 30, 2026, 8:05am

DEBUG shows up because you set the log level too high in the DEBUG logs module

change it to Notice

TuHao · March 30, 2026, 8:17am

Ok, I have modified the Settings. Thank you

@jonbendtsen

TuHao · March 30, 2026, 10:05am

Hello, there are now many “ERR” and “WARNING” errors. Could you please tell me what the problem is? @jonbendtsen

2026-03-30 09:38:12 NOTICE   2018499   1000 --- Access to GET /reception/card.php - action=confirm_valid, massaction=
2026-03-30 09:38:12 ERR      2018499   1000 DoliDBMysqli::query SQL Error query: SELECT obj.rowid, obj.fk_product, obj.label, obj.description, obj.product_type as fk_product_type, obj.qty as qty_asked, obj.date_start, obj.date_end, ed.rowid as receptionline_id, ed.qty, ed.fk_reception as reception_id,  ed.fk_entrepot, e.rowid as reception_id, e.ref as reception_ref, e.date_creation, e.date_valid, e.date_delivery, e.date_reception, p.label as product_label, p.ref, p.fk_product_type, p.rowid as prodid, p.tobatch as product_tobatch, p.description as product_desc FROM llx_receptiondet_batch as ed, llx_reception as e, llx_order_supplierdet as obj LEFT JOIN llx_product as p ON obj.fk_product = p.rowid WHERE e.entity IN (1) AND obj.fk_commande = 4526 AND obj.rowid = ed.fk_elementdet AND ed.fk_reception = e.rowid AND ed.fk_reception !=2393 ORDER BY obj.fk_product
2026-03-30 09:38:12 ERR      2018499   1000 DoliDBMysqli::query SQL Error message: DB_ERROR_NOSUCHTABLE Table 'doli_xxx_com.llx_order_supplierdet' doesn't exist From /www/wwwroot/doli.xxx.com/htdocs/reception/card.php:2501.
2026-03-30 09:38:14 NOTICE   2053603   1000 --- Access to GET /reception/card.php - action=edittrueWeight, massaction=
2026-03-30 09:38:14 ERR      2053603   1000 DoliDBMysqli::query SQL Error query: SELECT obj.rowid, obj.fk_product, obj.label, obj.description, obj.product_type as fk_product_type, obj.qty as qty_asked, obj.date_start, obj.date_end, ed.rowid as receptionline_id, ed.qty, ed.fk_reception as reception_id,  ed.fk_entrepot, e.rowid as reception_id, e.ref as reception_ref, e.date_creation, e.date_valid, e.date_delivery, e.date_reception, p.label as product_label, p.ref, p.fk_product_type, p.rowid as prodid, p.tobatch as product_tobatch, p.description as product_desc FROM llx_receptiondet_batch as ed, llx_reception as e, llx_order_supplierdet as obj LEFT JOIN llx_product as p ON obj.fk_product = p.rowid WHERE e.entity IN (1) AND obj.fk_commande = 4526 AND obj.rowid = ed.fk_elementdet AND ed.fk_reception = e.rowid AND ed.fk_reception !=2393 ORDER BY obj.fk_product
2026-03-30 09:38:14 ERR      2053603   1000 DoliDBMysqli::query SQL Error message: DB_ERROR_NOSUCHTABLE Table 'doli_xxx_com.llx_order_supplierdet' doesn't exist From /www/wwwroot/doli.xxx.com/htdocs/reception/card.php:2501.
2026-03-30 09:38:14 NOTICE   2018523   1000 --- Access to GET /index.php - action= - actionlogin= - showing the login form and exit
2026-03-30 09:38:17 NOTICE   2018504   1000 --- Access to POST /reception/card.php - action=settrueWeight, massaction=
2026-03-30 09:38:17 NOTICE   2018505   1000 --- Access to GET /reception/card.php - action=, massaction=
2026-03-30 09:38:17 ERR      2018505   1000 DoliDBMysqli::query SQL Error query: SELECT obj.rowid, obj.fk_product, obj.label, obj.description, obj.product_type as fk_product_type, obj.qty as qty_asked, obj.date_start, obj.date_end, ed.rowid as receptionline_id, ed.qty, ed.fk_reception as reception_id,  ed.fk_entrepot, e.rowid as reception_id, e.ref as reception_ref, e.date_creation, e.date_valid, e.date_delivery, e.date_reception, p.label as product_label, p.ref, p.fk_product_type, p.rowid as prodid, p.tobatch as product_tobatch, p.description as product_desc FROM llx_receptiondet_batch as ed, llx_reception as e, llx_order_supplierdet as obj LEFT JOIN llx_product as p ON obj.fk_product = p.rowid WHERE e.entity IN (1) AND obj.fk_commande = 4526 AND obj.rowid = ed.fk_elementdet AND ed.fk_reception = e.rowid AND ed.fk_reception !=2393 ORDER BY obj.fk_product
2026-03-30 09:38:17 ERR      2018505   1000 DoliDBMysqli::query SQL Error message: DB_ERROR_NOSUCHTABLE Table 'doli_xxx_com.llx_order_supplierdet' doesn't exist From /www/wwwroot/doli.xxx.com/htdocs/reception/card.php:2501.
2026-03-30 09:38:20 NOTICE   2018501   1000 --- Access to POST /core/ajax/ajaxtooltip.php - action=, massaction= NOTOKENRENEWAL=1
2026-03-30 09:38:20 NOTICE   2018522   1000 --- Access to GET /fourn/commande/card.php - action=, massaction=
2026-03-30 09:38:30 NOTICE   2018496   1000 --- Access to GET /fourn/commande/dispatch.php - action=, massaction=
2026-03-30 09:38:32 NOTICE   2018509   1000 --- Access to GET /fourn/commande/card.php - action=, massaction=
2026-03-30 09:38:49 WARNING  2018499   1000 --- Access to POST /core/ajax/ajaxtooltip.php refused by CSRF protection (invalid token), so we disable POST and some GET parameters - referrer=https://doli.xxx.com/fourn/commande/list.php?sortfield=cf.date_commande&sortorder=desc&begin=&leftmenu=orders_suppliers&contextpage=supplierorderlist&search_project_ref=, action=, _GET|POST['token']=0e60b5d0bcc32db1dd02d987b6e7b1d7
2026-03-30 09:38:49 NOTICE   2018499   1000 --- Access to POST /core/ajax/ajaxtooltip.php - action=, massaction= NOTOKENRENEWAL=1
2026-03-30 09:38:49 WARNING  2018499   1000 functions::dol_include_once Tried to load unexisting file: //class/.class.php
2026-03-30 09:40:12 WARNING  2018503   1000 --- Access to POST /core/ajax/ajaxtooltip.php refused by CSRF protection (invalid token), so we disable POST and some GET parameters - referrer=https://doli.xxx.com/fourn/commande/list.php?sortfield=cf.date_commande&sortorder=desc&begin=&leftmenu=orders_suppliers&contextpage=supplierorderlist&search_project_ref=, action=, _GET|POST['token']=0e60b5d0bcc32db1dd02d987b6e7b1d7
2026-03-30 09:40:12 NOTICE   2018503   1000 --- Access to POST /core/ajax/ajaxtooltip.php - action=, massaction= NOTOKENRENEWAL=1
2026-03-30 09:40:12 WARNING  2018503   1000 functions::dol_include_once Tried to load unexisting file: //class/.class.php
2026-03-30 09:40:12 WARNING  2018509   1000 --- Access to POST /core/ajax/ajaxtooltip.php refused by CSRF protection (invalid token), so we disable POST and some GET parameters - referrer=https://doli.xxx.com/fourn/commande/list.php?sortfield=cf.date_commande&sortorder=desc&begin=&leftmenu=orders_suppliers&contextpage=supplierorderlist&search_project_ref=, action=, _GET|POST['token']=0e60b5d0bcc32db1dd02d987b6e7b1d7
2026-03-30 09:40:12 NOTICE   2018509   1000 --- Access to POST /core/ajax/ajaxtooltip.php - action=, massaction= NOTOKENRENEWAL=1
2026-03-30 09:40:12 WARNING  2018509   1000 functions::dol_include_once Tried to load unexisting file: //class/.class.php
2026-03-30 09:41:30 NOTICE   2018503   1000 --- Access to GET /document.php - action=, massaction= NOTOKENRENEWAL=1
2026-03-30 09:43:40 NOTICE   2018522   1000 --- Access to POST /commande/card.php - action=send, massaction=
2026-03-30 09:43:40 NOTICE   2018522   1000 CMailFile::sendfile: sendMsg, HOST=ssl://smtp.qiye.aliyun.com, PORT=465
2026-03-30 09:43:41 NOTICE   2018524   1000 --- Access to GET /commande/card.php - action=, massaction=
2026-03-30 09:48:53 WARNING  2018502   1000 --- Access to POST /core/ajax/ajaxtooltip.php refused by CSRF protection (invalid token), so we disable POST and some GET parameters - referrer=https://doli.xxx.com/fourn/commande/list.php?sortfield=cf.date_commande&sortorder=desc&begin=&leftmenu=orders_suppliers&contextpage=supplierorderlist&search_project_ref=, action=, _GET|POST['token']=0e60b5d0bcc32db1dd02d987b6e7b1d7
2026-03-30 09:48:53 NOTICE   2018502   1000 --- Access to POST /core/ajax/ajaxtooltip.php - action=, massaction= NOTOKENRENEWAL=1
2026-03-30 09:48:53 WARNING  2018502   1000 functions::dol_include_once Tried to load unexisting file: //class/.class.php
2026-03-30 09:48:53 NOTICE   2053603   1000 --- Access to GET /hrm/index.php - action=, massaction=
2026-03-30 09:48:53 NOTICE   2018523   1000 --- Access to GET /viewimage.php - action=, massaction= NOTOKENRENEWAL=1
2026-03-30 09:48:54 NOTICE   2018504   1000 --- Access to GET /compta/index.php - action=, massaction=
2026-03-30 09:48:54 NOTICE   2018505   1000 --- Access to GET /viewimage.php - action=, massaction= NOTOKENRENEWAL=1
2026-03-30 09:48:56 NOTICE   2018501   1000 --- Access to GET /compta/bank/various_payment/list.php - action=, massaction=
2026-03-30 09:48:56 NOTICE   2018498   1000 --- Access to GET /viewimage.php - action=, massaction= NOTOKENRENEWAL=1

jonbendtsen · March 30, 2026, 10:50am

hey @TuHao

it seems to be related to the reception module - is that something you use?

2026-03-30 09:38:12 NOTICE   2018499   1000 --- Access to GET /reception/card.php - action=confirm_valid, massaction=
2026-03-30 09:38:12 ERR      2018499   1000 DoliDBMysqli::query SQL Error query: SELECT obj.rowid, obj.fk_product, obj.label, obj.description, obj.product_type as fk_product_type, obj.qty as qty_asked, obj.date_start, obj.date_end, ed.rowid as receptionline_id, ed.qty, ed.fk_reception as reception_id,  ed.fk_entrepot, e.rowid as reception_id, e.ref as reception_ref, e.date_creation, e.date_valid, e.date_delivery, e.date_reception, p.label as product_label, p.ref, p.fk_product_type, p.rowid as prodid, p.tobatch as product_tobatch, p.description as product_desc FROM llx_receptiondet_batch as ed, llx_reception as e, llx_order_supplierdet as obj LEFT JOIN llx_product as p ON obj.fk_product = p.rowid WHERE e.entity IN (1) AND obj.fk_commande = 4526 AND obj.rowid = ed.fk_elementdet AND ed.fk_reception = e.rowid AND ed.fk_reception !=2393 ORDER BY obj.fk_product
2026-03-30 09:38:12 ERR      2018499   1000 DoliDBMysqli::query SQL Error message: DB_ERROR_NOSUCHTABLE Table 'doli_xxx_com.llx_order_supplierdet' doesn't exist From /www/wwwroot/doli.xxx.com/htdocs/reception/card.php:2501.
2026-03-30 09:38:14 NOTICE   2053603   1000 --- Access to GET /reception/card.php - action=edittrueWeight, massaction=
2026-03-30 09:38:14 ERR      2053603   1000 DoliDBMysqli::query SQL Error query: SELECT obj.rowid, obj.fk_product, obj.label, obj.description, obj.product_type as fk_product_type, obj.qty as qty_asked, obj.date_start, obj.date_end, ed.rowid as receptionline_id, ed.qty, ed.fk_reception as reception_id,  ed.fk_entrepot, e.rowid as reception_id, e.ref as reception_ref, e.date_creation, e.date_valid, e.date_delivery, e.date_reception, p.label as product_label, p.ref, p.fk_product_type, p.rowid as prodid, p.tobatch as product_tobatch, p.description as product_desc FROM llx_receptiondet_batch as ed, llx_reception as e, llx_order_supplierdet as obj LEFT JOIN llx_product as p ON obj.fk_product = p.rowid WHERE e.entity IN (1) AND obj.fk_commande = 4526 AND obj.rowid = ed.fk_elementdet AND ed.fk_reception = e.rowid AND ed.fk_reception !=2393 ORDER BY obj.fk_product
2026-03-30 09:38:14 ERR      2053603   1000 DoliDBMysqli::query SQL Error message: DB_ERROR_NOSUCHTABLE Table 'doli_xxx_com.llx_order_supplierdet' doesn't exist From /www/wwwroot/doli.xxx.com/htdocs/reception/card.php:2501.
2026-03-30 09:38:14 NOTICE   2018523   1000 --- Access to GET /index.php - action= - actionlogin= - showing the login form and exit
2026-03-30 09:38:17 NOTICE   2018504   1000 --- Access to POST /reception/card.php - action=settrueWeight, massaction=
2026-03-30 09:38:17 NOTICE   2018505   1000 --- Access to GET /reception/card.php - action=, massaction=
2026-03-30 09:38:17 ERR      2018505   1000 DoliDBMysqli::query SQL Error query: SELECT obj.rowid, obj.fk_product, obj.label, obj.description, obj.product_type as fk_product_type, obj.qty as qty_asked, obj.date_start, obj.date_end, ed.rowid as receptionline_id, ed.qty, ed.fk_reception as reception_id,  ed.fk_entrepot, e.rowid as reception_id, e.ref as reception_ref, e.date_creation, e.date_valid, e.date_delivery, e.date_reception, p.label as product_label, p.ref, p.fk_product_type, p.rowid as prodid, p.tobatch as product_tobatch, p.description as product_desc FROM llx_receptiondet_batch as ed, llx_reception as e, llx_order_supplierdet as obj LEFT JOIN llx_product as p ON obj.fk_product = p.rowid WHERE e.entity IN (1) AND obj.fk_commande = 4526 AND obj.rowid = ed.fk_elementdet AND ed.fk_reception = e.rowid AND ed.fk_reception !=2393 ORDER BY obj.fk_product
2026-03-30 09:38:17 ERR      2018505   1000 DoliDBMysqli::query SQL Error message: DB_ERROR_NOSUCHTABLE Table 'doli_xxx_com.llx_order_supplierdet' doesn't exist From /www/wwwroot/doli.xxx.com/htdocs/reception/card.php:2501.

And this looks like tooltips on a vendor order

2026-03-30 09:38:49 WARNING  2018499   1000 --- Access to POST /core/ajax/ajaxtooltip.php refused by CSRF protection (invalid token), so we disable POST and some GET parameters - referrer=https://doli.xxx.com/fourn/commande/list.php?sortfield=cf.date_commande&sortorder=desc&begin=&leftmenu=orders_suppliers&contextpage=supplierorderlist&search_project_ref=, action=, _GET|POST['token']=0e60b5d0bcc32db1dd02d987b6e7b1d7
2026-03-30 09:38:49 NOTICE   2018499   1000 --- Access to POST /core/ajax/ajaxtooltip.php - action=, massaction= NOTOKENRENEWAL=1
2026-03-30 09:38:49 WARNING  2018499   1000 functions::dol_include_once Tried to load unexisting file: //class/.class.php
2026-03-30 09:40:12 WARNING  2018503   1000 --- Access to POST /core/ajax/ajaxtooltip.php refused by CSRF protection (invalid token), so we disable POST and some GET parameters - referrer=https://doli.xxx.com/fourn/commande/list.php?sortfield=cf.date_commande&sortorder=desc&begin=&leftmenu=orders_suppliers&contextpage=supplierorderlist&search_project_ref=, action=, _GET|POST['token']=0e60b5d0bcc32db1dd02d987b6e7b1d7
2026-03-30 09:40:12 NOTICE   2018503   1000 --- Access to POST /core/ajax/ajaxtooltip.php - action=, massaction= NOTOKENRENEWAL=1
2026-03-30 09:40:12 WARNING  2018503   1000 functions::dol_include_once Tried to load unexisting file: //class/.class.php
2026-03-30 09:40:12 WARNING  2018509   1000 --- Access to POST /core/ajax/ajaxtooltip.php refused by CSRF protection (invalid token), so we disable POST and some GET parameters - referrer=https://doli.xxx.com/fourn/commande/list.php?sortfield=cf.date_commande&sortorder=desc&begin=&leftmenu=orders_suppliers&contextpage=supplierorderlist&search_project_ref=, action=, _GET|POST['token']=0e60b5d0bcc32db1dd02d987b6e7b1d7
2026-03-30 09:40:12 NOTICE   2018509   1000 --- Access to POST /core/ajax/ajaxtooltip.php - action=, massaction= NOTOKENRENEWAL=1

Try reloading that order page - does it still happen?

TuHao · March 31, 2026, 3:24am

@jonbendtsen

No errors were found when opening the purchase order

When opening reception/card.php, the following error was found

2026-03-31 11:19:09 ERR     2018505    1000 DoliDBMysqli::query SQL Error query: SELECT obj.rowid, obj.fk_product, obj.label, obj.description, obj.product_type as fk_product_type, obj.qty as qty_asked, obj.date_start, obj.date_end, ed.rowid as receptionline_id, ed.qty, ed.fk_reception as reception_id,  ed.fk_entrepot, e.rowid as reception_id, e.ref as reception_ref, e.date_creation, e.date_valid, e.date_delivery, e.date_reception, p.label as product_label, p.ref, p.fk_product_type, p.rowid as prodid, p.tobatch as product_tobatch, p.description as product_desc FROM llx_receptiondet_batch as ed, llx_reception as e, llx_order_supplierdet as obj LEFT JOIN llx_product as p ON obj.fk_product = p.rowid WHERE e.entity IN (1) AND obj.fk_commande = 4572 AND obj.rowid = ed.fk_elementdet AND ed.fk_reception = e.rowid AND ed.fk_reception !=2387 ORDER BY obj.fk_product
error

2026-03-31 11:19:09 ERR     2018505    1000 DoliDBMysqli::query SQL Error message: DB_ERROR_NOSUCHTABLE Table 'doli_xxx_com.llx_order_supplierdet' doesn't exist From /www/wwwroot/doli.xxx.com/htdocs/debugbar/class/TraceableDB.php:362.
Search

TuHao · March 31, 2026, 4:00am

The data table “llx_order_supplierdet” was not seen in the database

I just tested it, but I didn’t see this data table in the newly installed Dolibarr either、

@jonbendtsen

jonbendtsen · March 31, 2026, 8:13am

@TuHao yeah I also can not find that table in the database. I think this error has started because they want to transition away from french names for the database tables:

This screenshot is from my v23.0.0 installation.

Okay, so now we:

go here GitHub - Dolibarr/dolibarr: Dolibarr ERP CRM is a modern software package to manage your company or foundation's activity (contacts, suppliers, invoices, orders, stocks, agenda, accounting, ...). it's an open source Web application (written in PHP) designed for businesses of any sizes, foundations and freelancers. · GitHub
navigate htdocs/, reception/, and click on card.php
Now make sure you shift to tag 23.0.1 in the left side because you run 23.0.1 not development.
Search for LEFT JOIN and you find that there is only one place with a LEFT JOIN
You notice the line number, 2492, and switch in the top to Blame not Code
You see who changed that line 4 months ago calling the commit Debug v23 and you click that
This will take you to a commit, and at the bottom of that commit you can make a comment.

In that comment I would write this:

Hi @eldy

I think this commit has introduced an error which we have discussed here:

https://www.dolibarr.org/forum/t/im-using-version-23-0-1-which-has-a-bug/31088/7

Alternatively if you can, you could create and test a working fix, which you then submit as a Pull request, complete with links here and links to the commit in case and also do look for any existing issues at Dolibarrs github page. There might also be an Pull Request that someone else has started.

What I think is missing is that the table has been renamed to `llx_order_supplierdet``

So what I would create if I where you would be this file:

htdocs/install/mysql/migration/23.0.1-23.0.2.sql

And what it contains is an ALTER TABLE that changes the table name from llx_commande_fournisseurdet to llx_order_supplierdet

TuHao · March 31, 2026, 8:24am

Hello @jonbendtsen
I’m not very familiar with the above operations

Can I directly change llx_commande_fournisseurdet to llx_order_supplierdet on Navicat ?

jonbendtsen · March 31, 2026, 8:33am

@TuHao okay, and I don’t know what Navicat is.

The minimum I think you should do is to search for an issue on dolibarrs github page for this issue, and no do not just state that 23.0.1 has a bug, be super specific, state that it can not find the new table name, but that the old one exists. Then you also include a link to this thread.

Until you get a fix, what you can actually do is to somehow change the name of the table to llx_order_supplierdet - BUT have in mind that the code elsewhere might be looking for llx_commande_fournisseurdet.

TuHao · March 31, 2026, 9:22am

@jonbendtsen

Navicat is a database management software, It can directly modify the name of the data table

It is true that the “llx_commande_fournisseurdet” data table is being used in other places

If I change the name, it might lead to other errors. What should I do now?

jonbendtsen · March 31, 2026, 10:29am

You should fix it everywhere or pay someone to fix it everywhere or wait for someone to fix it everywhere.