Bonjour,
Voici une partie des logs:
2018-10-26 15:08:18 DEBUG 193.253.217.150 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 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 › ORDER BY u.entity ASC
2018-10-26 15:08:18 INFO 193.253.217.150 fetch_name_optionals_label elementtype=user
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,fielddefault,fieldcomputed,entity,enabled FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ user › ORDER BY pos
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT rowid, contrat, com_totalmonth_min, com_total_min, com_percentage, sortie, sosname, sostel, info FROM llx_user_extrafields WHERE fk_object = 1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (0,1) AND user_id IN (0, 1)
2018-10-26 15:08:18 DEBUG 193.253.217.150 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 ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
2018-10-26 15:08:18 DEBUG 193.253.217.150 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 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
2018-10-26 15:08:18 INFO 193.253.217.150 — Access to /custom/fastupload/js/fastupload.js.php - action=, massaction=
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang=‹ fr_FR ›
2018-10-26 15:08:18 DEBUG 193.253.217.150 Menubase::menuLoad mymainmenu=home myleftmenu=admintools type_user=0 menu_handler=eldy tabMenu size=0
2018-10-26 15:08:18 DEBUG 193.253.217.150 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
2018-10-26 15:08:18 INFO 193.253.217.150 — End access to /custom/fastupload/js/fastupload.js.php
2018-10-26 15:08:18 DEBUG 193.253.217.150 - This is an already logged session. _SESSION[‹ dol_login ›]=admin _SESSION[‹ dol_entity ›]=1
2018-10-26 15:08:18 DEBUG 193.253.217.150 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 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 › ORDER BY u.entity ASC
2018-10-26 15:08:18 INFO 193.253.217.150 fetch_name_optionals_label elementtype=user
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,fielddefault,fieldcomputed,entity,enabled FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ user › ORDER BY pos
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT rowid, contrat, com_totalmonth_min, com_total_min, com_percentage, sortie, sosname, sostel, info FROM llx_user_extrafields WHERE fk_object = 1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (0,1) AND user_id IN (0, 1)
2018-10-26 15:08:18 DEBUG 193.253.217.150 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 ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
2018-10-26 15:08:18 DEBUG 193.253.217.150 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 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
2018-10-26 15:08:18 INFO 193.253.217.150 — Access to /index.php - action=, massaction=
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang=‹ fr_FR ›
2018-10-26 15:08:18 DEBUG 193.253.217.150 Menubase::menuLoad mymainmenu=home myleftmenu=admintools type_user=0 menu_handler=eldy tabMenu size=0
2018-10-26 15:08:18 DEBUG 193.253.217.150 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
2018-10-26 15:08:18 INFO 193.253.217.150 HookManager::initHooks Loading hook class for context searchform: actions_domain.class.php
2018-10-26 15:08:18 DEBUG 193.253.217.150 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method addSearchEntry of class ActionsDomain, module=domain, action= context=searchform
2018-10-26 15:08:18 DEBUG 193.253.217.150 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method printSearchForm of class ActionsDomain, module=domain, action= context=searchform
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT rowid, title, url, target FROM llx_bookmark WHERE (fk_user = 1 OR fk_user is NULL OR fk_user = 0) AND entity IN (1) ORDER BY position
2018-10-26 15:08:18 DEBUG 193.253.217.150 InfoBox::listBoxes get default box list for mode=activated userid=1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT b.rowid, b.position, b.box_order, b.fk_user, d.rowid as box_id, d.file, d.note, d.tms FROM llx_boxes as b, llx_boxes_def as d WHERE b.box_id = d.rowid AND b.entity IN (0,1) AND b.position = 0 AND b.fk_user IN (0,1) ORDER BY b.box_order
2018-10-26 15:08:18 ERR 193.253.217.150 functions::dol_include_once Tried to load unexisting file: /management/core/boxes/box_projet.php
2018-10-26 15:08:18 WARNING 193.253.217.150 Failed to load box ‹ box_projet › into file ‹ /management/core/boxes/box_projet.php ›
2018-10-26 15:08:18 ERR 193.253.217.150 functions::dol_include_once Tried to load unexisting file: /management/core/boxes/box_task.php
2018-10-26 15:08:18 WARNING 193.253.217.150 Failed to load box ‹ box_task › into file ‹ /management/core/boxes/box_task.php ›
2018-10-26 15:08:18 INFO 193.253.217.150 FactureStats::getNbByMonthWithPrevYear read data from cache file /var/www/vhosts/konverseo.com/httpdocs/preproddolibarr/documents/users/temp/FactureStats_getNbByMonthWithPrevYear_customer_fr_FR_entity.1_user1.cache 1540556359.
2018-10-26 15:08:18 INFO 193.253.217.150 DolGraph::draw_jflot this->type= this->MaxValue=40
2018-10-26 15:08:18 INFO 193.253.217.150 FactureStats::getAmountByMonthWithPrevYear read data from cache file /var/www/vhosts/konverseo.com/httpdocs/preproddolibarr/documents/users/temp/FactureStats_getAmountByMonthWithPrevYear_customer_fr_FR_entity.1_user1.cache 1540556359.
2018-10-26 15:08:18 INFO 193.253.217.150 DolGraph::draw_jflot this->type= this->MaxValue=20000
2018-10-26 15:08:18 INFO 193.253.217.150 box_graph_invoices_permonth::showBox
2018-10-26 15:08:18 INFO 193.253.217.150 ModeleBoxes::showBox
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT t.rowid as id, t.ref, t.track_id, t.fk_soc, t.fk_user_create, t.fk_user_assign, t.subject, t.message, t.fk_statut, t.type_code, t.category_code, t.severity_code, t.datec, t.date_read, t.date_close, t.origin_email , type.label as type_label, category.label as category_label, severity.label as severity_label, s.nom as company_name FROM llx_ticket as t LEFT JOIN llx_c_ticket_type as type ON type.code=t.type_code LEFT JOIN llx_c_ticket_category as category ON category.code=t.category_code LEFT JOIN llx_c_ticket_severity as severity ON severity.code=t.severity_code LEFT JOIN llx_societe as s ON s.rowid=t.fk_soc WHERE t.entity = 1 ORDER BY t.datec DESC, t.rowid DESC LIMIT 30
2018-10-26 15:08:18 ERR 193.253.217.150 Functions.lib::dol_print_date function call with deprecated value of time in page /index.php
2018-10-26 15:08:18 ERR 193.253.217.150 Functions.lib::dol_print_date function call with deprecated value of time in page /index.php
2018-10-26 15:08:18 ERR 193.253.217.150 Functions.lib::dol_print_date function call with deprecated value of time in page /index.php
2018-10-26 15:08:18 ERR 193.253.217.150 Functions.lib::dol_print_date function call with deprecated value of time in page /index.php
2018-10-26 15:08:18 ERR 193.253.217.150 Functions.lib::dol_print_date function call with deprecated value of time in page /index.php
2018-10-26 15:08:18 ERR 193.253.217.150 Functions.lib::dol_print_date function call with deprecated value of time in page /index.php
2018-10-26 15:08:18 ERR 193.253.217.150 Functions.lib::dol_print_date function call with deprecated value of time in page /index.php
2018-10-26 15:08:18 ERR 193.253.217.150 Functions.lib::dol_print_date function call with deprecated value of time in page /index.php
2018-10-26 15:08:18 ERR 193.253.217.150 Functions.lib::dol_print_date function call with deprecated value of time in page /index.php
2018-10-26 15:08:18 ERR 193.253.217.150 Functions.lib::dol_print_date function call with deprecated value of time in page /index.php
2018-10-26 15:08:18 INFO 193.253.217.150 box_last_ticket::showBox
2018-10-26 15:08:18 DEBUG 193.253.217.150 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
2018-10-26 15:08:18 DEBUG 193.253.217.150 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 = 202
2018-10-26 15:08:18 DEBUG 193.253.217.150 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 = 201
2018-10-26 15:08:18 DEBUG 193.253.217.150 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 = 199
2018-10-26 15:08:18 DEBUG 193.253.217.150 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 = 171
2018-10-26 15:08:18 DEBUG 193.253.217.150 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 = 158
2018-10-26 15:08:18 DEBUG 193.253.217.150 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 = 57
2018-10-26 15:08:18 DEBUG 193.253.217.150 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 = 53
2018-10-26 15:08:18 DEBUG 193.253.217.150 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 = 41
2018-10-26 15:08:18 INFO 193.253.217.150 box_project::showBox
2018-10-26 15:08:18 DEBUG 193.253.217.150 box_comptes::loadBox
2018-10-26 15:08:18 DEBUG 193.253.217.150 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 llx_bank_account as b LEFT JOIN llx_accounting_journal as aj ON aj.rowid=b.fk_accountancy_journal WHERE b.entity = 1 AND clos = 0 ORDER BY label LIMIT 30
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT sum(amount) as amount FROM llx_bank WHERE fk_account = 1
2018-10-26 15:08:18 DEBUG 193.253.217.150 Translate::loadCacheCurrencies
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = ‹ EUR ›
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT sum(amount) as amount FROM llx_bank WHERE fk_account = 3
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT sum(amount) as amount FROM llx_bank WHERE fk_account = 2
2018-10-26 15:08:18 INFO 193.253.217.150 box_comptes::showBox
2018-10-26 15:08:18 INFO 193.253.217.150 CommandeStats::getNbByMonthWithPrevYear read data from cache file /var/www/vhosts/konverseo.com/httpdocs/preproddolibarr/documents/users/temp/CommandeStats_getNbByMonthWithPrevYear_customer_fr_FR_entity.1_user1.cache 1540556359.
2018-10-26 15:08:18 INFO 193.253.217.150 DolGraph::draw_jflot this->type= this->MaxValue=10
2018-10-26 15:08:18 INFO 193.253.217.150 CommandeStats::getAmountByMonthWithPrevYear read data from cache file /var/www/vhosts/konverseo.com/httpdocs/preproddolibarr/documents/users/temp/CommandeStats_getAmountByMonthWithPrevYear_customer_fr_FR_entity.1_user1.cache 1540556359.
2018-10-26 15:08:18 INFO 193.253.217.150 DolGraph::draw_jflot this->type= this->MaxValue=20000
2018-10-26 15:08:18 INFO 193.253.217.150 box_graph_orders_permonth::showBox
2018-10-26 15:08:18 INFO 193.253.217.150 ModeleBoxes::showBox
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT count(u.rowid) as nb FROM llx_user as u WHERE u.statut > 0 AND u.entity IN (0,1)
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT count(s.rowid) as nb, s.client FROM llx_societe as s WHERE s.client IN (1,2,3) AND s.entity IN (1) GROUP BY s.client
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT count(s.rowid) as nb FROM llx_societe as s WHERE s.fournisseur = 1 AND s.entity IN (1)
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT count(sp.rowid) as nb FROM llx_socpeople as sp WHERE sp.entity IN (1) AND (sp.priv=‹ 0 › OR (sp.priv=‹ 1 › AND sp.fk_user_creat=1))
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT count(p.rowid) as nb, fk_product_type FROM llx_product as p WHERE p.entity IN (1) GROUP BY fk_product_type
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT count(p.rowid) as nb FROM llx_propal as p LEFT JOIN llx_societe as s ON p.fk_soc = s.rowid WHERE p.entity IN (1)
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT count(co.rowid) as nb FROM llx_commande as co LEFT JOIN llx_societe as s ON co.fk_soc = s.rowid WHERE co.entity IN (1)
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT count(f.rowid) as nb FROM llx_facture as f LEFT JOIN llx_societe as s ON f.fk_soc = s.rowid WHERE f.entity = 1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT count(c.rowid) as nb FROM llx_contrat as c LEFT JOIN llx_societe as s ON c.fk_soc = s.rowid WHERE c.entity = 1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT count(fi.rowid) as nb FROM llx_fichinter as fi LEFT JOIN llx_societe as s ON fi.fk_soc = s.rowid WHERE fi.entity IN (1)
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT count(co.rowid) as nb FROM llx_commande_fournisseur as co LEFT JOIN llx_societe as s ON co.fk_soc = s.rowid WHERE co.entity = 1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT count(f.rowid) as nb FROM llx_facture_fourn as f LEFT JOIN llx_societe as s ON f.fk_soc = s.rowid WHERE f.entity = 1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT count(p.rowid) as nb FROM llx_projet as p WHERE p.entity IN (1)
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT count(ex.rowid) as nb FROM llx_expensereport as ex WHERE ex.fk_statut > 0 AND ex.entity IN (1)
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT a.id, a.datep as dp FROM (llx_actioncomm as a) LEFT JOIN llx_societe as s ON a.fk_soc = s.rowid WHERE 1 = 1 AND a.percent >= 0 AND a.percent < 100 AND a.entity IN (1)
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT p.rowid, p.fk_statut as status, p.fk_opp_status, p.datee as datee FROM (llx_projet as p) LEFT JOIN llx_societe as s on p.fk_soc = s.rowid WHERE p.fk_statut = 1 AND p.entity IN (1)
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT ctc.rowid, ctc.code FROM llx_c_type_contact as ctc WHERE ctc.element = ‹ project › AND ctc.source = ‹ internal ›
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT DISTINCT p.rowid, p.ref FROM llx_projet as p, llx_element_contact as ec WHERE p.entity IN (1) AND ec.element_id = p.rowid AND ( p.public = 1 OR ( ec.fk_c_type_contact IN (197,161,195,196,160,194) AND ec.fk_socpeople = 1) )
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT p.rowid as projectid, p.fk_statut as projectstatus, t.rowid as taskid, t.progress as progress, t.fk_statut as status, t.dateo as date_start, t.datee as datee FROM llx_projet as p LEFT JOIN llx_societe as s on p.fk_soc = s.rowid, llx_projet_task as t WHERE p.entity IN (1) AND p.fk_statut = 1 AND t.fk_projet = p.rowid AND t.progress < 100
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT p.rowid, p.ref, p.datec as datec, p.fin_validite as datefin FROM llx_propal as p WHERE p.entity IN (1) AND p.fk_statut = 1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT p.rowid, p.ref, p.datec as datec, p.fin_validite as datefin FROM llx_propal as p WHERE p.entity IN (1) AND p.fk_statut = 2
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT c.rowid, c.date_creation as datec, c.date_commande, c.date_livraison as delivery_date, c.fk_statut FROM llx_commande as c WHERE c.entity IN (1) AND ((c.fk_statut IN (1,2)) OR (c.fk_statut = 3 AND c.facture = 0))
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT c.rowid, c.date_creation as datec, c.date_commande, c.fk_statut, c.date_livraison as delivery_date FROM llx_commande_fournisseur as c WHERE c.entity = 1 AND c.fk_statut IN (1, 2)
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT cd.rowid, cd.date_ouverture_prevue as datefin FROM llx_contrat as c, llx_contratdet as cd, llx_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
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT cd.rowid, cd.date_fin_validite as datefin FROM llx_contrat as c, llx_contratdet as cd, llx_societe as s WHERE c.statut = 1 AND c.rowid = cd.fk_contrat AND cd.statut = 4 AND cd.date_fin_validite < ‹ 2018-10-26 15:08:18 › AND c.fk_soc = s.rowid AND c.entity = 1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT f.rowid, f.date_lim_reglement as datefin,f.fk_statut FROM llx_facture as f WHERE f.paye=0 AND f.entity = 1 AND f.fk_statut = 1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT ff.rowid, ff.date_lim_reglement as datefin, ff.fk_statut FROM llx_facture_fourn as ff WHERE ff.paye=0 AND ff.fk_statut > 0 AND ff.entity = 1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT COUNT(ba.rowid) as nb FROM llx_bank_account as ba WHERE ba.rappro > 0 and ba.clos = 0 AND ba.entity IN (1) AND ba.courant != 2
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT b.rowid, b.datev as datefin FROM llx_bank as b, llx_bank_account as ba WHERE b.rappro=0 AND b.fk_account = ba.rowid AND ba.entity IN (1) AND (ba.rappro = 1 AND ba.courant != 2) AND clos = 0
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT b.rowid, b.datev as datefin FROM llx_bank as b, llx_bank_account as ba WHERE b.fk_account = ba.rowid AND ba.entity IN (1) AND b.fk_type = ‹ CHQ › AND b.fk_bordereau = 0 AND b.amount > 0
2018-10-26 15:08:18 DEBUG 193.253.217.150 User::load_parentof
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT fk_user as id_parent, rowid as id_son FROM llx_user WHERE fk_user <> 0 AND entity IN (0,1)
2018-10-26 15:08:18 DEBUG 193.253.217.150 User::get_full_tree get user list
2018-10-26 15:08:18 DEBUG 193.253.217.150 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)
2018-10-26 15:08:18 DEBUG 193.253.217.150 User::get_full_tree call to build_path_from_id_user
2018-10-26 15:08:18 DEBUG 193.253.217.150 User::build_path_from_id_user id_user=1 protection=0
2018-10-26 15:08:18 DEBUG 193.253.217.150 User::build_path_from_id_user id_user=2 protection=0
2018-10-26 15:08:18 DEBUG 193.253.217.150 User::build_path_from_id_user id_user=3 protection=0
2018-10-26 15:08:18 DEBUG 193.253.217.150 User::build_path_from_id_user id_user=6 protection=0
2018-10-26 15:08:18 DEBUG 193.253.217.150 User::build_path_from_id_user id_user=9 protection=0
2018-10-26 15:08:18 DEBUG 193.253.217.150 User::build_path_from_id_user id_user=12 protection=0
2018-10-26 15:08:18 DEBUG 193.253.217.150 User::build_path_from_id_user id_user=13 protection=0
2018-10-26 15:08:18 DEBUG 193.253.217.150 User::build_path_from_id_user id_user=15 protection=0
2018-10-26 15:08:18 DEBUG 193.253.217.150 User::build_path_from_id_user id_user=19 protection=0
2018-10-26 15:08:18 DEBUG 193.253.217.150 User::build_path_from_id_user id_user=20 protection=0
2018-10-26 15:08:18 DEBUG 193.253.217.150 User::build_path_from_id_user id_user=21 protection=0
2018-10-26 15:08:18 DEBUG 193.253.217.150 User::build_path_from_id_user id_user=22 protection=0
2018-10-26 15:08:18 DEBUG 193.253.217.150 User::get_full_tree dol_sort_array
2018-10-26 15:08:18 INFO 193.253.217.150 Build childid for id = 1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT ex.rowid, ex.date_valid FROM llx_expensereport as ex WHERE ex.fk_statut = 2 AND ex.entity IN (1) AND (ex.fk_user_author IN (3,9,6,22,2,15,21,12,13,1) OR ex.fk_user_validator IN (3,9,6,22,2,15,21,12,13,1))
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT ex.rowid, ex.date_valid FROM llx_expensereport as ex WHERE ex.fk_statut = 5 AND ex.entity IN (1) AND (ex.fk_user_author IN (3,9,6,22,2,15,21,12,13,1) OR ex.fk_user_validator IN (3,9,6,22,2,15,21,12,13,1))
2018-10-26 15:08:18 INFO 193.253.217.150 — End access to /index.php
2018-10-26 15:08:18 DEBUG 193.253.217.150 - This is an already logged session. _SESSION[‹ dol_login ›]=admin _SESSION[‹ dol_entity ›]=1
2018-10-26 15:08:18 DEBUG 193.253.217.150 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 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 › ORDER BY u.entity ASC
2018-10-26 15:08:18 INFO 193.253.217.150 fetch_name_optionals_label elementtype=user
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,fielddefault,fieldcomputed,entity,enabled FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ user › ORDER BY pos
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT rowid, contrat, com_totalmonth_min, com_total_min, com_percentage, sortie, sosname, sostel, info FROM llx_user_extrafields WHERE fk_object = 1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (0,1) AND user_id IN (0, 1)
2018-10-26 15:08:18 DEBUG 193.253.217.150 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 ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
2018-10-26 15:08:18 DEBUG 193.253.217.150 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 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
2018-10-26 15:08:18 INFO 193.253.217.150 — Access to /index.php - action=, massaction=
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang=‹ fr_FR ›
2018-10-26 15:08:18 DEBUG 193.253.217.150 Menubase::menuLoad mymainmenu=home myleftmenu=admintools type_user=0 menu_handler=eldy tabMenu size=0
2018-10-26 15:08:18 DEBUG 193.253.217.150 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
2018-10-26 15:08:18 INFO 193.253.217.150 HookManager::initHooks Loading hook class for context searchform: actions_domain.class.php
2018-10-26 15:08:18 DEBUG 193.253.217.150 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method addSearchEntry of class ActionsDomain, module=domain, action= context=searchform
2018-10-26 15:08:18 DEBUG 193.253.217.150 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method printSearchForm of class ActionsDomain, module=domain, action= context=searchform
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT rowid, title, url, target FROM llx_bookmark WHERE (fk_user = 1 OR fk_user is NULL OR fk_user = 0) AND entity IN (1) ORDER BY position
2018-10-26 15:08:18 DEBUG 193.253.217.150 InfoBox::listBoxes get default box list for mode=activated userid=1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT b.rowid, b.position, b.box_order, b.fk_user, d.rowid as box_id, d.file, d.note, d.tms FROM llx_boxes as b, llx_boxes_def as d WHERE b.box_id = d.rowid AND b.entity IN (0,1) AND b.position = 0 AND b.fk_user IN (0,1) ORDER BY b.box_order
2018-10-26 15:08:18 ERR 193.253.217.150 functions::dol_include_once Tried to load unexisting file: /management/core/boxes/box_projet.php
2018-10-26 15:08:18 WARNING 193.253.217.150 Failed to load box ‹ box_projet › into file ‹ /management/core/boxes/box_projet.php ›
2018-10-26 15:08:18 ERR 193.253.217.150 functions::dol_include_once Tried to load unexisting file: /management/core/boxes/box_task.php
2018-10-26 15:08:18 WARNING 193.253.217.150 Failed to load box ‹ box_task › into file ‹ /management/core/boxes/box_task.php ›
2018-10-26 15:08:18 INFO 193.253.217.150 FactureStats::getNbByMonthWithPrevYear read data from cache file /var/www/vhosts/konverseo.com/httpdocs/preproddolibarr/documents/users/temp/FactureStats_getNbByMonthWithPrevYear_customer_fr_FR_entity.1_user1.cache 1540556359.
2018-10-26 15:08:18 INFO 193.253.217.150 DolGraph::draw_jflot this->type= this->MaxValue=40
2018-10-26 15:08:18 INFO 193.253.217.150 FactureStats::getAmountByMonthWithPrevYear read data from cache file /var/www/vhosts/konverseo.com/httpdocs/preproddolibarr/documents/users/temp/FactureStats_getAmountByMonthWithPrevYear_customer_fr_FR_entity.1_user1.cache 1540556359.
2018-10-26 15:08:18 INFO 193.253.217.150 DolGraph::draw_jflot this->type= this->MaxValue=20000
2018-10-26 15:08:18 INFO 193.253.217.150 box_graph_invoices_permonth::showBox
2018-10-26 15:08:18 INFO 193.253.217.150 ModeleBoxes::showBox
Est-il possible d’importer les tiers en masse via une requête SQL ?