Bonjour,
Voici les lignes du journal après le nouvel essai.
Cordialement,
2019-02-01 08:40:24 INFO 78.209.101.169 functions_dolibarr::check_user_password_dolibarr Authentification ok - md5 of pass is ok
2019-02-01 08:40:24 DEBUG 78.209.101.169 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.signature, u.office_phone, u.office_fax, u.user_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, 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.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llxap_user as u LEFT JOIN llxap_c_country as c ON u.fk_country = c.rowid LEFT JOIN llxap_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'Benoitadmin' ORDER BY u.entity ASC
2019-02-01 08:40:24 INFO 78.209.101.169 fetch_name_optionals_label elementtype=user
2019-02-01 08:40:24 DEBUG 78.209.101.169 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,fielddefault,fieldcomputed,entity,enabled FROM llxap_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos
2019-02-01 08:40:24 DEBUG 78.209.101.169 sql=SELECT param, value FROM llxap_user_param WHERE fk_user = 1 AND entity = 1
2019-02-01 08:40:24 DEBUG 78.209.101.169 sql=SELECT rowid, entity, type, page, param, value FROM llxap_default_values WHERE entity IN (0,1) AND user_id IN (0, 1)
2019-02-01 08:40:24 INFO 78.209.101.169 This is a new started user session. _SESSION['dol_login']=Benoitadmin Session id=oua0efrvtvvbr3bsrlte9pe0b5
2019-02-01 08:40:24 DEBUG 78.209.101.169 BEGIN Transaction
2019-02-01 08:40:24 DEBUG 78.209.101.169 User::update_last_login_date user->id=1 UPDATE llxap_user SET datepreviouslogin = datelastlogin, datelastlogin = '2019-02-01 08:40:24', tms = tms WHERE rowid = 1
2019-02-01 08:40:24 DEBUG 78.209.101.169 sql=UPDATE llxap_user SET datepreviouslogin = datelastlogin, datelastlogin = '2019-02-01 08:40:24', tms = tms WHERE rowid = 1
2019-02-01 08:40:25 DEBUG 78.209.101.169 COMMIT Transaction
2019-02-01 08:40:25 DEBUG 78.209.101.169 sql=SELECT r.module, r.perms, r.subperms FROM llxap_user_rights as ur, llxap_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
2019-02-01 08:40:25 DEBUG 78.209.101.169 sql=SELECT r.module, r.perms, r.subperms FROM llxap_usergroup_rights as gr, llxap_usergroup_user as gu, llxap_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
2019-02-01 08:40:25 INFO 78.209.101.169 --- Access to /admin/index.php - action=, massaction=
2019-02-01 08:40:25 DEBUG 78.209.101.169 sql=SELECT transkey, transvalue FROM llxap_overwrite_trans where lang='fr_FR'
2019-02-01 08:40:25 DEBUG 78.209.101.169 Menubase::menuLoad mymainmenu=home myleftmenu= type_user=0 menu_handler=eldy tabMenu size=0
2019-02-01 08:40:25 DEBUG 78.209.101.169 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llxap_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.position, m.rowid
2019-02-01 08:40:25 INFO 78.209.101.169 --- End access to /admin/index.php
2019-02-01 08:40:26 INFO 78.209.101.169 --- Access to /theme/eldy/style.css.php - action=, massaction=
2019-02-01 08:40:26 DEBUG 78.209.101.169 sql=SELECT transkey, transvalue FROM llxap_overwrite_trans where lang='fr_FR'
2019-02-01 08:40:26 DEBUG 78.209.101.169 Menubase::menuLoad mymainmenu=home myleftmenu= type_user=0 menu_handler=eldy tabMenu size=0
2019-02-01 08:40:26 DEBUG 78.209.101.169 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llxap_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.position, m.rowid
2019-02-01 08:40:26 DEBUG 78.209.101.169 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.signature, u.office_phone, u.office_fax, u.user_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, 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.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llxap_user as u LEFT JOIN llxap_c_country as c ON u.fk_country = c.rowid LEFT JOIN llxap_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.login = 'Benoitadmin' ORDER BY u.entity ASC
2019-02-01 08:40:26 INFO 78.209.101.169 fetch_name_optionals_label elementtype=user
2019-02-01 08:40:26 DEBUG 78.209.101.169 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,fielddefault,fieldcomputed,entity,enabled FROM llxap_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos
2019-02-01 08:40:26 DEBUG 78.209.101.169 sql=SELECT param, value FROM llxap_user_param WHERE fk_user = 1 AND entity = 1
2019-02-01 08:40:26 DEBUG 78.209.101.169 sql=SELECT rowid, entity, type, page, param, value FROM llxap_default_values WHERE entity IN (0,1) AND user_id IN (0, 1)
2019-02-01 08:40:26 INFO 78.209.101.169 --- End access to /theme/eldy/style.css.php
2019-02-01 08:40:26 INFO 78.209.101.169 --- Access to /core/js/lib_foot.js.php - action=, massaction=
2019-02-01 08:40:26 DEBUG 78.209.101.169 sql=SELECT transkey, transvalue FROM llxap_overwrite_trans where lang='fr_FR'
2019-02-01 08:40:26 INFO 78.209.101.169 --- End access to /core/js/lib_foot.js.php
2019-02-01 08:40:31 DEBUG 78.209.101.169 - This is an already logged session. _SESSION['dol_login']=Benoitadmin _SESSION['dol_entity']=1
2019-02-01 08:40:31 DEBUG 78.209.101.169 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.signature, u.office_phone, u.office_fax, u.user_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, 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.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llxap_user as u LEFT JOIN llxap_c_country as c ON u.fk_country = c.rowid LEFT JOIN llxap_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'Benoitadmin' ORDER BY u.entity ASC
2019-02-01 08:40:31 INFO 78.209.101.169 fetch_name_optionals_label elementtype=user
2019-02-01 08:40:31 DEBUG 78.209.101.169 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,fielddefault,fieldcomputed,entity,enabled FROM llxap_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos
2019-02-01 08:40:31 DEBUG 78.209.101.169 sql=SELECT param, value FROM llxap_user_param WHERE fk_user = 1 AND entity = 1
2019-02-01 08:40:31 DEBUG 78.209.101.169 sql=SELECT rowid, entity, type, page, param, value FROM llxap_default_values WHERE entity IN (0,1) AND user_id IN (0, 1)
2019-02-01 08:40:31 DEBUG 78.209.101.169 sql=SELECT r.module, r.perms, r.subperms FROM llxap_user_rights as ur, llxap_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
2019-02-01 08:40:31 DEBUG 78.209.101.169 sql=SELECT r.module, r.perms, r.subperms FROM llxap_usergroup_rights as gr, llxap_usergroup_user as gu, llxap_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
2019-02-01 08:40:31 INFO 78.209.101.169 --- Access to /accountancy/index.php - action=, massaction=
2019-02-01 08:40:31 DEBUG 78.209.101.169 sql=SELECT transkey, transvalue FROM llxap_overwrite_trans where lang='fr_FR'
2019-02-01 08:40:31 DEBUG 78.209.101.169 Menubase::menuLoad mymainmenu=accountancy myleftmenu= type_user=0 menu_handler=eldy tabMenu size=0
2019-02-01 08:40:31 DEBUG 78.209.101.169 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llxap_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.position, m.rowid
2019-02-01 08:40:31 DEBUG 78.209.101.169 sql=SELECT rowid, code, label, nature FROM llxap_accounting_journal WHERE entity = 1 AND active = 1 ORDER BY label DESC
2019-02-01 08:40:31 INFO 78.209.101.169 --- End access to /accountancy/index.php
2019-02-01 08:40:33 DEBUG 78.209.101.169 - This is an already logged session. _SESSION['dol_login']=Benoitadmin _SESSION['dol_entity']=1
2019-02-01 08:40:33 DEBUG 78.209.101.169 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.signature, u.office_phone, u.office_fax, u.user_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, 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.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llxap_user as u LEFT JOIN llxap_c_country as c ON u.fk_country = c.rowid LEFT JOIN llxap_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'Benoitadmin' ORDER BY u.entity ASC
2019-02-01 08:40:33 INFO 78.209.101.169 fetch_name_optionals_label elementtype=user
2019-02-01 08:40:33 DEBUG 78.209.101.169 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,fielddefault,fieldcomputed,entity,enabled FROM llxap_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos
2019-02-01 08:40:33 DEBUG 78.209.101.169 sql=SELECT param, value FROM llxap_user_param WHERE fk_user = 1 AND entity = 1
2019-02-01 08:40:33 DEBUG 78.209.101.169 sql=SELECT rowid, entity, type, page, param, value FROM llxap_default_values WHERE entity IN (0,1) AND user_id IN (0, 1)
2019-02-01 08:40:33 DEBUG 78.209.101.169 sql=SELECT r.module, r.perms, r.subperms FROM llxap_user_rights as ur, llxap_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
2019-02-01 08:40:33 DEBUG 78.209.101.169 sql=SELECT r.module, r.perms, r.subperms FROM llxap_usergroup_rights as gr, llxap_usergroup_user as gu, llxap_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
2019-02-01 08:40:33 INFO 78.209.101.169 --- Access to /accountancy/index.php - action=, massaction=
2019-02-01 08:40:33 DEBUG 78.209.101.169 sql=SELECT transkey, transvalue FROM llxap_overwrite_trans where lang='fr_FR'
2019-02-01 08:40:33 DEBUG 78.209.101.169 Menubase::menuLoad mymainmenu=accountancy myleftmenu=accountancy_admin type_user=0 menu_handler=eldy tabMenu size=0
2019-02-01 08:40:33 DEBUG 78.209.101.169 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llxap_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.position, m.rowid
2019-02-01 08:40:33 DEBUG 78.209.101.169 sql=SELECT rowid, code, label, nature FROM llxap_accounting_journal WHERE entity = 1 AND active = 1 ORDER BY label DESC
2019-02-01 08:40:33 INFO 78.209.101.169 --- End access to /accountancy/index.php
2019-02-01 08:40:36 DEBUG 78.209.101.169 - This is an already logged session. _SESSION['dol_login']=Benoitadmin _SESSION['dol_entity']=1
2019-02-01 08:40:36 DEBUG 78.209.101.169 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.signature, u.office_phone, u.office_fax, u.user_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, 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.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llxap_user as u LEFT JOIN llxap_c_country as c ON u.fk_country = c.rowid LEFT JOIN llxap_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'Benoitadmin' ORDER BY u.entity ASC
2019-02-01 08:40:36 INFO 78.209.101.169 fetch_name_optionals_label elementtype=user
2019-02-01 08:40:36 DEBUG 78.209.101.169 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,fielddefault,fieldcomputed,entity,enabled FROM llxap_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos
2019-02-01 08:40:36 DEBUG 78.209.101.169 sql=SELECT param, value FROM llxap_user_param WHERE fk_user = 1 AND entity = 1
2019-02-01 08:40:36 DEBUG 78.209.101.169 sql=SELECT rowid, entity, type, page, param, value FROM llxap_default_values WHERE entity IN (0,1) AND user_id IN (0, 1)
2019-02-01 08:40:36 DEBUG 78.209.101.169 sql=SELECT r.module, r.perms, r.subperms FROM llxap_user_rights as ur, llxap_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
2019-02-01 08:40:36 DEBUG 78.209.101.169 sql=SELECT r.module, r.perms, r.subperms FROM llxap_usergroup_rights as gr, llxap_usergroup_user as gu, llxap_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
2019-02-01 08:40:36 INFO 78.209.101.169 --- Access to /accountancy/admin/account.php - action=, massaction=
2019-02-01 08:40:36 DEBUG 78.209.101.169 sql=SELECT transkey, transvalue FROM llxap_overwrite_trans where lang='fr_FR'
2019-02-01 08:40:36 DEBUG 78.209.101.169 Menubase::menuLoad mymainmenu=accountancy myleftmenu=accountancy_admin type_user=0 menu_handler=eldy tabMenu size=0
2019-02-01 08:40:36 DEBUG 78.209.101.169 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llxap_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.position, m.rowid
2019-02-01 08:40:36 DEBUG 78.209.101.169 sql=SELECT rowid, code, label, nature FROM llxap_accounting_journal WHERE entity = 1 AND active = 1 ORDER BY label DESC
2019-02-01 08:40:36 DEBUG 78.209.101.169 sql=SELECT aa.rowid, aa.fk_pcg_version, aa.pcg_type, aa.pcg_subtype, aa.account_number, aa.account_parent , aa.label, aa.active, a2.rowid as rowid2, a2.label as label2, a2.account_number as account_number2 FROM llxap_accounting_account as aa LEFT JOIN llxap_accounting_system as asy ON aa.fk_pcg_version = asy.pcg_version AND aa.entity = 1 LEFT JOIN llxap_accounting_account as a2 ON a2.rowid = aa.account_parent AND a2.entity = 1 WHERE asy.rowid = 3 ORDER BY aa.account_number ASC
2019-02-01 08:40:36 INFO 78.209.101.169 accountancy/admin/account.php:: $sql=SELECT aa.rowid, aa.fk_pcg_version, aa.pcg_type, aa.pcg_subtype, aa.account_number, aa.account_parent , aa.label, aa.active, a2.rowid as rowid2, a2.label as label2, a2.account_number as account_number2 FROM llxap_accounting_account as aa LEFT JOIN llxap_accounting_system as asy ON aa.fk_pcg_version = asy.pcg_version AND aa.entity = 1 LEFT JOIN llxap_accounting_account as a2 ON a2.rowid = aa.account_parent AND a2.entity = 1 WHERE asy.rowid = 3 ORDER BY aa.account_number ASC LIMIT 26
2019-02-01 08:40:36 DEBUG 78.209.101.169 sql=SELECT aa.rowid, aa.fk_pcg_version, aa.pcg_type, aa.pcg_subtype, aa.account_number, aa.account_parent , aa.label, aa.active, a2.rowid as rowid2, a2.label as label2, a2.account_number as account_number2 FROM llxap_accounting_account as aa LEFT JOIN llxap_accounting_system as asy ON aa.fk_pcg_version = asy.pcg_version AND aa.entity = 1 LEFT JOIN llxap_accounting_account as a2 ON a2.rowid = aa.account_parent AND a2.entity = 1 WHERE asy.rowid = 3 ORDER BY aa.account_number ASC LIMIT 26
2019-02-01 08:40:36 INFO 78.209.101.169 accountancy/admin/account.php $sql=SELECT a.rowid, a.pcg_version, a.label, a.active, c.code as country_code FROM llxap_accounting_system as a LEFT JOIN llxap_c_country as c ON a.fk_country = c.rowid WHERE a.active = 1
2019-02-01 08:40:36 DEBUG 78.209.101.169 sql=SELECT a.rowid, a.pcg_version, a.label, a.active, c.code as country_code FROM llxap_accounting_system as a LEFT JOIN llxap_c_country as c ON a.fk_country = c.rowid WHERE a.active = 1
2019-02-01 08:40:36 INFO 78.209.101.169 --- End access to /accountancy/admin/account.php
2019-02-01 08:40:44 DEBUG 78.209.101.169 - This is an already logged session. _SESSION['dol_login']=Benoitadmin _SESSION['dol_entity']=1
2019-02-01 08:40:44 DEBUG 78.209.101.169 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.signature, u.office_phone, u.office_fax, u.user_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, 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.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llxap_user as u LEFT JOIN llxap_c_country as c ON u.fk_country = c.rowid LEFT JOIN llxap_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'Benoitadmin' ORDER BY u.entity ASC
2019-02-01 08:40:44 INFO 78.209.101.169 fetch_name_optionals_label elementtype=user
2019-02-01 08:40:44 DEBUG 78.209.101.169 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,fielddefault,fieldcomputed,entity,enabled FROM llxap_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos
2019-02-01 08:40:44 DEBUG 78.209.101.169 sql=SELECT param, value FROM llxap_user_param WHERE fk_user = 1 AND entity = 1
2019-02-01 08:40:44 DEBUG 78.209.101.169 sql=SELECT rowid, entity, type, page, param, value FROM llxap_default_values WHERE entity IN (0,1) AND user_id IN (0, 1)
2019-02-01 08:40:44 DEBUG 78.209.101.169 sql=SELECT r.module, r.perms, r.subperms FROM llxap_user_rights as ur, llxap_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
2019-02-01 08:40:44 DEBUG 78.209.101.169 sql=SELECT r.module, r.perms, r.subperms FROM llxap_usergroup_rights as gr, llxap_usergroup_user as gu, llxap_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
2019-02-01 08:40:44 INFO 78.209.101.169 --- Access to /accountancy/admin/account.php - action=list, massaction=
2019-02-01 08:40:44 DEBUG 78.209.101.169 sql=SELECT transkey, transvalue FROM llxap_overwrite_trans where lang='fr_FR'
2019-02-01 08:40:44 DEBUG 78.209.101.169 Menubase::menuLoad mymainmenu=accountancy myleftmenu=accountancy_admin type_user=0 menu_handler=eldy tabMenu size=0
2019-02-01 08:40:44 DEBUG 78.209.101.169 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llxap_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.position, m.rowid
2019-02-01 08:40:44 DEBUG 78.209.101.169 sql=SELECT code FROM llxap_c_country as c, llxap_accounting_system as a WHERE c.rowid = a.fk_country AND a.rowid = 3
2019-02-01 08:40:44 DEBUG 78.209.101.169 Admin.lib::run_sql run sql file /home/tafenjoy/compta.tafenjoy.fr/install/mysql/data/llx_accounting_account_fr.sql silent=1 entity=1 usesavepoint=1 handler= okerror=default
2019-02-01 08:40:44 ERR 78.209.101.169 Admin.lib::run_sql failed to open file /home/tafenjoy/compta.tafenjoy.fr/install/mysql/data/llx_accounting_account_fr.sql
2019-02-01 08:40:44 DEBUG 78.209.101.169 BEGIN Transaction
2019-02-01 08:40:44 DEBUG 78.209.101.169 admin.lib::dolibarr_set_const
2019-02-01 08:40:44 DEBUG 78.209.101.169 sql=DELETE FROM llxap_const WHERE name = 'CHARTOFACCOUNTS' AND entity = 1
2019-02-01 08:40:44 DEBUG 78.209.101.169 admin.lib::dolibarr_set_const
2019-02-01 08:40:44 DEBUG 78.209.101.169 sql=INSERT INTO llxap_const(name,value,type,visible,note,entity) VALUES ('CHARTOFACCOUNTS', '3','chaine',0,'',1)
2019-02-01 08:40:44 DEBUG 78.209.101.169 COMMIT Transaction
2019-02-01 08:40:44 DEBUG 78.209.101.169 sql=SELECT rowid, code, label, nature FROM llxap_accounting_journal WHERE entity = 1 AND active = 1 ORDER BY label DESC
2019-02-01 08:40:44 DEBUG 78.209.101.169 sql=SELECT aa.rowid, aa.fk_pcg_version, aa.pcg_type, aa.pcg_subtype, aa.account_number, aa.account_parent , aa.label, aa.active, a2.rowid as rowid2, a2.label as label2, a2.account_number as account_number2 FROM llxap_accounting_account as aa LEFT JOIN llxap_accounting_system as asy ON aa.fk_pcg_version = asy.pcg_version AND aa.entity = 1 LEFT JOIN llxap_accounting_account as a2 ON a2.rowid = aa.account_parent AND a2.entity = 1 WHERE asy.rowid = 3 ORDER BY aa.account_number ASC
2019-02-01 08:40:44 INFO 78.209.101.169 accountancy/admin/account.php:: $sql=SELECT aa.rowid, aa.fk_pcg_version, aa.pcg_type, aa.pcg_subtype, aa.account_number, aa.account_parent , aa.label, aa.active, a2.rowid as rowid2, a2.label as label2, a2.account_number as account_number2 FROM llxap_accounting_account as aa LEFT JOIN llxap_accounting_system as asy ON aa.fk_pcg_version = asy.pcg_version AND aa.entity = 1 LEFT JOIN llxap_accounting_account as a2 ON a2.rowid = aa.account_parent AND a2.entity = 1 WHERE asy.rowid = 3 ORDER BY aa.account_number ASC LIMIT 26
2019-02-01 08:40:44 DEBUG 78.209.101.169 sql=SELECT aa.rowid, aa.fk_pcg_version, aa.pcg_type, aa.pcg_subtype, aa.account_number, aa.account_parent , aa.label, aa.active, a2.rowid as rowid2, a2.label as label2, a2.account_number as account_number2 FROM llxap_accounting_account as aa LEFT JOIN llxap_accounting_system as asy ON aa.fk_pcg_version = asy.pcg_version AND aa.entity = 1 LEFT JOIN llxap_accounting_account as a2 ON a2.rowid = aa.account_parent AND a2.entity = 1 WHERE asy.rowid = 3 ORDER BY aa.account_number ASC LIMIT 26
2019-02-01 08:40:44 INFO 78.209.101.169 accountancy/admin/account.php $sql=SELECT a.rowid, a.pcg_version, a.label, a.active, c.code as country_code FROM llxap_accounting_system as a LEFT JOIN llxap_c_country as c ON a.fk_country = c.rowid WHERE a.active = 1
2019-02-01 08:40:44 DEBUG 78.209.101.169 sql=SELECT a.rowid, a.pcg_version, a.label, a.active, c.code as country_code FROM llxap_accounting_system as a LEFT JOIN llxap_c_country as c ON a.fk_country = c.rowid WHERE a.active = 1
2019-02-01 08:40:44 INFO 78.209.101.169 Save lastsearch_values_tmp_accountancy/admin/account.php={"sortfield":"aa.account_number","sortorder":"ASC"} (systematic recording of last search criterias)
2019-02-01 08:40:44 INFO 78.209.101.169 --- End access to /accountancy/admin/account.php
2019-02-01 08:40:48 DEBUG 78.209.101.169 - This is an already logged session. _SESSION['dol_login']=Benoitadmin _SESSION['dol_entity']=1
2019-02-01 08:40:48 DEBUG 78.209.101.169 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.signature, u.office_phone, u.office_fax, u.user_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, 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.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llxap_user as u LEFT JOIN llxap_c_country as c ON u.fk_country = c.rowid LEFT JOIN llxap_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'Benoitadmin' ORDER BY u.entity ASC
2019-02-01 08:40:48 INFO 78.209.101.169 fetch_name_optionals_label elementtype=user
2019-02-01 08:40:48 DEBUG 78.209.101.169 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,fielddefault,fieldcomputed,entity,enabled FROM llxap_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos
2019-02-01 08:40:48 DEBUG 78.209.101.169 sql=SELECT param, value FROM llxap_user_param WHERE fk_user = 1 AND entity = 1
2019-02-01 08:40:48 DEBUG 78.209.101.169 sql=SELECT rowid, entity, type, page, param, value FROM llxap_default_values WHERE entity IN (0,1) AND user_id IN (0, 1)
2019-02-01 08:40:48 DEBUG 78.209.101.169 sql=SELECT r.module, r.perms, r.subperms FROM llxap_user_rights as ur, llxap_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
2019-02-01 08:40:48 DEBUG 78.209.101.169 sql=SELECT r.module, r.perms, r.subperms FROM llxap_usergroup_rights as gr, llxap_usergroup_user as gu, llxap_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
2019-02-01 08:40:48 INFO 78.209.101.169 --- Access to /index.php - action=, massaction=
2019-02-01 08:40:48 DEBUG 78.209.101.169 sql=SELECT transkey, transvalue FROM llxap_overwrite_trans where lang='fr_FR'
2019-02-01 08:40:48 DEBUG 78.209.101.169 Menubase::menuLoad mymainmenu=home myleftmenu=home type_user=0 menu_handler=eldy tabMenu size=0
2019-02-01 08:40:48 DEBUG 78.209.101.169 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llxap_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.position, m.rowid
2019-02-01 08:40:48 DEBUG 78.209.101.169 InfoBox::listBoxes get default box list for mode=activated userid=
2019-02-01 08:40:48 DEBUG 78.209.101.169 sql=SELECT b.rowid, b.position, b.box_order, b.fk_user, d.rowid as box_id, d.file, d.note, d.tms FROM llxap_boxes as b, llxap_boxes_def as d WHERE b.box_id = d.rowid AND b.entity IN (0,1) AND b.position = 0 AND b.fk_user = 0 ORDER BY b.box_order
2019-02-01 08:40:50 INFO 78.209.101.169 box_lastlogin::showBox
2019-02-01 08:40:51 DEBUG 78.209.101.169 sql=SELECT s.nom as name, s.rowid as socid, s.code_fournisseur, s.logo, f.rowid as facid, f.ref, f.ref_supplier, f.total_ht, f.total_tva, f.total_ttc, f.paye, f.fk_statut, f.datef as df, f.datec as datec, f.date_lim_reglement as datelimite, f.tms, f.type FROM llxap_societe as s, llxap_facture_fourn as f WHERE f.fk_soc = s.rowid AND f.entity = 1 ORDER BY f.tms DESC, f.ref DESC LIMIT 5
2019-02-01 08:40:51 INFO 78.209.101.169 box_factures_fourn::showBox
2019-02-01 08:40:51 DEBUG 78.209.101.169 sql=SELECT s.nom as name, s.rowid as socid, s.code_client, s.code_fournisseur, s.logo, c.rowid, c.ref, c.tms, c.date_commande, c.total_ht, c.tva as total_tva, c.total_ttc, c.fk_statut FROM llxap_societe as s, llxap_commande_fournisseur as c WHERE c.fk_soc = s.rowid AND c.entity = 1 ORDER BY c.tms DESC, c.ref DESC LIMIT 5
2019-02-01 08:40:51 INFO 78.209.101.169 box_supplier_orders::showBox
2019-02-01 08:40:51 INFO 78.209.101.169 PropaleStats::getNbByMonthWithPrevYear cache file /home/tafenjoy/dolibarrdata/users/temp/PropaleStats_getNbByMonthWithPrevYear_fr_FR_entity.1_user1.cache is not found or older than now - cachedelay (1549006851 - 86400) so we can't use it.
2019-02-01 08:40:51 DEBUG 78.209.101.169 PropaleStats::_getNbByMonth
2019-02-01 08:40:51 DEBUG 78.209.101.169 sql=SELECT date_format(p.datep,'%m') as dm, COUNT(*) as nb FROM llxap_propal as p WHERE p.datep BETWEEN '2018-01-01 00:00:00' AND '2018-12-31 23:59:59' AND p.fk_statut > 0 AND p.entity IN (1) GROUP BY dm ORDER BY dm DESC
2019-02-01 08:40:51 DEBUG 78.209.101.169 PropaleStats::_getNbByMonth
2019-02-01 08:40:51 DEBUG 78.209.101.169 sql=SELECT date_format(p.datep,'%m') as dm, COUNT(*) as nb FROM llxap_propal as p WHERE p.datep BETWEEN '2019-01-01 00:00:00' AND '2019-12-31 23:59:59' AND p.fk_statut > 0 AND p.entity IN (1) GROUP BY dm ORDER BY dm DESC
2019-02-01 08:40:51 INFO 78.209.101.169 PropaleStats::getNbByMonthWithPrevYear save cache file /home/tafenjoy/dolibarrdata/users/temp/PropaleStats_getNbByMonthWithPrevYear_fr_FR_entity.1_user1.cache onto disk.
2019-02-01 08:40:51 INFO 78.209.101.169 DolGraph::draw_jflot this->type=bars,bars this->MaxValue=0
2019-02-01 08:40:51 INFO 78.209.101.169 PropaleStats::getAmountByMonthWithPrevYear cache file /home/tafenjoy/dolibarrdata/users/temp/PropaleStats_getAmountByMonthWithPrevYear_fr_FR_entity.1_user1.cache is not found or older than now - cachedelay (1549006851 - 86400) so we can't use it.
2019-02-01 08:40:51 DEBUG 78.209.101.169 PropaleStats::_getAmountByMonth
2019-02-01 08:40:51 DEBUG 78.209.101.169 sql=SELECT date_format(p.datep,'%m') as dm, SUM(p.total_ht) FROM llxap_propal as p WHERE p.datep BETWEEN '2018-01-01 00:00:00' AND '2018-12-31 23:59:59' AND p.fk_statut > 0 AND p.entity IN (1) GROUP BY dm ORDER BY dm DESC
2019-02-01 08:40:51 DEBUG 78.209.101.169 PropaleStats::_getAmountByMonth
2019-02-01 08:40:51 DEBUG 78.209.101.169 sql=SELECT date_format(p.datep,'%m') as dm, SUM(p.total_ht) FROM llxap_propal as p WHERE p.datep BETWEEN '2019-01-01 00:00:00' AND '2019-12-31 23:59:59' AND p.fk_statut > 0 AND p.entity IN (1) GROUP BY dm ORDER BY dm DESC
2019-02-01 08:40:51 INFO 78.209.101.169 PropaleStats::getAmountByMonthWithPrevYear save cache file /home/tafenjoy/dolibarrdata/users/temp/PropaleStats_getAmountByMonthWithPrevYear_fr_FR_entity.1_user1.cache onto disk.
2019-02-01 08:40:51 INFO 78.209.101.169 DolGraph::draw_jflot this->type=bars,bars this->MaxValue=0
2019-02-01 08:40:51 INFO 78.209.101.169 box_graph_propales_permonth::showBox
2019-02-01 08:40:51 DEBUG 78.209.101.169 sql=SELECT s.nom as name, s.rowid as socid, s.code_client, s.logo, p.rowid, p.ref, p.fk_statut, p.datep as dp, p.datec, p.fin_validite, p.date_cloture, p.total_ht, p.tva as total_tva, p.total as total_ttc, p.tms FROM llxap_societe as s, llxap_propal as p WHERE p.fk_soc = s.rowid AND p.entity = 1 ORDER BY p.tms DESC, p.ref DESC LIMIT 5
2019-02-01 08:40:51 INFO 78.209.101.169 box_propales::showBox
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT s.nom as name, s.rowid as socid, s.code_client, s.logo, 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.tva as total_tva, c.total_ttc FROM llxap_societe as s, llxap_commande as c WHERE c.fk_soc = s.rowid AND c.entity = 1 ORDER BY c.tms DESC, c.ref DESC LIMIT 5
2019-02-01 08:40:52 INFO 78.209.101.169 box_commandes::showBox
2019-02-01 08:40:52 INFO 78.209.101.169 CommandeStats::getNbByMonthWithPrevYear cache file /home/tafenjoy/dolibarrdata/users/temp/CommandeStats_getNbByMonthWithPrevYear_customer_fr_FR_entity.1_user1.cache is not found or older than now - cachedelay (1549006852 - 86400) so we can't use it.
2019-02-01 08:40:52 DEBUG 78.209.101.169 CommandeStats::_getNbByMonth
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT date_format(c.date_commande,'%m') as dm, COUNT(*) as nb FROM llxap_commande as c WHERE c.date_commande BETWEEN '2018-01-01 00:00:00' AND '2018-12-31 23:59:59' AND c.fk_statut > 0 AND c.entity IN (1) GROUP BY dm ORDER BY dm DESC
2019-02-01 08:40:52 DEBUG 78.209.101.169 CommandeStats::_getNbByMonth
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT date_format(c.date_commande,'%m') as dm, COUNT(*) as nb FROM llxap_commande as c WHERE c.date_commande BETWEEN '2019-01-01 00:00:00' AND '2019-12-31 23:59:59' AND c.fk_statut > 0 AND c.entity IN (1) GROUP BY dm ORDER BY dm DESC
2019-02-01 08:40:52 INFO 78.209.101.169 CommandeStats::getNbByMonthWithPrevYear save cache file /home/tafenjoy/dolibarrdata/users/temp/CommandeStats_getNbByMonthWithPrevYear_customer_fr_FR_entity.1_user1.cache onto disk.
2019-02-01 08:40:52 INFO 78.209.101.169 DolGraph::draw_jflot this->type= this->MaxValue=0
2019-02-01 08:40:52 INFO 78.209.101.169 CommandeStats::getAmountByMonthWithPrevYear cache file /home/tafenjoy/dolibarrdata/users/temp/CommandeStats_getAmountByMonthWithPrevYear_customer_fr_FR_entity.1_user1.cache is not found or older than now - cachedelay (1549006852 - 86400) so we can't use it.
2019-02-01 08:40:52 DEBUG 78.209.101.169 CommandeStats::_getAmountByMonth
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT date_format(c.date_commande,'%m') as dm, SUM(c.total_ht) FROM llxap_commande as c WHERE c.date_commande BETWEEN '2018-01-01 00:00:00' AND '2018-12-31 23:59:59' AND c.fk_statut > 0 AND c.entity IN (1) GROUP BY dm ORDER BY dm DESC
2019-02-01 08:40:52 DEBUG 78.209.101.169 CommandeStats::_getAmountByMonth
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT date_format(c.date_commande,'%m') as dm, SUM(c.total_ht) FROM llxap_commande as c WHERE c.date_commande BETWEEN '2019-01-01 00:00:00' AND '2019-12-31 23:59:59' AND c.fk_statut > 0 AND c.entity IN (1) GROUP BY dm ORDER BY dm DESC
2019-02-01 08:40:52 INFO 78.209.101.169 CommandeStats::getAmountByMonthWithPrevYear save cache file /home/tafenjoy/dolibarrdata/users/temp/CommandeStats_getAmountByMonthWithPrevYear_customer_fr_FR_entity.1_user1.cache onto disk.
2019-02-01 08:40:52 INFO 78.209.101.169 DolGraph::draw_jflot this->type= this->MaxValue=0
2019-02-01 08:40:52 INFO 78.209.101.169 box_graph_orders_permonth::showBox
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT s.nom as name, s.rowid as socid, c.rowid, c.ref, c.statut as fk_statut, c.date_contrat, c.datec, c.fin_validite, c.date_cloture FROM llxap_societe as s, llxap_contrat as c WHERE c.fk_soc = s.rowid AND c.entity = 1 ORDER BY c.tms DESC, c.ref DESC LIMIT 5
2019-02-01 08:40:52 INFO 78.209.101.169 box_contracts::showBox
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT c.rowid, c.ref, c.statut as fk_statut, c.date_contrat, c.ref_customer, c.ref_supplier, s.nom as name, s.rowid as socid, MIN(cd.date_fin_validite) as date_line, COUNT(cd.rowid) as nb_services FROM llxap_contrat as c, llxap_societe s, llxap_contratdet as cd WHERE cd.statut = 4 AND cd.date_fin_validite <= '2019-02-01 08:40:52' AND c.entity = 1 AND c.fk_soc=s.rowid AND cd.fk_contrat=c.rowid AND c.statut > 0 GROUP BY c.rowid, c.ref, c.statut, c.date_contrat, c.ref_customer, c.ref_supplier, s.nom, s.rowid ORDER BY date_line ASC LIMIT 5
2019-02-01 08:40:52 INFO 78.209.101.169 box_services_expired::showBox
2019-02-01 08:40:52 DEBUG 78.209.101.169 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 FROM llxap_product as p WHERE p.entity IN (1) ORDER BY p.datec DESC LIMIT 5
2019-02-01 08:40:52 INFO 78.209.101.169 box_produits::showBox
2019-02-01 08:40:52 INFO 78.209.101.169 FactureStats::getAllByProductEntry cache file /home/tafenjoy/dolibarrdata/users/temp/FactureStats_getAllByProductEntry_customer_fr_FR_entity.1_user1.cache is not found or older than now - cachedelay (1549006852 - 86400) so we can't use it.
2019-02-01 08:40:52 DEBUG 78.209.101.169 FactureStats::_getAllByProduct
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT product.ref, COUNT(product.ref) as nb, SUM(tl.total_ht) as total, AVG(tl.total_ht) as avg FROM llxap_facture as f, llxap_facturedet as tl, llxap_product as product WHERE f.fk_statut > 0 AND f.entity = 1 AND (f.fk_statut <> 3 OR f.close_code <> 'replaced') AND f.type IN (0,1,2,3,5) AND f.rowid = tl.fk_facture AND tl.fk_product = product.rowid AND f.datef BETWEEN '2019-01-01 00:00:00' AND '2019-12-31 23:59:59' GROUP BY product.ref ORDER BY nb DESC
2019-02-01 08:40:52 INFO 78.209.101.169 FactureStats::getAllByProductEntry save cache file /home/tafenjoy/dolibarrdata/users/temp/FactureStats_getAllByProductEntry_customer_fr_FR_entity.1_user1.cache onto disk.
2019-02-01 08:40:52 INFO 78.209.101.169 DolGraph::draw_jflot this->type=pie this->MaxValue=2
2019-02-01 08:40:52 INFO 78.209.101.169 PropaleStats::getAllByProductEntry cache file /home/tafenjoy/dolibarrdata/users/temp/PropaleStats_getAllByProductEntry_fr_FR_entity.1_user1.cache is not found or older than now - cachedelay (1549006852 - 86400) so we can't use it.
2019-02-01 08:40:52 DEBUG 78.209.101.169 PropaleStats::_getAllByProduct
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT product.ref, COUNT(product.ref) as nb, SUM(tl.total_ht) as total, AVG(tl.total_ht) as avg FROM llxap_propal as p, llxap_propaldet as tl, llxap_product as product WHERE p.fk_statut > 0 AND p.entity IN (1) AND p.rowid = tl.fk_propal AND tl.fk_product = product.rowid AND p.datep BETWEEN '2019-01-01 00:00:00' AND '2019-12-31 23:59:59' GROUP BY product.ref ORDER BY nb DESC
2019-02-01 08:40:52 INFO 78.209.101.169 PropaleStats::getAllByProductEntry save cache file /home/tafenjoy/dolibarrdata/users/temp/PropaleStats_getAllByProductEntry_fr_FR_entity.1_user1.cache onto disk.
2019-02-01 08:40:52 INFO 78.209.101.169 DolGraph::draw_jflot this->type=pie this->MaxValue=2
2019-02-01 08:40:52 INFO 78.209.101.169 CommandeStats::getAllByProductEntry cache file /home/tafenjoy/dolibarrdata/users/temp/CommandeStats_getAllByProductEntry_customer_fr_FR_entity.1_user1.cache is not found or older than now - cachedelay (1549006852 - 86400) so we can't use it.
2019-02-01 08:40:52 DEBUG 78.209.101.169 CommandeStats::_getAllByProduct
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT product.ref, COUNT(product.ref) as nb, SUM(tl.total_ht) as total, AVG(tl.total_ht) as avg FROM llxap_commande as c, llxap_commandedet as tl, llxap_product as product WHERE c.fk_statut > 0 AND c.entity IN (1) AND c.rowid = tl.fk_commande AND tl.fk_product = product.rowid AND c.date_commande BETWEEN '2019-01-01 00:00:00' AND '2019-12-31 23:59:59' GROUP BY product.ref ORDER BY nb DESC
2019-02-01 08:40:52 INFO 78.209.101.169 CommandeStats::getAllByProductEntry save cache file /home/tafenjoy/dolibarrdata/users/temp/CommandeStats_getAllByProductEntry_customer_fr_FR_entity.1_user1.cache onto disk.
2019-02-01 08:40:52 INFO 78.209.101.169 DolGraph::draw_jflot this->type=pie this->MaxValue=2
2019-02-01 08:40:52 INFO 78.209.101.169 box_graph_product_distribution::showBox
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT s.nom as name, s.rowid as socid, f.rowid as facid, f.ref, f.ref_supplier, f.date_lim_reglement as datelimite, f.amount, f.datef as df, f.total_ht as total_ht, f.tva as total_tva, f.total_ttc, f.paye, f.fk_statut, f.type FROM llxap_societe as s,llxap_facture_fourn as f WHERE f.fk_soc = s.rowid AND f.entity = 1 AND f.paye=0 AND fk_statut = 1 ORDER BY datelimite DESC, f.ref_supplier DESC LIMIT 5
2019-02-01 08:40:52 INFO 78.209.101.169 box_factures_fourn_imp::showBox
2019-02-01 08:40:52 INFO 78.209.101.169 ModeleBoxes::showBox
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT s.nom as name, s.rowid as socid, s.datec, s.tms, s.status, s.code_fournisseur, s.logo FROM llxap_societe as s WHERE s.fournisseur = 1 AND s.entity IN (1) ORDER BY s.tms DESC LIMIT 5
2019-02-01 08:40:52 INFO 78.209.101.169 box_fournisseurs::showBox
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT s.nom as name, s.rowid as socid, s.email, s.code_client, s.logo, f.facnumber, f.date_lim_reglement as datelimite, f.type, f.amount, f.datef as df, f.total as total_ht, f.tva as total_tva, f.total_ttc, f.paye, f.fk_statut, f.rowid as facid, sum(pf.amount) as am FROM llxap_societe as s, llxap_facture as f LEFT JOIN llxap_paiement_facture as pf ON f.rowid=pf.fk_facture WHERE f.fk_soc = s.rowid AND f.entity = 1 AND f.paye = 0 AND fk_statut = 1 GROUP BY s.nom, s.rowid, s.code_client, s.logo, f.facnumber, f.date_lim_reglement, f.type, f.amount, f.datef, f.total, f.tva, f.total_ttc, f.paye, f.fk_statut, f.rowid ORDER BY datelimite ASC, f.facnumber ASC LIMIT 5
2019-02-01 08:40:52 INFO 78.209.101.169 box_factures_imp::showBox
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT f.rowid as facid, f.facnumber, f.type, f.total as total_ht, f.tva as total_tva, f.total_ttc, f.datef as df, f.paye, f.fk_statut, f.datec, f.tms, s.rowid as socid, s.nom as name, s.code_client, s.email, s.tva_intra, s.code_compta, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, f.date_lim_reglement as datelimite FROM (llxap_societe as s,llxap_facture as f) WHERE f.fk_soc = s.rowid AND f.entity = 1 ORDER BY f.tms DESC, f.facnumber DESC LIMIT 5
2019-02-01 08:40:52 INFO 78.209.101.169 box_factures::showBox
2019-02-01 08:40:52 INFO 78.209.101.169 FactureStats::getNbByMonthWithPrevYear cache file /home/tafenjoy/dolibarrdata/users/temp/FactureStats_getNbByMonthWithPrevYear_customer_fr_FR_entity.1_user1.cache is not found or older than now - cachedelay (1549006852 - 86400) so we can't use it.
2019-02-01 08:40:52 DEBUG 78.209.101.169 FactureStats::_getNbByMonth
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT date_format(f.datef,'%m') as dm, COUNT(*) as nb FROM llxap_facture as f WHERE f.datef BETWEEN '2018-01-01 00:00:00' AND '2018-12-31 23:59:59' AND f.fk_statut > 0 AND f.entity = 1 AND (f.fk_statut <> 3 OR f.close_code <> 'replaced') AND f.type IN (0,1,2,3,5) GROUP BY dm ORDER BY dm DESC
2019-02-01 08:40:52 DEBUG 78.209.101.169 FactureStats::_getNbByMonth
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT date_format(f.datef,'%m') as dm, COUNT(*) as nb FROM llxap_facture as f WHERE f.datef BETWEEN '2019-01-01 00:00:00' AND '2019-12-31 23:59:59' AND f.fk_statut > 0 AND f.entity = 1 AND (f.fk_statut <> 3 OR f.close_code <> 'replaced') AND f.type IN (0,1,2,3,5) GROUP BY dm ORDER BY dm DESC
2019-02-01 08:40:52 INFO 78.209.101.169 FactureStats::getNbByMonthWithPrevYear save cache file /home/tafenjoy/dolibarrdata/users/temp/FactureStats_getNbByMonthWithPrevYear_customer_fr_FR_entity.1_user1.cache onto disk.
2019-02-01 08:40:52 INFO 78.209.101.169 DolGraph::draw_jflot this->type= this->MaxValue=0
2019-02-01 08:40:52 INFO 78.209.101.169 FactureStats::getAmountByMonthWithPrevYear cache file /home/tafenjoy/dolibarrdata/users/temp/FactureStats_getAmountByMonthWithPrevYear_customer_fr_FR_entity.1_user1.cache is not found or older than now - cachedelay (1549006852 - 86400) so we can't use it.
2019-02-01 08:40:52 DEBUG 78.209.101.169 FactureStats::_getAmountByMonth
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT date_format(datef,'%m') as dm, SUM(f.total) FROM llxap_facture as f WHERE f.datef BETWEEN '2018-01-01 00:00:00' AND '2018-12-31 23:59:59' AND f.fk_statut > 0 AND f.entity = 1 AND (f.fk_statut <> 3 OR f.close_code <> 'replaced') AND f.type IN (0,1,2,3,5) GROUP BY dm ORDER BY dm DESC
2019-02-01 08:40:52 DEBUG 78.209.101.169 FactureStats::_getAmountByMonth
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT date_format(datef,'%m') as dm, SUM(f.total) FROM llxap_facture as f WHERE f.datef BETWEEN '2019-01-01 00:00:00' AND '2019-12-31 23:59:59' AND f.fk_statut > 0 AND f.entity = 1 AND (f.fk_statut <> 3 OR f.close_code <> 'replaced') AND f.type IN (0,1,2,3,5) GROUP BY dm ORDER BY dm DESC
2019-02-01 08:40:52 INFO 78.209.101.169 FactureStats::getAmountByMonthWithPrevYear save cache file /home/tafenjoy/dolibarrdata/users/temp/FactureStats_getAmountByMonthWithPrevYear_customer_fr_FR_entity.1_user1.cache onto disk.
2019-02-01 08:40:52 INFO 78.209.101.169 DolGraph::draw_jflot this->type= this->MaxValue=0
2019-02-01 08:40:52 INFO 78.209.101.169 box_graph_invoices_permonth::showBox
2019-02-01 08:40:52 DEBUG 78.209.101.169 box_clients::loadBox
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT s.nom as name, s.rowid as socid, s.code_client, s.client, s.code_fournisseur, s.fournisseur, s.code_compta, s.code_compta_fournisseur, s.logo, s.email, s.datec, s.tms, s.status FROM llxap_societe as s WHERE s.client IN (1, 3) AND s.entity IN (1) ORDER BY s.tms DESC LIMIT 5
2019-02-01 08:40:52 INFO 78.209.101.169 box_clients::showBox
2019-02-01 08:40:52 DEBUG 78.209.101.169 box_prospect::loadBox
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT s.nom as name, s.rowid as socid, s.code_client, s.client, s.code_fournisseur, s.fournisseur, s.logo, s.fk_stcomm, s.datec, s.tms, s.status FROM llxap_societe as s WHERE s.client IN (2, 3) AND s.entity IN (1) ORDER BY s.tms DESC LIMIT 5
2019-02-01 08:40:52 INFO 78.209.101.169 box_prospect::showBox
2019-02-01 08:40:52 DEBUG 78.209.101.169 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, s.nom as socname, s.name_alias, s.client, s.fournisseur, s.code_client, s.code_fournisseur FROM llxap_socpeople as sp LEFT JOIN llxap_societe as s ON sp.fk_soc = s.rowid WHERE sp.entity IN (1) ORDER BY sp.tms DESC LIMIT 5
2019-02-01 08:40:52 INFO 78.209.101.169 box_contacts::showBox
2019-02-01 08:40:52 DEBUG 78.209.101.169 box_comptes::loadBox
2019-02-01 08:40:52 DEBUG 78.209.101.169 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, 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 llxap_bank_account as b LEFT JOIN llxap_accounting_journal as aj ON aj.rowid=b.fk_accountancy_journal WHERE b.entity = 1 AND clos = 0 ORDER BY label LIMIT 5
2019-02-01 08:40:52 INFO 78.209.101.169 box_comptes::showBox
2019-02-01 08:40:52 INFO 78.209.101.169 FactureStats::getNbByMonthWithPrevYear cache file /home/tafenjoy/dolibarrdata/users/temp/FactureStats_getNbByMonthWithPrevYear_supplier_fr_FR_entity.1_user1.cache is not found or older than now - cachedelay (1549006852 - 86400) so we can't use it.
2019-02-01 08:40:52 DEBUG 78.209.101.169 FactureStats::_getNbByMonth
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT date_format(f.datef,'%m') as dm, COUNT(*) as nb FROM llxap_facture_fourn as f WHERE f.datef BETWEEN '2018-01-01 00:00:00' AND '2018-12-31 23:59:59' AND f.fk_statut > 0 AND f.entity = 1 AND f.type IN (0,1,2,3,5) GROUP BY dm ORDER BY dm DESC
2019-02-01 08:40:52 DEBUG 78.209.101.169 FactureStats::_getNbByMonth
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT date_format(f.datef,'%m') as dm, COUNT(*) as nb FROM llxap_facture_fourn as f WHERE f.datef BETWEEN '2019-01-01 00:00:00' AND '2019-12-31 23:59:59' AND f.fk_statut > 0 AND f.entity = 1 AND f.type IN (0,1,2,3,5) GROUP BY dm ORDER BY dm DESC
2019-02-01 08:40:52 INFO 78.209.101.169 FactureStats::getNbByMonthWithPrevYear save cache file /home/tafenjoy/dolibarrdata/users/temp/FactureStats_getNbByMonthWithPrevYear_supplier_fr_FR_entity.1_user1.cache onto disk.
2019-02-01 08:40:52 INFO 78.209.101.169 DolGraph::draw_jflot this->type= this->MaxValue=0
2019-02-01 08:40:52 INFO 78.209.101.169 FactureStats::getAmountByMonthWithPrevYear cache file /home/tafenjoy/dolibarrdata/users/temp/FactureStats_getAmountByMonthWithPrevYear_supplier_fr_FR_entity.1_user1.cache is not found or older than now - cachedelay (1549006852 - 86400) so we can't use it.
2019-02-01 08:40:52 DEBUG 78.209.101.169 FactureStats::_getAmountByMonth
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT date_format(datef,'%m') as dm, SUM(f.total_ht) FROM llxap_facture_fourn as f WHERE f.datef BETWEEN '2018-01-01 00:00:00' AND '2018-12-31 23:59:59' AND f.fk_statut > 0 AND f.entity = 1 AND f.type IN (0,1,2,3,5) GROUP BY dm ORDER BY dm DESC
2019-02-01 08:40:52 DEBUG 78.209.101.169 FactureStats::_getAmountByMonth
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT date_format(datef,'%m') as dm, SUM(f.total_ht) FROM llxap_facture_fourn as f WHERE f.datef BETWEEN '2019-01-01 00:00:00' AND '2019-12-31 23:59:59' AND f.fk_statut > 0 AND f.entity = 1 AND f.type IN (0,1,2,3,5) GROUP BY dm ORDER BY dm DESC
2019-02-01 08:40:52 INFO 78.209.101.169 FactureStats::getAmountByMonthWithPrevYear save cache file /home/tafenjoy/dolibarrdata/users/temp/FactureStats_getAmountByMonthWithPrevYear_supplier_fr_FR_entity.1_user1.cache onto disk.
2019-02-01 08:40:52 INFO 78.209.101.169 DolGraph::draw_jflot this->type= this->MaxValue=0
2019-02-01 08:40:52 INFO 78.209.101.169 box_graph_invoices_supplier_permonth::showBox
2019-02-01 08:40:52 INFO 78.209.101.169 CommandeStats::getNbByMonthWithPrevYear cache file /home/tafenjoy/dolibarrdata/users/temp/CommandeStats_getNbByMonthWithPrevYear_supplier_fr_FR_entity.1_user1.cache is not found or older than now - cachedelay (1549006852 - 86400) so we can't use it.
2019-02-01 08:40:52 DEBUG 78.209.101.169 CommandeStats::_getNbByMonth
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT date_format(c.date_commande,'%m') as dm, COUNT(*) as nb FROM llxap_commande_fournisseur as c WHERE c.date_commande BETWEEN '2018-01-01 00:00:00' AND '2018-12-31 23:59:59' AND c.fk_statut > 2 AND c.entity IN (1) GROUP BY dm ORDER BY dm DESC
2019-02-01 08:40:52 DEBUG 78.209.101.169 CommandeStats::_getNbByMonth
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT date_format(c.date_commande,'%m') as dm, COUNT(*) as nb FROM llxap_commande_fournisseur as c WHERE c.date_commande BETWEEN '2019-01-01 00:00:00' AND '2019-12-31 23:59:59' AND c.fk_statut > 2 AND c.entity IN (1) GROUP BY dm ORDER BY dm DESC
2019-02-01 08:40:52 INFO 78.209.101.169 CommandeStats::getNbByMonthWithPrevYear save cache file /home/tafenjoy/dolibarrdata/users/temp/CommandeStats_getNbByMonthWithPrevYear_supplier_fr_FR_entity.1_user1.cache onto disk.
2019-02-01 08:40:52 INFO 78.209.101.169 DolGraph::draw_jflot this->type= this->MaxValue=0
2019-02-01 08:40:52 INFO 78.209.101.169 CommandeStats::getAmountByMonthWithPrevYear cache file /home/tafenjoy/dolibarrdata/users/temp/CommandeStats_getAmountByMonthWithPrevYear_supplier_fr_FR_entity.1_user1.cache is not found or older than now - cachedelay (1549006852 - 86400) so we can't use it.
2019-02-01 08:40:52 DEBUG 78.209.101.169 CommandeStats::_getAmountByMonth
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT date_format(c.date_commande,'%m') as dm, SUM(c.total_ht) FROM llxap_commande_fournisseur as c WHERE c.date_commande BETWEEN '2018-01-01 00:00:00' AND '2018-12-31 23:59:59' AND c.fk_statut > 2 AND c.entity IN (1) GROUP BY dm ORDER BY dm DESC
2019-02-01 08:40:52 DEBUG 78.209.101.169 CommandeStats::_getAmountByMonth
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT date_format(c.date_commande,'%m') as dm, SUM(c.total_ht) FROM llxap_commande_fournisseur as c WHERE c.date_commande BETWEEN '2019-01-01 00:00:00' AND '2019-12-31 23:59:59' AND c.fk_statut > 2 AND c.entity IN (1) GROUP BY dm ORDER BY dm DESC
2019-02-01 08:40:52 INFO 78.209.101.169 CommandeStats::getAmountByMonthWithPrevYear save cache file /home/tafenjoy/dolibarrdata/users/temp/CommandeStats_getAmountByMonthWithPrevYear_supplier_fr_FR_entity.1_user1.cache onto disk.
2019-02-01 08:40:52 INFO 78.209.101.169 DolGraph::draw_jflot this->type= this->MaxValue=0
2019-02-01 08:40:52 INFO 78.209.101.169 box_graph_orders_supplier_permonth::showBox
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT s.nom as name, s.rowid as socid, c.rowid, c.ref, c.statut as contract_status, cd.rowid as cdid, cd.label, cd.description, cd.tms as datem, cd.statut, cd.product_type as type, p.rowid as product_id, p.ref as product_ref, p.label as plabel, p.fk_product_type as ptype, p.entity FROM (llxap_societe as s INNER JOIN llxap_contrat as c ON s.rowid = c.fk_soc INNER JOIN llxap_contratdet as cd ON c.rowid = cd.fk_contrat LEFT JOIN llxap_product as p ON cd.fk_product = p.rowid) WHERE c.entity = 1 ORDER BY c.tms DESC LIMIT 5
2019-02-01 08:40:52 INFO 78.209.101.169 box_services_contracts::showBox
2019-02-01 08:40:52 INFO 78.209.101.169 ModeleBoxes::showBox
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT count(u.rowid) as nb FROM llxap_user as u WHERE u.statut > 0 AND u.entity IN (0,1)
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT count(s.rowid) as nb, s.client FROM llxap_societe as s WHERE s.client IN (1,2,3) AND s.entity IN (1) GROUP BY s.client
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT count(s.rowid) as nb FROM llxap_societe as s WHERE s.fournisseur = 1 AND s.entity IN (1)
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT count(sp.rowid) as nb FROM llxap_socpeople as sp WHERE sp.entity IN (1) AND (sp.priv='0' OR (sp.priv='1' AND sp.fk_user_creat=1))
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT count(p.rowid) as nb, fk_product_type FROM llxap_product as p WHERE p.entity IN (1) GROUP BY fk_product_type
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT count(p.rowid) as nb FROM llxap_propal as p LEFT JOIN llxap_societe as s ON p.fk_soc = s.rowid WHERE p.entity IN (1)
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT count(co.rowid) as nb FROM llxap_commande as co LEFT JOIN llxap_societe as s ON co.fk_soc = s.rowid WHERE co.entity IN (1)
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT count(f.rowid) as nb FROM llxap_facture as f LEFT JOIN llxap_societe as s ON f.fk_soc = s.rowid WHERE f.entity = 1
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT count(c.rowid) as nb FROM llxap_contrat as c LEFT JOIN llxap_societe as s ON c.fk_soc = s.rowid WHERE c.entity = 1
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT count(co.rowid) as nb FROM llxap_commande_fournisseur as co LEFT JOIN llxap_societe as s ON co.fk_soc = s.rowid WHERE co.entity = 1
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT count(f.rowid) as nb FROM llxap_facture_fourn as f LEFT JOIN llxap_societe as s ON f.fk_soc = s.rowid WHERE f.entity = 1
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT count(ex.rowid) as nb FROM llxap_expensereport as ex WHERE ex.fk_statut > 0 AND ex.entity IN (1)
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT p.rowid, p.ref, p.datec as datec, p.fin_validite as datefin FROM llxap_propal as p WHERE p.entity IN (1) AND p.fk_statut = 1
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT p.rowid, p.ref, p.datec as datec, p.fin_validite as datefin FROM llxap_propal as p WHERE p.entity IN (1) AND p.fk_statut = 2
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT c.rowid, c.date_creation as datec, c.date_commande, c.date_livraison as delivery_date, c.fk_statut FROM llxap_commande as c WHERE c.entity IN (1) AND ((c.fk_statut IN (1,2)) OR (c.fk_statut = 3 AND c.facture = 0))
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT c.rowid, c.date_creation as datec, c.date_commande, c.fk_statut, c.date_livraison as delivery_date FROM llxap_commande_fournisseur as c WHERE c.entity = 1 AND c.fk_statut IN (1, 2)
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT cd.rowid, cd.date_ouverture_prevue as datefin FROM llxap_contrat as c, llxap_contratdet as cd, llxap_societe as s WHERE c.statut = 1 AND c.rowid = cd.fk_contrat AND cd.statut = 0 AND c.fk_soc = s.rowid AND c.entity = 1
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT cd.rowid, cd.date_fin_validite as datefin FROM llxap_contrat as c, llxap_contratdet as cd, llxap_societe as s WHERE c.statut = 1 AND c.rowid = cd.fk_contrat AND cd.statut = 4 AND cd.date_fin_validite < '2019-02-01 08:40:52' AND c.fk_soc = s.rowid AND c.entity = 1
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT f.rowid, f.date_lim_reglement as datefin,f.fk_statut FROM llxap_facture as f WHERE f.paye=0 AND f.entity = 1 AND f.fk_statut = 1
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT ff.rowid, ff.date_lim_reglement as datefin, ff.fk_statut FROM llxap_facture_fourn as ff WHERE ff.paye=0 AND ff.fk_statut > 0 AND ff.entity = 1
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT COUNT(ba.rowid) as nb FROM llxap_bank_account as ba WHERE ba.rappro > 0 and ba.clos = 0 AND ba.entity IN (1) AND ba.courant != 2
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT b.rowid, b.datev as datefin FROM llxap_bank as b, llxap_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
2019-02-01 08:40:52 DEBUG 78.209.101.169 User::load_parentof
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT fk_user as id_parent, rowid as id_son FROM llxap_user WHERE fk_user <> 0 AND entity IN (0,1)
2019-02-01 08:40:52 DEBUG 78.209.101.169 User::get_full_tree get user list
2019-02-01 08:40:52 DEBUG 78.209.101.169 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 llxap_user as u WHERE u.entity IN (0,1)
2019-02-01 08:40:52 DEBUG 78.209.101.169 User::get_full_tree call to build_path_from_id_user
2019-02-01 08:40:52 DEBUG 78.209.101.169 User::build_path_from_id_user id_user=1 protection=0
2019-02-01 08:40:52 DEBUG 78.209.101.169 User::get_full_tree dol_sort_array
2019-02-01 08:40:52 INFO 78.209.101.169 Build childid for id = 1
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT ex.rowid, ex.date_valid FROM llxap_expensereport as ex WHERE ex.fk_statut = 2 AND ex.entity IN (1) AND (ex.fk_user_author IN (1) OR ex.fk_user_validator IN (1))
2019-02-01 08:40:52 DEBUG 78.209.101.169 sql=SELECT ex.rowid, ex.date_valid FROM llxap_expensereport as ex WHERE ex.fk_statut = 5 AND ex.entity IN (1) AND (ex.fk_user_author IN (1) OR ex.fk_user_validator IN (1))
2019-02-01 08:40:52 INFO 78.209.101.169 --- End access to /index.php
2019-02-01 08:40:55 DEBUG 78.209.101.169 - This is an already logged session. _SESSION['dol_login']=Benoitadmin _SESSION['dol_entity']=1
2019-02-01 08:40:55 DEBUG 78.209.101.169 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.signature, u.office_phone, u.office_fax, u.user_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, 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.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llxap_user as u LEFT JOIN llxap_c_country as c ON u.fk_country = c.rowid LEFT JOIN llxap_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'Benoitadmin' ORDER BY u.entity ASC
2019-02-01 08:40:55 INFO 78.209.101.169 fetch_name_optionals_label elementtype=user
2019-02-01 08:40:55 DEBUG 78.209.101.169 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,fielddefault,fieldcomputed,entity,enabled FROM llxap_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos
2019-02-01 08:40:55 DEBUG 78.209.101.169 sql=SELECT param, value FROM llxap_user_param WHERE fk_user = 1 AND entity = 1
2019-02-01 08:40:55 DEBUG 78.209.101.169 sql=SELECT rowid, entity, type, page, param, value FROM llxap_default_values WHERE entity IN (0,1) AND user_id IN (0, 1)
2019-02-01 08:40:55 DEBUG 78.209.101.169 sql=SELECT r.module, r.perms, r.subperms FROM llxap_user_rights as ur, llxap_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
2019-02-01 08:40:55 DEBUG 78.209.101.169 sql=SELECT r.module, r.perms, r.subperms FROM llxap_usergroup_rights as gr, llxap_usergroup_user as gu, llxap_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
2019-02-01 08:40:55 INFO 78.209.101.169 --- Access to /accountancy/index.php - action=, massaction=
2019-02-01 08:40:55 DEBUG 78.209.101.169 sql=SELECT transkey, transvalue FROM llxap_overwrite_trans where lang='fr_FR'
2019-02-01 08:40:55 DEBUG 78.209.101.169 Menubase::menuLoad mymainmenu=accountancy myleftmenu= type_user=0 menu_handler=eldy tabMenu size=0
2019-02-01 08:40:55 DEBUG 78.209.101.169 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llxap_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.position, m.rowid
2019-02-01 08:40:55 DEBUG 78.209.101.169 sql=SELECT rowid, code, label, nature FROM llxap_accounting_journal WHERE entity = 1 AND active = 1 ORDER BY label DESC
2019-02-01 08:40:55 INFO 78.209.101.169 --- End access to /accountancy/index.php
2019-02-01 08:40:59 DEBUG 78.209.101.169 - This is an already logged session. _SESSION['dol_login']=Benoitadmin _SESSION['dol_entity']=1
2019-02-01 08:40:59 DEBUG 78.209.101.169 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.signature, u.office_phone, u.office_fax, u.user_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, 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.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llxap_user as u LEFT JOIN llxap_c_country as c ON u.fk_country = c.rowid LEFT JOIN llxap_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'Benoitadmin' ORDER BY u.entity ASC