Bonjour,
J’ai le même soucis depuis mon passage en 5.0, lors de la sélection des mes commandes à facturer, dés que je clique sur Brouillon il revient sur l’écran de sélection des Commandes à facturer.
J’ai tenté d’arrêter et redémarrer les modules un à un commande cité dans ce poste : [url=www.dolibarr.fr/forum/t/impossible-de-valider-une-facture-en-v5/24767/1 modules[/url] mains le problème reste identique.
Avez vous trouver une solution svp ?
Ci-dessous le Log de Dolibarr si cela peut aider :
2017-03-31 10:16:23 DEBUG 192.168.1.166 This is an already logged session. _SESSION[‹ dol_login ›]=VF
2017-03-31 10:16:23 DEBUG 192.168.1.166 User::fetch
2017-03-31 10:16:23 DEBUG 192.168.1.166 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 IS NOT NULL AND u.login = ‹ VF ›
2017-03-31 10:16:23 DEBUG 192.168.1.166 ExtraFields::fetch_name_optionals_label
2017-03-31 10:16:23 DEBUG 192.168.1.166 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-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 5 AND entity = 1
2017-03-31 10:16:23 DEBUG 192.168.1.166 User::getrights
2017-03-31 10:16:23 DEBUG 192.168.1.166 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= 5 AND r.perms IS NOT NULL
2017-03-31 10:16:23 DEBUG 192.168.1.166 User::getrights
2017-03-31 10:16:23 DEBUG 192.168.1.166 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 = 5 AND r.perms IS NOT NULL
2017-03-31 10:16:23 DEBUG 192.168.1.166 — Access to /dolibarr/admin/modules.php
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang=‹ fr_FR ›
2017-03-31 10:16:23 DEBUG 192.168.1.166 Menubase::menuLoad mymainmenu=home myleftmenu=setup type_user=0 menu_handler=eldy tabMenu size=0
2017-03-31 10:16:23 DEBUG 192.168.1.166 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-03-31 10:16:23 DEBUG 192.168.1.166 Scan directory D:/dolibarr/www/dolibarr/htdocs/core/modules/ for module descriptor files (modXXX.class.php)
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ adherent › AND type != ‹ separate › AND entity IN (0, 1)
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = ‹ adherent › AND entity = 1
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT code, label, description FROM llx_c_action_trigger ORDER by rang
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ societe ›
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ socpeople ›
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ commande › AND type != ‹ separate › AND entity IN (0, 1)
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ commandedet › AND type != ‹ separate › AND entity IN (0, 1)
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ product › AND type != ‹ separate › AND entity IN (0, 1)
2017-03-31 10:16:23 DEBUG 192.168.1.166 User::load_parentof
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT fk_user as id_parent, rowid as id_son FROM llx_user WHERE fk_user <> 0 AND entity IN (0,1)
2017-03-31 10:16:23 DEBUG 192.168.1.166 User::get_full_tree get user list
2017-03-31 10:16:23 DEBUG 192.168.1.166 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-03-31 10:16:23 DEBUG 192.168.1.166 User::get_full_tree call to build_path_from_id_user
2017-03-31 10:16:23 DEBUG 192.168.1.166 User::build_path_from_id_user id_user=1 protection=0
2017-03-31 10:16:23 DEBUG 192.168.1.166 User::build_path_from_id_user id_user=3 protection=0
2017-03-31 10:16:23 DEBUG 192.168.1.166 User::build_path_from_id_user id_user=4 protection=0
2017-03-31 10:16:23 DEBUG 192.168.1.166 User::build_path_from_id_user id_user=5 protection=0
2017-03-31 10:16:23 DEBUG 192.168.1.166 User::build_path_from_id_user id_user=6 protection=0
2017-03-31 10:16:23 DEBUG 192.168.1.166 User::build_path_from_id_user id_user=7 protection=0
2017-03-31 10:16:23 DEBUG 192.168.1.166 User::get_full_tree dol_sort_array
2017-03-31 10:16:23 DEBUG 192.168.1.166 Build childid for id = 5
2017-03-31 10:16:23 DEBUG 192.168.1.166 Module modDeplacement not qualified
2017-03-31 10:16:23 DEBUG 192.168.1.166 Module modDocumentGeneration not qualified
2017-03-31 10:16:23 DEBUG 192.168.1.166 Module modDynamicPrices not qualified
2017-03-31 10:16:23 DEBUG 192.168.1.166 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-03-31 10:16:23 DEBUG 192.168.1.166 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-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ expedition › AND type != ‹ separate › AND entity IN (0, 1)
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ expeditiondet › AND type != ‹ separate › AND entity IN (0, 1)
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ facture › AND type != ‹ separate › AND entity IN (0, 1)
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ facturedet › AND type != ‹ separate › AND entity IN (0, 1)
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ product › AND type != ‹ separate › AND entity IN (0, 1)
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ facture › AND type != ‹ separate › AND entity IN (0, 1)
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ facture_fourn ›
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ facture_fourn_det ›
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ facture_fourn ›
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ commande_fournisseur ›
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ commande_fournisseurdet ›
2017-03-31 10:16:23 DEBUG 192.168.1.166 Module modHRM not qualified
2017-03-31 10:16:23 DEBUG 192.168.1.166 Module modLabel not qualified
2017-03-31 10:16:23 DEBUG 192.168.1.166 useNPR
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = ‹ FR › AND t.active = 1 AND t.recuperableonly = 1
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ product › AND type != ‹ separate › AND entity IN (0, 1)
2017-03-31 10:16:23 DEBUG 192.168.1.166 useNPR
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = ‹ FR › AND t.active = 1 AND t.recuperableonly = 1
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = ‹ product › AND entity IN (0, 1)
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ projet › AND type != ‹ separate › AND entity IN (0, 1)
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ projet_task › AND type != ‹ separate › AND entity IN (0, 1)
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = ‹ projet_task › AND entity = 1
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ propal › AND type != ‹ separate › AND entity IN (0, 1)
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ propaldet › AND type != ‹ separate › AND entity IN (0, 1)
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ product › AND type != ‹ separate › AND entity IN (0, 1)
2017-03-31 10:16:23 DEBUG 192.168.1.166 Module modReceiptPrinter not qualified
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT name, label, type FROM llx_extrafields WHERE elementtype = ‹ product ›
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = ‹ product › AND entity = 1
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ societe › AND type != ‹ separate › AND entity IN (0, 1)
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ socpeople › AND type != ‹ separate › AND entity IN (0, 1)
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ societe › AND type != ‹ separate › AND entity IN (0, 1)
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = ‹ societe › AND entity = 1
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = ‹ socpeople › AND entity = 1
2017-03-31 10:16:23 DEBUG 192.168.1.166 Module modWebServicesClient not qualified
2017-03-31 10:16:23 DEBUG 192.168.1.166 Module modWebsite not qualified
2017-03-31 10:16:23 DEBUG 192.168.1.166 Module modWebsites not qualified
2017-03-31 10:16:23 DEBUG 192.168.1.166 Scan directory D:/dolibarr/www/dolibarr/htdocs/ecotaxdeee/core/modules/ for module descriptor files (modXXX.class.php)
2017-03-31 10:16:23 DEBUG 192.168.1.166 modUser::getLastActiveDate
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_USER › AND entity IN (0, 1)
2017-03-31 10:16:23 DEBUG 192.168.1.166 modExpenseReport::getLastActiveDate
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_EXPENSEREPORT › AND entity IN (0, 1)
2017-03-31 10:16:23 DEBUG 192.168.1.166 modSalaries::getLastActiveDate
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_SALARIES › AND entity IN (0, 1)
2017-03-31 10:16:23 DEBUG 192.168.1.166 modSociete::getLastActiveDate
2017-03-31 10:16:23 DEBUG 192.168.1.166 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_SOCIETE › AND entity IN (0, 1)
2017-03-31 10:16:24 DEBUG 192.168.1.166 modPropale::getLastActiveDate
2017-03-31 10:16:24 DEBUG 192.168.1.166 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_PROPALE › AND entity IN (0, 1)
2017-03-31 10:16:24 DEBUG 192.168.1.166 modCommande::getLastActiveDate
2017-03-31 10:16:24 DEBUG 192.168.1.166 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_COMMANDE › AND entity IN (0, 1)
2017-03-31 10:16:24 DEBUG 192.168.1.166 modExpedition::getLastActiveDate
2017-03-31 10:16:24 DEBUG 192.168.1.166 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_EXPEDITION › AND entity IN (0, 1)
2017-03-31 10:16:24 DEBUG 192.168.1.166 modFournisseur::getLastActiveDate
2017-03-31 10:16:24 DEBUG 192.168.1.166 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_FOURNISSEUR › AND entity IN (0, 1)
2017-03-31 10:16:24 DEBUG 192.168.1.166 modFacture::getLastActiveDate
2017-03-31 10:16:24 DEBUG 192.168.1.166 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_FACTURE › AND entity IN (0, 1)
2017-03-31 10:16:24 DEBUG 192.168.1.166 modTax::getLastActiveDate
2017-03-31 10:16:24 DEBUG 192.168.1.166 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_TAX › AND entity IN (0, 1)
2017-03-31 10:16:24 DEBUG 192.168.1.166 modBanque::getLastActiveDate
2017-03-31 10:16:24 DEBUG 192.168.1.166 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_BANQUE › AND entity IN (0, 1)
2017-03-31 10:16:24 DEBUG 192.168.1.166 modMargin::getLastActiveDate
2017-03-31 10:16:24 DEBUG 192.168.1.166 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_MARGIN › AND entity IN (0, 1)
2017-03-31 10:16:24 DEBUG 192.168.1.166 modComptabilite::getLastActiveDate
2017-03-31 10:16:24 DEBUG 192.168.1.166 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_COMPTABILITE › AND entity IN (0, 1)
2017-03-31 10:16:24 DEBUG 192.168.1.166 modProduct::getLastActiveDate
2017-03-31 10:16:24 DEBUG 192.168.1.166 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_PRODUCT › AND entity IN (0, 1)
2017-03-31 10:16:24 DEBUG 192.168.1.166 modService::getLastActiveDate
2017-03-31 10:16:24 DEBUG 192.168.1.166 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_SERVICE › AND entity IN (0, 1)
2017-03-31 10:16:24 DEBUG 192.168.1.166 modEcoTaxDeee::getLastActiveDate
2017-03-31 10:16:24 DEBUG 192.168.1.166 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_ECOTAXDEEE › AND entity IN (0, 1)
2017-03-31 10:16:24 DEBUG 192.168.1.166 modProjet::getLastActiveDate
2017-03-31 10:16:24 DEBUG 192.168.1.166 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_PROJET › AND entity IN (0, 1)
2017-03-31 10:16:24 DEBUG 192.168.1.166 modAgenda::getLastActiveDate
2017-03-31 10:16:24 DEBUG 192.168.1.166 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_AGENDA › AND entity IN (0, 1)
2017-03-31 10:16:24 DEBUG 192.168.1.166 modECM::getLastActiveDate
2017-03-31 10:16:24 DEBUG 192.168.1.166 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_ECM › AND entity IN (0, 1)
2017-03-31 10:16:24 DEBUG 192.168.1.166 modCategorie::getLastActiveDate
2017-03-31 10:16:24 DEBUG 192.168.1.166 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_CATEGORIE › AND entity IN (0, 1)
2017-03-31 10:16:24 DEBUG 192.168.1.166 modFckeditor::getLastActiveDate
2017-03-31 10:16:24 DEBUG 192.168.1.166 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_FCKEDITOR › AND entity IN (0, 1)
2017-03-31 10:16:24 DEBUG 192.168.1.166 modMailing::getLastActiveDate
2017-03-31 10:16:24 DEBUG 192.168.1.166 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_MAILING › AND entity IN (0, 1)
2017-03-31 10:16:24 DEBUG 192.168.1.166 modImport::getLastActiveDate
2017-03-31 10:16:24 DEBUG 192.168.1.166 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_IMPORT › AND entity IN (0, 1)
2017-03-31 10:16:24 DEBUG 192.168.1.166 modExport::getLastActiveDate
2017-03-31 10:16:24 DEBUG 192.168.1.166 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_EXPORT › AND entity IN (0, 1)
2017-03-31 10:16:24 DEBUG 192.168.1.166 modSyslog::getLastActiveDate
2017-03-31 10:16:24 DEBUG 192.168.1.166 sql=SELECT tms FROM llx_const WHERE name = ‹ MAIN_MODULE_SYSLOG › AND entity IN (0, 1)
2017-03-31 10:16:24 DEBUG 192.168.1.166 — End access to /dolibarr/admin/modules.php
2017-03-31 10:16:26 DEBUG 192.168.1.166 This is an already logged session. _SESSION[‹ dol_login ›]=VF
2017-03-31 10:16:26 DEBUG 192.168.1.166 User::fetch
2017-03-31 10:16:26 DEBUG 192.168.1.166 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 IS NOT NULL AND u.login = ‹ VF ›
2017-03-31 10:16:26 DEBUG 192.168.1.166 ExtraFields::fetch_name_optionals_label
2017-03-31 10:16:26 DEBUG 192.168.1.166 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-03-31 10:16:26 DEBUG 192.168.1.166 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 5 AND entity = 1
2017-03-31 10:16:26 DEBUG 192.168.1.166 User::getrights
2017-03-31 10:16:26 DEBUG 192.168.1.166 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= 5 AND r.perms IS NOT NULL
2017-03-31 10:16:26 DEBUG 192.168.1.166 User::getrights
2017-03-31 10:16:26 DEBUG 192.168.1.166 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 = 5 AND r.perms IS NOT NULL
2017-03-31 10:16:26 DEBUG 192.168.1.166 — Access to /dolibarr/admin/syslog.php
2017-03-31 10:16:26 DEBUG 192.168.1.166 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang=‹ fr_FR ›
2017-03-31 10:16:26 DEBUG 192.168.1.166 Menubase::menuLoad mymainmenu=home myleftmenu=setup type_user=0 menu_handler=eldy tabMenu size=0
2017-03-31 10:16:26 DEBUG 192.168.1.166 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-03-31 10:16:26 DEBUG 192.168.1.166 admin.lib::dolibarr_get_const
2017-03-31 10:16:26 DEBUG 192.168.1.166 sql=SELECT value as value FROM llx_const WHERE name = ‹ SYSLOG_FACILITY › AND entity = 0
2017-03-31 10:16:26 DEBUG 192.168.1.166 admin.lib::dolibarr_get_const
2017-03-31 10:16:26 DEBUG 192.168.1.166 sql=SELECT value as value FROM llx_const WHERE name = ‹ SYSLOG_FILE › AND entity = 0
2017-03-31 10:16:26 DEBUG 192.168.1.166 — End access to /dolibarr/admin/syslog.php
2017-03-31 10:16:50 DEBUG 192.168.1.166 This is an already logged session. _SESSION[‹ dol_login ›]=VF
2017-03-31 10:16:50 DEBUG 192.168.1.166 User::fetch
2017-03-31 10:16:50 DEBUG 192.168.1.166 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 IS NOT NULL AND u.login = ‹ VF ›
2017-03-31 10:16:50 DEBUG 192.168.1.166 ExtraFields::fetch_name_optionals_label
2017-03-31 10:16:50 DEBUG 192.168.1.166 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-03-31 10:16:50 DEBUG 192.168.1.166 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 5 AND entity = 1
2017-03-31 10:16:50 DEBUG 192.168.1.166 User::getrights
2017-03-31 10:16:50 DEBUG 192.168.1.166 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= 5 AND r.perms IS NOT NULL
2017-03-31 10:16:50 DEBUG 192.168.1.166 User::getrights
2017-03-31 10:16:50 DEBUG 192.168.1.166 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 = 5 AND r.perms IS NOT NULL
2017-03-31 10:16:50 DEBUG 192.168.1.166 — Access to /dolibarr/comm/index.php
2017-03-31 10:16:50 DEBUG 192.168.1.166 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang=‹ fr_FR ›
2017-03-31 10:16:50 DEBUG 192.168.1.166 Menubase::menuLoad mymainmenu=commercial myleftmenu= type_user=0 menu_handler=eldy tabMenu size=0
2017-03-31 10:16:50 DEBUG 192.168.1.166 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-03-31 10:16:50 DEBUG 192.168.1.166 sql=SELECT p.rowid, p.ref, p.ref_client, p.total_ht, p.tva as total_tva, p.total as total_ttc, s.rowid as socid, s.nom as name, s.client, s.canvas, s.code_client FROM llx_propal as p, llx_societe as s WHERE p.fk_statut = 0 AND p.fk_soc = s.rowid AND p.entity IN (1)
2017-03-31 10:16:50 DEBUG 192.168.1.166 Translate::loadCacheCurrencies
2017-03-31 10:16:50 DEBUG 192.168.1.166 sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = ‹ EUR ›
2017-03-31 10:16:50 DEBUG 192.168.1.166 sql=SELECT c.rowid, c.ref, c.ref_client, c.total_ht, c.tva as total_tva, c.total_ttc, s.rowid as socid, s.nom as name, s.client, s.canvas, s.code_client FROM llx_commande as c, llx_societe as s WHERE c.fk_soc = s.rowid AND c.fk_statut = 0 AND c.entity IN (1)
2017-03-31 10:16:50 DEBUG 192.168.1.166 sql=SELECT cf.rowid, cf.ref, cf.ref_supplier, cf.total_ttc, s.rowid as socid, s.nom as name, s.client, s.canvas, s.code_client, s.code_fournisseur FROM llx_commande_fournisseur as cf, llx_societe as s WHERE cf.fk_soc = s.rowid AND cf.fk_statut = 0 AND cf.entity IN (1)
2017-03-31 10:16:50 DEBUG 192.168.1.166 sql=SELECT s.rowid, s.nom as name, s.client, s.datec, s.tms, s.canvas, s.code_client FROM llx_societe as s WHERE s.client IN (1, 2, 3) AND s.entity IN (1) ORDER BY s.tms DESC LIMIT 3
2017-03-31 10:16:50 DEBUG 192.168.1.166 sql=SELECT s.nom as name, s.rowid, s.datec as dc, s.canvas, s.tms as dm, s.code_fournisseur FROM llx_societe as s WHERE s.fournisseur = 1 AND s.entity IN (1) ORDER BY s.datec DESC LIMIT 3
2017-03-31 10:16:50 DEBUG 192.168.1.166 sql=SELECT a.id, a.percent, a.datep as da, a.datep2 as da2, a.fk_user_author, a.label, c.code, c.libelle, s.rowid, s.nom as sname, s.client FROM llx_c_actioncomm as c LEFT JOIN llx_actioncomm as a ON c.id = a.fk_action LEFT JOIN llx_societe as s ON a.fk_soc = s.rowid WHERE a.entity = 1 AND (a.percent >= 100 OR (a.percent = -1 AND a.datep2 <= ‹ 20170331101650 ›)) ORDER BY a.datep2 DESC LIMIT 3
2017-03-31 10:16:50 DEBUG 192.168.1.166 sql=SELECT a.id, a.label, a.datep as dp, a.datep2 as dp2, a.fk_user_author, a.percent, c.code, c.libelle as type_label, s.nom as sname, s.rowid, s.client FROM llx_c_actioncomm as c LEFT JOIN llx_actioncomm as a ON c.id = a.fk_action LEFT JOIN llx_societe as s ON a.fk_soc = s.rowid WHERE a.entity = 1 AND ((a.percent >= 0 AND a.percent < 100) OR (a.percent = -1 AND a.datep2 > ‹ 20170331101650 ›)) ORDER BY a.datep DESC, a.id DESC LIMIT 10
2017-03-31 10:16:50 DEBUG 192.168.1.166 sql=SELECT s.nom as name, s.rowid, p.rowid as propalid, p.total as total_ttc, p.total_ht, p.tva as total_tva, p.ref, p.ref_client, p.fk_statut, p.datep as dp, p.fin_validite as dfv, s.code_client FROM llx_societe as s, llx_propal as p WHERE p.fk_soc = s.rowid AND p.entity IN (1) AND p.fk_statut = 1 ORDER BY p.rowid DESC
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1703-0345 types=files recursive=0 filter=PR1703-0345[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1703-0337 types=files recursive=0 filter=PR1703-0337[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1703-0332 types=files recursive=0 filter=PR1703-0332[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1703-0329 types=files recursive=0 filter=PR1703-0329[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1703-0325 types=files recursive=0 filter=PR1703-0325[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1703-0322 types=files recursive=0 filter=PR1703-0322[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1703-0320 types=files recursive=0 filter=PR1703-0320[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1703-0319 types=files recursive=0 filter=PR1703-0319[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1703-0318 types=files recursive=0 filter=PR1703-0318[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1703-0314 types=files recursive=0 filter=PR1703-0314[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1703-0312 types=files recursive=0 filter=PR1703-0312[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1703-0310 types=files recursive=0 filter=PR1703-0310[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1703-0309 types=files recursive=0 filter=PR1703-0309[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1703-0307 types=files recursive=0 filter=PR1703-0307[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1703-0305 types=files recursive=0 filter=PR1703-0305[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1702-0299 types=files recursive=0 filter=PR1702-0299[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1702-0298 types=files recursive=0 filter=PR1702-0298[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1702-0297 types=files recursive=0 filter=PR1702-0297[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1702-0295 types=files recursive=0 filter=PR1702-0295[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1702-0293 types=files recursive=0 filter=PR1702-0293[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1702-0294 types=files recursive=0 filter=PR1702-0294[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1702-0290 types=files recursive=0 filter=PR1702-0290[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1702-0287 types=files recursive=0 filter=PR1702-0287[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1702-0286 types=files recursive=0 filter=PR1702-0286[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1702-0283 types=files recursive=0 filter=PR1702-0283[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1702-0273 types=files recursive=0 filter=PR1702-0273[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1702-0272 types=files recursive=0 filter=PR1702-0272[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1702-0271 types=files recursive=0 filter=PR1702-0271[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1702-0266 types=files recursive=0 filter=PR1702-0266[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1702-0264 types=files recursive=0 filter=PR1702-0264[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1701-0255 types=files recursive=0 filter=PR1701-0255[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1701-0253 types=files recursive=0 filter=PR1701-0253[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1701-0227 types=files recursive=0 filter=PR1701-0227[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1701-0216 types=files recursive=0 filter=PR1701-0216[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1701-0215 types=files recursive=0 filter=PR1701-0215[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1612-0207 types=files recursive=0 filter=PR1612-0207[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1612-0202 types=files recursive=0 filter=PR1612-0202[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1612-0200 types=files recursive=0 filter=PR1612-0200[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1612-0199 types=files recursive=0 filter=PR1612-0199[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1612-0185 types=files recursive=0 filter=PR1612-0185[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1612-0184 types=files recursive=0 filter=PR1612-0184[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1611-0177 types=files recursive=0 filter=PR1611-0177[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1611-0176 types=files recursive=0 filter=PR1611-0176[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1611-0175 types=files recursive=0 filter=PR1611-0175[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1611-0172 types=files recursive=0 filter=PR1611-0172[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1611-0171 types=files recursive=0 filter=PR1611-0171[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1611-0162 types=files recursive=0 filter=PR1611-0162[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1611-0161 types=files recursive=0 filter=PR1611-0161[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1611-0138 types=files recursive=0 filter=PR1611-0138[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1610-0122 types=files recursive=0 filter=PR1610-0122[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/propale/PR1610-0119 types=files recursive=0 filter=PR1610-0119[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 sql=SELECT s.nom as name, s.rowid, c.rowid as commandeid, c.total_ttc, c.total_ht, c.tva as total_tva, c.ref, c.ref_client, c.fk_statut, c.date_valid as dv, c.facture as billed, s.code_client FROM llx_societe as s, llx_commande as c WHERE c.fk_soc = s.rowid AND c.entity IN (1) AND c.fk_statut = 1 ORDER BY c.rowid DESC
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/commande/CO1703-0433 types=files recursive=0 filter=CO1703-0433[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/commande/CO1703-0438 types=files recursive=0 filter=CO1703-0438[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/commande/CO1703-0430 types=files recursive=0 filter=CO1703-0430[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/commande/CO1703-0429 types=files recursive=0 filter=CO1703-0429[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/commande/CO1703-0416 types=files recursive=0 filter=CO1703-0416[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:16:50 DEBUG 192.168.1.166 — End access to /dolibarr/comm/index.php
2017-03-31 10:17:19 DEBUG 192.168.1.166 This is an already logged session. _SESSION[‹ dol_login ›]=VF
2017-03-31 10:17:19 DEBUG 192.168.1.166 User::fetch
2017-03-31 10:17:19 DEBUG 192.168.1.166 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 IS NOT NULL AND u.login = ‹ VF ›
2017-03-31 10:17:19 DEBUG 192.168.1.166 ExtraFields::fetch_name_optionals_label
2017-03-31 10:17:19 DEBUG 192.168.1.166 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-03-31 10:17:19 DEBUG 192.168.1.166 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 5 AND entity = 1
2017-03-31 10:17:19 DEBUG 192.168.1.166 User::getrights
2017-03-31 10:17:19 DEBUG 192.168.1.166 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= 5 AND r.perms IS NOT NULL
2017-03-31 10:17:19 DEBUG 192.168.1.166 User::getrights
2017-03-31 10:17:19 DEBUG 192.168.1.166 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 = 5 AND r.perms IS NOT NULL
2017-03-31 10:17:19 DEBUG 192.168.1.166 — Access to /dolibarr/commande/list.php
2017-03-31 10:17:19 DEBUG 192.168.1.166 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang=‹ fr_FR ›
2017-03-31 10:17:19 DEBUG 192.168.1.166 Menubase::menuLoad mymainmenu=commercial myleftmenu=orders type_user=0 menu_handler=eldy tabMenu size=0
2017-03-31 10:17:19 DEBUG 192.168.1.166 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-03-31 10:17:19 DEBUG 192.168.1.166 ExtraFields::fetch_name_optionals_label
2017-03-31 10:17:19 DEBUG 192.168.1.166 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 = ‹ commande › ORDER BY pos
2017-03-31 10:17:19 DEBUG 192.168.1.166 sql=SELECT s.rowid as socid, s.nom as name, s.town, s.zip, s.fk_pays, s.client, s.code_client, typent.code as typent_code, state.code_departement as state_code, state.nom as state_name, c.rowid, c.ref, c.total_ht, c.tva as total_tva, c.total_ttc, c.ref_client, c.date_valid, c.date_commande, c.note_private, c.date_livraison as date_delivery, c.fk_statut, c.facture as billed, c.date_creation as date_creation, c.tms as date_update FROM llx_societe as s LEFT JOIN llx_c_country as country on (country.rowid = s.fk_pays) LEFT JOIN llx_c_typent as typent on (typent.id = s.fk_typent) LEFT JOIN llx_c_departements as state on (state.rowid = s.fk_departement), llx_commande as c WHERE c.fk_soc = s.rowid AND c.entity IN (1) ORDER BY c.ref DESC
2017-03-31 10:17:19 DEBUG 192.168.1.166 sql=SELECT s.rowid as socid, s.nom as name, s.town, s.zip, s.fk_pays, s.client, s.code_client, typent.code as typent_code, state.code_departement as state_code, state.nom as state_name, c.rowid, c.ref, c.total_ht, c.tva as total_tva, c.total_ttc, c.ref_client, c.date_valid, c.date_commande, c.note_private, c.date_livraison as date_delivery, c.fk_statut, c.facture as billed, c.date_creation as date_creation, c.tms as date_update FROM llx_societe as s LEFT JOIN llx_c_country as country on (country.rowid = s.fk_pays) LEFT JOIN llx_c_typent as typent on (typent.id = s.fk_typent) LEFT JOIN llx_c_departements as state on (state.rowid = s.fk_departement), llx_commande as c WHERE c.fk_soc = s.rowid AND c.entity IN (1) ORDER BY c.ref DESC LIMIT 101
2017-03-31 10:17:19 DEBUG 192.168.1.166 sql=SELECT u.rowid, u.lastname, u.firstname, u.statut, u.login FROM llx_user as u WHERE u.entity IN (0,1) ORDER BY u.statut DESC, lastname ASC
2017-03-31 10:17:19 DEBUG 192.168.1.166 Form::select_dolusers
2017-03-31 10:17:19 DEBUG 192.168.1.166 sql=SELECT DISTINCT u.rowid, u.lastname as lastname, u.firstname, u.statut, u.login, u.admin, u.entity FROM llx_user as u WHERE u.entity IN (0,1) ORDER BY u.lastname ASC
2017-03-31 10:17:19 WARNING 192.168.1.166 Form::select_all_categories: using numeric value for parameter type is deprecated. Use string code instead.
2017-03-31 10:17:19 WARNING 192.168.1.166 Categorie::get_full_arbo(): numeric types are deprecated, please use string instead
2017-03-31 10:17:19 DEBUG 192.168.1.166 Categorie::load_motherof
2017-03-31 10:17:19 DEBUG 192.168.1.166 sql=SELECT fk_parent as id_parent, rowid as id_son FROM llx_categorie WHERE fk_parent != 0 AND entity IN (1)
2017-03-31 10:17:19 DEBUG 192.168.1.166 Categorie::get_full_arbo get category list
2017-03-31 10:17:19 DEBUG 192.168.1.166 sql=SELECT DISTINCT c.rowid, c.label, c.description, c.color, c.fk_parent FROM llx_categorie as c WHERE c.entity IN (1) AND c.type = 0
2017-03-31 10:17:19 DEBUG 192.168.1.166 Categorie::get_full_arbo call to build_path_from_id_categ
2017-03-31 10:17:19 DEBUG 192.168.1.166 Categorie::get_full_arbo dol_sort_array
2017-03-31 10:17:19 DEBUG 192.168.1.166 Commande::fetch_lines
2017-03-31 10:17:19 DEBUG 192.168.1.166 sql=SELECT l.rowid, l.fk_product, l.fk_parent_line, l.product_type, l.fk_commande, l.label as custom_label, l.description, l.price, l.qty, l.vat_src_code, l.tva_tx, l.localtax1_tx, l.localtax2_tx, l.fk_remise_except, l.remise_percent, l.subprice, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.rang, l.info_bits, l.special_code, l.total_ht, l.total_ttc, l.total_tva, l.total_localtax1, l.total_localtax2, l.date_start, l.date_end, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.description as product_desc, p.fk_product_type, p.label as product_label, p.tobatch as product_tobatch, p.weight, p.weight_units, p.volume, p.volume_units FROM llx_commandedet as l LEFT JOIN llx_product as p ON (p.rowid = l.fk_product) WHERE l.fk_commande = 483 ORDER BY l.rang, l.rowid
2017-03-31 10:17:19 DEBUG 192.168.1.166 Translate::loadCacheCurrencies
2017-03-31 10:17:19 DEBUG 192.168.1.166 sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = ‹ EUR ›
2017-03-31 10:17:19 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/commande/CO1703-0438 types=files recursive=0 filter=CO1703-0438[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:17:19 DEBUG 192.168.1.166 Commande::fetch_lines
2017-03-31 10:17:19 DEBUG 192.168.1.166 sql=SELECT l.rowid, l.fk_product, l.fk_parent_line, l.product_type, l.fk_commande, l.label as custom_label, l.description, l.price, l.qty, l.vat_src_code, l.tva_tx, l.localtax1_tx, l.localtax2_tx, l.fk_remise_except, l.remise_percent, l.subprice, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.rang, l.info_bits, l.special_code, l.total_ht, l.total_ttc, l.total_tva, l.total_localtax1, l.total_localtax2, l.date_start, l.date_end, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.description as product_desc, p.fk_product_type, p.label as product_label, p.tobatch as product_tobatch, p.weight, p.weight_units, p.volume, p.volume_units FROM llx_commandedet as l LEFT JOIN llx_product as p ON (p.rowid = l.fk_product) WHERE l.fk_commande = 487 ORDER BY l.rang, l.rowid
2017-03-31 10:17:19 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/commande/CO1703-0437 types=files recursive=0 filter=CO1703-0437[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:17:19 DEBUG 192.168.1.166 Commande::fetch_lines
2017-03-31 10:17:19 DEBUG 192.168.1.166 sql=SELECT l.rowid, l.fk_product, l.fk_parent_line, l.product_type, l.fk_commande, l.label as custom_label, l.description, l.price, l.qty, l.vat_src_code, l.tva_tx, l.localtax1_tx, l.localtax2_tx, l.fk_remise_except, l.remise_percent, l.subprice, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.rang, l.info_bits, l.special_code, l.total_ht, l.total_ttc, l.total_tva, l.total_localtax1, l.total_localtax2, l.date_start, l.date_end, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.description as product_desc, p.fk_product_type, p.label as product_label, p.tobatch as product_tobatch, p.weight, p.weight_units, p.volume, p.volume_units FROM llx_commandedet as l LEFT JOIN llx_product as p ON (p.rowid = l.fk_product) WHERE l.fk_commande = 486 ORDER BY l.rang, l.rowid
2017-03-31 10:17:19 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/commande/CO1703-0436 types=files recursive=0 filter=CO1703-0436[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:17:19 DEBUG 192.168.1.166 Commande::fetch_lines
2017-03-31 10:17:19 DEBUG 192.168.1.166 sql=SELECT l.rowid, l.fk_product, l.fk_parent_line, l.product_type, l.fk_commande, l.label as custom_label, l.description, l.price, l.qty, l.vat_src_code, l.tva_tx, l.localtax1_tx, l.localtax2_tx, l.fk_remise_except, l.remise_percent, l.subprice, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.rang, l.info_bits, l.special_code, l.total_ht, l.total_ttc, l.total_tva, l.total_localtax1, l.total_localtax2, l.date_start, l.date_end, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.description as product_desc, p.fk_product_type, p.label as product_label, p.tobatch as product_tobatch, p.weight, p.weight_units, p.volume, p.volume_units FROM llx_commandedet as l LEFT JOIN llx_product as p ON (p.rowid = l.fk_product) WHERE l.fk_commande = 485 ORDER BY l.rang, l.rowid
2017-03-31 10:17:19 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/commande/CO1703-0435 types=files recursive=0 filter=CO1703-0435[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:17:19 DEBUG 192.168.1.166 Commande::fetch_lines
2017-03-31 10:17:19 DEBUG 192.168.1.166 sql=SELECT l.rowid, l.fk_product, l.fk_parent_line, l.product_type, l.fk_commande, l.label as custom_label, l.description, l.price, l.qty, l.vat_src_code, l.tva_tx, l.localtax1_tx, l.localtax2_tx, l.fk_remise_except, l.remise_percent, l.subprice, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.rang, l.info_bits, l.special_code, l.total_ht, l.total_ttc, l.total_tva, l.total_localtax1, l.total_localtax2, l.date_start, l.date_end, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.description as product_desc, p.fk_product_type, p.label as product_label, p.tobatch as product_tobatch, p.weight, p.weight_units, p.volume, p.volume_units FROM llx_commandedet as l LEFT JOIN llx_product as p ON (p.rowid = l.fk_product) WHERE l.fk_commande = 474 ORDER BY l.rang, l.rowid
2017-03-31 10:17:19 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/commande/CO1703-0434 types=files recursive=0 filter=CO1703-0434[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:17:19 DEBUG 192.168.1.166 Commande::fetch_lines
2017-03-31 10:17:19 DEBUG 192.168.1.166 sql=SELECT l.rowid, l.fk_product, l.fk_parent_line, l.product_type, l.fk_commande, l.label as custom_label, l.description, l.price, l.qty, l.vat_src_code, l.tva_tx, l.localtax1_tx, l.localtax2_tx, l.fk_remise_except, l.remise_percent, l.subprice, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.rang, l.info_bits, l.special_code, l.total_ht, l.total_ttc, l.total_tva, l.total_localtax1, l.total_localtax2, l.date_start, l.date_end, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.description as product_desc, p.fk_product_type, p.label as product_label, p.tobatch as product_tobatch, p.weight, p.weight_units, p.volume, p.volume_units FROM llx_commandedet as l LEFT JOIN llx_product as p ON (p.rowid = l.fk_product) WHERE l.fk_commande = 484 ORDER BY l.rang, l.rowid
2017-03-31 10:17:19 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/commande/CO1703-0433 types=files recursive=0 filter=CO1703-0433[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:17:19 DEBUG 192.168.1.166 Commande::fetch_lines
2017-03-31 10:17:19 DEBUG 192.168.1.166 sql=SELECT l.rowid, l.fk_product, l.fk_parent_line, l.product_type, l.fk_commande, l.label as custom_label, l.description, l.price, l.qty, l.vat_src_code, l.tva_tx, l.localtax1_tx, l.localtax2_tx, l.fk_remise_except, l.remise_percent, l.subprice, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.rang, l.info_bits, l.special_code, l.total_ht, l.total_ttc, l.total_tva, l.total_localtax1, l.total_localtax2, l.date_start, l.date_end, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.description as product_desc, p.fk_product_type, p.label as product_label, p.tobatch as product_tobatch, p.weight, p.weight_units, p.volume, p.volume_units FROM llx_commandedet as l LEFT JOIN llx_product as p ON (p.rowid = l.fk_product) WHERE l.fk_commande = 482 ORDER BY l.rang, l.rowid
2017-03-31 10:17:19 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/commande/CO1703-0432 types=files recursive=0 filter=CO1703-0432[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:17:19 DEBUG 192.168.1.166 Commande::fetch_lines
2017-03-31 10:17:19 DEBUG 192.168.1.166 sql=SELECT l.rowid, l.fk_product, l.fk_parent_line, l.product_type, l.fk_commande, l.label as custom_label, l.description, l.price, l.qty, l.vat_src_code, l.tva_tx, l.localtax1_tx, l.localtax2_tx, l.fk_remise_except, l.remise_percent, l.subprice, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.rang, l.info_bits, l.special_code, l.total_ht, l.total_ttc, l.total_tva, l.total_localtax1, l.total_localtax2, l.date_start, l.date_end, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.description as product_desc, p.fk_product_type, p.label as product_label, p.tobatch as product_tobatch, p.weight, p.weight_units, p.volume, p.volume_units FROM llx_commandedet as l LEFT JOIN llx_product as p ON (p.rowid = l.fk_product) WHERE l.fk_commande = 481 ORDER BY l.rang, l.rowid
2017-03-31 10:17:19 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/commande/CO1703-0431 types=files recursive=0 filter=CO1703-0431[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:17:19 DEBUG 192.168.1.166 Commande::fetch_lines
2017-03-31 10:17:19 DEBUG 192.168.1.166 sql=SELECT l.rowid, l.fk_product, l.fk_parent_line, l.product_type, l.fk_commande, l.label as custom_label, l.description, l.price, l.qty, l.vat_src_code, l.tva_tx, l.localtax1_tx, l.localtax2_tx, l.fk_remise_except, l.remise_percent, l.subprice, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.rang, l.info_bits, l.special_code, l.total_ht, l.total_ttc, l.total_tva, l.total_localtax1, l.total_localtax2, l.date_start, l.date_end, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.description as product_desc, p.fk_product_type, p.label as product_label, p.tobatch as product_tobatch, p.weight, p.weight_units, p.volume, p.volume_units FROM llx_commandedet as l LEFT JOIN llx_product as p ON (p.rowid = l.fk_product) WHERE l.fk_commande = 480 ORDER BY l.rang, l.rowid
2017-03-31 10:17:19 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/commande/CO1703-0430 types=files recursive=0 filter=CO1703-0430[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:17:19 DEBUG 192.168.1.166 Commande::fetch_lines
2017-03-31 10:17:19 DEBUG 192.168.1.166 sql=SELECT l.rowid, l.fk_product, l.fk_parent_line, l.product_type, l.fk_commande, l.label as custom_label, l.description, l.price, l.qty, l.vat_src_code, l.tva_tx, l.localtax1_tx, l.localtax2_tx, l.fk_remise_except, l.remise_percent, l.subprice, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.rang, l.info_bits, l.special_code, l.total_ht, l.total_ttc, l.total_tva, l.total_localtax1, l.total_localtax2, l.date_start, l.date_end, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.description as product_desc, p.fk_product_type, p.label as product_label, p.tobatch as product_tobatch, p.weight, p.weight_units, p.volume, p.volume_units FROM llx_commandedet as l LEFT JOIN llx_product as p ON (p.rowid = l.fk_product) WHERE l.fk_commande = 479 ORDER BY l.rang, l.rowid
2017-03-31 10:17:19 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/commande/CO1703-0429 types=files recursive=0 filter=CO1703-0429[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:17:19 DEBUG 192.168.1.166 Commande::fetch_lines
2017-03-31 10:17:19 DEBUG 192.168.1.166 sql=SELECT l.rowid, l.fk_product, l.fk_parent_line, l.product_type, l.fk_commande, l.label as custom_label, l.description, l.price, l.qty, l.vat_src_code, l.tva_tx, l.localtax1_tx, l.localtax2_tx, l.fk_remise_except, l.remise_percent, l.subprice, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.rang, l.info_bits, l.special_code, l.total_ht, l.total_ttc, l.total_tva, l.total_localtax1, l.total_localtax2, l.date_start, l.date_end, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.description as product_desc, p.fk_product_type, p.label as product_label, p.tobatch as product_tobatch, p.weight, p.weight_units, p.volume, p.volume_units FROM llx_commandedet as l LEFT JOIN llx_product as p ON (p.rowid = l.fk_product) WHERE l.fk_commande = 478 ORDER BY l.rang, l.rowid
2017-03-31 10:17:19 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/commande/CO1703-0428 types=files recursive=0 filter=CO1703-0428[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:17:19 DEBUG 192.168.1.166 Commande::fetch_lines
2017-03-31 10:17:19 DEBUG 192.168.1.166 sql=SELECT l.rowid, l.fk_product, l.fk_parent_line, l.product_type, l.fk_commande, l.label as custom_label, l.description, l.price, l.qty, l.vat_src_code, l.tva_tx, l.localtax1_tx, l.localtax2_tx, l.fk_remise_except, l.remise_percent, l.subprice, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.rang, l.info_bits, l.special_code, l.total_ht, l.total_ttc, l.total_tva, l.total_localtax1, l.total_localtax2, l.date_start, l.date_end, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.description as product_desc, p.fk_product_type, p.label as product_label, p.tobatch as product_tobatch, p.weight, p.weight_units, p.volume, p.volume_units FROM llx_commandedet as l LEFT JOIN llx_product as p ON (p.rowid = l.fk_product) WHERE l.fk_commande = 477 ORDER BY l.rang, l.rowid
2017-03-31 10:17:19 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/commande/CO1703-0427 types=files recursive=0 filter=CO1703-0427[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:17:19 DEBUG 192.168.1.166 Commande::fetch_lines
2017-03-31 10:17:19 DEBUG 192.168.1.166 sql=SELECT l.rowid, l.fk_product, l.fk_parent_line, l.product_type, l.fk_commande, l.label as custom_label, l.description, l.price, l.qty, l.vat_src_code, l.tva_tx, l.localtax1_tx, l.localtax2_tx, l.fk_remise_except, l.remise_percent, l.subprice, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.rang, l.info_bits, l.special_code, l.total_ht, l.total_ttc, l.total_tva, l.total_localtax1, l.total_localtax2, l.date_start, l.date_end, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.description as product_desc, p.fk_product_type, p.label as product_label, p.tobatch as product_tobatch, p.weight, p.weight_units, p.volume, p.volume_units FROM llx_commandedet as l LEFT JOIN llx_product as p ON (p.rowid = l.fk_product) WHERE l.fk_commande = 476 ORDER BY l.rang, l.rowid
2017-03-31 10:17:19 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/commande/CO1703-0426 types=files recursive=0 filter=CO1703-0426[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:17:19 DEBUG 192.168.1.166 Commande::fetch_lines
2017-03-31 10:17:19 DEBUG 192.168.1.166 sql=SELECT l.rowid, l.fk_product, l.fk_parent_line, l.product_type, l.fk_commande, l.label as custom_label, l.description, l.price, l.qty, l.vat_src_code, l.tva_tx, l.localtax1_tx, l.localtax2_tx, l.fk_remise_except, l.remise_percent, l.subprice, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.rang, l.info_bits, l.special_code, l.total_ht, l.total_ttc, l.total_tva, l.total_localtax1, l.total_localtax2, l.date_start, l.date_end, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.description as product_desc, p.fk_product_type, p.label as product_label, p.tobatch as product_tobatch, p.weight, p.weight_units, p.volume, p.volume_units FROM llx_commandedet as l LEFT JOIN llx_product as p ON (p.rowid = l.fk_product) WHERE l.fk_commande = 475 ORDER BY l.rang, l.rowid
2017-03-31 10:17:19 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/commande/CO1703-0425 types=files recursive=0 filter=CO1703-0425[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:17:19 DEBUG 192.168.1.166 Commande::fetch_lines
2017-03-31 10:17:19 DEBUG 192.168.1.166 sql=SELECT l.rowid, l.fk_product, l.fk_parent_line, l.product_type, l.fk_commande, l.label as custom_label, l.description, l.price, l.qty, l.vat_src_code, l.tva_tx, l.localtax1_tx, l.localtax2_tx, l.fk_remise_except, l.remise_percent, l.subprice, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.rang, l.info_bits, l.special_code, l.total_ht, l.total_ttc, l.total_tva, l.total_localtax1, l.total_localtax2, l.date_start, l.date_end, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.description as product_desc, p.fk_product_type, p.label as product_label, p.tobatch as product_tobatch, p.weight, p.weight_units, p.volume, p.volume_units FROM llx_commandedet as l LEFT JOIN llx_product as p ON (p.rowid = l.fk_product) WHERE l.fk_commande = 473 ORDER BY l.rang, l.rowid
2017-03-31 10:17:19 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents/commande/CO1703-0424 types=files recursive=0 filter=CO1703-0424[^-]+ excludefilter="\.meta$|\.png$"
2017-03-31 10:17:19 DEBUG 192.168.1.166 Commande::fetch_lines
2017-03-31 10:17:19 DEBUG 192.168.1.166 sql=SELECT l.rowid, l.fk_product, l.fk_parent_line, l.product_type, l.fk_commande, l.label as custom_label, l.description, l.price, l.qty, l.vat_src_code, l.tva_tx, l.localtax1_tx, l.localtax2_tx, l.fk_remise_except, l.remise_percent, l.subprice, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.rang, l.info_bits, l.special_code, l.total_ht, l.total_ttc, l.total_tva, l.total_localtax1, l.total_localtax2, l.date_start, l.date_end, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.description as product_desc, p.fk_product_type, p.label as product_label, p.tobatch as product_tobatch, p.weight, p.weight_units, p.volume, p.volume_units FROM llx_commandedet as l LEFT JOIN llx_product as p ON (p.rowid = l.fk_product) WHERE l.fk_commande = 470 ORDER BY l.rang, l.rowid
2017-03-31 10:17:19 DEBUG 192.168.1.166 files.lib.php::dol_dir_list path=d:/dolibarr/dolibarr_documents