Bonjour j’ai effectué la mise à jour sur mon serveur vps ovh. Tout semble s’être passé sans problème sauf que ma page d’accueil : « Mon Tableau de bord » est complètement vide à présent. Ce n’est pas majeure comme problème mais tout de même ce tableau de bord était pratique.
Pièces jointes :
- Capturedecran2017-09-12a14.02.23.png (43.5 KB)
Bonjour,
Une page blanche indique une erreur PHP, Pouvez vous activer vos log, ouvrir la page ( ou la rafraichir avec F5) et copier le log ?
(le fichier log est dans dolibarrr/documents/dolibarr.log)
Bien à vous
Note: il est mieux de faire d’ouvrir qu’une seul page comme ça les logs sont plus court et ne concernent que le problème, ensuite vous pouvez les déactiver et supprimer le fichier dolibarr.log dans dolibarrr/documents
Bonjour, Merci de votre réponse si rapide.
ci-joint le fichier log.
cordialement
Bonjour,
Merci pour votre réponse si rapide.
Ci-joint le fichier dolibarr.log
il semblerait que je n’arrive pas à joindre à nouveau un fichier, voila le dolibarr.log:
2017-09-13 06:50:12 DEBUG 114.69.209.134 - This is an already logged session. _SESSION[‹ dol_login ›]=admin _SESSION[‹ dol_entity ›]=1
2017-09-13 06:50:12 DEBUG 114.69.209.134 User::fetch
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, 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, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = ‹ admin ›
2017-09-13 06:50:12 DEBUG 114.69.209.134 ExtraFields::fetch_name_optionals_label
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ user › ORDER BY pos
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
2017-09-13 06:50:12 DEBUG 114.69.209.134 User::getrights
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND r.entity IN (0,1) AND ur.fk_user= 1 AND r.perms IS NOT NULL
2017-09-13 06:50:12 DEBUG 114.69.209.134 User::getrights
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
2017-09-13 06:50:12 INFO 114.69.209.134 — Access to /admin/modules.php
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang=‹ fr_NC ›
2017-09-13 06:50:12 DEBUG 114.69.209.134 Menubase::menuLoad mymainmenu=home myleftmenu=setup type_user=0 menu_handler=eldy tabMenu size=0
2017-09-13 06:50:12 DEBUG 114.69.209.134 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 llx_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN (‹ eldy ›,‹ all ›) AND m.usertype IN (0,2) ORDER BY m.position, m.rowid
2017-09-13 06:50:12 INFO 114.69.209.134 Scan directory /usr/share/dolibarr/htdocs/core/modules/ for module descriptor files (modXXX.class.php)
2017-09-13 06:50:12 DEBUG 114.69.209.134 User::load_parentof
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT fk_user as id_parent, rowid as id_son FROM llx_user WHERE fk_user <> 0 AND entity IN (0,1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 User::get_full_tree get user list
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT DISTINCT u.rowid, u.firstname, u.lastname, u.fk_user, u.fk_soc, u.login, u.email, u.gender, u.admin, u.statut, u.photo, u.entity FROM llx_user as u WHERE u.entity IN (0,1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 User::get_full_tree call to build_path_from_id_user
2017-09-13 06:50:12 DEBUG 114.69.209.134 User::build_path_from_id_user id_user=1 protection=0
2017-09-13 06:50:12 DEBUG 114.69.209.134 User::build_path_from_id_user id_user=6 protection=0
2017-09-13 06:50:12 DEBUG 114.69.209.134 User::build_path_from_id_user id_user=7 protection=0
2017-09-13 06:50:12 DEBUG 114.69.209.134 User::get_full_tree dol_sort_array
2017-09-13 06:50:12 INFO 114.69.209.134 Build childid for id = 1
2017-09-13 06:50:12 INFO 114.69.209.134 Module modDeplacement not qualified
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ societe › AND type != ‹ separate › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ socpeople › AND type != ‹ separate › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ societe › AND type != ‹ separate › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = ‹ societe › AND entity = 1
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = ‹ socpeople › AND entity = 1
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT code, label, description FROM llx_c_action_trigger ORDER by rang
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT DISTINCT tc.rowid, tc.code, tc.libelle, tc.position FROM llx_c_type_contact as tc WHERE tc.element=‹ commande › AND tc.source=‹ external › ORDER BY position ASC,code ASC
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT DISTINCT tc.rowid, tc.code, tc.libelle, tc.position FROM llx_c_type_contact as tc WHERE tc.element=‹ commande › AND tc.source=‹ external › ORDER BY position ASC,code ASC
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ expedition › AND type != ‹ separate › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ expeditiondet › AND type != ‹ separate › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT name, label, type FROM llx_extrafields WHERE elementtype = ‹ product ›
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = ‹ product › AND entity = 1
2017-09-13 06:50:12 DEBUG 114.69.209.134 useNPR
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = ‹ NC › AND t.active = 1 AND t.recuperableonly = 1
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ product › AND type != ‹ separate › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 useNPR
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = ‹ NC › AND t.active = 1 AND t.recuperableonly = 1
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = ‹ product › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ facture › AND type != ‹ separate › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ facturedet › AND type != ‹ separate › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ product › AND type != ‹ separate › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ facture › AND type != ‹ separate › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ projet › AND type != ‹ separate › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ projet_task › AND type != ‹ separate › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = ‹ projet_task › AND entity = 1
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ propal › AND type != ‹ separate › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ propaldet › AND type != ‹ separate › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ product › AND type != ‹ separate › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ facture_fourn ›
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ facture_fourn_det ›
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ facture_fourn ›
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ commande_fournisseur ›
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ commande_fournisseurdet ›
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ adherent › AND type != ‹ separate › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = ‹ adherent › AND entity = 1
2017-09-13 06:50:12 ERR 114.69.209.134 Failed to load /usr/share/dolibarr/htdocs/core/modules/modAdherent.class.php DateTime::__construct(): It is not safe to rely on the system’s timezone settings. You are required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone ‹ UTC › for now, but please set date.timezone to select your timezone.
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ commande › AND type != ‹ separate › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ commandedet › AND type != ‹ separate › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ product › AND type != ‹ separate › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ societe ›
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ socpeople ›
2017-09-13 06:50:12 DEBUG 114.69.209.134 modUser::getLastActiveDate
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_USER › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 modSociete::getLastActiveDate
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_SOCIETE › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 modPropale::getLastActiveDate
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_PROPALE › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 modCommande::getLastActiveDate
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_COMMANDE › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 modExpedition::getLastActiveDate
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_EXPEDITION › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 modContrat::getLastActiveDate
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_CONTRAT › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 modFicheinter::getLastActiveDate
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_FICHEINTER › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 modFournisseur::getLastActiveDate
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_FOURNISSEUR › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 modFacture::getLastActiveDate
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_FACTURE › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 modTax::getLastActiveDate
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_TAX › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 modBanque::getLastActiveDate
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_BANQUE › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 modPrelevement::getLastActiveDate
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_PRELEVEMENT › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 modMargin::getLastActiveDate
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_MARGIN › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 modComptabilite::getLastActiveDate
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_COMPTABILITE › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 modProduct::getLastActiveDate
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_PRODUCT › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 modService::getLastActiveDate
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_SERVICE › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 modStock::getLastActiveDate
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_STOCK › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 modProjet::getLastActiveDate
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_PROJET › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 modAgenda::getLastActiveDate
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_AGENDA › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 modResource::getLastActiveDate
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_RESOURCE › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 modECM::getLastActiveDate
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_ECM › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 modCategorie::getLastActiveDate
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_CATEGORIE › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 modImport::getLastActiveDate
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_IMPORT › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 modExport::getLastActiveDate
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_EXPORT › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 modCashDesk::getLastActiveDate
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_CASHDESK › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 modExternalSite::getLastActiveDate
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_EXTERNALSITE › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 modLdap::getLastActiveDate
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_LDAP › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 modSkype::getLastActiveDate
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_SKYPE › AND entity IN (0, 1)
2017-09-13 06:50:12 DEBUG 114.69.209.134 modPaypal::getLastActiveDate
2017-09-13 06:50:12 DEBUG 114.69.209.134 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_PAYPAL › AND entity IN (0, 1)
2017-09-13 06:50:13 DEBUG 114.69.209.134 modSyslog::getLastActiveDate
2017-09-13 06:50:13 DEBUG 114.69.209.134 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_SYSLOG › AND entity IN (0, 1)
2017-09-13 06:50:13 INFO 114.69.209.134 — End access to /admin/modules.php
2017-09-13 06:50:21 DEBUG 114.69.209.134 - This is an already logged session. _SESSION[‹ dol_login ›]=admin _SESSION[‹ dol_entity ›]=1
2017-09-13 06:50:21 DEBUG 114.69.209.134 User::fetch
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, 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, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = ‹ admin ›
2017-09-13 06:50:21 DEBUG 114.69.209.134 ExtraFields::fetch_name_optionals_label
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ user › ORDER BY pos
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
2017-09-13 06:50:21 DEBUG 114.69.209.134 User::getrights
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND r.entity IN (0,1) AND ur.fk_user= 1 AND r.perms IS NOT NULL
2017-09-13 06:50:21 DEBUG 114.69.209.134 User::getrights
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
2017-09-13 06:50:21 INFO 114.69.209.134 — Access to /index.php
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang=‹ fr_NC ›
2017-09-13 06:50:21 DEBUG 114.69.209.134 Menubase::menuLoad mymainmenu=home myleftmenu= type_user=0 menu_handler=eldy tabMenu size=0
2017-09-13 06:50:21 DEBUG 114.69.209.134 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 llx_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN (‹ eldy ›,‹ all ›) AND m.usertype IN (0,2) ORDER BY m.position, m.rowid
2017-09-13 06:50:21 DEBUG 114.69.209.134 InfoBox::listBoxes get default box list for mode=activated userid=
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT b.rowid, b.position, b.box_order, b.fk_user, d.rowid as box_id, d.file, d.note, d.tms FROM llx_boxes as b, llx_boxes_def as d WHERE b.box_id = d.rowid AND b.entity IN (0,1) AND b.position = 0 AND b.fk_user = 0 ORDER BY b.box_order
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT a.rowid, a.lastname, a.firstname, a.societe as company, a.fk_soc, a.datec, a.tms, a.statut as status, a.datefin as date_end_subscription, t.subscription FROM llx_adherent as a, llx_adherent_type as t WHERE a.entity = 1 AND a.fk_adherent_type = t.rowid ORDER BY a.tms DESC LIMIT 5
2017-09-13 06:50:21 INFO 114.69.209.134 box_members::showBox
2017-09-13 06:50:21 DEBUG 114.69.209.134 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 llx_societe as s, llx_facture_fourn as f WHERE f.fk_soc = s.rowid AND f.entity = 1 ORDER BY f.tms DESC, f.ref DESC LIMIT 5
2017-09-13 06:50:21 DEBUG 114.69.209.134 Translate::loadCacheCurrencies
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = ‹ XPF ›
2017-09-13 06:50:21 DEBUG 114.69.209.134 FactureFournisseur::fetch
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT t.rowid, t.ref, t.ref_supplier, t.entity, t.type, t.fk_soc, t.datec, t.datef, t.tms, t.libelle, t.paye, t.amount, t.remise, t.close_code, t.close_note, t.tva, t.localtax1, t.localtax2, t.total_ht, t.total_tva, t.total_ttc, t.fk_statut, t.fk_user_author, t.fk_user_valid, t.fk_facture_source, t.fk_projet, t.fk_cond_reglement, t.fk_account, t.fk_mode_reglement, t.date_lim_reglement, t.note_private, t.note_public, t.model_pdf, t.import_key, t.extraparams, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, s.nom as socnom, s.rowid as socid, t.fk_incoterms, t.location_incoterms, i.libelle as libelle_incoterms, t.fk_multicurrency, t.multicurrency_code, t.multicurrency_tx, t.multicurrency_total_ht, t.multicurrency_total_tva, t.multicurrency_total_ttc FROM llx_facture_fourn as t LEFT JOIN llx_societe as s ON (t.fk_soc = s.rowid) LEFT JOIN llx_c_payment_term as cr ON (t.fk_cond_reglement = cr.rowid) LEFT JOIN llx_c_paiement as p ON (t.fk_mode_reglement = p.id) LEFT JOIN llx_c_incoterms as i ON t.fk_incoterms = i.rowid WHERE t.rowid=94
2017-09-13 06:50:21 DEBUG 114.69.209.134 ExtraFields::fetch_name_optionals_label
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ facture_fourn › ORDER BY pos
2017-09-13 06:50:21 DEBUG 114.69.209.134 FactureFournisseur::fetch_lines
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT f.rowid, f.ref as ref_supplier, f.description, f.pu_ht, f.pu_ttc, f.qty, f.remise_percent, f.vat_src_code, f.tva_tx, f.localtax1_tx, f.localtax2_tx, f.total_localtax1, f.total_localtax2, f.fk_facture_fourn , f.total_ht, f.tva as total_tva, f.total_ttc, f.fk_product, f.product_type, f.info_bits, f.rang, f.special_code, f.fk_parent_line, f.fk_unit, p.rowid as product_id, p.ref as product_ref, p.label as label, p.description as product_desc, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_subprice, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc FROM llx_facture_fourn_det as f LEFT JOIN llx_product as p ON f.fk_product = p.rowid WHERE fk_facture_fourn=94 ORDER BY f.rang, f.rowid
2017-09-13 06:50:21 DEBUG 114.69.209.134 FactureFournisseur::getSommePaiement
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 94
2017-09-13 06:50:21 DEBUG 114.69.209.134 FactureFournisseur::fetch
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT t.rowid, t.ref, t.ref_supplier, t.entity, t.type, t.fk_soc, t.datec, t.datef, t.tms, t.libelle, t.paye, t.amount, t.remise, t.close_code, t.close_note, t.tva, t.localtax1, t.localtax2, t.total_ht, t.total_tva, t.total_ttc, t.fk_statut, t.fk_user_author, t.fk_user_valid, t.fk_facture_source, t.fk_projet, t.fk_cond_reglement, t.fk_account, t.fk_mode_reglement, t.date_lim_reglement, t.note_private, t.note_public, t.model_pdf, t.import_key, t.extraparams, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, s.nom as socnom, s.rowid as socid, t.fk_incoterms, t.location_incoterms, i.libelle as libelle_incoterms, t.fk_multicurrency, t.multicurrency_code, t.multicurrency_tx, t.multicurrency_total_ht, t.multicurrency_total_tva, t.multicurrency_total_ttc FROM llx_facture_fourn as t LEFT JOIN llx_societe as s ON (t.fk_soc = s.rowid) LEFT JOIN llx_c_payment_term as cr ON (t.fk_cond_reglement = cr.rowid) LEFT JOIN llx_c_paiement as p ON (t.fk_mode_reglement = p.id) LEFT JOIN llx_c_incoterms as i ON t.fk_incoterms = i.rowid WHERE t.rowid=98
2017-09-13 06:50:21 DEBUG 114.69.209.134 ExtraFields::fetch_name_optionals_label
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ facture_fourn › ORDER BY pos
2017-09-13 06:50:21 DEBUG 114.69.209.134 FactureFournisseur::fetch_lines
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT f.rowid, f.ref as ref_supplier, f.description, f.pu_ht, f.pu_ttc, f.qty, f.remise_percent, f.vat_src_code, f.tva_tx, f.localtax1_tx, f.localtax2_tx, f.total_localtax1, f.total_localtax2, f.fk_facture_fourn , f.total_ht, f.tva as total_tva, f.total_ttc, f.fk_product, f.product_type, f.info_bits, f.rang, f.special_code, f.fk_parent_line, f.fk_unit, p.rowid as product_id, p.ref as product_ref, p.label as label, p.description as product_desc, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_subprice, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc FROM llx_facture_fourn_det as f LEFT JOIN llx_product as p ON f.fk_product = p.rowid WHERE fk_facture_fourn=98 ORDER BY f.rang, f.rowid
2017-09-13 06:50:21 DEBUG 114.69.209.134 FactureFournisseur::getSommePaiement
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 98
2017-09-13 06:50:21 DEBUG 114.69.209.134 FactureFournisseur::fetch
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT t.rowid, t.ref, t.ref_supplier, t.entity, t.type, t.fk_soc, t.datec, t.datef, t.tms, t.libelle, t.paye, t.amount, t.remise, t.close_code, t.close_note, t.tva, t.localtax1, t.localtax2, t.total_ht, t.total_tva, t.total_ttc, t.fk_statut, t.fk_user_author, t.fk_user_valid, t.fk_facture_source, t.fk_projet, t.fk_cond_reglement, t.fk_account, t.fk_mode_reglement, t.date_lim_reglement, t.note_private, t.note_public, t.model_pdf, t.import_key, t.extraparams, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, s.nom as socnom, s.rowid as socid, t.fk_incoterms, t.location_incoterms, i.libelle as libelle_incoterms, t.fk_multicurrency, t.multicurrency_code, t.multicurrency_tx, t.multicurrency_total_ht, t.multicurrency_total_tva, t.multicurrency_total_ttc FROM llx_facture_fourn as t LEFT JOIN llx_societe as s ON (t.fk_soc = s.rowid) LEFT JOIN llx_c_payment_term as cr ON (t.fk_cond_reglement = cr.rowid) LEFT JOIN llx_c_paiement as p ON (t.fk_mode_reglement = p.id) LEFT JOIN llx_c_incoterms as i ON t.fk_incoterms = i.rowid WHERE t.rowid=103
2017-09-13 06:50:21 DEBUG 114.69.209.134 ExtraFields::fetch_name_optionals_label
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ facture_fourn › ORDER BY pos
2017-09-13 06:50:21 DEBUG 114.69.209.134 FactureFournisseur::fetch_lines
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT f.rowid, f.ref as ref_supplier, f.description, f.pu_ht, f.pu_ttc, f.qty, f.remise_percent, f.vat_src_code, f.tva_tx, f.localtax1_tx, f.localtax2_tx, f.total_localtax1, f.total_localtax2, f.fk_facture_fourn , f.total_ht, f.tva as total_tva, f.total_ttc, f.fk_product, f.product_type, f.info_bits, f.rang, f.special_code, f.fk_parent_line, f.fk_unit, p.rowid as product_id, p.ref as product_ref, p.label as label, p.description as product_desc, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_subprice, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc FROM llx_facture_fourn_det as f LEFT JOIN llx_product as p ON f.fk_product = p.rowid WHERE fk_facture_fourn=103 ORDER BY f.rang, f.rowid
2017-09-13 06:50:21 DEBUG 114.69.209.134 FactureFournisseur::getSommePaiement
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 103
2017-09-13 06:50:21 DEBUG 114.69.209.134 FactureFournisseur::fetch
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT t.rowid, t.ref, t.ref_supplier, t.entity, t.type, t.fk_soc, t.datec, t.datef, t.tms, t.libelle, t.paye, t.amount, t.remise, t.close_code, t.close_note, t.tva, t.localtax1, t.localtax2, t.total_ht, t.total_tva, t.total_ttc, t.fk_statut, t.fk_user_author, t.fk_user_valid, t.fk_facture_source, t.fk_projet, t.fk_cond_reglement, t.fk_account, t.fk_mode_reglement, t.date_lim_reglement, t.note_private, t.note_public, t.model_pdf, t.import_key, t.extraparams, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, s.nom as socnom, s.rowid as socid, t.fk_incoterms, t.location_incoterms, i.libelle as libelle_incoterms, t.fk_multicurrency, t.multicurrency_code, t.multicurrency_tx, t.multicurrency_total_ht, t.multicurrency_total_tva, t.multicurrency_total_ttc FROM llx_facture_fourn as t LEFT JOIN llx_societe as s ON (t.fk_soc = s.rowid) LEFT JOIN llx_c_payment_term as cr ON (t.fk_cond_reglement = cr.rowid) LEFT JOIN llx_c_paiement as p ON (t.fk_mode_reglement = p.id) LEFT JOIN llx_c_incoterms as i ON t.fk_incoterms = i.rowid WHERE t.rowid=61
2017-09-13 06:50:21 DEBUG 114.69.209.134 ExtraFields::fetch_name_optionals_label
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ facture_fourn › ORDER BY pos
2017-09-13 06:50:21 DEBUG 114.69.209.134 FactureFournisseur::fetch_lines
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT f.rowid, f.ref as ref_supplier, f.description, f.pu_ht, f.pu_ttc, f.qty, f.remise_percent, f.vat_src_code, f.tva_tx, f.localtax1_tx, f.localtax2_tx, f.total_localtax1, f.total_localtax2, f.fk_facture_fourn , f.total_ht, f.tva as total_tva, f.total_ttc, f.fk_product, f.product_type, f.info_bits, f.rang, f.special_code, f.fk_parent_line, f.fk_unit, p.rowid as product_id, p.ref as product_ref, p.label as label, p.description as product_desc, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_subprice, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc FROM llx_facture_fourn_det as f LEFT JOIN llx_product as p ON f.fk_product = p.rowid WHERE fk_facture_fourn=61 ORDER BY f.rang, f.rowid
2017-09-13 06:50:21 DEBUG 114.69.209.134 FactureFournisseur::getSommePaiement
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 61
2017-09-13 06:50:21 DEBUG 114.69.209.134 FactureFournisseur::fetch
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT t.rowid, t.ref, t.ref_supplier, t.entity, t.type, t.fk_soc, t.datec, t.datef, t.tms, t.libelle, t.paye, t.amount, t.remise, t.close_code, t.close_note, t.tva, t.localtax1, t.localtax2, t.total_ht, t.total_tva, t.total_ttc, t.fk_statut, t.fk_user_author, t.fk_user_valid, t.fk_facture_source, t.fk_projet, t.fk_cond_reglement, t.fk_account, t.fk_mode_reglement, t.date_lim_reglement, t.note_private, t.note_public, t.model_pdf, t.import_key, t.extraparams, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, s.nom as socnom, s.rowid as socid, t.fk_incoterms, t.location_incoterms, i.libelle as libelle_incoterms, t.fk_multicurrency, t.multicurrency_code, t.multicurrency_tx, t.multicurrency_total_ht, t.multicurrency_total_tva, t.multicurrency_total_ttc FROM llx_facture_fourn as t LEFT JOIN llx_societe as s ON (t.fk_soc = s.rowid) LEFT JOIN llx_c_payment_term as cr ON (t.fk_cond_reglement = cr.rowid) LEFT JOIN llx_c_paiement as p ON (t.fk_mode_reglement = p.id) LEFT JOIN llx_c_incoterms as i ON t.fk_incoterms = i.rowid WHERE t.rowid=81
2017-09-13 06:50:21 DEBUG 114.69.209.134 ExtraFields::fetch_name_optionals_label
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ facture_fourn › ORDER BY pos
2017-09-13 06:50:21 DEBUG 114.69.209.134 FactureFournisseur::fetch_lines
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT f.rowid, f.ref as ref_supplier, f.description, f.pu_ht, f.pu_ttc, f.qty, f.remise_percent, f.vat_src_code, f.tva_tx, f.localtax1_tx, f.localtax2_tx, f.total_localtax1, f.total_localtax2, f.fk_facture_fourn , f.total_ht, f.tva as total_tva, f.total_ttc, f.fk_product, f.product_type, f.info_bits, f.rang, f.special_code, f.fk_parent_line, f.fk_unit, p.rowid as product_id, p.ref as product_ref, p.label as label, p.description as product_desc, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_subprice, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc FROM llx_facture_fourn_det as f LEFT JOIN llx_product as p ON f.fk_product = p.rowid WHERE fk_facture_fourn=81 ORDER BY f.rang, f.rowid
2017-09-13 06:50:21 DEBUG 114.69.209.134 FactureFournisseur::getSommePaiement
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 81
2017-09-13 06:50:21 INFO 114.69.209.134 box_factures_fourn::showBox
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT s.nom as name, s.rowid as socid, s.code_client, s.code_fournisseur, s.logo, c.ref, c.tms, c.rowid, c.date_commande, c.total_ht, c.tva as total_tva, c.total_ttc, c.fk_statut FROM llx_societe as s, llx_commande_fournisseur as c WHERE c.fk_soc = s.rowid AND c.entity = 1 ORDER BY c.tms DESC, c.ref DESC LIMIT 5
2017-09-13 06:50:21 INFO 114.69.209.134 box_supplier_orders::showBox
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT s.nom as name, s.rowid as socid, c.rowid, c.ref, c.statut as contract_status, cd.rowid as cdid, cd.tms as datem, cd.statut, cd.label, cd.description, cd.product_type as type, p.rowid as product_id, p.ref as product_ref FROM (llx_societe as s INNER JOIN llx_contrat as c ON s.rowid = c.fk_soc INNER JOIN llx_contratdet as cd ON c.rowid = cd.fk_contrat LEFT JOIN llx_product as p ON cd.fk_product = p.rowid) WHERE c.entity = 1 ORDER BY c.tms DESC LIMIT 5
2017-09-13 06:50:21 INFO 114.69.209.134 box_services_contracts::showBox
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT p.rowid, p.ref, p.title, p.fk_statut, p.public FROM llx_projet as p WHERE p.entity IN (1) AND p.fk_statut = 1 ORDER BY p.datec DESC
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT count() as nb, sum(progress) as totprogress FROM llx_projet as p LEFT JOIN llx_projet_task as pt on pt.fk_projet = p.rowid WHERE p.entity IN (1) AND p.rowid = 1
2017-09-13 06:50:21 INFO 114.69.209.134 box_project::showBox
2017-09-13 06:50:21 DEBUG 114.69.209.134 Box_actions::loadBox
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT a.id, a.label, a.datep as dp, a.percent as percentage, ta.code, ta.libelle as type_label, s.nom as name, s.rowid as socid, s.code_client FROM (llx_c_actioncomm AS ta, llx_actioncomm AS a) LEFT JOIN llx_societe as s ON a.fk_soc = s.rowid WHERE a.fk_action = ta.id AND a.entity = 1 AND a.percent >= 0 AND a.percent < 100 ORDER BY a.datec DESC LIMIT 5
2017-09-13 06:50:21 INFO 114.69.209.134 box_actions::showBox
2017-09-13 06:50:21 DEBUG 114.69.209.134 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 llx_product as p WHERE p.entity IN (1) ORDER BY p.datec DESC LIMIT 5
2017-09-13 06:50:21 INFO 114.69.209.134 box_produits::showBox
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT p.rowid, p.label, p.price, p.ref, p.price_base_type, p.price_ttc, p.fk_product_type, p.tms, p.tosell, p.tobuy, p.seuil_stock_alerte, p.entity, SUM(IF(s.reel IS NULL,0,s.reel)) as total_stock FROM llx_product as p LEFT JOIN llx_product_stock as s on p.rowid = s.fk_product WHERE p.entity IN (1) AND p.tosell = 1 AND p.seuil_stock_alerte > 0 GROUP BY p.rowid, p.ref, p.label, p.price, p.price_base_type, p.price_ttc, p.fk_product_type, p.tms, p.tosell, p.tobuy, p.seuil_stock_alerte, p.entity HAVING SUM(IF(s.reel IS NULL,0,s.reel)) < p.seuil_stock_alerte ORDER BY p.seuil_stock_alerte DESC LIMIT 5
2017-09-13 06:50:21 INFO 114.69.209.134 box_produits_alerte_stock::showBox
2017-09-13 06:50:21 INFO 114.69.209.134 FactureStats::getAllByProductEntry read data from cache file /var/lib/dolibarr/documents/users/temp/FactureStats_getAllByProductEntry_customer_fr_NC_entity.1_user1.cache 1505284845.
2017-09-13 06:50:21 INFO 114.69.209.134 DolGraph::draw_jflot this->type=pie
2017-09-13 06:50:21 INFO 114.69.209.134 PropaleStats::getAllByProductEntry read data from cache file /var/lib/dolibarr/documents/users/temp/PropaleStats_getAllByProductEntry_fr_NC_entity.1_user1.cache 1505284845.
2017-09-13 06:50:21 INFO 114.69.209.134 DolGraph::draw_jflot this->type=pie
2017-09-13 06:50:21 INFO 114.69.209.134 CommandeStats::getAllByProductEntry read data from cache file /var/lib/dolibarr/documents/users/temp/CommandeStats_getAllByProductEntry_customer_fr_NC_entity.1_user1.cache 1505284845.
2017-09-13 06:50:21 INFO 114.69.209.134 DolGraph::draw_jflot this->type=pie
2017-09-13 06:50:21 INFO 114.69.209.134 box_graph_product_distribution::showBox
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT s.nom as name, s.rowid as socid, 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 llx_societe as s, llx_facture as f LEFT JOIN llx_paiement_facture as pf ON f.rowid=pf.fk_facture WHERE f.fk_soc = s.rowid AND f.entity = 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
2017-09-13 06:50:21 INFO 114.69.209.134 box_factures_imp::showBox
2017-09-13 06:50:21 DEBUG 114.69.209.134 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.nom as name, s.rowid as socid, s.code_client, f.date_lim_reglement as datelimite FROM (llx_societe as s,llx_facture as f) WHERE f.fk_soc = s.rowid AND f.entity = 1 ORDER BY f.tms DESC, f.facnumber DESC LIMIT 5
2017-09-13 06:50:21 INFO 114.69.209.134 box_factures::showBox
2017-09-13 06:50:21 INFO 114.69.209.134 FactureStats::getAmountByMonthWithPrevYear read data from cache file /var/lib/dolibarr/documents/users/temp/FactureStats_getAmountByMonthWithPrevYear_customer_fr_NC_entity.1_user1.cache 1505284845.
2017-09-13 06:50:21 INFO 114.69.209.134 DolGraph::draw_jflot this->type=
2017-09-13 06:50:21 INFO 114.69.209.134 box_graph_invoices_permonth::showBox
2017-09-13 06:50:21 DEBUG 114.69.209.134 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 llx_societe as s,llx_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
2017-09-13 06:50:21 DEBUG 114.69.209.134 FactureFournisseur::fetch
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT t.rowid, t.ref, t.ref_supplier, t.entity, t.type, t.fk_soc, t.datec, t.datef, t.tms, t.libelle, t.paye, t.amount, t.remise, t.close_code, t.close_note, t.tva, t.localtax1, t.localtax2, t.total_ht, t.total_tva, t.total_ttc, t.fk_statut, t.fk_user_author, t.fk_user_valid, t.fk_facture_source, t.fk_projet, t.fk_cond_reglement, t.fk_account, t.fk_mode_reglement, t.date_lim_reglement, t.note_private, t.note_public, t.model_pdf, t.import_key, t.extraparams, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, s.nom as socnom, s.rowid as socid, t.fk_incoterms, t.location_incoterms, i.libelle as libelle_incoterms, t.fk_multicurrency, t.multicurrency_code, t.multicurrency_tx, t.multicurrency_total_ht, t.multicurrency_total_tva, t.multicurrency_total_ttc FROM llx_facture_fourn as t LEFT JOIN llx_societe as s ON (t.fk_soc = s.rowid) LEFT JOIN llx_c_payment_term as cr ON (t.fk_cond_reglement = cr.rowid) LEFT JOIN llx_c_paiement as p ON (t.fk_mode_reglement = p.id) LEFT JOIN llx_c_incoterms as i ON t.fk_incoterms = i.rowid WHERE t.rowid=154
2017-09-13 06:50:21 DEBUG 114.69.209.134 ExtraFields::fetch_name_optionals_label
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ facture_fourn › ORDER BY pos
2017-09-13 06:50:21 DEBUG 114.69.209.134 FactureFournisseur::fetch_lines
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT f.rowid, f.ref as ref_supplier, f.description, f.pu_ht, f.pu_ttc, f.qty, f.remise_percent, f.vat_src_code, f.tva_tx, f.localtax1_tx, f.localtax2_tx, f.total_localtax1, f.total_localtax2, f.fk_facture_fourn , f.total_ht, f.tva as total_tva, f.total_ttc, f.fk_product, f.product_type, f.info_bits, f.rang, f.special_code, f.fk_parent_line, f.fk_unit, p.rowid as product_id, p.ref as product_ref, p.label as label, p.description as product_desc, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_subprice, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc FROM llx_facture_fourn_det as f LEFT JOIN llx_product as p ON f.fk_product = p.rowid WHERE fk_facture_fourn=154 ORDER BY f.rang, f.rowid
2017-09-13 06:50:21 DEBUG 114.69.209.134 FactureFournisseur::getSommePaiement
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 154
2017-09-13 06:50:21 DEBUG 114.69.209.134 FactureFournisseur::fetch
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT t.rowid, t.ref, t.ref_supplier, t.entity, t.type, t.fk_soc, t.datec, t.datef, t.tms, t.libelle, t.paye, t.amount, t.remise, t.close_code, t.close_note, t.tva, t.localtax1, t.localtax2, t.total_ht, t.total_tva, t.total_ttc, t.fk_statut, t.fk_user_author, t.fk_user_valid, t.fk_facture_source, t.fk_projet, t.fk_cond_reglement, t.fk_account, t.fk_mode_reglement, t.date_lim_reglement, t.note_private, t.note_public, t.model_pdf, t.import_key, t.extraparams, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, s.nom as socnom, s.rowid as socid, t.fk_incoterms, t.location_incoterms, i.libelle as libelle_incoterms, t.fk_multicurrency, t.multicurrency_code, t.multicurrency_tx, t.multicurrency_total_ht, t.multicurrency_total_tva, t.multicurrency_total_ttc FROM llx_facture_fourn as t LEFT JOIN llx_societe as s ON (t.fk_soc = s.rowid) LEFT JOIN llx_c_payment_term as cr ON (t.fk_cond_reglement = cr.rowid) LEFT JOIN llx_c_paiement as p ON (t.fk_mode_reglement = p.id) LEFT JOIN llx_c_incoterms as i ON t.fk_incoterms = i.rowid WHERE t.rowid=152
2017-09-13 06:50:21 DEBUG 114.69.209.134 ExtraFields::fetch_name_optionals_label
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ facture_fourn › ORDER BY pos
2017-09-13 06:50:21 DEBUG 114.69.209.134 FactureFournisseur::fetch_lines
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT f.rowid, f.ref as ref_supplier, f.description, f.pu_ht, f.pu_ttc, f.qty, f.remise_percent, f.vat_src_code, f.tva_tx, f.localtax1_tx, f.localtax2_tx, f.total_localtax1, f.total_localtax2, f.fk_facture_fourn , f.total_ht, f.tva as total_tva, f.total_ttc, f.fk_product, f.product_type, f.info_bits, f.rang, f.special_code, f.fk_parent_line, f.fk_unit, p.rowid as product_id, p.ref as product_ref, p.label as label, p.description as product_desc, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_subprice, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc FROM llx_facture_fourn_det as f LEFT JOIN llx_product as p ON f.fk_product = p.rowid WHERE fk_facture_fourn=152 ORDER BY f.rang, f.rowid
2017-09-13 06:50:21 DEBUG 114.69.209.134 FactureFournisseur::getSommePaiement
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 152
2017-09-13 06:50:21 DEBUG 114.69.209.134 FactureFournisseur::fetch
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT t.rowid, t.ref, t.ref_supplier, t.entity, t.type, t.fk_soc, t.datec, t.datef, t.tms, t.libelle, t.paye, t.amount, t.remise, t.close_code, t.close_note, t.tva, t.localtax1, t.localtax2, t.total_ht, t.total_tva, t.total_ttc, t.fk_statut, t.fk_user_author, t.fk_user_valid, t.fk_facture_source, t.fk_projet, t.fk_cond_reglement, t.fk_account, t.fk_mode_reglement, t.date_lim_reglement, t.note_private, t.note_public, t.model_pdf, t.import_key, t.extraparams, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, s.nom as socnom, s.rowid as socid, t.fk_incoterms, t.location_incoterms, i.libelle as libelle_incoterms, t.fk_multicurrency, t.multicurrency_code, t.multicurrency_tx, t.multicurrency_total_ht, t.multicurrency_total_tva, t.multicurrency_total_ttc FROM llx_facture_fourn as t LEFT JOIN llx_societe as s ON (t.fk_soc = s.rowid) LEFT JOIN llx_c_payment_term as cr ON (t.fk_cond_reglement = cr.rowid) LEFT JOIN llx_c_paiement as p ON (t.fk_mode_reglement = p.id) LEFT JOIN llx_c_incoterms as i ON t.fk_incoterms = i.rowid WHERE t.rowid=151
2017-09-13 06:50:21 DEBUG 114.69.209.134 ExtraFields::fetch_name_optionals_label
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ facture_fourn › ORDER BY pos
2017-09-13 06:50:21 DEBUG 114.69.209.134 FactureFournisseur::fetch_lines
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT f.rowid, f.ref as ref_supplier, f.description, f.pu_ht, f.pu_ttc, f.qty, f.remise_percent, f.vat_src_code, f.tva_tx, f.localtax1_tx, f.localtax2_tx, f.total_localtax1, f.total_localtax2, f.fk_facture_fourn , f.total_ht, f.tva as total_tva, f.total_ttc, f.fk_product, f.product_type, f.info_bits, f.rang, f.special_code, f.fk_parent_line, f.fk_unit, p.rowid as product_id, p.ref as product_ref, p.label as label, p.description as product_desc, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_subprice, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc FROM llx_facture_fourn_det as f LEFT JOIN llx_product as p ON f.fk_product = p.rowid WHERE fk_facture_fourn=151 ORDER BY f.rang, f.rowid
2017-09-13 06:50:21 DEBUG 114.69.209.134 FactureFournisseur::getSommePaiement
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 151
2017-09-13 06:50:21 DEBUG 114.69.209.134 FactureFournisseur::fetch
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT t.rowid, t.ref, t.ref_supplier, t.entity, t.type, t.fk_soc, t.datec, t.datef, t.tms, t.libelle, t.paye, t.amount, t.remise, t.close_code, t.close_note, t.tva, t.localtax1, t.localtax2, t.total_ht, t.total_tva, t.total_ttc, t.fk_statut, t.fk_user_author, t.fk_user_valid, t.fk_facture_source, t.fk_projet, t.fk_cond_reglement, t.fk_account, t.fk_mode_reglement, t.date_lim_reglement, t.note_private, t.note_public, t.model_pdf, t.import_key, t.extraparams, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, s.nom as socnom, s.rowid as socid, t.fk_incoterms, t.location_incoterms, i.libelle as libelle_incoterms, t.fk_multicurrency, t.multicurrency_code, t.multicurrency_tx, t.multicurrency_total_ht, t.multicurrency_total_tva, t.multicurrency_total_ttc FROM llx_facture_fourn as t LEFT JOIN llx_societe as s ON (t.fk_soc = s.rowid) LEFT JOIN llx_c_payment_term as cr ON (t.fk_cond_reglement = cr.rowid) LEFT JOIN llx_c_paiement as p ON (t.fk_mode_reglement = p.id) LEFT JOIN llx_c_incoterms as i ON t.fk_incoterms = i.rowid WHERE t.rowid=149
2017-09-13 06:50:21 DEBUG 114.69.209.134 ExtraFields::fetch_name_optionals_label
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ facture_fourn › ORDER BY pos
2017-09-13 06:50:21 DEBUG 114.69.209.134 FactureFournisseur::fetch_lines
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT f.rowid, f.ref as ref_supplier, f.description, f.pu_ht, f.pu_ttc, f.qty, f.remise_percent, f.vat_src_code, f.tva_tx, f.localtax1_tx, f.localtax2_tx, f.total_localtax1, f.total_localtax2, f.fk_facture_fourn , f.total_ht, f.tva as total_tva, f.total_ttc, f.fk_product, f.product_type, f.info_bits, f.rang, f.special_code, f.fk_parent_line, f.fk_unit, p.rowid as product_id, p.ref as product_ref, p.label as label, p.description as product_desc, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_subprice, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc FROM llx_facture_fourn_det as f LEFT JOIN llx_product as p ON f.fk_product = p.rowid WHERE fk_facture_fourn=149 ORDER BY f.rang, f.rowid
2017-09-13 06:50:21 DEBUG 114.69.209.134 FactureFournisseur::getSommePaiement
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 149
2017-09-13 06:50:21 DEBUG 114.69.209.134 FactureFournisseur::fetch
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT t.rowid, t.ref, t.ref_supplier, t.entity, t.type, t.fk_soc, t.datec, t.datef, t.tms, t.libelle, t.paye, t.amount, t.remise, t.close_code, t.close_note, t.tva, t.localtax1, t.localtax2, t.total_ht, t.total_tva, t.total_ttc, t.fk_statut, t.fk_user_author, t.fk_user_valid, t.fk_facture_source, t.fk_projet, t.fk_cond_reglement, t.fk_account, t.fk_mode_reglement, t.date_lim_reglement, t.note_private, t.note_public, t.model_pdf, t.import_key, t.extraparams, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, s.nom as socnom, s.rowid as socid, t.fk_incoterms, t.location_incoterms, i.libelle as libelle_incoterms, t.fk_multicurrency, t.multicurrency_code, t.multicurrency_tx, t.multicurrency_total_ht, t.multicurrency_total_tva, t.multicurrency_total_ttc FROM llx_facture_fourn as t LEFT JOIN llx_societe as s ON (t.fk_soc = s.rowid) LEFT JOIN llx_c_payment_term as cr ON (t.fk_cond_reglement = cr.rowid) LEFT JOIN llx_c_paiement as p ON (t.fk_mode_reglement = p.id) LEFT JOIN llx_c_incoterms as i ON t.fk_incoterms = i.rowid WHERE t.rowid=148
2017-09-13 06:50:21 DEBUG 114.69.209.134 ExtraFields::fetch_name_optionals_label
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ facture_fourn › ORDER BY pos
2017-09-13 06:50:21 DEBUG 114.69.209.134 FactureFournisseur::fetch_lines
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT f.rowid, f.ref as ref_supplier, f.description, f.pu_ht, f.pu_ttc, f.qty, f.remise_percent, f.vat_src_code, f.tva_tx, f.localtax1_tx, f.localtax2_tx, f.total_localtax1, f.total_localtax2, f.fk_facture_fourn , f.total_ht, f.tva as total_tva, f.total_ttc, f.fk_product, f.product_type, f.info_bits, f.rang, f.special_code, f.fk_parent_line, f.fk_unit, p.rowid as product_id, p.ref as product_ref, p.label as label, p.description as product_desc, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_subprice, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc FROM llx_facture_fourn_det as f LEFT JOIN llx_product as p ON f.fk_product = p.rowid WHERE fk_facture_fourn=148 ORDER BY f.rang, f.rowid
2017-09-13 06:50:21 DEBUG 114.69.209.134 FactureFournisseur::getSommePaiement
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 148
2017-09-13 06:50:21 INFO 114.69.209.134 box_factures_fourn_imp::showBox
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT s.nom as name, s.rowid as socid, s.datec, s.tms, s.status, s.code_fournisseur, s.logo FROM llx_societe as s WHERE s.fournisseur = 1 AND s.entity IN (1) ORDER BY s.tms DESC LIMIT 5
2017-09-13 06:50:21 INFO 114.69.209.134 box_fournisseurs::showBox
2017-09-13 06:50:21 INFO 114.69.209.134 ModeleBoxes::showBox
2017-09-13 06:50:21 DEBUG 114.69.209.134 box_clients::loadBox
2017-09-13 06:50:21 DEBUG 114.69.209.134 sql=SELECT s.nom as name, s.rowid as socid, s.code_client, s.client, s.code_fournisseur, s.fournisseur, s.logo, s.datec, s.tms, s.status FROM llx_societe as s WHERE s.client IN (1, 3) AND s.entity IN (1) ORDER BY s.tms DESC LIMIT 5
2017-09-13 06:50:21 INFO 114.69.209.134 box_clients::showBox
2017-09-13 06:50:21 DEBUG 114.69.209.134 box_prospect::loadBox
2017-09-13 06:50:21 DEBUG 114.69.209.134 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 llx_societe as s WHERE s.client IN (2, 3) AND s.entity IN (1) ORDER BY s.tms DESC LIMIT 5
2017-09-13 06:50:21 INFO 114.69.209.134 box_prospect::showBox
2017-09-13 06:50:21 DEBUG 114.69.209.134 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 llx_socpeople as sp LEFT JOIN llx_societe as s ON sp.fk_soc = s.rowid WHERE sp.entity IN (1) ORDER BY sp.tms DESC LIMIT 5
2017-09-13 06:50:21 INFO 114.69.209.134 box_contacts::showBox
2017-09-13 06:50:21 INFO 114.69.209.134 — End access to /index.php
Merci mais malheureusement cette erreur n’est pas provoqué par la db ( pas d’erreur dans le log), il faut donc regarder les log php mais leurs emplacement/existence dépend de votre config. apparemment pour toi c’est via logs.ovh.net
bien à to
Bonjour,
Je n’ai pas eu le temps de regarder. C’est quand même bizarre que seule cette page pose problème. Je regarde ca plus en avant.
Merci
Bonjour,
J’ai regardé dans l’error log apache / php et l’erreur que j’ai trouvé concerne la timezone dans le module date.lib.php de dolibarr.
Est-ce la raison du problème?
Cordialement/
Error log:
[Mon Oct 02 07:21:06 2017] [error] [client 114.69.213.x] PHP Warning: getdate(): It is not safe to rely on the system’s timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone ‹ UTC › for now, but please set date.timezone to select your timezone. in /usr/share/dolibarr/htdocs/core/lib/functions.lib.php on line 1456, referer: https://erp.gcs.nc/
[Mon Oct 02 07:21:06 2017] [error] [client 114.69.213.x] PHP Warning: getdate(): It is not safe to rely on the system’s timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone ‹ UTC › for now, but please set date.timezone to select your timezone. in /usr/share/dolibarr/htdocs/core/lib/functions.lib.php on line 1456, referer: https://erp.gcs.nc/
[Mon Oct 02 07:21:06 2017] [error] [client 114.69.213.x] PHP Fatal error: Uncaught exception ‹ Exception › with message ‹ DateTime::__construct(): It is not safe to rely on the system’s timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone ‹ UTC › for now, but please set date.timezone to select your timezone. › in /usr/share/dolibarr/htdocs/core/lib/date.lib.php:130\nStack trace:\n#0 /usr/share/dolibarr/htdocs/core/lib/date.lib.php(130): DateTime->__construct()\n#1 /usr/share/dolibarr/htdocs/core/boxes/box_activity.php(96): dol_time_plus_duree(1506921666, -2, ‹ y ›)\n#2 /usr/share/dolibarr/htdocs/core/class/html.formother.class.php(1183): box_activity->loadBox(5)\n#3 /usr/share/dolibarr/htdocs/index.php(82): FormOther::getBoxesArea(Object(User), ‹ 0 ›)\n#4 {main}\n thrown in /usr/share/dolibarr/htdocs/core/lib/date.lib.php on line 130, referer: https://erp.gcs.nc/
[Mon Oct 02 07:21:14 2017] [error] [client 114.69.213.x] PHP Warning: getdate(): It is not safe to rely on the system’s timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone ‹ UTC › for now, but please set date.timezone to select your timezone. in /usr/share/dolibarr/htdocs/core/lib/functions.lib.php on line 1456, referer: https://erp.gcs.nc/index.php?mainmenu=home
[Mon Oct 02 07:21:14 2017] [error] [client 114.69.213.x PHP Warning: getdate(): It is not safe to rely on the system’s timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone ‹ UTC › for now, but please set date.timezone to select your timezone. in /usr/share/dolibarr/htdocs/core/lib/functions.lib.php on line 1456, referer: https://erp.gcs.nc/index.php?mainmenu=home
[Mon Oct 02 07:21:14 2017] [error] [client 114.69.213.x] PHP Fatal error: Uncaught exception ‹ Exception › with message ‹ DateTime::__construct(): It is not safe to rely on the system’s timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone ‹ UTC › for now, but please set date.timezone to select your timezone. › in /usr/share/dolibarr/htdocs/core/lib/date.lib.php:130\nStack trace:\n#0 /usr/share/dolibarr/htdocs/core/lib/date.lib.php(130): DateTime->__construct()\n#1 /usr/share/dolibarr/htdocs/core/boxes/box_activity.php(96): dol_time_plus_duree(1506921674, -2, ‹ y ›)\n#2 /usr/share/dolibarr/htdocs/core/class/html.formother.class.php(1183): box_activity->loadBox(5)\n#3 /usr/share/dolibarr/htdocs/index.php(82): FormOther::getBoxesArea(Object(User), ‹ 0 ›)\n#4 {main}\n thrown in /usr/share/dolibarr/htdocs/core/lib/date.lib.php on line 130, referer: https://erp.gcs.nc/index.php?mainmenu=home
Bonjour,
Le soucis semble venir de la box activité
vs pouvez la déactiver avec ce liens
https://erp.gcs.nc/core/ajax/box.php?closing=1&userid=1
br
Bonjour,
Non, ca n’a pas marché. Mais j’ai trouvé la solution. en Fait je l’avais déjà trouvé mais j’avais modifié le mauvais php.ini
ca aurait le mérite de se trouver dans une FAQ.
Il faut donc modifier le php.ini (sur Debian: /etc/php5/apache2/php.ini)
et modifier la valeur: date.timezone ( rechercher date. dans votre éditeur)
[Date]
; Defines the default timezone used by the date functions
; http://php.net/date.timezone
date.timezone = ‹ Europe/Paris ›
ici ‹ Europe/Paris › mon serveur se trouvant chez OVH.
Le titre du sujet n’est pas le bon. Il devrait être: « Plus de page d’accueil après migration chez OVH »
Merci encore pour votre aide 
Cordialement.
Pierre Surmont.
ce message pour marquer résolu
Merci.
