Bienvenue, Invité
Nom d'utilisateur : Mot de passe : Se souvenir de moi

SUJET : Bug sur facturation de commandes

Bug sur facturation de commandes il y a 6 mois 2 jours #82225

  • TCHOBYE
  • Portrait de TCHOBYE
  • Hors ligne
  • Junior Boarder
  • Messages : 26
  • Remerciements reçus 2
  • Karma: 0
Bonjour,
Lorsque j'utilise la fonction FACTURER COMMANDES (fournisseurs) je n'arrive pas à passer en mode brouillon.
Voici le message :
Invalid argument supplied for foreach() in C:\dolibarr\www\dolibarr\htdocs\fourn\commande\orderstoinvoice.php on line 358

version dolibarr 5.0
firefox 52.0

J'ai l'impression de l'avoir déjà fait sans problème depuis l'instal de la 5.0 sans avoir eu ce message pourtant ! .....

Merci de votre aide.
L'administrateur a désactivé l'accès en écriture pour le public.

Bug sur facturation de commandes il y a 5 mois 3 semaines #82747

  • alientouch
  • Portrait de alientouch
  • Hors ligne
  • Junior Boarder
  • Messages : 22
  • Remerciements reçus 1
  • Karma: 0
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 : stop/start modules 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=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=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=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=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
Dernière édition: il y a 5 mois 3 semaines par alientouch.
L'administrateur a désactivé l'accès en écriture pour le public.

Bug sur facturation de commandes il y a 5 mois 3 semaines #82759

  • alientouch
  • Portrait de alientouch
  • Hors ligne
  • Junior Boarder
  • Messages : 22
  • Remerciements reçus 1
  • Karma: 0
Bonjour,

Je suis revenu sur une version 4.0.4 et tout est redevenu fonctionnel pour la facturation des commandes.
L'administrateur a désactivé l'accès en écriture pour le public.

Bug sur facturation de commandes il y a 5 mois 2 semaines #82830

  • alientouch
  • Portrait de alientouch
  • Hors ligne
  • Junior Boarder
  • Messages : 22
  • Remerciements reçus 1
  • Karma: 0
Bonjour,

J'ai préparer un poste de test sous Windows 7 Pro, j'ai installer Dolibar 4.0.4 puis restaurer mes données, tout est bon.

Je suis passer en 5.0 et j'ai à nouveau le même problème, lorsque je veux facturer les commandes livrées pour un client, je les sélectionne, je clique sur Facturer, la page Nouvelle Facture apparaît, je fais Créer brouillon et cela me renvoie à la Liste des commandes du client.

Quelqu'un a t il même soucis ??? Ou y aurait il une solution svp ?

Merci
L'administrateur a désactivé l'accès en écriture pour le public.

Bug sur facturation de commandes il y a 5 mois 2 semaines #82931

  • PascalH
  • Portrait de PascalH
  • Hors ligne
  • Junior Boarder
  • Messages : 33
  • Remerciements reçus 1
  • Karma: 3
Bonjour,

J'ai également ce même problème qui m'a été remonté par un client. Il s'agit donc d'une régression puisque cela fonctionnait sur la 4.0.
Est ce que le(s) dev(s) qui ont travaillés sur cette partie du code peuvent se penser dessus et émettre un patch, nous lui/leurs en serions reconnaissants.

Cordialement
L'administrateur a désactivé l'accès en écriture pour le public.

Bug sur facturation de commandes il y a 5 mois 2 semaines #83039

  • alientouch
  • Portrait de alientouch
  • Hors ligne
  • Junior Boarder
  • Messages : 22
  • Remerciements reçus 1
  • Karma: 0
Bonjour,

Problème résolu avec la mise à jour 5.0.1.

Un grand merci aux dev.
L'administrateur a désactivé l'accès en écriture pour le public.