You have an error in your SQL syntax...

Bonjour à toute et à tous;

je suis un utilisateur novice de Dolibarr et je sollicite votre aide pour résoudre un problème qui survient lors du passage d’une commande dans le module « Commercial>nouvelle commande fournisseur ».
Je souhaite commander un produit, que je ne possède pas dans mes stocks, que j’ai vendus au travers d’une proposition commerciale (et que je n’ai eu aucun souci à renseigner dans la Propal). Le problème est que je ne peux pas ajouter mon produit (nommé « Main D’oeuvre ») dans ma commande fournisseur, seul un message d’erreur en résulte. J’ai eu beau chercher sur les forums, je n’ai pas trouvé de solution et je commence un peu à perdre espoir. ^^

probleme.jpg

Es ce que l’un d’entre vous aurez déjà eu ce problème ? Si oui comment le solutionner ?
Merci d’avance =)

Bonjour,

pour qu’on puisse aider il faut que tu active les log dans configuration / module /log

ensuite tu vas sur la page qui plante puis tu copie le ficher Dolibarr/documents/dolibarr.log et tu le post.

bien à toi

Ps: dans le log on vois les querries mais pas les réponse donc il ne devrait pas y avoir de donnée trop perso.

Bonsoir,
Essayez d’enlever l’apostrophe dans le texte « main d’oeuvre ? » du service et réessayez.
@+

1 « J'aime »

Bonjour delcroip, bonjour philazerty,

Merci à vous de prendre du temps pour essayer de résoudre mon problème.
Philazerty, j’avais lu que l’apostrophe pouvait poser problème et j’avais essayé entre-temps de le supprimé, ça n’a rien changé… :-/ Je vais essayer de supprimer le « service » et le recréer avec un autre orthographe, je vous dirais si ça a fonctionné.
Delcroip, j’ai fait la manipulation que tu m’as décris ci-dessus, je te copie le seul document qui pourrait correspondre à celui que tu m’as indiqué, mais c’est un pavé…

Merci pour votre aide !

Dolibarr.log :
« 2017-01-12 10:17:12 DEBUG ::1 This is an already logged session. SESSION[‹ dol_login ›]=admin
2017-01-12 10:17:12 DEBUG ::1 User::fetch
2017-01-12 10:17:12 DEBUG ::1 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.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 = ‹ admin ›
2017-01-12 10:17:12 DEBUG ::1 ExtraFields::fetch_name_optionals_label
2017-01-12 10:17:12 DEBUG ::1 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-01-12 10:17:12 DEBUG ::1 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
2017-01-12 10:17:12 DEBUG ::1 User::getrights
2017-01-12 10:17:12 DEBUG ::1 sql=SELECT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND r.entity IN (0,1) AND ur.fk_user= 1 AND r.perms IS NOT NULL
2017-01-12 10:17:12 DEBUG ::1 User::getrights
2017-01-12 10:17:12 DEBUG ::1 sql=SELECT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
2017-01-12 10:17:12 DEBUG ::1 — Access to /dolibarr/admin/modules.php
2017-01-12 10:17:12 DEBUG ::1 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang=‹ fr_FR ›
2017-01-12 10:17:12 DEBUG ::1 Menubase::menuLoad mymainmenu=home myleftmenu=setup type_user=0 menu_handler=eldy tabMenu size=0
2017-01-12 10:17:12 DEBUG ::1 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-01-12 10:17:12 DEBUG ::1 Scan directory Q:/Programmes/dolibarr/www/dolibarr/htdocs/core/modules/ for module descriptor files (modXXX.class.php)
2017-01-12 10:17:12 DEBUG ::1 Module modAccounting not qualified
2017-01-12 10:17:12 DEBUG ::1 sql=SELECT name, label FROM llx_extrafields WHERE elementtype = ‹ adherent › AND entity = 1
2017-01-12 10:17:12 DEBUG ::1 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = ‹ adherent › AND entity = 1
2017-01-12 10:17:12 DEBUG ::1 sql=SELECT code, label, description FROM llx_c_action_trigger ORDER by rang
2017-01-12 10:17:12 DEBUG ::1 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ socpeople ›
2017-01-12 10:17:12 DEBUG ::1 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ commande › AND entity IN (0, 1)
2017-01-12 10:17:12 DEBUG ::1 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ commandedet › AND entity IN (0, 1)
2017-01-12 10:17:12 DEBUG ::1 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ product › AND entity IN (0, 1)
2017-01-12 10:17:12 DEBUG ::1 Module modDeplacement not qualified
2017-01-12 10:17:12 DEBUG ::1 Module modDocumentGeneration not qualified
2017-01-12 10:17:12 DEBUG ::1 Module modDynamicPrices not qualified
2017-01-12 10:17:12 DEBUG ::1 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-01-12 10:17:12 DEBUG ::1 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-01-12 10:17:12 DEBUG ::1 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ expedition › AND entity IN (0, 1)
2017-01-12 10:17:12 DEBUG ::1 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ expeditiondet › AND entity IN (0, 1)
2017-01-12 10:17:12 DEBUG ::1 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ facture › AND entity IN (0, 1)
2017-01-12 10:17:12 DEBUG ::1 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ facturedet › AND entity IN (0, 1)
2017-01-12 10:17:12 DEBUG ::1 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ product › AND entity IN (0, 1)
2017-01-12 10:17:12 DEBUG ::1 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ facture › AND entity IN (0, 1)
2017-01-12 10:17:12 DEBUG ::1 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ facture_fourn ›
2017-01-12 10:17:12 DEBUG ::1 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ facture_fourn_det ›
2017-01-12 10:17:12 DEBUG ::1 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ facture_fourn ›
2017-01-12 10:17:12 DEBUG ::1 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ commande_fournisseur ›
2017-01-12 10:17:12 DEBUG ::1 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ commande_fournisseurdet ›
2017-01-12 10:17:12 DEBUG ::1 Module modHRM not qualified
2017-01-12 10:17:12 DEBUG ::1 Module modLabel not qualified
2017-01-12 10:17:12 DEBUG ::1 Module modMultiCurrency not qualified
2017-01-12 10:17:12 DEBUG ::1 useNPR
2017-01-12 10:17:12 DEBUG ::1 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-01-12 10:17:12 DEBUG ::1 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ product › AND entity IN (0, 1)
2017-01-12 10:17:12 DEBUG ::1 useNPR
2017-01-12 10:17:12 DEBUG ::1 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-01-12 10:17:12 DEBUG ::1 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = ‹ product › AND entity IN (0, 1)
2017-01-12 10:17:12 DEBUG ::1 sql=SELECT name, label FROM llx_extrafields WHERE elementtype = ‹ projet ›
2017-01-12 10:17:12 DEBUG ::1 sql=SELECT name, label FROM llx_extrafields WHERE elementtype = ‹ projet_task ›
2017-01-12 10:17:12 DEBUG ::1 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ propal › AND entity IN (0, 1)
2017-01-12 10:17:12 DEBUG ::1 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ propaldet › AND entity IN (0, 1)
2017-01-12 10:17:12 DEBUG ::1 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ product › AND entity IN (0, 1)
2017-01-12 10:17:12 DEBUG ::1 Module modReceiptPrinter not qualified
2017-01-12 10:17:12 DEBUG ::1 sql=SELECT name, label, type FROM llx_extrafields WHERE elementtype = ‹ product ›
2017-01-12 10:17:12 DEBUG ::1 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = ‹ product › AND entity = 1
2017-01-12 10:17:12 DEBUG ::1 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ societe › AND entity IN (0, 1)
2017-01-12 10:17:12 DEBUG ::1 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = ‹ socpeople › AND entity IN (0, 1)
2017-01-12 10:17:12 DEBUG ::1 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = ‹ societe › AND entity = 1
2017-01-12 10:17:12 DEBUG ::1 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = ‹ socpeople › AND entity = 1
2017-01-12 10:17:12 DEBUG ::1 Module modWebServicesClient not qualified
2017-01-12 10:17:12 DEBUG ::1 Module modWebsites not qualified
2017-01-12 10:17:12 DEBUG ::1 Scan directory Q:/Programmes/dolibarr/www/dolibarr/htdocs/productseasyaccess/core/modules/ for module descriptor files (modXXX.class.php)
2017-01-12 10:17:13 DEBUG ::1 — End access to /dolibarr/admin/modules.php
2017-01-12 10:17:19 DEBUG ::1 This is an already logged session. SESSION[‹ dol_login ›]=admin
2017-01-12 10:17:19 DEBUG ::1 User::fetch
2017-01-12 10:17:19 DEBUG ::1 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.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 = ‹ admin ›
2017-01-12 10:17:19 DEBUG ::1 ExtraFields::fetch_name_optionals_label
2017-01-12 10:17:19 DEBUG ::1 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-01-12 10:17:19 DEBUG ::1 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
2017-01-12 10:17:19 DEBUG ::1 User::getrights
2017-01-12 10:17:19 DEBUG ::1 sql=SELECT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND r.entity IN (0,1) AND ur.fk_user= 1 AND r.perms IS NOT NULL
2017-01-12 10:17:19 DEBUG ::1 User::getrights
2017-01-12 10:17:19 DEBUG ::1 sql=SELECT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
2017-01-12 10:17:19 DEBUG ::1 — Access to /dolibarr/admin/syslog.php
2017-01-12 10:17:19 DEBUG ::1 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang=‹ fr_FR ›
2017-01-12 10:17:19 DEBUG ::1 Menubase::menuLoad mymainmenu=home myleftmenu=setup type_user=0 menu_handler=eldy tabMenu size=0
2017-01-12 10:17:19 DEBUG ::1 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-01-12 10:17:19 DEBUG ::1 admin.lib::dolibarr_get_const
2017-01-12 10:17:19 DEBUG ::1 sql=SELECT value as value FROM llx_const WHERE name = ‹ SYSLOG_FACILITY › AND entity = 0
2017-01-12 10:17:19 DEBUG ::1 admin.lib::dolibarr_get_const
2017-01-12 10:17:19 DEBUG ::1 sql=SELECT value as value FROM llx_const WHERE name = ‹ SYSLOG_FILE › AND entity = 0
2017-01-12 10:17:19 DEBUG ::1 — End access to /dolibarr/admin/syslog.php
2017-01-12 10:17:40 DEBUG ::1 This is an already logged session. SESSION[‹ dol_login ›]=admin
2017-01-12 10:17:40 DEBUG ::1 User::fetch
2017-01-12 10:17:40 DEBUG ::1 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.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 = ‹ admin ›
2017-01-12 10:17:40 DEBUG ::1 ExtraFields::fetch_name_optionals_label
2017-01-12 10:17:40 DEBUG ::1 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-01-12 10:17:40 DEBUG ::1 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
2017-01-12 10:17:40 DEBUG ::1 User::getrights
2017-01-12 10:17:40 DEBUG ::1 sql=SELECT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND r.entity IN (0,1) AND ur.fk_user= 1 AND r.perms IS NOT NULL
2017-01-12 10:17:40 DEBUG ::1 User::getrights
2017-01-12 10:17:40 DEBUG ::1 sql=SELECT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
2017-01-12 10:17:40 DEBUG ::1 — Access to /dolibarr/product/index.php
2017-01-12 10:17:40 DEBUG ::1 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang=‹ fr_FR ›
2017-01-12 10:17:40 DEBUG ::1 Menubase::menuLoad mymainmenu=products myleftmenu= type_user=0 menu_handler=eldy tabMenu size=0
2017-01-12 10:17:40 DEBUG ::1 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-01-12 10:17:40 DEBUG ::1 sql=SELECT COUNT(p.rowid) as total, p.fk_product_type, p.tosell, p.tobuy FROM llx_product as p WHERE p.entity IN (1) GROUP BY p.fk_product_type, p.tosell, p.tobuy
2017-01-12 10:17:40 DEBUG ::1 sql=SELECT p.rowid, p.label, p.price, p.ref, p.fk_product_type, p.tosell, p.tobuy, p.fk_price_expression, p.entity, p.tms as datem FROM llx_product as p WHERE p.entity IN (1) ORDER BY p.tms DESC LIMIT 15
2017-01-12 10:17:40 DEBUG ::1 — End access to /dolibarr/product/index.php
2017-01-12 10:17:54 DEBUG ::1 This is an already logged session. SESSION[‹ dol_login ›]=admin
2017-01-12 10:17:54 DEBUG ::1 User::fetch
2017-01-12 10:17:54 DEBUG ::1 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.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 = ‹ admin ›
2017-01-12 10:17:54 DEBUG ::1 ExtraFields::fetch_name_optionals_label
2017-01-12 10:17:54 DEBUG ::1 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-01-12 10:17:54 DEBUG ::1 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
2017-01-12 10:17:54 DEBUG ::1 User::getrights
2017-01-12 10:17:54 DEBUG ::1 sql=SELECT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND r.entity IN (0,1) AND ur.fk_user= 1 AND r.perms IS NOT NULL
2017-01-12 10:17:54 DEBUG ::1 User::getrights
2017-01-12 10:17:54 DEBUG ::1 sql=SELECT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
2017-01-12 10:17:54 DEBUG ::1 — Access to /dolibarr/product/list.php
2017-01-12 10:17:54 DEBUG ::1 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang=‹ fr_FR ›
2017-01-12 10:17:54 DEBUG ::1 Menubase::menuLoad mymainmenu=products myleftmenu=product type_user=0 menu_handler=eldy tabMenu size=0
2017-01-12 10:17:54 DEBUG ::1 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-01-12 10:17:54 DEBUG ::1 ExtraFields::fetch_name_optionals_label
2017-01-12 10:17:54 DEBUG ::1 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 = ‹ product › ORDER BY pos
2017-01-12 10:17:54 DEBUG ::1 sql=SELECT DISTINCT p.rowid, p.ref, p.label, p.barcode, p.price, p.price_ttc, p.price_base_type, p.entity, p.fk_product_type, p.duration, p.tosell, p.tobuy, p.seuil_stock_alerte, p.desiredstock, p.tobatch, p.accountancy_code_sell, p.accountancy_code_buy, p.datec as date_creation, p.tms as date_update, MIN(pfp.unitprice) as minsellprice FROM llx_product as p LEFT JOIN llx_product_fournisseur_price as pfp ON p.rowid = pfp.fk_product WHERE p.entity IN (1) AND p.fk_product_type <> ‹ 1 › GROUP BY p.rowid, p.ref, p.label, p.barcode, p.price, p.price_ttc, p.price_base_type, p.fk_product_type, p.duration, p.tosell, p.tobuy, p.seuil_stock_alerte, p.desiredstock, p.datec, p.tms, p.entity, p.tobatch, p.accountancy_code_sell, p.accountancy_code_buy ORDER BY p.ref ASC
2017-01-12 10:17:54 DEBUG ::1 sql=SELECT DISTINCT p.rowid, p.ref, p.label, p.barcode, p.price, p.price_ttc, p.price_base_type, p.entity, p.fk_product_type, p.duration, p.tosell, p.tobuy, p.seuil_stock_alerte, p.desiredstock, p.tobatch, p.accountancy_code_sell, p.accountancy_code_buy, p.datec as date_creation, p.tms as date_update, MIN(pfp.unitprice) as minsellprice FROM llx_product as p LEFT JOIN llx_product_fournisseur_price as pfp ON p.rowid = pfp.fk_product WHERE p.entity IN (1) AND p.fk_product_type <> ‹ 1 › GROUP BY p.rowid, p.ref, p.label, p.barcode, p.price, p.price_ttc, p.price_base_type, p.fk_product_type, p.duration, p.tosell, p.tobuy, p.seuil_stock_alerte, p.desiredstock, p.datec, p.tms, p.entity, p.tobatch, p.accountancy_code_sell, p.accountancy_code_buy ORDER BY p.ref ASC LIMIT 26
2017-01-12 10:17:54 WARNING ::1 FormOther::select_categories: using numeric value for parameter type is deprecated. Use string code instead.
2017-01-12 10:17:54 WARNING ::1 Categorie::get_full_arbo(): numeric types are deprecated, please use string instead
2017-01-12 10:17:54 DEBUG ::1 Categorie::load_motherof
2017-01-12 10:17:54 DEBUG ::1 sql=SELECT fk_parent as id_parent, rowid as id_son FROM llx_categorie WHERE fk_parent != 0 AND entity IN (1)
2017-01-12 10:17:54 DEBUG ::1 Categorie::get_full_arbo get category list
2017-01-12 10:17:54 DEBUG ::1 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-01-12 10:17:54 DEBUG ::1 Categorie::get_full_arbo call to build_path_from_id_categ
2017-01-12 10:17:54 DEBUG ::1 Categorie::get_full_arbo dol_sort_array
2017-01-12 10:17:54 DEBUG ::1 Product::load_stock
2017-01-12 10:17:54 DEBUG ::1 sql=SELECT ps.rowid, ps.reel, ps.fk_entrepot FROM llx_product_stock as ps, llx_entrepot as w WHERE w.entity IN (1) AND w.rowid = ps.fk_entrepot AND ps.fk_product = 2
2017-01-12 10:17:54 DEBUG ::1 sql=SELECT COUNT(DISTINCT c.fk_soc) as nb_suppliers, COUNT(DISTINCT c.rowid) as nb, COUNT(cd.rowid) as nb_rows, SUM(cd.qty) as qty FROM llx_commande_fournisseurdet as cd, llx_commande_fournisseur as c, llx_societe as s WHERE c.rowid = cd.fk_commande AND c.fk_soc = s.rowid AND c.entity IN (1) AND cd.fk_product = 2 AND c.fk_statut in (1,2,3,4)
2017-01-12 10:17:54 DEBUG ::1 sql=SELECT COUNT(DISTINCT cf.fk_soc) as nb_customers, COUNT(DISTINCT cf.rowid) as nb, COUNT(fd.rowid) as nb_rows, SUM(fd.qty) as qty FROM llx_commande_fournisseur_dispatch as fd, llx_commande_fournisseur as cf, llx_societe as s WHERE cf.rowid = fd.fk_commande AND cf.fk_soc = s.rowid AND cf.entity IN (1) AND fd.fk_product = 2 AND cf.fk_statut in (4)
2017-01-12 10:17:54 DEBUG ::1 ProductFournisseur::find_min_price_product_fournisseur
2017-01-12 10:17:54 DEBUG ::1 sql=SELECT s.nom as supplier_name, s.rowid as fourn_id, pfp.rowid as product_fourn_price_id, pfp.ref_fourn, pfp.price, pfp.quantity, pfp.unitprice, pfp.tva_tx, pfp.charges, pfp.unitcharges, pfp.remise, pfp.remise_percent, pfp.fk_supplier_price_expression, pfp.delivery_time_days FROM llx_societe as s, llx_product_fournisseur_price as pfp WHERE s.entity IN (1) AND pfp.fk_product = 2 AND pfp.fk_soc = s.rowid AND s.status = 1
2017-01-12 10:17:54 DEBUG ::1 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.price_level, s.tms as date_modification, s.phone, s.fax, s.email, s.skype, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.barcode, s.fk_departement, s.fk_pays as country_id, s.fk_stcomm, s.remise_client, s.mode_reglement, s.cond_reglement, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code, i.libelle as libelle_incoterms FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.rowid = 3
2017-01-12 10:17:54 DEBUG ::1 Fournisseur::fetch SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.price_level, s.tms as date_modification, s.phone, s.fax, s.email, s.skype, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.barcode, s.fk_departement, s.fk_pays as country_id, s.fk_stcomm, s.remise_client, s.mode_reglement, s.cond_reglement, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code, i.libelle as libelle_incoterms FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.rowid = 3
2017-01-12 10:17:54 DEBUG ::1 ExtraFields::fetch_name_optionals_label
2017-01-12 10:17:54 DEBUG ::1 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 = ‹ societe › ORDER BY pos
2017-01-12 10:17:54 DEBUG ::1 — End access to /dolibarr/product/list.php
2017-01-12 10:18:01 DEBUG ::1 This is an already logged session. SESSION[‹ dol_login ›]=admin
2017-01-12 10:18:01 DEBUG ::1 User::fetch
2017-01-12 10:18:01 DEBUG ::1 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.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 = ‹ admin ›
2017-01-12 10:18:01 DEBUG ::1 ExtraFields::fetch_name_optionals_label
2017-01-12 10:18:01 DEBUG ::1 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-01-12 10:18:01 DEBUG ::1 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
2017-01-12 10:18:01 DEBUG ::1 User::getrights
2017-01-12 10:18:01 DEBUG ::1 sql=SELECT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND r.entity IN (0,1) AND ur.fk_user= 1 AND r.perms IS NOT NULL
2017-01-12 10:18:01 DEBUG ::1 User::getrights
2017-01-12 10:18:01 DEBUG ::1 sql=SELECT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
2017-01-12 10:18:01 DEBUG ::1 — Access to /dolibarr/product/card.php
2017-01-12 10:18:01 DEBUG ::1 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang=‹ fr_FR ›
2017-01-12 10:18:01 DEBUG ::1 Menubase::menuLoad mymainmenu=products myleftmenu=product type_user=0 menu_handler=eldy tabMenu size=0
2017-01-12 10:18:01 DEBUG ::1 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-01-12 10:18:01 DEBUG ::1 ExtraFields::fetch_name_optionals_label
2017-01-12 10:18:01 DEBUG ::1 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 = ‹ product › ORDER BY pos
2017-01-12 10:18:01 DEBUG ::1 Product::fetch id=2 ref= ref_ext=
2017-01-12 10:18:01 DEBUG ::1 sql=SELECT rowid, ref, ref_ext, label, description, url, note, customcode, fk_country, price, price_ttc, price_min, price_min_ttc, price_base_type, cost_price, default_vat_code, tva_tx, recuperableonly as tva_npr, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, tosell, tobuy, fk_product_type, duration, seuil_stock_alerte, canvas, weight, weight_units, length, length_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 2
2017-01-12 10:18:01 DEBUG ::1 Company.lib::getCountry
2017-01-12 10:18:01 DEBUG ::1 sql=SELECT rowid, code, label FROM llx_c_country WHERE rowid=1
2017-01-12 10:18:01 DEBUG ::1 ExtraFields::fetch_name_optionals_label
2017-01-12 10:18:01 DEBUG ::1 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 = ‹ product › ORDER BY pos
2017-01-12 10:18:01 DEBUG ::1 sql=SELECT dbt.rowid FROM llx_product as dbt WHERE dbt.rowid = 2 AND dbt.entity IN (1)
2017-01-12 10:18:01 DEBUG ::1 sql=SELECT dbt.rowid FROM llx_product as dbt WHERE dbt.rowid = 2 AND dbt.entity IN (1)
2017-01-12 10:18:01 DEBUG ::1 files.lib.php::dol_dir_list path=Q:/Programmes/dolibarr/dolibarr_documents/produit/PROD000001 types=files recursive=0 filter= excludefilter="(\.meta|preview\.png)$"
2017-01-12 10:18:01 DEBUG ::1 sql=SELECT COUNT(rowid) as nb FROM llx_links WHERE objecttype = ‹ product › AND objectid = 2 AND entity = 1
2017-01-12 10:18:01 DEBUG ::1 sql=SELECT MAX(te.ref) FROM llx_product as te WHERE te.ref < ‹ PROD000001 › AND te.entity IN (1)
2017-01-12 10:18:01 DEBUG ::1 sql=SELECT MIN(te.ref) FROM llx_product as te WHERE te.ref > ‹ PROD000001 › AND te.entity IN (1)
2017-01-12 10:18:01 DEBUG ::1 Company.lib::getCountry
2017-01-12 10:18:01 DEBUG ::1 sql=SELECT rowid, code, label FROM llx_c_country WHERE rowid=1
2017-01-12 10:18:01 DEBUG ::1 sql=SELECT ct.fk_categorie, c.label, c.rowid FROM llx_categorie_product as ct, llx_categorie as c WHERE ct.fk_categorie = c.rowid AND ct.fk_product = 2 AND c.type = 0 AND c.entity IN (1)
2017-01-12 10:18:01 DEBUG ::1 functions2::get_next_value mode=next
2017-01-12 10:18:01 DEBUG ::1 sql=SELECT MAX(SUBSTRING(ref, 5, 6)) as val FROM llx_product WHERE ref LIKE 'PROD
’ AND ref NOT LIKE ‹ (PROV%) › AND entity IN (1)
2017-01-12 10:18:01 DEBUG ::1 functions2::get_next_value return PROD000002
2017-01-12 10:18:01 DEBUG ::1 sql=SELECT COUNT() as nb from llx_supplier_proposaldet WHERE fk_product = 2
2017-01-12 10:18:01 DEBUG ::1 sql=SELECT COUNT(
) as nb from llx_propaldet WHERE fk_product = 2
2017-01-12 10:18:01 DEBUG ::1 sql=SELECT COUNT() as nb from llx_commandedet WHERE fk_product = 2
2017-01-12 10:18:01 DEBUG ::1 sql=SELECT COUNT(
) as nb from llx_facturedet WHERE fk_product = 2
2017-01-12 10:18:01 DEBUG ::1 sql=SELECT COUNT() as nb from llx_contratdet WHERE fk_product = 2
2017-01-12 10:18:01 DEBUG ::1 sql=SELECT COUNT(
) as nb from llx_facture_fourn_det WHERE fk_product = 2
2017-01-12 10:18:01 DEBUG ::1 sql=SELECT COUNT(*) as nb from llx_commande_fournisseurdet WHERE fk_product = 2
2017-01-12 10:18:01 DEBUG ::1 sql=SELECT s.rowid, s.nom as name, s.client, p.rowid as propalid, p.fk_statut, p.total_ht, p.ref, p.remise, p.datep as dp, p.fin_validite as datelimite FROM llx_societe as s, llx_propal as p, llx_c_propalst as c WHERE p.entity IN (1) AND p.fk_soc = s.rowid AND p.fk_statut = c.id AND p.fk_statut = 0 ORDER BY p.datep DESC
2017-01-12 10:18:01 DEBUG ::1 sql=SELECT s.rowid, s.nom as name, s.client, f.rowid as fid, f.facnumber as ref, f.datef as df FROM llx_societe as s, llx_facture as f WHERE f.entity = 1 AND f.fk_soc = s.rowid AND f.fk_statut = 0 ORDER BY f.datef DESC,f.rowid DESC
2017-01-12 10:18:01 DEBUG ::1 /core/lib/function2.lib.php::getListOfModels
2017-01-12 10:18:01 DEBUG ::1 sql=SELECT nom as id, nom as lib, libelle as label, description as description FROM llx_document_model WHERE type = ‹ product › AND entity IN (0,1) ORDER BY description DESC
2017-01-12 10:18:01 DEBUG ::1 files.lib.php::dol_dir_list path=Q:/Programmes/dolibarr/dolibarr_documents/produit/PROD000001 types=files recursive=0 filter= excludefilter= »(\.meta|_preview\.png)$"
2017-01-12 10:18:01 DEBUG ::1 — End access to /dolibarr/product/card.php
2017-01-12 10:18:05 DEBUG ::1 This is an already logged session. _SESSION[‹ dol_login ›]=admin
2017-01-12 10:18:05 DEBUG ::1 User::fetch
2017-01-12 10:18:05 DEBUG ::1 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.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 = ‹ admin ›
2017-01-12 10:18:05 DEBUG ::1 ExtraFields::fetch_name_optionals_label
2017-01-12 10:18:05 DEBUG ::1 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-01-12 10:18:05 DEBUG ::1 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
2017-01-12 10:18:05 DEBUG ::1 User::getrights
2017-01-12 10:18:05 DEBUG ::1 sql=SELECT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND r.entity IN (0,1) AND ur.fk_user= 1 AND r.perms IS NOT NULL
2017-01-12 10:18:05 DEBUG ::1 User::getrights
2017-01-12 10:18:05 DEBUG ::1 sql=SELECT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
2017-01-12 10:18:05 DEBUG ::1 — Access to /dolibarr/product/price.php
2017-01-12 10:18:05 DEBUG ::1 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang=‹ fr_FR ›
2017-01-12 10:18:05 DEBUG ::1 Menubase::menuLoad mymainmenu=products myleftmenu=product type_user=0 menu_handler=eldy tabMenu size=0
2017-01-12 10:18:05 DEBUG ::1 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-01-12 10:18:05 DEBUG ::1 sql=SELECT dbt.rowid FROM llx_product as dbt WHERE dbt.rowid = 2 AND dbt.entity IN (1)
2017-01-12 10:18:05 DEBUG ::1 sql=SELECT dbt.rowid FROM llx_product as dbt WHERE dbt.rowid = 2 AND dbt.entity IN (1)
2017-01-12 10:18:05 DEBUG ::1 Product::fetch id=2 ref= ref_ext=
2017-01-12 10:18:05 DEBUG ::1 sql=SELECT rowid, ref, ref_ext, label, description, url, note, customcode, fk_country, price, price_ttc, price_min, price_min_ttc, price_base_type, cost_price, default_vat_code, tva_tx, recuperableonly as tva_npr, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, tosell, tobuy, fk_product_type, duration, seuil_stock_alerte, canvas, weight, weight_units, length, length_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 2
2017-01-12 10:18:05 DEBUG ::1 Company.lib::getCountry
2017-01-12 10:18:05 DEBUG ::1 sql=SELECT rowid, code, label FROM llx_c_country WHERE rowid=1
2017-01-12 10:18:05 DEBUG ::1 ExtraFields::fetch_name_optionals_label
2017-01-12 10:18:05 DEBUG ::1 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 = ‹ product › ORDER BY pos
2017-01-12 10:18:05 DEBUG ::1 Product::fetch id=2 ref= ref_ext=
2017-01-12 10:18:05 DEBUG ::1 sql=SELECT rowid, ref, ref_ext, label, description, url, note, customcode, fk_country, price, price_ttc, price_min, price_min_ttc, price_base_type, cost_price, default_vat_code, tva_tx, recuperableonly as tva_npr, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, tosell, tobuy, fk_product_type, duration, seuil_stock_alerte, canvas, weight, weight_units, length, length_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 2
2017-01-12 10:18:05 DEBUG ::1 Company.lib::getCountry
2017-01-12 10:18:05 DEBUG ::1 sql=SELECT rowid, code, label FROM llx_c_country WHERE rowid=1
2017-01-12 10:18:05 DEBUG ::1 ExtraFields::fetch_name_optionals_label
2017-01-12 10:18:05 DEBUG ::1 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 = ‹ product › ORDER BY pos
2017-01-12 10:18:05 DEBUG ::1 files.lib.php::dol_dir_list path=Q:/Programmes/dolibarr/dolibarr_documents/produit/PROD000001 types=files recursive=0 filter= excludefilter="(\.meta|_preview\.png)$"
2017-01-12 10:18:05 DEBUG ::1 sql=SELECT COUNT(rowid) as nb FROM llx_links WHERE objecttype = ‹ product › AND objectid = 2 AND entity = 1
2017-01-12 10:18:05 DEBUG ::1 sql=SELECT MAX(te.ref) FROM llx_product as te WHERE te.ref < ‹ PROD000001 › AND te.entity IN (1)
2017-01-12 10:18:05 DEBUG ::1 sql=SELECT MIN(te.ref) FROM llx_product as te WHERE te.ref > ‹ PROD000001 › AND te.entity IN (1)
2017-01-12 10:18:05 DEBUG ::1 Productcustomerprice::fetch_all
2017-01-12 10:18:05 DEBUG ::1 sql=SELECT t.rowid, t.entity, t.datec, t.tms, t.fk_product, t.fk_soc, t.price, t.price_ttc, t.price_min, t.price_min_ttc, t.price_base_type, t.tva_tx, t.recuperableonly, t.localtax1_tx, t.localtax2_tx, t.fk_user, t.import_key, soc.nom as socname, prod.ref as prodref FROM llx_product_customer_price as t ,llx_product as prod ,llx_societe as soc WHERE soc.rowid=t.fk_soc AND prod.rowid=t.fk_product AND prod.entity IN (1) AND t.fk_product = 2 ORDER BY soc.nom ASC
2017-01-12 10:18:05 DEBUG ::1 Productcustomerprice::fetch_all
2017-01-12 10:18:05 DEBUG ::1 sql=SELECT t.rowid, t.entity, t.datec, t.tms, t.fk_product, t.fk_soc, t.price, t.price_ttc, t.price_min, t.price_min_ttc, t.price_base_type, t.tva_tx, t.recuperableonly, t.localtax1_tx, t.localtax2_tx, t.fk_user, t.import_key, soc.nom as socname, prod.ref as prodref FROM llx_product_customer_price as t ,llx_product as prod ,llx_societe as soc WHERE soc.rowid=t.fk_soc AND prod.rowid=t.fk_product AND prod.entity IN (1) AND t.fk_product = 2 ORDER BY soc.nom ASC LIMIT 26
2017-01-12 10:18:05 DEBUG ::1 — End access to /dolibarr/product/price.php
2017-01-12 10:18:10 DEBUG ::1 This is an already logged session. _SESSION[‹ dol_login ›]=admin
2017-01-12 10:18:10 DEBUG ::1 User::fetch
2017-01-12 10:18:10 DEBUG ::1 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.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 = ‹ admin ›
2017-01-12 10:18:10 DEBUG ::1 ExtraFields::fetch_name_optionals_label
2017-01-12 10:18:10 DEBUG ::1 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-01-12 10:18:10 DEBUG ::1 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
2017-01-12 10:18:10 DEBUG ::1 User::getrights
2017-01-12 10:18:10 DEBUG ::1 sql=SELECT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND r.entity IN (0,1) AND ur.fk_user= 1 AND r.perms IS NOT NULL
2017-01-12 10:18:10 DEBUG ::1 User::getrights
2017-01-12 10:18:10 DEBUG ::1 sql=SELECT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
2017-01-12 10:18:10 DEBUG ::1 — Access to /dolibarr/product/fournisseurs.php
2017-01-12 10:18:10 DEBUG ::1 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang=‹ fr_FR ›
2017-01-12 10:18:10 DEBUG ::1 Menubase::menuLoad mymainmenu=products myleftmenu=product type_user=0 menu_handler=eldy tabMenu size=0
2017-01-12 10:18:10 DEBUG ::1 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-01-12 10:18:10 DEBUG ::1 sql=SELECT dbt.rowid FROM llx_product as dbt WHERE dbt.rowid = 2 AND dbt.entity IN (1)
2017-01-12 10:18:10 DEBUG ::1 ProductFournisseur::fetch id=2 ref= ref_ext=
2017-01-12 10:18:10 DEBUG ::1 sql=SELECT rowid, ref, ref_ext, label, description, url, note, customcode, fk_country, price, price_ttc, price_min, price_min_ttc, price_base_type, cost_price, default_vat_code, tva_tx, recuperableonly as tva_npr, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, tosell, tobuy, fk_product_type, duration, seuil_stock_alerte, canvas, weight, weight_units, length, length_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 2
2017-01-12 10:18:10 DEBUG ::1 Company.lib::getCountry
2017-01-12 10:18:10 DEBUG ::1 sql=SELECT rowid, code, label FROM llx_c_country WHERE rowid=1
2017-01-12 10:18:10 DEBUG ::1 ExtraFields::fetch_name_optionals_label
2017-01-12 10:18:10 DEBUG ::1 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 = ‹ product › ORDER BY pos
2017-01-12 10:18:10 DEBUG ::1 files.lib.php::dol_dir_list path=Q:/Programmes/dolibarr/dolibarr_documents/produit/PROD000001 types=files recursive=0 filter= excludefilter="(\.meta|_preview\.png)$"
2017-01-12 10:18:10 DEBUG ::1 sql=SELECT COUNT(rowid) as nb FROM llx_links WHERE objecttype = ‹ product › AND objectid = 2 AND entity = 1
2017-01-12 10:18:10 DEBUG ::1 sql=SELECT MAX(te.ref) FROM llx_product as te WHERE te.ref < ‹ PROD000001 › AND te.entity IN (1)
2017-01-12 10:18:10 DEBUG ::1 sql=SELECT MIN(te.ref) FROM llx_product as te WHERE te.ref > ‹ PROD000001 › AND te.entity IN (1)
2017-01-12 10:18:10 DEBUG ::1 ProductFournisseur::find_min_price_product_fournisseur
2017-01-12 10:18:10 DEBUG ::1 sql=SELECT s.nom as supplier_name, s.rowid as fourn_id, pfp.rowid as product_fourn_price_id, pfp.ref_fourn, pfp.price, pfp.quantity, pfp.unitprice, pfp.tva_tx, pfp.charges, pfp.unitcharges, pfp.remise, pfp.remise_percent, pfp.fk_supplier_price_expression, pfp.delivery_time_days FROM llx_societe as s, llx_product_fournisseur_price as pfp WHERE s.entity IN (1) AND pfp.fk_product = 2 AND pfp.fk_soc = s.rowid AND s.status = 1
2017-01-12 10:18:10 DEBUG ::1 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.price_level, s.tms as date_modification, s.phone, s.fax, s.email, s.skype, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.barcode, s.fk_departement, s.fk_pays as country_id, s.fk_stcomm, s.remise_client, s.mode_reglement, s.cond_reglement, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code, i.libelle as libelle_incoterms FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.rowid = 3
2017-01-12 10:18:10 DEBUG ::1 Fournisseur::fetch SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.price_level, s.tms as date_modification, s.phone, s.fax, s.email, s.skype, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.barcode, s.fk_departement, s.fk_pays as country_id, s.fk_stcomm, s.remise_client, s.mode_reglement, s.cond_reglement, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code, i.libelle as libelle_incoterms FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.rowid = 3
2017-01-12 10:18:10 DEBUG ::1 ExtraFields::fetch_name_optionals_label
2017-01-12 10:18:10 DEBUG ::1 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 = ‹ societe › ORDER BY pos
2017-01-12 10:18:10 DEBUG ::1 ProductFournisseur::list_product_fournisseur_price
2017-01-12 10:18:10 DEBUG ::1 sql=SELECT s.nom as supplier_name, s.rowid as fourn_id, pfp.rowid as product_fourn_pri_id, pfp.ref_fourn, pfp.fk_product as product_fourn_id, pfp.fk_supplier_price_expression, pfp.price, pfp.quantity, pfp.unitprice, pfp.remise_percent, pfp.remise, pfp.tva_tx, pfp.fk_availability, pfp.charges, pfp.unitcharges, pfp.info_bits, pfp.delivery_time_days, pfp.supplier_reputation FROM llx_product_fournisseur_price as pfp, llx_societe as s WHERE pfp.entity IN (1) AND pfp.fk_soc = s.rowid AND s.status=1 AND pfp.fk_product = 2 ORDER BY s.nom ASC
2017-01-12 10:18:10 DEBUG ::1 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.price_level, s.tms as date_modification, s.phone, s.fax, s.email, s.skype, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.barcode, s.fk_departement, s.fk_pays as country_id, s.fk_stcomm, s.remise_client, s.mode_reglement, s.cond_reglement, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code, i.libelle as libelle_incoterms FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.rowid = 3
2017-01-12 10:18:10 DEBUG ::1 Fournisseur::fetch SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.price_level, s.tms as date_modification, s.phone, s.fax, s.email, s.skype, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.barcode, s.fk_departement, s.fk_pays as country_id, s.fk_stcomm, s.remise_client, s.mode_reglement, s.cond_reglement, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code, i.libelle as libelle_incoterms FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.rowid = 3
2017-01-12 10:18:10 DEBUG ::1 ExtraFields::fetch_name_optionals_label
2017-01-12 10:18:10 DEBUG ::1 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 = ‹ societe › ORDER BY pos
2017-01-12 10:18:10 DEBUG ::1 — End access to /dolibarr/product/fournisseurs.php
2017-01-12 10:18:17 DEBUG ::1 This is an already logged session. _SESSION[‹ dol_login ›]=admin
2017-01-12 10:18:17 DEBUG ::1 User::fetch
2017-01-12 10:18:17 DEBUG ::1 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.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 = ‹ admin ›
2017-01-12 10:18:17 DEBUG ::1 ExtraFields::fetch_name_optionals_label
2017-01-12 10:18:17 DEBUG ::1 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-01-12 10:18:17 DEBUG ::1 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
2017-01-12 10:18:17 DEBUG ::1 User::getrights
2017-01-12 10:18:17 DEBUG ::1 sql=SELECT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND r.entity IN (0,1) AND ur.fk_user= 1 AND r.perms IS NOT NULL
2017-01-12 10:18:17 DEBUG ::1 User::getrights
2017-01-12 10:18:17 DEBUG ::1 sql=SELECT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
2017-01-12 10:18:17 DEBUG ::1 — Access to /dolibarr/product/list.php
2017-01-12 10:18:17 DEBUG ::1 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang=‹ fr_FR ›
2017-01-12 10:18:17 DEBUG ::1 Menubase::menuLoad mymainmenu=products myleftmenu=service type_user=0 menu_handler=eldy tabMenu size=0
2017-01-12 10:18:17 DEBUG ::1 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-01-12 10:18:17 DEBUG ::1 ExtraFields::fetch_name_optionals_label
2017-01-12 10:18:17 DEBUG ::1 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 = ‹ product › ORDER BY pos
2017-01-12 10:18:17 DEBUG ::1 sql=SELECT DISTINCT p.rowid, p.ref, p.label, p.barcode, p.price, p.price_ttc, p.price_base_type, p.entity, p.fk_product_type, p.duration, p.tosell, p.tobuy, p.seuil_stock_alerte, p.desiredstock, p.tobatch, p.accountancy_code_sell, p.accountancy_code_buy, p.datec as date_creation, p.tms as date_update, MIN(pfp.unitprice) as minsellprice FROM llx_product as p LEFT JOIN llx_product_fournisseur_price as pfp ON p.rowid = pfp.fk_product WHERE p.entity IN (1) AND p.fk_product_type = ‹ 1 › GROUP BY p.rowid, p.ref, p.label, p.barcode, p.price, p.price_ttc, p.price_base_type, p.fk_product_type, p.duration, p.tosell, p.tobuy, p.seuil_stock_alerte, p.desiredstock, p.datec, p.tms, p.entity, p.tobatch, p.accountancy_code_sell, p.accountancy_code_buy ORDER BY p.ref ASC
2017-01-12 10:18:17 DEBUG ::1 sql=SELECT DISTINCT p.rowid, p.ref, p.label, p.barcode, p.price, p.price_ttc, p.price_base_type, p.entity, p.fk_product_type, p.duration, p.tosell, p.tobuy, p.seuil_stock_alerte, p.desiredstock, p.tobatch, p.accountancy_code_sell, p.accountancy_code_buy, p.datec as date_creation, p.tms as date_update, MIN(pfp.unitprice) as minsellprice FROM llx_product as p LEFT JOIN llx_product_fournisseur_price as pfp ON p.rowid = pfp.fk_product WHERE p.entity IN (1) AND p.fk_product_type = ‹ 1 › GROUP BY p.rowid, p.ref, p.label, p.barcode, p.price, p.price_ttc, p.price_base_type, p.fk_product_type, p.duration, p.tosell, p.tobuy, p.seuil_stock_alerte, p.desiredstock, p.datec, p.tms, p.entity, p.tobatch, p.accountancy_code_sell, p.accountancy_code_buy ORDER BY p.ref ASC LIMIT 26
2017-01-12 10:18:18 WARNING ::1 FormOther::select_categories: using numeric value for parameter type is deprecated. Use string code instead.
2017-01-12 10:18:18 WARNING ::1 Categorie::get_full_arbo(): numeric types are deprecated, please use string instead
2017-01-12 10:18:18 DEBUG ::1 Categorie::load_motherof
2017-01-12 10:18:18 DEBUG ::1 sql=SELECT fk_parent as id_parent, rowid as id_son FROM llx_categorie WHERE fk_parent != 0 AND entity IN (1)
2017-01-12 10:18:18 DEBUG ::1 Categorie::get_full_arbo get category list
2017-01-12 10:18:18 DEBUG ::1 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-01-12 10:18:18 DEBUG ::1 Categorie::get_full_arbo call to build_path_from_id_categ
2017-01-12 10:18:18 DEBUG ::1 Categorie::get_full_arbo dol_sort_array
2017-01-12 10:18:18 DEBUG ::1 ProductFournisseur::find_min_price_product_fournisseur
2017-01-12 10:18:18 DEBUG ::1 sql=SELECT s.nom as supplier_name, s.rowid as fourn_id, pfp.rowid as product_fourn_price_id, pfp.ref_fourn, pfp.price, pfp.quantity, pfp.unitprice, pfp.tva_tx, pfp.charges, pfp.unitcharges, pfp.remise, pfp.remise_percent, pfp.fk_supplier_price_expression, pfp.delivery_time_days FROM llx_societe as s, llx_product_fournisseur_price as pfp WHERE s.entity IN (1) AND pfp.fk_product = 1 AND pfp.fk_soc = s.rowid AND s.status = 1
2017-01-12 10:18:18 DEBUG ::1 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.price_level, s.tms as date_modification, s.phone, s.fax, s.email, s.skype, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.clie

Bonsoir,

je ne trouve pas la requête dans le log et je ne peux pas reproduire votre soucis ni en créant un service que j’ajoute ou en l’ajoutant directement sur l’ordre :
https://ide.pmpd.eu/dolibarr/htdocs/fourn/commande/card.php?id=2

login admintester
mdp admintester

bien á toi

PS: la prochaine fois, attache le log en pièce jointes c’est plus lisible

Bonjour,

J’ai également un problème du même type. Je ne peux plus créer de facture fournisseur, au moment ou j’appuis sur « créer brouillon » j’ai le message

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‹ 10) VALUES (718,null) › at line 1

Remarque : le 718 s’incrémente à chaque tentative !

Si quelqu’un peut m’aider car c’est problématique pour moi de ne pas pouvoir créer les facture fournisseur ! Je vous remercie grandement ! (fichier log attaché version dolibarr 4.0.3)

Olivier

Bonjour,

Petit up si quelqu’un peut m’aider svp ca serait vraiment sympa !

Bonne journée !
Olivier

Re bonjour,

Ouf !! J’ai finalement trouvé d’ou provenait l’erreur mais je ne comprend pas pourquoi cette erreur est apparue maintenant !

J’avais créer un attribut supplémentaire sur mes facture fournisseur que finalement je ne me servait pas. Jusqu’à hier ça ne m’avait pas posé de problème j’avais toujours pu créer mes facture fournisseur ! Bref j’ai supprimé l’attribut et voila que mes factures sont à nouveau opérationnelles :happy:

Merci à vous surtout si quelqu’un c’est déjà penché sur mon problème !

Olivier

Bonjour,

Évitez de faire un UP trop rapidement, dans la même journée c’est abusé !!!
Votre fichier de log n’est pas joint, votre configuration n’est pas précisée, depuis quand avez vous le souci ? L’apparition du pb correspond à une maj, l’installation d’un module …???
@+

Merci Philazerty,

On a du poster en même temps ! ma réponse comme quoi c’est résolu juste au dessus. Et désolé pour dérangement et mon up, j’étais pressé de résoudre le problème pour ma prod !

Bonne journée

Pas de souci, le principal c’est que vous soyez dépanné !
@+