2020-06-14 15:01:20 DEBUG ::1 Removed file D:/Ampps/www/erpv11/documents/dolibarr.log 2020-06-14 15:01:20 DEBUG ::1 functions.lib::dol_mkdir: dir=D:/Ampps/www/erpv11/documents/users/temp 2020-06-14 15:01:20 DEBUG ::1 --- End access to /erpv11/admin/tools/purge.php 2020-06-14 15:01:20 DEBUG ::1 --- Access to /erpv11/core/js/lib_notification.js.php - action=, massaction= 2020-06-14 15:01:20 DEBUG ::1 sql=SELECT transkey, transvalue FROM bk_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-06-14 15:01:20 DEBUG ::1 --- End access to /erpv11/core/js/lib_notification.js.php 2020-06-14 15:01:29 DEBUG ::1 - This is an already logged session. _SESSION['dol_login']=adminbk _SESSION['dol_entity']=1 2020-06-14 15:01:29 DEBUG ::1 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_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 as note_private, u.note_public, 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.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM bk_user as u LEFT JOIN bk_c_country as c ON u.fk_country = c.rowid LEFT JOIN bk_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'adminbk' ORDER BY u.entity ASC 2020-06-14 15:01:29 DEBUG ::1 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM bk_extrafields WHERE elementtype = 'user' ORDER BY pos 2020-06-14 15:01:29 DEBUG ::1 sql=SELECT param, value FROM bk_user_param WHERE fk_user = 1 AND entity = 1 2020-06-14 15:01:29 DEBUG ::1 sql=SELECT rowid, entity, type, page, param, value FROM bk_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-06-14 15:01:29 DEBUG ::1 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM bk_user_rights as ur, bk_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2020-06-14 15:01:29 DEBUG ::1 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM bk_usergroup_rights as gr, bk_usergroup_user as gu, bk_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-06-14 15:01:29 DEBUG ::1 --- Access to /erpv11/mrp/index.php - action=, massaction= 2020-06-14 15:01:29 DEBUG ::1 sql=SELECT transkey, transvalue FROM bk_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-06-14 15:01:29 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 bk_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 2020-06-14 15:01:29 DEBUG ::1 sql=SELECT COUNT(t.rowid) as nb, status FROM bk_mrp_mo as t GROUP BY t.status 2020-06-14 15:01:29 WARNING ::1 DolGraph::draw Call to draw method was made but SetData was is an empty dataset 2020-06-14 15:01:29 DEBUG ::1 DolGraph::draw_jflot this->type=pie this->MaxValue=0 2020-06-14 15:01:29 DEBUG ::1 sql=SELECT a.rowid, a.status, a.ref, a.tms as datem, a.status FROM bk_bom_bom as a WHERE a.entity IN (1) ORDER BY a.tms DESC LIMIT 5 2020-06-14 15:01:29 DEBUG ::1 sql=SELECT a.rowid, a.status, a.ref, a.tms as datem, a.status FROM bk_mrp_mo as a WHERE a.entity IN (1) ORDER BY a.tms DESC LIMIT 5 2020-06-14 15:01:29 DEBUG ::1 --- End access to /erpv11/mrp/index.php 2020-06-14 15:01:30 DEBUG ::1 --- Access to /erpv11/core/js/lib_notification.js.php - action=, massaction= 2020-06-14 15:01:30 DEBUG ::1 sql=SELECT transkey, transvalue FROM bk_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-06-14 15:01:30 DEBUG ::1 --- End access to /erpv11/core/js/lib_notification.js.php 2020-06-14 15:01:32 DEBUG ::1 - This is an already logged session. _SESSION['dol_login']=adminbk _SESSION['dol_entity']=1 2020-06-14 15:01:32 DEBUG ::1 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_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 as note_private, u.note_public, 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.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM bk_user as u LEFT JOIN bk_c_country as c ON u.fk_country = c.rowid LEFT JOIN bk_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'adminbk' ORDER BY u.entity ASC 2020-06-14 15:01:32 DEBUG ::1 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM bk_extrafields WHERE elementtype = 'user' ORDER BY pos 2020-06-14 15:01:32 DEBUG ::1 sql=SELECT param, value FROM bk_user_param WHERE fk_user = 1 AND entity = 1 2020-06-14 15:01:32 DEBUG ::1 sql=SELECT rowid, entity, type, page, param, value FROM bk_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-06-14 15:01:32 DEBUG ::1 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM bk_user_rights as ur, bk_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2020-06-14 15:01:32 DEBUG ::1 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM bk_usergroup_rights as gr, bk_usergroup_user as gu, bk_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-06-14 15:01:32 DEBUG ::1 --- Access to /erpv11/bom/bom_card.php - action=, massaction= 2020-06-14 15:01:32 DEBUG ::1 sql=SELECT transkey, transvalue FROM bk_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-06-14 15:01:32 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 bk_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 2020-06-14 15:01:32 DEBUG ::1 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM bk_extrafields WHERE elementtype = 'bom_bom' ORDER BY pos 2020-06-14 15:01:32 DEBUG ::1 sql=SELECT rowid,ref,label,description,fk_product,qty,efficiency,duration,fk_warehouse,note_public,note_private,date_creation,tms,date_valid,fk_user_creat,fk_user_modif,fk_user_valid,import_key,model_pdf,status FROM bk_bom_bom WHERE rowid = 1 LIMIT 1 2020-06-14 15:01:32 DEBUG ::1 sql=SELECT rowid,fk_bom,fk_product,description,qty,qty_frozen,disable_stock_change,position,import_key FROM bk_bom_bomline WHERE fk_bom = 1 2020-06-14 15:01:32 DEBUG ::1 files.lib.php::dol_dir_list path=D:/Ampps/www/erpv11/documents/bom/bom/BOM2005-0001 types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-06-14 15:01:32 DEBUG ::1 sql=SELECT COUNT(rowid) as nb FROM bk_links WHERE objecttype = 'bom' AND objectid = 1 AND entity = 1 2020-06-14 15:01:32 DEBUG ::1 sql=SELECT MAX(te.ref) FROM bk_bom_bom as te WHERE te.ref < 'BOM2005-0001' AND te.entity IN (1) 2020-06-14 15:01:32 DEBUG ::1 sql=SELECT MIN(te.ref) FROM bk_bom_bom as te WHERE te.ref > 'BOM2005-0001' AND te.entity IN (1) 2020-06-14 15:01:32 DEBUG ::1 Product::fetch id=8117 ref= ref_ext= 2020-06-14 15:01:32 DEBUG ::1 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, 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, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM bk_product WHERE rowid = 8117 2020-06-14 15:01:32 DEBUG ::1 sql=SELECT rowid, code, label FROM bk_c_country WHERE rowid=24 2020-06-14 15:01:32 DEBUG ::1 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM bk_extrafields WHERE elementtype = 'product' ORDER BY pos 2020-06-14 15:01:32 DEBUG ::1 sql=SELECT lang, label, description, note as other FROM bk_product_lang WHERE fk_product=8117 2020-06-14 15:01:32 DEBUG ::1 files.lib.php::dol_dir_list path=D:/Ampps/www/erpv11/documents/produit/7/1/8117/photos/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-06-14 15:01:32 DEBUG ::1 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM bk_ecm_files WHERE filepath = 'produit/7/1/8117/photos' AND entity = 1 2020-06-14 15:01:32 DEBUG ::1 Entrepot::fetch id=16 ref= 2020-06-14 15:01:32 DEBUG ::1 sql=SELECT rowid, fk_parent, ref as label, description, statut, lieu, address, zip, town, fk_pays as country_id FROM bk_entrepot WHERE rowid = '16' 2020-06-14 15:01:32 DEBUG ::1 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM bk_extrafields WHERE elementtype = 'entrepot' ORDER BY pos 2020-06-14 15:01:32 DEBUG ::1 sql=SELECT rowid, code, label FROM bk_c_country WHERE rowid=24 2020-06-14 15:01:32 DEBUG ::1 BOMLine::fetchAll 2020-06-14 15:01:32 DEBUG ::1 sql=SELECT rowid,fk_bom,fk_product,description,qty,qty_frozen,disable_stock_change,position,import_key FROM bk_bom_bomline as t WHERE 1 = 1 AND (fk_bom = 1) ORDER BY position ASC 2020-06-14 15:01:32 DEBUG ::1 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM bk_extrafields WHERE elementtype = 'bom_bomline' ORDER BY pos 2020-06-14 15:01:32 DEBUG ::1 Product::fetch id=6176 ref= ref_ext= 2020-06-14 15:01:32 DEBUG ::1 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, 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, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM bk_product WHERE rowid = 6176 2020-06-14 15:01:32 DEBUG ::1 sql=SELECT rowid, code, label FROM bk_c_country WHERE rowid=24 2020-06-14 15:01:32 DEBUG ::1 sql=SELECT lang, label, description, note as other FROM bk_product_lang WHERE fk_product=6176 2020-06-14 15:01:32 DEBUG ::1 CUnits::fetchAll 2020-06-14 15:01:32 DEBUG ::1 sql=SELECT t.rowid, t.code, t.label, t.short_label, t.unit_type, t.scale, t.active FROM bk_c_units as t WHERE (t.scale=0 AND t.unit_type = 'weight' AND t.active=1) 2020-06-14 15:01:33 DEBUG ::1 files.lib.php::dol_dir_list path=D:/Ampps/www/erpv11/documents/produit/6/7/6176/photos/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM bk_ecm_files WHERE filepath = 'produit/6/7/6176/photos' AND entity = 1 2020-06-14 15:01:33 DEBUG ::1 Product::fetch id=6176 ref= ref_ext= 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, 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, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM bk_product WHERE rowid = 6176 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT rowid, code, label FROM bk_c_country WHERE rowid=24 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT lang, label, description, note as other FROM bk_product_lang WHERE fk_product=6176 2020-06-14 15:01:33 DEBUG ::1 Product::fetch id=6176 ref= ref_ext= 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, 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, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM bk_product WHERE rowid = 6176 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT rowid, code, label FROM bk_c_country WHERE rowid=24 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT lang, label, description, note as other FROM bk_product_lang WHERE fk_product=6176 2020-06-14 15:01:33 DEBUG ::1 files.lib.php::dol_dir_list path=D:/Ampps/www/erpv11/documents/produit/6/7/6176/photos/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM bk_ecm_files WHERE filepath = 'produit/6/7/6176/photos' AND entity = 1 2020-06-14 15:01:33 DEBUG ::1 Product::fetch id=8422 ref= ref_ext= 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, 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, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM bk_product WHERE rowid = 8422 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT rowid, code, label FROM bk_c_country WHERE rowid=24 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT lang, label, description, note as other FROM bk_product_lang WHERE fk_product=8422 2020-06-14 15:01:33 DEBUG ::1 files.lib.php::dol_dir_list path=D:/Ampps/www/erpv11/documents/produit/2/2/8422/photos/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM bk_ecm_files WHERE filepath = 'produit/2/2/8422/photos' AND entity = 1 2020-06-14 15:01:33 DEBUG ::1 Product::fetch id=8422 ref= ref_ext= 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, 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, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM bk_product WHERE rowid = 8422 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT rowid, code, label FROM bk_c_country WHERE rowid=24 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT lang, label, description, note as other FROM bk_product_lang WHERE fk_product=8422 2020-06-14 15:01:33 DEBUG ::1 Product::fetch id=8422 ref= ref_ext= 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, 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, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM bk_product WHERE rowid = 8422 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT rowid, code, label FROM bk_c_country WHERE rowid=24 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT lang, label, description, note as other FROM bk_product_lang WHERE fk_product=8422 2020-06-14 15:01:33 DEBUG ::1 files.lib.php::dol_dir_list path=D:/Ampps/www/erpv11/documents/produit/2/2/8422/photos/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM bk_ecm_files WHERE filepath = 'produit/2/2/8422/photos' AND entity = 1 2020-06-14 15:01:33 DEBUG ::1 Product::fetch id=6193 ref= ref_ext= 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, 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, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM bk_product WHERE rowid = 6193 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT rowid, code, label FROM bk_c_country WHERE rowid=24 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT lang, label, description, note as other FROM bk_product_lang WHERE fk_product=6193 2020-06-14 15:01:33 DEBUG ::1 files.lib.php::dol_dir_list path=D:/Ampps/www/erpv11/documents/produit/3/9/6193/photos/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM bk_ecm_files WHERE filepath = 'produit/3/9/6193/photos' AND entity = 1 2020-06-14 15:01:33 DEBUG ::1 Product::fetch id=6193 ref= ref_ext= 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, 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, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM bk_product WHERE rowid = 6193 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT rowid, code, label FROM bk_c_country WHERE rowid=24 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT lang, label, description, note as other FROM bk_product_lang WHERE fk_product=6193 2020-06-14 15:01:33 DEBUG ::1 Product::fetch id=6193 ref= ref_ext= 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, 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, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM bk_product WHERE rowid = 6193 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT rowid, code, label FROM bk_c_country WHERE rowid=24 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT lang, label, description, note as other FROM bk_product_lang WHERE fk_product=6193 2020-06-14 15:01:33 DEBUG ::1 files.lib.php::dol_dir_list path=D:/Ampps/www/erpv11/documents/produit/3/9/6193/photos/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM bk_ecm_files WHERE filepath = 'produit/3/9/6193/photos' AND entity = 1 2020-06-14 15:01:33 DEBUG ::1 Product::fetch id=8423 ref= ref_ext= 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, 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, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM bk_product WHERE rowid = 8423 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT lang, label, description, note as other FROM bk_product_lang WHERE fk_product=8423 2020-06-14 15:01:33 DEBUG ::1 files.lib.php::dol_dir_list path=D:/Ampps/www/erpv11/documents/produit/3/2/8423/photos/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM bk_ecm_files WHERE filepath = 'produit/3/2/8423/photos' AND entity = 1 2020-06-14 15:01:33 DEBUG ::1 Product::fetch id=8423 ref= ref_ext= 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, 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, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM bk_product WHERE rowid = 8423 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT lang, label, description, note as other FROM bk_product_lang WHERE fk_product=8423 2020-06-14 15:01:33 DEBUG ::1 Product::fetch id=8423 ref= ref_ext= 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, 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, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM bk_product WHERE rowid = 8423 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT lang, label, description, note as other FROM bk_product_lang WHERE fk_product=8423 2020-06-14 15:01:33 DEBUG ::1 files.lib.php::dol_dir_list path=D:/Ampps/www/erpv11/documents/produit/3/2/8423/photos/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM bk_ecm_files WHERE filepath = 'produit/3/2/8423/photos' AND entity = 1 2020-06-14 15:01:33 DEBUG ::1 Product::fetch id=8424 ref= ref_ext= 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, 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, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM bk_product WHERE rowid = 8424 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT lang, label, description, note as other FROM bk_product_lang WHERE fk_product=8424 2020-06-14 15:01:33 DEBUG ::1 CUnits::fetchAll 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT t.rowid, t.code, t.label, t.short_label, t.unit_type, t.scale, t.active FROM bk_c_units as t WHERE (t.scale=-3 AND t.unit_type = 'volume' AND t.active=1) 2020-06-14 15:01:33 DEBUG ::1 files.lib.php::dol_dir_list path=D:/Ampps/www/erpv11/documents/produit/4/2/8424/photos/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM bk_ecm_files WHERE filepath = 'produit/4/2/8424/photos' AND entity = 1 2020-06-14 15:01:33 DEBUG ::1 Product::fetch id=8424 ref= ref_ext= 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, 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, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM bk_product WHERE rowid = 8424 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT lang, label, description, note as other FROM bk_product_lang WHERE fk_product=8424 2020-06-14 15:01:33 DEBUG ::1 Product::fetch id=8424 ref= ref_ext= 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, 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, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM bk_product WHERE rowid = 8424 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT lang, label, description, note as other FROM bk_product_lang WHERE fk_product=8424 2020-06-14 15:01:33 DEBUG ::1 files.lib.php::dol_dir_list path=D:/Ampps/www/erpv11/documents/produit/4/2/8424/photos/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM bk_ecm_files WHERE filepath = 'produit/4/2/8424/photos' AND entity = 1 2020-06-14 15:01:33 DEBUG ::1 files.lib.php::dol_dir_list path=D:/Ampps/www/erpv11/documents/bom/BOM2005-0001 types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*.*\\.png)$" 2020-06-14 15:01:33 DEBUG ::1 /core/lib/function2.lib.php::getListOfModels 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT nom as id, nom as doc_template_name, libelle as label, description as description FROM bk_document_model WHERE type = 'bom' AND entity IN (0,1) ORDER BY description DESC 2020-06-14 15:01:33 DEBUG ::1 BOM::fetchObjectLink 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT rowid, fk_source, sourcetype, fk_target, targettype FROM bk_element_element WHERE (fk_source = 1 AND sourcetype = 'bom') OR (fk_target = 1 AND targettype = 'bom') ORDER BY sourcetype 2020-06-14 15:01:33 DEBUG ::1 ActionComm::getActions 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT a.id FROM bk_actioncomm as a WHERE a.entity IN (1) AND a.fk_element = 1 AND a.elementtype = 'bom' ORDER BY a.datep DESC, a.id DESC LIMIT 11 2020-06-14 15:01:33 DEBUG ::1 ActionComm::fetch 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT a.id, a.id as ref, a.ref_ext, a.datep, a.datep2, a.durationp, a.datec, a.tms as datem, a.code, a.label, a.note, a.fk_soc, a.fk_project, a.fk_user_author, a.fk_user_mod, a.fk_user_action, a.fk_user_done, a.fk_contact, a.percent as percentage, a.fk_element as elementid, a.elementtype, a.priority, a.fulldayevent, a.location, a.punctual, a.transparency, c.id as type_id, c.code as type_code, c.libelle as type_label, c.color as type_color, c.picto as type_picto, s.nom as socname, u.firstname, u.lastname as lastname FROM bk_actioncomm as a LEFT JOIN bk_c_actioncomm as c ON a.fk_action=c.id LEFT JOIN bk_user as u on u.rowid = a.fk_user_author LEFT JOIN bk_societe as s on s.rowid = a.fk_soc WHERE a.id=25276 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT fk_actioncomm, element_type, fk_element, answer_status, mandatory, transparency FROM bk_actioncomm_resources WHERE fk_actioncomm = 25276 AND element_type IN ('user', 'socpeople') 2020-06-14 15:01:33 DEBUG ::1 ActionComm::fetch 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT a.id, a.id as ref, a.ref_ext, a.datep, a.datep2, a.durationp, a.datec, a.tms as datem, a.code, a.label, a.note, a.fk_soc, a.fk_project, a.fk_user_author, a.fk_user_mod, a.fk_user_action, a.fk_user_done, a.fk_contact, a.percent as percentage, a.fk_element as elementid, a.elementtype, a.priority, a.fulldayevent, a.location, a.punctual, a.transparency, c.id as type_id, c.code as type_code, c.libelle as type_label, c.color as type_color, c.picto as type_picto, s.nom as socname, u.firstname, u.lastname as lastname FROM bk_actioncomm as a LEFT JOIN bk_c_actioncomm as c ON a.fk_action=c.id LEFT JOIN bk_user as u on u.rowid = a.fk_user_author LEFT JOIN bk_societe as s on s.rowid = a.fk_soc WHERE a.id=25273 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT fk_actioncomm, element_type, fk_element, answer_status, mandatory, transparency FROM bk_actioncomm_resources WHERE fk_actioncomm = 25273 AND element_type IN ('user', 'socpeople') 2020-06-14 15:01:33 DEBUG ::1 ActionComm::fetch 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT a.id, a.id as ref, a.ref_ext, a.datep, a.datep2, a.durationp, a.datec, a.tms as datem, a.code, a.label, a.note, a.fk_soc, a.fk_project, a.fk_user_author, a.fk_user_mod, a.fk_user_action, a.fk_user_done, a.fk_contact, a.percent as percentage, a.fk_element as elementid, a.elementtype, a.priority, a.fulldayevent, a.location, a.punctual, a.transparency, c.id as type_id, c.code as type_code, c.libelle as type_label, c.color as type_color, c.picto as type_picto, s.nom as socname, u.firstname, u.lastname as lastname FROM bk_actioncomm as a LEFT JOIN bk_c_actioncomm as c ON a.fk_action=c.id LEFT JOIN bk_user as u on u.rowid = a.fk_user_author LEFT JOIN bk_societe as s on s.rowid = a.fk_soc WHERE a.id=25268 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT fk_actioncomm, element_type, fk_element, answer_status, mandatory, transparency FROM bk_actioncomm_resources WHERE fk_actioncomm = 25268 AND element_type IN ('user', 'socpeople') 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_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 as note_private, u.note_public, 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.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM bk_user as u LEFT JOIN bk_c_country as c ON u.fk_country = c.rowid LEFT JOIN bk_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.rowid = 1 ORDER BY u.entity ASC 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM bk_extrafields WHERE elementtype = 'user' ORDER BY pos 2020-06-14 15:01:33 DEBUG ::1 --- End access to /erpv11/bom/bom_card.php 2020-06-14 15:01:33 DEBUG ::1 --- Access to /erpv11/core/js/lib_notification.js.php - action=, massaction= 2020-06-14 15:01:33 DEBUG ::1 sql=SELECT transkey, transvalue FROM bk_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-06-14 15:01:33 DEBUG ::1 --- End access to /erpv11/core/js/lib_notification.js.php 2020-06-14 15:01:36 DEBUG ::1 - This is an already logged session. _SESSION['dol_login']=adminbk _SESSION['dol_entity']=1 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_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 as note_private, u.note_public, 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.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM bk_user as u LEFT JOIN bk_c_country as c ON u.fk_country = c.rowid LEFT JOIN bk_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'adminbk' ORDER BY u.entity ASC 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM bk_extrafields WHERE elementtype = 'user' ORDER BY pos 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT param, value FROM bk_user_param WHERE fk_user = 1 AND entity = 1 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT rowid, entity, type, page, param, value FROM bk_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM bk_user_rights as ur, bk_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM bk_usergroup_rights as gr, bk_usergroup_user as gu, bk_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-06-14 15:01:36 DEBUG ::1 --- Access to /erpv11/mrp/mo_card.php - action=create, massaction= 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT transkey, transvalue FROM bk_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-06-14 15:01:36 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 bk_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 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM bk_extrafields WHERE elementtype = 'mrp_mo' ORDER BY pos 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT rowid,ref,label,description,fk_product,qty,efficiency,duration,fk_warehouse,note_public,note_private,date_creation,tms,date_valid,fk_user_creat,fk_user_modif,fk_user_valid,import_key,model_pdf,status FROM bk_bom_bom WHERE rowid = 1 LIMIT 1 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT rowid,fk_bom,fk_product,description,qty,qty_frozen,disable_stock_change,position,import_key FROM bk_bom_bomline WHERE fk_bom = 1 2020-06-14 15:01:36 DEBUG ::1 Form::selectForForms object->filter=t.status=1 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT t.rowid, t.ref,t.label FROM bk_bom_bom as t WHERE 1=1 AND t.entity IN (1) AND (t.status=1) ORDER BY t.ref ASC, t.label 2020-06-14 15:01:36 DEBUG ::1 Form::selectForForms object->filter= 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT t.rowid, t.ref,t.label FROM bk_product as t WHERE 1=1 AND t.entity IN (1) ORDER BY t.ref ASC, t.label 2020-06-14 15:01:36 DEBUG ::1 Form::selectForForms object->filter= 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT t.rowid, t.nom,t.name_alias FROM bk_societe as t WHERE 1=1 AND t.entity IN (1) ORDER BY t.nom ASC, t.name_alias 2020-06-14 15:01:36 DEBUG ::1 Form::selectForForms object->filter=fk_statut=1 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT t.rowid, t.ref,t.title FROM bk_projet as t WHERE 1=1 AND t.entity IN (1) AND (fk_statut=1) ORDER BY t.ref ASC, t.title 2020-06-14 15:01:36 DEBUG ::1 Form::selectForForms object->filter= 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT t.rowid, t.ref,t.lieu FROM bk_entrepot as t WHERE 1=1 AND t.entity IN (1) ORDER BY t.ref ASC, t.lieu 2020-06-14 15:01:36 DEBUG ::1 Product::fetch id=6176 ref= ref_ext= 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, 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, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM bk_product WHERE rowid = 6176 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT rowid, code, label FROM bk_c_country WHERE rowid=24 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM bk_extrafields WHERE elementtype = 'product' ORDER BY pos 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT lang, label, description, note as other FROM bk_product_lang WHERE fk_product=6176 2020-06-14 15:01:36 DEBUG ::1 CUnits::fetchAll 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT t.rowid, t.code, t.label, t.short_label, t.unit_type, t.scale, t.active FROM bk_c_units as t WHERE (t.scale=0 AND t.unit_type = 'weight' AND t.active=1) 2020-06-14 15:01:36 DEBUG ::1 files.lib.php::dol_dir_list path=D:/Ampps/www/erpv11/documents/produit/6/7/6176/photos/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM bk_ecm_files WHERE filepath = 'produit/6/7/6176/photos' AND entity = 1 2020-06-14 15:01:36 DEBUG ::1 Product::fetch id=8422 ref= ref_ext= 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, 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, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM bk_product WHERE rowid = 8422 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT rowid, code, label FROM bk_c_country WHERE rowid=24 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT lang, label, description, note as other FROM bk_product_lang WHERE fk_product=8422 2020-06-14 15:01:36 DEBUG ::1 files.lib.php::dol_dir_list path=D:/Ampps/www/erpv11/documents/produit/2/2/8422/photos/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM bk_ecm_files WHERE filepath = 'produit/2/2/8422/photos' AND entity = 1 2020-06-14 15:01:36 DEBUG ::1 Product::fetch id=6193 ref= ref_ext= 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, 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, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM bk_product WHERE rowid = 6193 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT rowid, code, label FROM bk_c_country WHERE rowid=24 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT lang, label, description, note as other FROM bk_product_lang WHERE fk_product=6193 2020-06-14 15:01:36 DEBUG ::1 files.lib.php::dol_dir_list path=D:/Ampps/www/erpv11/documents/produit/3/9/6193/photos/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM bk_ecm_files WHERE filepath = 'produit/3/9/6193/photos' AND entity = 1 2020-06-14 15:01:36 DEBUG ::1 Product::fetch id=8423 ref= ref_ext= 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, 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, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM bk_product WHERE rowid = 8423 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT lang, label, description, note as other FROM bk_product_lang WHERE fk_product=8423 2020-06-14 15:01:36 DEBUG ::1 files.lib.php::dol_dir_list path=D:/Ampps/www/erpv11/documents/produit/3/2/8423/photos/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM bk_ecm_files WHERE filepath = 'produit/3/2/8423/photos' AND entity = 1 2020-06-14 15:01:36 DEBUG ::1 Product::fetch id=8424 ref= ref_ext= 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, 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, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM bk_product WHERE rowid = 8424 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT lang, label, description, note as other FROM bk_product_lang WHERE fk_product=8424 2020-06-14 15:01:36 DEBUG ::1 CUnits::fetchAll 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT t.rowid, t.code, t.label, t.short_label, t.unit_type, t.scale, t.active FROM bk_c_units as t WHERE (t.scale=-3 AND t.unit_type = 'volume' AND t.active=1) 2020-06-14 15:01:36 DEBUG ::1 files.lib.php::dol_dir_list path=D:/Ampps/www/erpv11/documents/produit/4/2/8424/photos/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM bk_ecm_files WHERE filepath = 'produit/4/2/8424/photos' AND entity = 1 2020-06-14 15:01:36 DEBUG ::1 --- End access to /erpv11/mrp/mo_card.php 2020-06-14 15:01:36 DEBUG ::1 --- Access to /erpv11/core/js/lib_notification.js.php - action=, massaction= 2020-06-14 15:01:36 DEBUG ::1 sql=SELECT transkey, transvalue FROM bk_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-06-14 15:01:36 DEBUG ::1 --- End access to /erpv11/core/js/lib_notification.js.php 2020-06-14 15:02:07 DEBUG ::1 - This is an already logged session. _SESSION['dol_login']=adminbk _SESSION['dol_entity']=1 2020-06-14 15:02:07 DEBUG ::1 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_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 as note_private, u.note_public, 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.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM bk_user as u LEFT JOIN bk_c_country as c ON u.fk_country = c.rowid LEFT JOIN bk_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'adminbk' ORDER BY u.entity ASC 2020-06-14 15:02:07 DEBUG ::1 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM bk_extrafields WHERE elementtype = 'user' ORDER BY pos 2020-06-14 15:02:07 DEBUG ::1 sql=SELECT param, value FROM bk_user_param WHERE fk_user = 1 AND entity = 1 2020-06-14 15:02:07 DEBUG ::1 sql=SELECT rowid, entity, type, page, param, value FROM bk_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-06-14 15:02:07 DEBUG ::1 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM bk_user_rights as ur, bk_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2020-06-14 15:02:07 DEBUG ::1 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM bk_usergroup_rights as gr, bk_usergroup_user as gu, bk_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-06-14 15:02:07 DEBUG ::1 --- Access to /erpv11/core/ajax/check_notifications.php - action=, massaction= 2020-06-14 15:02:07 DEBUG ::1 sql=SELECT transkey, transvalue FROM bk_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-06-14 15:02:07 DEBUG ::1 NEW $_SESSION[auto_check_events_not_before]=1592146926 2020-06-14 15:02:07 DEBUG ::1 sql=SELECT id FROM bk_actioncomm a, bk_actioncomm_resources ar WHERE a.id = ar.fk_actioncomm AND datep BETWEEN '2020-06-14 15:00:48' AND '2020-06-14 15:02:05' AND a.code <> "AC_OTH_AUTO" AND ar.element_type = "user" AND ar.fk_element = 1 LIMIT 10 2020-06-14 15:02:07 DEBUG ::1 --- End access to /erpv11/core/ajax/check_notifications.php 2020-06-14 15:02:19 DEBUG ::1 - This is an already logged session. _SESSION['dol_login']=adminbk _SESSION['dol_entity']=1 2020-06-14 15:02:19 DEBUG ::1 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_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 as note_private, u.note_public, 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.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM bk_user as u LEFT JOIN bk_c_country as c ON u.fk_country = c.rowid LEFT JOIN bk_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'adminbk' ORDER BY u.entity ASC 2020-06-14 15:02:19 DEBUG ::1 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM bk_extrafields WHERE elementtype = 'user' ORDER BY pos 2020-06-14 15:02:19 DEBUG ::1 sql=SELECT param, value FROM bk_user_param WHERE fk_user = 1 AND entity = 1 2020-06-14 15:02:19 DEBUG ::1 sql=SELECT rowid, entity, type, page, param, value FROM bk_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-06-14 15:02:19 DEBUG ::1 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM bk_user_rights as ur, bk_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2020-06-14 15:02:19 DEBUG ::1 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM bk_usergroup_rights as gr, bk_usergroup_user as gu, bk_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-06-14 15:02:19 DEBUG ::1 --- Access to /erpv11/mrp/mo_card.php - action=add, massaction= 2020-06-14 15:02:19 DEBUG ::1 sql=SELECT transkey, transvalue FROM bk_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-06-14 15:02: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 bk_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 2020-06-14 15:02:19 DEBUG ::1 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM bk_extrafields WHERE elementtype = 'mrp_mo' ORDER BY pos 2020-06-14 15:02:20 DEBUG ::1 sql=SELECT rowid,ref,label,description,fk_product,qty,efficiency,duration,fk_warehouse,note_public,note_private,date_creation,tms,date_valid,fk_user_creat,fk_user_modif,fk_user_valid,import_key,model_pdf,status FROM bk_bom_bom WHERE rowid = 1 LIMIT 1 2020-06-14 15:02:20 DEBUG ::1 sql=SELECT rowid,fk_bom,fk_product,description,qty,qty_frozen,disable_stock_change,position,import_key FROM bk_bom_bomline WHERE fk_bom = 1 2020-06-14 15:02:20 DEBUG ::1 BEGIN Transaction 2020-06-14 15:02:20 DEBUG ::1 sql=INSERT INTO bk_mrp_mo (ref, fk_bom, fk_product, qty, label, fk_soc, fk_project, fk_warehouse, note_public, note_private, date_creation, tms, fk_user_creat, fk_user_modif, date_start_planned, date_end_planned, import_key, model_pdf, status) VALUES ('', 1, 8117, 1, 'Production Pain baguette 100', 1, NULL, 16, NULL, NULL, '2020-06-14 15:02:20', NULL, 1, NULL, '2020-06-14 16:30:00', '2020-06-14 23:00:00', NULL, NULL, 0) 2020-06-14 15:02:20 ERR ::1 DoliDBMysqli::query SQL Error message: DB_ERROR_CONSTRAINT Column 'tms' cannot be null 2020-06-14 15:02:20 DEBUG ::1 ROLLBACK Transaction 2020-06-14 15:02:20 DEBUG ::1 Form::selectForForms object->filter=t.status=1 2020-06-14 15:02:20 DEBUG ::1 sql=SELECT t.rowid, t.ref,t.label FROM bk_bom_bom as t WHERE 1=1 AND t.entity IN (1) AND (t.status=1) ORDER BY t.ref ASC, t.label 2020-06-14 15:02:20 DEBUG ::1 Form::selectForForms object->filter= 2020-06-14 15:02:20 DEBUG ::1 sql=SELECT t.rowid, t.ref,t.label FROM bk_product as t WHERE 1=1 AND t.entity IN (1) ORDER BY t.ref ASC, t.label 2020-06-14 15:02:20 DEBUG ::1 Form::selectForForms object->filter= 2020-06-14 15:02:20 DEBUG ::1 sql=SELECT t.rowid, t.nom,t.name_alias FROM bk_societe as t WHERE 1=1 AND t.entity IN (1) ORDER BY t.nom ASC, t.name_alias 2020-06-14 15:02:20 DEBUG ::1 Form::selectForForms object->filter=fk_statut=1 2020-06-14 15:02:20 DEBUG ::1 sql=SELECT t.rowid, t.ref,t.title FROM bk_projet as t WHERE 1=1 AND t.entity IN (1) AND (fk_statut=1) ORDER BY t.ref ASC, t.title 2020-06-14 15:02:20 DEBUG ::1 Form::selectForForms object->filter= 2020-06-14 15:02:20 DEBUG ::1 sql=SELECT t.rowid, t.ref,t.lieu FROM bk_entrepot as t WHERE 1=1 AND t.entity IN (1) ORDER BY t.ref ASC, t.lieu 2020-06-14 15:02:20 DEBUG ::1 Product::fetch id=6176 ref= ref_ext= 2020-06-14 15:02:20 DEBUG ::1 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, 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, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM bk_product WHERE rowid = 6176 2020-06-14 15:02:20 DEBUG ::1 sql=SELECT rowid, code, label FROM bk_c_country WHERE rowid=24 2020-06-14 15:02:20 DEBUG ::1 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM bk_extrafields WHERE elementtype = 'product' ORDER BY pos 2020-06-14 15:02:20 DEBUG ::1 sql=SELECT lang, label, description, note as other FROM bk_product_lang WHERE fk_product=6176 2020-06-14 15:02:20 DEBUG ::1 CUnits::fetchAll 2020-06-14 15:02:20 DEBUG ::1 sql=SELECT t.rowid, t.code, t.label, t.short_label, t.unit_type, t.scale, t.active FROM bk_c_units as t WHERE (t.scale=0 AND t.unit_type = 'weight' AND t.active=1) 2020-06-14 15:02:20 DEBUG ::1 files.lib.php::dol_dir_list path=D:/Ampps/www/erpv11/documents/produit/6/7/6176/photos/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-06-14 15:02:20 DEBUG ::1 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM bk_ecm_files WHERE filepath = 'produit/6/7/6176/photos' AND entity = 1 2020-06-14 15:02:20 DEBUG ::1 Product::fetch id=8422 ref= ref_ext= 2020-06-14 15:02:20 DEBUG ::1 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, 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, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM bk_product WHERE rowid = 8422 2020-06-14 15:02:20 DEBUG ::1 sql=SELECT rowid, code, label FROM bk_c_country WHERE rowid=24 2020-06-14 15:02:20 DEBUG ::1 sql=SELECT lang, label, description, note as other FROM bk_product_lang WHERE fk_product=8422 2020-06-14 15:02:20 DEBUG ::1 files.lib.php::dol_dir_list path=D:/Ampps/www/erpv11/documents/produit/2/2/8422/photos/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-06-14 15:02:20 DEBUG ::1 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM bk_ecm_files WHERE filepath = 'produit/2/2/8422/photos' AND entity = 1 2020-06-14 15:02:20 DEBUG ::1 Product::fetch id=6193 ref= ref_ext= 2020-06-14 15:02:20 DEBUG ::1 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, 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, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM bk_product WHERE rowid = 6193 2020-06-14 15:02:20 DEBUG ::1 sql=SELECT rowid, code, label FROM bk_c_country WHERE rowid=24 2020-06-14 15:02:20 DEBUG ::1 sql=SELECT lang, label, description, note as other FROM bk_product_lang WHERE fk_product=6193 2020-06-14 15:02:20 DEBUG ::1 files.lib.php::dol_dir_list path=D:/Ampps/www/erpv11/documents/produit/3/9/6193/photos/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-06-14 15:02:20 DEBUG ::1 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM bk_ecm_files WHERE filepath = 'produit/3/9/6193/photos' AND entity = 1 2020-06-14 15:02:20 DEBUG ::1 Product::fetch id=8423 ref= ref_ext= 2020-06-14 15:02:20 DEBUG ::1 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, 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, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM bk_product WHERE rowid = 8423 2020-06-14 15:02:20 DEBUG ::1 sql=SELECT lang, label, description, note as other FROM bk_product_lang WHERE fk_product=8423 2020-06-14 15:02:20 DEBUG ::1 files.lib.php::dol_dir_list path=D:/Ampps/www/erpv11/documents/produit/3/2/8423/photos/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-06-14 15:02:20 DEBUG ::1 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM bk_ecm_files WHERE filepath = 'produit/3/2/8423/photos' AND entity = 1 2020-06-14 15:02:20 DEBUG ::1 Product::fetch id=8424 ref= ref_ext= 2020-06-14 15:02:20 DEBUG ::1 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, 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, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM bk_product WHERE rowid = 8424 2020-06-14 15:02:20 DEBUG ::1 sql=SELECT lang, label, description, note as other FROM bk_product_lang WHERE fk_product=8424 2020-06-14 15:02:20 DEBUG ::1 CUnits::fetchAll 2020-06-14 15:02:20 DEBUG ::1 sql=SELECT t.rowid, t.code, t.label, t.short_label, t.unit_type, t.scale, t.active FROM bk_c_units as t WHERE (t.scale=-3 AND t.unit_type = 'volume' AND t.active=1) 2020-06-14 15:02:20 DEBUG ::1 files.lib.php::dol_dir_list path=D:/Ampps/www/erpv11/documents/produit/4/2/8424/photos/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-06-14 15:02:20 DEBUG ::1 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM bk_ecm_files WHERE filepath = 'produit/4/2/8424/photos' AND entity = 1 2020-06-14 15:02:20 DEBUG ::1 --- End access to /erpv11/mrp/mo_card.php 2020-06-14 15:02:20 DEBUG ::1 --- Access to /erpv11/core/js/lib_notification.js.php - action=, massaction= 2020-06-14 15:02:20 DEBUG ::1 sql=SELECT transkey, transvalue FROM bk_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-06-14 15:02:20 DEBUG ::1 --- End access to /erpv11/core/js/lib_notification.js.php 2020-06-14 15:02:20 DEBUG ::1 --- Access to /erpv11/viewimage.php - action=, massaction= 2020-06-14 15:02:20 DEBUG ::1 modulepart=mycompany original_file=logos/thumbs/BFLogo_mini.png entity=1 2020-06-14 15:02:20 DEBUG ::1 viewimage.php return file D:/Ampps/www/erpv11/documents/mycompany/logos/thumbs/BFLogo_mini.png filename=BFLogo_mini.png content-type=image/png 2020-06-14 15:02:20 DEBUG ::1 --- End access to /erpv11/viewimage.php 2020-06-14 15:02:50 DEBUG ::1 - This is an already logged session. _SESSION['dol_login']=adminbk _SESSION['dol_entity']=1 2020-06-14 15:02:50 DEBUG ::1 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_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 as note_private, u.note_public, 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.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM bk_user as u LEFT JOIN bk_c_country as c ON u.fk_country = c.rowid LEFT JOIN bk_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'adminbk' ORDER BY u.entity ASC 2020-06-14 15:02:50 DEBUG ::1 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM bk_extrafields WHERE elementtype = 'user' ORDER BY pos 2020-06-14 15:02:50 DEBUG ::1 sql=SELECT param, value FROM bk_user_param WHERE fk_user = 1 AND entity = 1 2020-06-14 15:02:50 DEBUG ::1 sql=SELECT rowid, entity, type, page, param, value FROM bk_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-06-14 15:02:50 DEBUG ::1 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM bk_user_rights as ur, bk_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2020-06-14 15:02:50 DEBUG ::1 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM bk_usergroup_rights as gr, bk_usergroup_user as gu, bk_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-06-14 15:02:50 DEBUG ::1 --- Access to /erpv11/core/ajax/check_notifications.php - action=, massaction= 2020-06-14 15:02:50 DEBUG ::1 sql=SELECT transkey, transvalue FROM bk_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-06-14 15:02:50 DEBUG ::1 NEW $_SESSION[auto_check_events_not_before]=1592146970 2020-06-14 15:02:50 DEBUG ::1 sql=SELECT id FROM bk_actioncomm a, bk_actioncomm_resources ar WHERE a.id = ar.fk_actioncomm AND datep BETWEEN '2020-06-14 15:02:06' AND '2020-06-14 15:02:49' AND a.code <> "AC_OTH_AUTO" AND ar.element_type = "user" AND ar.fk_element = 1 LIMIT 10 2020-06-14 15:02:50 DEBUG ::1 --- End access to /erpv11/core/ajax/check_notifications.php 2020-06-14 15:03:20 DEBUG ::1 - This is an already logged session. _SESSION['dol_login']=adminbk _SESSION['dol_entity']=1 2020-06-14 15:03:20 DEBUG ::1 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_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 as note_private, u.note_public, 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.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM bk_user as u LEFT JOIN bk_c_country as c ON u.fk_country = c.rowid LEFT JOIN bk_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'adminbk' ORDER BY u.entity ASC 2020-06-14 15:03:20 DEBUG ::1 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM bk_extrafields WHERE elementtype = 'user' ORDER BY pos 2020-06-14 15:03:20 DEBUG ::1 sql=SELECT param, value FROM bk_user_param WHERE fk_user = 1 AND entity = 1 2020-06-14 15:03:20 DEBUG ::1 sql=SELECT rowid, entity, type, page, param, value FROM bk_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-06-14 15:03:20 DEBUG ::1 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM bk_user_rights as ur, bk_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2020-06-14 15:03:20 DEBUG ::1 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM bk_usergroup_rights as gr, bk_usergroup_user as gu, bk_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-06-14 15:03:20 DEBUG ::1 --- Access to /erpv11/core/ajax/check_notifications.php - action=, massaction= 2020-06-14 15:03:20 DEBUG ::1 sql=SELECT transkey, transvalue FROM bk_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-06-14 15:03:20 DEBUG ::1 NEW $_SESSION[auto_check_events_not_before]=1592147000 2020-06-14 15:03:20 DEBUG ::1 sql=SELECT id FROM bk_actioncomm a, bk_actioncomm_resources ar WHERE a.id = ar.fk_actioncomm AND datep BETWEEN '2020-06-14 15:02:50' AND '2020-06-14 15:03:19' AND a.code <> "AC_OTH_AUTO" AND ar.element_type = "user" AND ar.fk_element = 1 LIMIT 10 2020-06-14 15:03:20 DEBUG ::1 --- End access to /erpv11/core/ajax/check_notifications.php 2020-06-14 15:03:50 DEBUG ::1 - This is an already logged session. _SESSION['dol_login']=adminbk _SESSION['dol_entity']=1 2020-06-14 15:03:50 DEBUG ::1 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_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 as note_private, u.note_public, 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.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM bk_user as u LEFT JOIN bk_c_country as c ON u.fk_country = c.rowid LEFT JOIN bk_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'adminbk' ORDER BY u.entity ASC 2020-06-14 15:03:50 DEBUG ::1 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM bk_extrafields WHERE elementtype = 'user' ORDER BY pos 2020-06-14 15:03:50 DEBUG ::1 sql=SELECT param, value FROM bk_user_param WHERE fk_user = 1 AND entity = 1 2020-06-14 15:03:50 DEBUG ::1 sql=SELECT rowid, entity, type, page, param, value FROM bk_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-06-14 15:03:50 DEBUG ::1 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM bk_user_rights as ur, bk_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2020-06-14 15:03:50 DEBUG ::1 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM bk_usergroup_rights as gr, bk_usergroup_user as gu, bk_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-06-14 15:03:50 DEBUG ::1 --- Access to /erpv11/core/ajax/check_notifications.php - action=, massaction= 2020-06-14 15:03:50 DEBUG ::1 sql=SELECT transkey, transvalue FROM bk_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-06-14 15:03:50 DEBUG ::1 NEW $_SESSION[auto_check_events_not_before]=1592147030 2020-06-14 15:03:50 DEBUG ::1 sql=SELECT id FROM bk_actioncomm a, bk_actioncomm_resources ar WHERE a.id = ar.fk_actioncomm AND datep BETWEEN '2020-06-14 15:03:20' AND '2020-06-14 15:03:49' AND a.code <> "AC_OTH_AUTO" AND ar.element_type = "user" AND ar.fk_element = 1 LIMIT 10 2020-06-14 15:03:50 DEBUG ::1 --- End access to /erpv11/core/ajax/check_notifications.php 2020-06-14 15:04:20 DEBUG ::1 - This is an already logged session. _SESSION['dol_login']=adminbk _SESSION['dol_entity']=1 2020-06-14 15:04:20 DEBUG ::1 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_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 as note_private, u.note_public, 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.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM bk_user as u LEFT JOIN bk_c_country as c ON u.fk_country = c.rowid LEFT JOIN bk_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'adminbk' ORDER BY u.entity ASC 2020-06-14 15:04:20 DEBUG ::1 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM bk_extrafields WHERE elementtype = 'user' ORDER BY pos 2020-06-14 15:04:20 DEBUG ::1 sql=SELECT param, value FROM bk_user_param WHERE fk_user = 1 AND entity = 1 2020-06-14 15:04:20 DEBUG ::1 sql=SELECT rowid, entity, type, page, param, value FROM bk_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-06-14 15:04:20 DEBUG ::1 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM bk_user_rights as ur, bk_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2020-06-14 15:04:20 DEBUG ::1 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM bk_usergroup_rights as gr, bk_usergroup_user as gu, bk_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-06-14 15:04:20 DEBUG ::1 --- Access to /erpv11/core/ajax/check_notifications.php - action=, massaction= 2020-06-14 15:04:20 DEBUG ::1 sql=SELECT transkey, transvalue FROM bk_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-06-14 15:04:20 DEBUG ::1 NEW $_SESSION[auto_check_events_not_before]=1592147060 2020-06-14 15:04:20 DEBUG ::1 sql=SELECT id FROM bk_actioncomm a, bk_actioncomm_resources ar WHERE a.id = ar.fk_actioncomm AND datep BETWEEN '2020-06-14 15:03:50' AND '2020-06-14 15:04:19' AND a.code <> "AC_OTH_AUTO" AND ar.element_type = "user" AND ar.fk_element = 1 LIMIT 10 2020-06-14 15:04:20 DEBUG ::1 --- End access to /erpv11/core/ajax/check_notifications.php