2025-10-29 02:25:21 DEBUG 192.168.1.183 5603 33 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2025-10-29 02:25:21 DEBUG 192.168.1.183 5603 33 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, u.statut as status, u.lang, u.entity, u.datec as datec, u.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_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 = 'admin' ORDER BY u.entity ASC 2025-10-29 02:25:21 DEBUG 192.168.1.183 5603 33 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, aiprompt, css, cssview, csslist FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2025-10-29 02:25:21 DEBUG 192.168.1.183 5603 33 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2025-10-29 02:25:21 DEBUG 192.168.1.183 5603 33 DefaultValues::fetchAll 2025-10-29 02:25:21 DEBUG 192.168.1.183 5603 33 sql=SELECT rowid, type, user_id, page, param, value FROM llx_default_values as t WHERE 1 = 1 AND ((t.user_id IN (0,1)) AND (entity IN (0,1))) 2025-10-29 02:25:21 DEBUG 192.168.1.183 5603 33 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 = 1 AND r.perms IS NOT NULL AND r.perms NOT LIKE '%_advance' 2025-10-29 02:25:21 DEBUG 192.168.1.183 5603 33 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 = 1 AND r.perms IS NOT NULL AND r.perms NOT LIKE '%_advance' 2025-10-29 02:25:21 NOTICE 192.168.1.183 5603 33 --- Access to GET - action=create, massaction= 2025-10-29 02:25:21 DEBUG 192.168.1.183 5603 33 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 2025-10-29 02:25:21 DEBUG 192.168.1.183 5603 33 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 2025-10-29 02:25:21 DEBUG 192.168.1.183 5603 33 User::loadParentOf 2025-10-29 02:25:21 DEBUG 192.168.1.183 5603 33 sql=SELECT fk_user as id_parent, rowid as id_son FROM llx_user WHERE fk_user <> 0 AND entity IN (0,1) 2025-10-29 02:25:21 DEBUG 192.168.1.183 5603 33 User::get_full_tree get user list 2025-10-29 02:25:21 DEBUG 192.168.1.183 5603 33 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) 2025-10-29 02:25:21 DEBUG 192.168.1.183 5603 33 User::get_full_tree call to build_path_from_id_user 2025-10-29 02:25:21 DEBUG 192.168.1.183 5603 33 User::get_full_tree dol_sort_array 2025-10-29 02:25:21 INFO 192.168.1.183 5603 33 Build childid for id = 1 2025-10-29 02:25:21 DEBUG 192.168.1.183 5603 33 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, aiprompt, css, cssview, csslist FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2025-10-29 02:25:21 DEBUG 192.168.1.183 5603 33 sql=SELECT rowid, code, label, url, icon, active FROM llx_c_socialnetworks WHERE entity=1 2025-10-29 02:25:21 DEBUG 192.168.1.183 5603 33 sql=SELECT COUNT(rowid) as nb FROM llx_user WHERE entity IN (0,1) 2025-10-29 02:25:21 DEBUG 192.168.1.183 5603 33 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 = 'US' AND t.active = 1 AND t.entity IN (1) AND t.localtax1_type <> '0' 2025-10-29 02:25:21 DEBUG 192.168.1.183 5603 33 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 = 'US' AND t.active = 1 AND t.entity IN (1) AND t.localtax2_type <> '0' 2025-10-29 02:25:21 DEBUG 192.168.1.183 5603 33 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 = 'US' AND t.active = 1 AND t.entity IN (1) AND t.localtax1_type <> '0' 2025-10-29 02:25:21 DEBUG 192.168.1.183 5603 33 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 = 'US' AND t.active = 1 AND t.entity IN (1) AND t.localtax2_type <> '0' 2025-10-29 02:25:21 DEBUG 192.168.1.183 5603 33 Form::select_civility 2025-10-29 02:25:21 DEBUG 192.168.1.183 5603 33 sql=SELECT rowid, code, label, active FROM llx_c_civility WHERE active = 1 2025-10-29 02:25:21 DEBUG 192.168.1.183 5603 33 Form::select_dolusers 2025-10-29 02:25:21 DEBUG 192.168.1.183 5603 33 sql=SELECT DISTINCT u.rowid, u.lastname as lastname, u.firstname, u.statut as status, u.login, u.admin, u.entity, u.gender, u.photo FROM llx_user as u WHERE u.entity IN (0,1) ORDER BY u.statut DESC, u.firstname ASC, u.lastname ASC 2025-10-29 02:25:21 DEBUG 192.168.1.183 5603 33 Form::select_country 2025-10-29 02:25:21 DEBUG 192.168.1.183 5603 33 sql=SELECT rowid, code as code_iso, code_iso as code_iso3, label, favorite, eec FROM llx_c_country WHERE active > 0 2025-10-29 02:25:21 DEBUG 192.168.1.183 5603 33 FormCompany::select_departement selected=, country_codeid= 2025-10-29 02:25:21 DEBUG 192.168.1.183 5603 33 sql=SELECT d.rowid, d.code_departement as code, d.nom as name, d.active, c.label as country, c.code as country_code, r.nom as region_name FROM llx_c_departements as d, llx_c_regions as r,llx_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement 2025-10-29 02:25:21 DEBUG 192.168.1.183 5603 33 FormCompany::select_departement num=1837 2025-10-29 02:25:21 INFO 192.168.1.183 5603 33 DolEditor::DolEditor htmlname=signature width= height=138 toolbarname=dolibarr_notes uselocalbrowser=0 2025-10-29 02:25:21 INFO 192.168.1.183 5603 33 DolEditor::DolEditor htmlname=note_public width= height=100 toolbarname=dolibarr_notes uselocalbrowser=1 2025-10-29 02:25:21 INFO 192.168.1.183 5603 33 DolEditor::DolEditor htmlname=note_private width= height=100 toolbarname=dolibarr_notes uselocalbrowser=1 2025-10-29 02:25:21 INFO 192.168.1.183 5603 33 --- End access to unknown 2025-10-29 02:25:31 DEBUG 192.168.1.183 1139 33 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2025-10-29 02:25:31 DEBUG 192.168.1.183 1139 33 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, u.statut as status, u.lang, u.entity, u.datec as datec, u.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_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 = 'admin' ORDER BY u.entity ASC 2025-10-29 02:25:31 DEBUG 192.168.1.183 1139 33 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, aiprompt, css, cssview, csslist FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2025-10-29 02:25:31 DEBUG 192.168.1.183 1139 33 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2025-10-29 02:25:31 DEBUG 192.168.1.183 1139 33 DefaultValues::fetchAll 2025-10-29 02:25:31 DEBUG 192.168.1.183 1139 33 sql=SELECT rowid, type, user_id, page, param, value FROM llx_default_values as t WHERE 1 = 1 AND ((t.user_id IN (0,1)) AND (entity IN (0,1))) 2025-10-29 02:25:31 DEBUG 192.168.1.183 1139 33 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 = 1 AND r.perms IS NOT NULL AND r.perms NOT LIKE '%_advance' 2025-10-29 02:25:31 DEBUG 192.168.1.183 1139 33 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 = 1 AND r.perms IS NOT NULL AND r.perms NOT LIKE '%_advance' 2025-10-29 02:25:31 NOTICE 192.168.1.183 1139 33 --- Access to POST - action=create, massaction= 2025-10-29 02:25:31 DEBUG 192.168.1.183 1139 33 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 2025-10-29 02:25:31 DEBUG 192.168.1.183 1139 33 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 2025-10-29 02:25:31 DEBUG 192.168.1.183 1139 33 User::loadParentOf 2025-10-29 02:25:31 DEBUG 192.168.1.183 1139 33 sql=SELECT fk_user as id_parent, rowid as id_son FROM llx_user WHERE fk_user <> 0 AND entity IN (0,1) 2025-10-29 02:25:31 DEBUG 192.168.1.183 1139 33 User::get_full_tree get user list 2025-10-29 02:25:31 DEBUG 192.168.1.183 1139 33 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) 2025-10-29 02:25:31 DEBUG 192.168.1.183 1139 33 User::get_full_tree call to build_path_from_id_user 2025-10-29 02:25:31 DEBUG 192.168.1.183 1139 33 User::get_full_tree dol_sort_array 2025-10-29 02:25:31 INFO 192.168.1.183 1139 33 Build childid for id = 1 2025-10-29 02:25:31 DEBUG 192.168.1.183 1139 33 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, aiprompt, css, cssview, csslist FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2025-10-29 02:25:31 DEBUG 192.168.1.183 1139 33 sql=SELECT rowid, code, label, url, icon, active FROM llx_c_socialnetworks WHERE entity=1 2025-10-29 02:25:31 DEBUG 192.168.1.183 1139 33 sql=SELECT COUNT(rowid) as nb FROM llx_user WHERE entity IN (0,1) 2025-10-29 02:25:31 DEBUG 192.168.1.183 1139 33 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 = 'US' AND t.active = 1 AND t.entity IN (1) AND t.localtax1_type <> '0' 2025-10-29 02:25:31 DEBUG 192.168.1.183 1139 33 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 = 'US' AND t.active = 1 AND t.entity IN (1) AND t.localtax2_type <> '0' 2025-10-29 02:25:31 DEBUG 192.168.1.183 1139 33 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 = 'US' AND t.active = 1 AND t.entity IN (1) AND t.localtax1_type <> '0' 2025-10-29 02:25:31 DEBUG 192.168.1.183 1139 33 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 = 'US' AND t.active = 1 AND t.entity IN (1) AND t.localtax2_type <> '0' 2025-10-29 02:25:31 DEBUG 192.168.1.183 1139 33 Form::select_civility 2025-10-29 02:25:31 DEBUG 192.168.1.183 1139 33 sql=SELECT rowid, code, label, active FROM llx_c_civility WHERE active = 1 2025-10-29 02:25:31 DEBUG 192.168.1.183 1139 33 Form::select_dolusers 2025-10-29 02:25:31 DEBUG 192.168.1.183 1139 33 sql=SELECT DISTINCT u.rowid, u.lastname as lastname, u.firstname, u.statut as status, u.login, u.admin, u.entity, u.gender, u.photo FROM llx_user as u WHERE u.entity IN (0,1) ORDER BY u.statut DESC, u.firstname ASC, u.lastname ASC 2025-10-29 02:25:31 DEBUG 192.168.1.183 1139 33 Form::select_country 2025-10-29 02:25:31 DEBUG 192.168.1.183 1139 33 sql=SELECT rowid, code as code_iso, code_iso as code_iso3, label, favorite, eec FROM llx_c_country WHERE active > 0 2025-10-29 02:25:31 DEBUG 192.168.1.183 1139 33 FormCompany::select_departement selected=, country_codeid= 2025-10-29 02:25:31 DEBUG 192.168.1.183 1139 33 sql=SELECT d.rowid, d.code_departement as code, d.nom as name, d.active, c.label as country, c.code as country_code, r.nom as region_name FROM llx_c_departements as d, llx_c_regions as r,llx_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement 2025-10-29 02:25:31 DEBUG 192.168.1.183 1139 33 FormCompany::select_departement num=1837 2025-10-29 02:25:31 INFO 192.168.1.183 1139 33 DolEditor::DolEditor htmlname=signature width= height=138 toolbarname=dolibarr_notes uselocalbrowser=0 2025-10-29 02:25:31 INFO 192.168.1.183 1139 33 DolEditor::DolEditor htmlname=note_public width= height=100 toolbarname=dolibarr_notes uselocalbrowser=1 2025-10-29 02:25:31 INFO 192.168.1.183 1139 33 DolEditor::DolEditor htmlname=note_private width= height=100 toolbarname=dolibarr_notes uselocalbrowser=1 2025-10-29 02:25:31 INFO 192.168.1.183 1139 33 --- End access to unknown