Impossible de charger un plan comptable Dolibarr 8

Bonjour,
Après avoir réaliser des essais sur mon serveur local, j’ai installé Dolibarr sur mon serveur distant (je suis chez O2switch). Je n’ai eu aucun problème pour installer les différentes applications. Seule l’application comptabilité avancée me pose problème. En voulant la paramétrer je n’arrive pas à charger le plan comptable. Je sélectionne le plan actif : « PCG14-DEV The developed accountancy french plan 2014 » et lorsque je clique sur le bouton « Changer et charger » apparait en haut à droite en vert : « ChartLoaded » mais aucune ligne de compte n’est chargée.
Pourtant sur mon local lors de mes essais tout fonctionné.
A savoir : sur mon local version : 8.0.3. Sur mon distant : 8.0.4
Y-a-t-il un bug sur l’application ?
Cela vient t’il de mon serveur distant ?

Capturedcran2019-01-3113.01.27.png

Merci pour vos réponses, si cela vous est arrivé et que vous ayez trouvé la solution.
Cordialement,

1 « J'aime »

Pls. examinez « documents / dolibarr.log » et « var / log / apache2 / error.log »

Merci pour votre réponse, mais n’étant pas un programmateur, j’ai du mal à comprendre.
Je suis allé dans l’arborescence des dossiers Dolibarr sur mon serveur distant et je n’ai pas trouvé les dossiers que vous m’indiquiez.
Merci encore.

Au moins « documents / dolibarr.log » doit être là. Commencez par activer la journalisation des erreurs en activant ce module dans la configuration:

Screenshotfrom2019-01-3121-15-23.png

Je viens d’activer l’application. Voici la capture d’écran :

Capturedcran2019-01-3121.25.56.png

Merci pour la méthode pas à pas.

Essayez de charger à nouveau le plan comptable - et immédiatement après, consultez le journal et affichez les dernières lignes ici.

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

Salut Beneiare,

tu as une erreur sur l’ouverture d’un fichier :

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

  1. peux tu vérifier la présence de ce fichier via FTP ?
  2. ton chemin d’accès est il le bon ? ton dolibarr est installé dans un sous répertoire de ton hébergement nommé compta.tafenjoy.fr ?
1 « J'aime »

Bonjour Arre,

Merci pour ton aide.
Je suis chez o2swicht et pour installer Dolibarr, via softaculous sur Cpanel, j’ai du créer un sous domaine nommé compta.tafenjoy.fr.
Lorsque je suis dans mon gestionnaire de fichier pour ce sous domaine (via Cpanel), je n’ai pas le fichier que tu me cites. J’ai uniquement celui-ci : /compta.tafenjoy.fr/install.lock

Cdlt,

Pas possible de n’avoir que ce fichier, sinon tu n’aurais accès à rien.
Je ne connais ni cette manière d’installer Dolibarr ni ton hébergeur.

Si c’est possible, essaie d’installer via la procédure recommandée :
https://wiki.dolibarr.org/index.php/Installation_/_Mise_a_jour

Sinon, patiente pour qu’un autre utilisateur puisse te venir en aide.

Ou contacter ton hébergeur ? (mais je n’y crois pas trop…)

Merci Arre, pour tes conseils et ton aide.

Je n’ai pas que ce fichier sur mon serveur, mais uniquement celui ci avec le mot /install.

Je vais essayé de l’installer sans passer par Cpanel.

cdlt,


Bonjour tout le monde,
Je suis chez PlanetHoster et j’ai Exactement le même problème, j’ai essayer de suivre les indications plus haut … mais je comprend pas comment je peux résoudre le problème.
Un technicien de chez PlanetHoster m’a confirmé le problème sur un fichier
Ci-joint capture écran de sa réponse

Mais après il m’a juste rediriger vers cette discussion …
Bref , je tourne en rond…

Bonjour,

softaculous n’install pas tous les fichiers, vous devez envoyer les fichiers « à la main » :

  1. téléchargez le fichier : https://raw.githubusercontent.com/Dolibarr/dolibarr/develop/htdocs/install/mysql/data/llx_accounting_account_fr.sql
  2. avec un client FTP, connectez vous à votre hébergement et envoyer le fichier dans le dossier htdocs/install/mysql/data/
2 « J'aime »

Bonjour à tous,
ksar a raison, j’ai eu le même soucis chez o2switch (v13.0.0).
En fait, le répertoire « install » est supprimé à la fin de l’installation et il faut le remettre à la main.
D’ailleurs, il faut le supprimer ce répertoire pour sécuriser dolibarr ?

A ma connaissance non, il suffit de placer un fichier vide nommé « install.lock » à la racine du repertoire document.

Conseil: il faut fuir ces installateurs automatiques et suivre la procédure d’installation décrite dans le wiki.

Merci Arre.
Je suis d’accord avec toi pour les installateurs auto.
Le seul avantage que j’ai actuellement c’est que l’on peut cloner ou « faire un git (staging) » d’une installation en 2 clics. Ça duplique les fichiers et la DB et ça modifie les fichiers de conf. Donc en 20 secondes tu as une copie de ton install prête pour des tests.
Bien entendu, je ne suis pas programmeur d’où mon intérêt pour la manip facile :slight_smile: