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