search

Dolibarr / dolibarr

Dolibarr ERP CRM is a modern software package to manage your company or foundation's activity (contacts, suppliers, invoices, orders, stocks, agenda, accounting, ...). it's an open source Web application (written in PHP) designed for businesses of any sizes, foundations and freelancers.
https://www.dolibarr.org
GNU General Public License v3.0
5.37k stars 2.77k forks source link

Bug: editing product variant reference does not work #14679

Closed dpriskorn closed 3 years ago

dpriskorn commented 4 years ago

Bug

it does not edit the ref nor generate an error.

Environment

Expected and actual behavior

expected and error or a changed ref

Steps to reproduce the behavior

add a variant to a product with a reference edit the reference by clicking the pencil icon press save

2020-09-09 07:31:56 DEBUG   127.0.0.1       - This is an already logged session. _SESSION['dol_login']=egils _SESSION['dol_entity']=1
2020-09-09 07:31:56 DEBUG   127.0.0.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_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 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 IN (0, 1) AND u.login = 'egils' ORDER BY u.entity ASC
2020-09-09 07:31:56 DEBUG   127.0.0.1       sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos
2020-09-09 07:31:56 DEBUG   127.0.0.1       sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
2020-09-09 07:31:56 DEBUG   127.0.0.1       sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1)
2020-09-09 07:31:56 DEBUG   127.0.0.1       HookManager::initHooks Loading hooks: context=main-path=/removeconf/class/actions_removeconf.class.php
2020-09-09 07:31:56 DEBUG   127.0.0.1       sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_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-09-09 07:31:56 DEBUG   127.0.0.1       sql=SELECT DISTINCT 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 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-09-09 07:31:56 INFO    127.0.0.1       --- Access to /variants/combinations.php - action=edit, massaction=
2020-09-09 07:31:56 DEBUG   127.0.0.1       sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='en_US' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC
2020-09-09 07:31:56 DEBUG   127.0.0.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
2020-09-09 07:31:56 DEBUG   127.0.0.1       sql=SELECT COUNT(dbt.rowid) as nb FROM llx_product as dbt WHERE dbt.rowid IN (1525) AND dbt.entity IN (1)
2020-09-09 07:31:56 DEBUG   127.0.0.1       sql=SELECT COUNT(dbt.rowid) as nb FROM llx_product as dbt WHERE dbt.rowid IN (1525) AND dbt.entity IN (1)
2020-09-09 07:31:56 INFO    127.0.0.1       Product::fetch id=1525 ref= ref_ext=
2020-09-09 07:31:56 DEBUG   127.0.0.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_buy_intra, accountancy_code_buy_export, 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 llx_product WHERE rowid = 1525
2020-09-09 07:31:56 DEBUG   127.0.0.1       sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'product' ORDER BY pos
2020-09-09 07:31:56 DEBUG   127.0.0.1       sql=SELECT rowid, expired, restock_date, stock, main_supplier_codename, postnord, schenker, sello_id, sello_desc_sv, sello_tosell, sello_label_sv, ms_ref, jv_ref, jo_ref, sh_ref, csn_ref, va_ref, nt_ref, pricedate_fiskekroken, pricedate_intersport, market_survey_description, price_intersport, price_fiskekroken, market_survey_date, alternative1, alternative2, picture_url, product_url, original, script_created, ean, label_en FROM llx_product_extrafields WHERE fk_object = 1525
2020-09-09 07:31:56 DEBUG   127.0.0.1       sql=SELECT price, price_ttc, price_min, price_min_ttc, price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly FROM llx_product_price WHERE entity IN (1) AND price_level=1 AND fk_product = 1525 ORDER BY date_price DESC, rowid DESC LIMIT 1
2020-09-09 07:31:56 DEBUG   127.0.0.1       sql=SELECT price, price_ttc, price_min, price_min_ttc, price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly FROM llx_product_price WHERE entity IN (1) AND price_level=2 AND fk_product = 1525 ORDER BY date_price DESC, rowid DESC LIMIT 1
2020-09-09 07:31:56 DEBUG   127.0.0.1       sql=SELECT rowid, fk_product_parent, fk_product_child, variation_price, variation_price_percentage, variation_weight FROM llx_product_attribute_combination WHERE fk_product_parent = 1525 AND entity IN (1)
2020-09-09 07:31:56 DEBUG   127.0.0.1       sql=SELECT rowid, fk_product_parent, fk_product_child, variation_price, variation_price_percentage, variation_weight FROM llx_product_attribute_combination WHERE rowid = 4 AND entity IN (1)
2020-09-09 07:31:56 DEBUG   127.0.0.1       sql=SELECT
        c.rowid,
        c2v.fk_prod_attr_val,
        c2v.fk_prod_attr,
        c2v.fk_prod_combination
        FROM llx_product_attribute c LEFT JOIN llx_product_attribute_combination2val c2v ON c.rowid = c2v.fk_prod_attr
        WHERE c2v.fk_prod_combination = 4 ORDER BY c.rang ASC
2020-09-09 07:31:56 DEBUG   127.0.0.1       HookManager::initHooks Loading hooks: context=toprightmenu-path=/removeconf/class/actions_removeconf.class.php
2020-09-09 07:31:56 DEBUG   127.0.0.1       HookManager::initHooks Loading hooks: context=searchform-path=/removeconf/class/actions_removeconf.class.php, context=leftblock-path=/removeconf/class/actions_removeconf.class.php
2020-09-09 07:31:56 DEBUG   127.0.0.1       sql=SHOW server_version
2020-09-09 07:31:56 DEBUG   127.0.0.1       sql=SELECT COUNT(pa.rowid) as nb FROM llx_product_association as pa WHERE pa.fk_product_fils = 1525 OR pa.fk_product_pere = 1525
2020-09-09 07:31:56 DEBUG   127.0.0.1       sql=SELECT rowid, fk_product_parent, fk_product_child, variation_price, variation_price_percentage, variation_weight FROM llx_product_attribute_combination WHERE fk_product_child = 1525 AND entity IN (1)
2020-09-09 07:31:56 DEBUG   127.0.0.1       sql=SELECT count(rowid) as nb FROM llx_product_attribute_combination WHERE fk_product_parent = 1525 AND entity IN (1)
2020-09-09 07:31:56 INFO    127.0.0.1       files.lib.php::dol_dir_list path=/var/lib/dolibarr-production/documents/produit/JV-Giant_Fathom_29_2_Pure_Red_Crest types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$"
2020-09-09 07:31:56 DEBUG   127.0.0.1       HookManager::initHooks Loading hooks: context=fileslib-path=/removeconf/class/actions_removeconf.class.php
2020-09-09 07:31:56 DEBUG   127.0.0.1       sql=SELECT COUNT(rowid) as nb FROM llx_links WHERE objecttype = 'product' AND objectid = 1525 AND entity = 1
2020-09-09 07:31:56 DEBUG   127.0.0.1       sql=SELECT MAX(te.ref) FROM llx_product as te WHERE te.ref < 'JV-Giant_Fathom_29_2_Pure_Red_Crest' AND  fk_product_type = 0 AND te.entity IN (1)
2020-09-09 07:31:56 DEBUG   127.0.0.1       sql=SELECT MIN(te.ref) FROM llx_product as te WHERE te.ref > 'JV-Giant_Fathom_29_2_Pure_Red_Crest' AND  fk_product_type = 0 AND te.entity IN (1)
2020-09-09 07:31:56 DEBUG   127.0.0.1       sql=SELECT rowid, ref, label, rang FROM llx_product_attribute WHERE rowid = 1 AND entity IN (1)
2020-09-09 07:31:56 DEBUG   127.0.0.1       sql=SELECT rowid, fk_product_attribute, ref, value FROM llx_product_attribute_value WHERE rowid = 1 AND entity IN (1)
2020-09-09 07:31:56 INFO    127.0.0.1       --- End access to /variants/combinations.php
2020-09-09 07:32:29 DEBUG   127.0.0.1       - This is an already logged session. _SESSION['dol_login']=egils _SESSION['dol_entity']=1
2020-09-09 07:32:29 DEBUG   127.0.0.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_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 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 IN (0, 1) AND u.login = 'egils' ORDER BY u.entity ASC
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1)
2020-09-09 07:32:29 DEBUG   127.0.0.1       HookManager::initHooks Loading hooks: context=main-path=/removeconf/class/actions_removeconf.class.php
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_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-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT DISTINCT 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 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-09-09 07:32:29 INFO    127.0.0.1       --- Access to /variants/combinations.php - action=update, massaction=
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='en_US' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC
2020-09-09 07:32:29 DEBUG   127.0.0.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
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT COUNT(dbt.rowid) as nb FROM llx_product as dbt WHERE dbt.rowid IN (1525) AND dbt.entity IN (1)
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT COUNT(dbt.rowid) as nb FROM llx_product as dbt WHERE dbt.rowid IN (1525) AND dbt.entity IN (1)
2020-09-09 07:32:29 INFO    127.0.0.1       Product::fetch id=1525 ref= ref_ext=
2020-09-09 07:32:29 DEBUG   127.0.0.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_buy_intra, accountancy_code_buy_export, 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 llx_product WHERE rowid = 1525
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'product' ORDER BY pos
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT rowid, expired, restock_date, stock, main_supplier_codename, postnord, schenker, sello_id, sello_desc_sv, sello_tosell, sello_label_sv, ms_ref, jv_ref, jo_ref, sh_ref, csn_ref, va_ref, nt_ref, pricedate_fiskekroken, pricedate_intersport, market_survey_description, price_intersport, price_fiskekroken, market_survey_date, alternative1, alternative2, picture_url, product_url, original, script_created, ean, label_en FROM llx_product_extrafields WHERE fk_object = 1525
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT price, price_ttc, price_min, price_min_ttc, price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly FROM llx_product_price WHERE entity IN (1) AND price_level=1 AND fk_product = 1525 ORDER BY date_price DESC, rowid DESC LIMIT 1
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT price, price_ttc, price_min, price_min_ttc, price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly FROM llx_product_price WHERE entity IN (1) AND price_level=2 AND fk_product = 1525 ORDER BY date_price DESC, rowid DESC LIMIT 1
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT rowid, fk_product_parent, fk_product_child, variation_price, variation_price_percentage, variation_weight FROM llx_product_attribute_combination WHERE rowid = 4 AND entity IN (1)
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=UPDATE llx_product_attribute_combination
        SET fk_product_parent = 1525, fk_product_child = 1529,
        variation_price = 0, variation_price_percentage = 0,
        variation_weight = 0 WHERE rowid = 4
2020-09-09 07:32:29 INFO    127.0.0.1       Product::fetch id=1525 ref= ref_ext=
2020-09-09 07:32:29 DEBUG   127.0.0.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_buy_intra, accountancy_code_buy_export, 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 llx_product WHERE rowid = 1525
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT rowid, expired, restock_date, stock, main_supplier_codename, postnord, schenker, sello_id, sello_desc_sv, sello_tosell, sello_label_sv, ms_ref, jv_ref, jo_ref, sh_ref, csn_ref, va_ref, nt_ref, pricedate_fiskekroken, pricedate_intersport, market_survey_description, price_intersport, price_fiskekroken, market_survey_date, alternative1, alternative2, picture_url, product_url, original, script_created, ean, label_en FROM llx_product_extrafields WHERE fk_object = 1525
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT price, price_ttc, price_min, price_min_ttc, price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly FROM llx_product_price WHERE entity IN (1) AND price_level=1 AND fk_product = 1525 ORDER BY date_price DESC, rowid DESC LIMIT 1
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT price, price_ttc, price_min, price_min_ttc, price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly FROM llx_product_price WHERE entity IN (1) AND price_level=2 AND fk_product = 1525 ORDER BY date_price DESC, rowid DESC LIMIT 1
2020-09-09 07:32:29 DEBUG   127.0.0.1       BEGIN Transaction
2020-09-09 07:32:29 INFO    127.0.0.1        Product::fetch id=1529 ref= ref_ext=
2020-09-09 07:32:29 DEBUG   127.0.0.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_buy_intra, accountancy_code_buy_export, 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 llx_product WHERE rowid = 1529
2020-09-09 07:32:29 DEBUG   127.0.0.1        sql=SELECT rowid, expired, restock_date, stock, main_supplier_codename, postnord, schenker, sello_id, sello_desc_sv, sello_tosell, sello_label_sv, ms_ref, jv_ref, jo_ref, sh_ref, csn_ref, va_ref, nt_ref, pricedate_fiskekroken, pricedate_intersport, market_survey_description, price_intersport, price_fiskekroken, market_survey_date, alternative1, alternative2, picture_url, product_url, original, script_created, ean, label_en FROM llx_product_extrafields WHERE fk_object = 1529
2020-09-09 07:32:29 DEBUG   127.0.0.1        sql=SELECT price, price_ttc, price_min, price_min_ttc, price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly FROM llx_product_price WHERE entity IN (1) AND price_level=1 AND fk_product = 1529 ORDER BY date_price DESC, rowid DESC LIMIT 1
2020-09-09 07:32:29 DEBUG   127.0.0.1        sql=SELECT price, price_ttc, price_min, price_min_ttc, price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly FROM llx_product_price WHERE entity IN (1) AND price_level=2 AND fk_product = 1529 ORDER BY date_price DESC, rowid DESC LIMIT 1
2020-09-09 07:32:29 INFO    127.0.0.1         Product::fetch id=1529 ref= ref_ext=
2020-09-09 07:32:29 DEBUG   127.0.0.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_buy_intra, accountancy_code_buy_export, 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 llx_product WHERE rowid = 1529
2020-09-09 07:32:29 DEBUG   127.0.0.1         sql=SELECT rowid, expired, restock_date, stock, main_supplier_codename, postnord, schenker, sello_id, sello_desc_sv, sello_tosell, sello_label_sv, ms_ref, jv_ref, jo_ref, sh_ref, csn_ref, va_ref, nt_ref, pricedate_fiskekroken, pricedate_intersport, market_survey_description, price_intersport, price_fiskekroken, market_survey_date, alternative1, alternative2, picture_url, product_url, original, script_created, ean, label_en FROM llx_product_extrafields WHERE fk_object = 1529
2020-09-09 07:32:29 DEBUG   127.0.0.1         sql=SELECT price, price_ttc, price_min, price_min_ttc, price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly FROM llx_product_price WHERE entity IN (1) AND price_level=1 AND fk_product = 1529 ORDER BY date_price DESC, rowid DESC LIMIT 1
2020-09-09 07:32:29 DEBUG   127.0.0.1         sql=SELECT price, price_ttc, price_min, price_min_ttc, price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly FROM llx_product_price WHERE entity IN (1) AND price_level=2 AND fk_product = 1529 ORDER BY date_price DESC, rowid DESC LIMIT 1
2020-09-09 07:32:29 DEBUG   127.0.0.1         Product::update
2020-09-09 07:32:29 DEBUG   127.0.0.1         sql=UPDATE llx_product SET label = 'Giant Fathom 29 2 Pure Red Crest (Giant) Large', ref = '2001068406', ref_ext = null, default_vat_code = null, tva_tx = 25.000, recuperableonly = 0, localtax1_tx = 0.000, localtax2_tx = 0.000, localtax1_type = '0', localtax2_type = '0', barcode = null, fk_barcode_type = null, tosell = 1, tobuy = 1, tobatch = 0, finished = null, net_measure = null, net_measure_units = null, weight = null, weight_units = '0', length = null, length_units = '0', width= null, width_units = '0', height = null, height_units = '0', surface = null, surface_units = '0', volume = null, volume_units = '0', fk_default_warehouse = null, seuil_stock_alerte = 0, description = '<strong>Storlek:</strong> (Giant) Large', url = null, customcode = '', fk_country = null, note = '', duration = '', accountancy_code_buy = '4000', accountancy_code_buy_intra = '4535', accountancy_code_buy_export = '4545', accountancy_code_sell= '3000', accountancy_code_sell_intra= '3000', accountancy_code_sell_export= '3000', desiredstock = 0, cost_price = null, fk_unit= NULL, price_autogen = 0, fk_price_expression = NULL, fk_user_modif = 1 WHERE rowid = 1529
2020-09-09 07:32:29 DEBUG   127.0.0.1         sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'product' ORDER BY pos
2020-09-09 07:32:29 DEBUG   127.0.0.1          Product::insertExtraFields delete then insert
2020-09-09 07:32:29 DEBUG   127.0.0.1          sql=DELETE FROM llx_product_extrafields WHERE fk_object = 1529
2020-09-09 07:32:29 DEBUG   127.0.0.1          sql=INSERT INTO llx_product_extrafields (fk_object,expired,restock_date,stock,main_supplier_codename,postnord,schenker,sello_id,sello_desc_sv,sello_tosell,sello_label_sv,ms_ref,jv_ref,jo_ref,sh_ref,csn_ref,va_ref,nt_ref,pricedate_fiskekroken,pricedate_intersport,market_survey_description,price_intersport,price_fiskekroken,market_survey_date,alternative1,alternative2,picture_url,product_url,original,script_created,ean,label_en) VALUES (1529,null,null,null,'JV',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null)
2020-09-09 07:32:29 DEBUG   127.0.0.1         sql=SELECT rowid, fk_product_parent, fk_product_child, variation_price, variation_price_percentage, variation_weight FROM llx_product_attribute_combination WHERE fk_product_parent = 1529 AND entity IN (1)
2020-09-09 07:32:29 INFO    127.0.0.1        Product::update_price id=1529 newprice=0 newpricebase= newminprice=0.00000000 level=1 npr=0 newdefaultvatcode=
2020-09-09 07:32:29 INFO    127.0.0.1        get_localtax tva=25.000 local=1 thirdparty_buyer id=/country_code= thirdparty_seller id=0/country_code=SE thirdparty_seller localtax1_assuj=0  thirdparty_seller localtax2_assuj=0
2020-09-09 07:32:29 INFO    127.0.0.1        get_localtax tva=25.000 local=2 thirdparty_buyer id=/country_code= thirdparty_seller id=0/country_code=SE thirdparty_seller localtax1_assuj=0  thirdparty_seller localtax2_assuj=0
2020-09-09 07:32:29 DEBUG   127.0.0.1         Product::update_price
2020-09-09 07:32:29 DEBUG   127.0.0.1         sql=UPDATE llx_product SET price_base_type='', price=0, price_ttc=0, price_min=0, price_min_ttc=0, localtax1_tx=0, localtax2_tx=0, localtax1_type='0', localtax2_type='0', default_vat_code=null, tva_tx='25', recuperableonly='0' WHERE rowid = 1529
2020-09-09 07:32:29 DEBUG   127.0.0.1         Product::_log_price
2020-09-09 07:32:29 DEBUG   127.0.0.1         sql=INSERT INTO llx_product_price(price_level,date_price, fk_product, fk_user_author, price, price_ttc, price_base_type,tosell, tva_tx, default_vat_code, recuperableonly, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, price_min,price_min_ttc,price_by_qty,entity,fk_price_expression)  VALUES(1, '2020-09-09 07:32:29',1529,1,0,0,'',1,25.000, null,0, 0, 0, '0', '0', 0,0,0,1,null)
2020-09-09 07:32:29 DEBUG   127.0.0.1       COMMIT Transaction
2020-09-09 07:32:29 INFO    127.0.0.1       --- End access to /variants/combinations.php
2020-09-09 07:32:29 DEBUG   127.0.0.1       - This is an already logged session. _SESSION['dol_login']=egils _SESSION['dol_entity']=1
2020-09-09 07:32:29 DEBUG   127.0.0.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_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 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 IN (0, 1) AND u.login = 'egils' ORDER BY u.entity ASC
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1)
2020-09-09 07:32:29 DEBUG   127.0.0.1       HookManager::initHooks Loading hooks: context=main-path=/removeconf/class/actions_removeconf.class.php
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_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-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT DISTINCT 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 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-09-09 07:32:29 INFO    127.0.0.1       --- Access to /variants/combinations.php - action=, massaction=
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='en_US' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC
2020-09-09 07:32:29 DEBUG   127.0.0.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
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT COUNT(dbt.rowid) as nb FROM llx_product as dbt WHERE dbt.rowid IN (1525) AND dbt.entity IN (1)
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT COUNT(dbt.rowid) as nb FROM llx_product as dbt WHERE dbt.rowid IN (1525) AND dbt.entity IN (1)
2020-09-09 07:32:29 INFO    127.0.0.1       Product::fetch id=1525 ref= ref_ext=
2020-09-09 07:32:29 DEBUG   127.0.0.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_buy_intra, accountancy_code_buy_export, 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 llx_product WHERE rowid = 1525
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'product' ORDER BY pos
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT rowid, expired, restock_date, stock, main_supplier_codename, postnord, schenker, sello_id, sello_desc_sv, sello_tosell, sello_label_sv, ms_ref, jv_ref, jo_ref, sh_ref, csn_ref, va_ref, nt_ref, pricedate_fiskekroken, pricedate_intersport, market_survey_description, price_intersport, price_fiskekroken, market_survey_date, alternative1, alternative2, picture_url, product_url, original, script_created, ean, label_en FROM llx_product_extrafields WHERE fk_object = 1525
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT price, price_ttc, price_min, price_min_ttc, price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly FROM llx_product_price WHERE entity IN (1) AND price_level=1 AND fk_product = 1525 ORDER BY date_price DESC, rowid DESC LIMIT 1
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT price, price_ttc, price_min, price_min_ttc, price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly FROM llx_product_price WHERE entity IN (1) AND price_level=2 AND fk_product = 1525 ORDER BY date_price DESC, rowid DESC LIMIT 1
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT rowid, fk_product_parent, fk_product_child, variation_price, variation_price_percentage, variation_weight FROM llx_product_attribute_combination WHERE fk_product_parent = 1525 AND entity IN (1)
2020-09-09 07:32:29 DEBUG   127.0.0.1       HookManager::initHooks Loading hooks: context=toprightmenu-path=/removeconf/class/actions_removeconf.class.php
2020-09-09 07:32:29 DEBUG   127.0.0.1       HookManager::initHooks Loading hooks: context=searchform-path=/removeconf/class/actions_removeconf.class.php, context=leftblock-path=/removeconf/class/actions_removeconf.class.php
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SHOW server_version
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT COUNT(pa.rowid) as nb FROM llx_product_association as pa WHERE pa.fk_product_fils = 1525 OR pa.fk_product_pere = 1525
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT rowid, fk_product_parent, fk_product_child, variation_price, variation_price_percentage, variation_weight FROM llx_product_attribute_combination WHERE fk_product_child = 1525 AND entity IN (1)
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT count(rowid) as nb FROM llx_product_attribute_combination WHERE fk_product_parent = 1525 AND entity IN (1)
2020-09-09 07:32:29 INFO    127.0.0.1       files.lib.php::dol_dir_list path=/var/lib/dolibarr-production/documents/produit/JV-Giant_Fathom_29_2_Pure_Red_Crest types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$"
2020-09-09 07:32:29 DEBUG   127.0.0.1       HookManager::initHooks Loading hooks: context=fileslib-path=/removeconf/class/actions_removeconf.class.php
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT COUNT(rowid) as nb FROM llx_links WHERE objecttype = 'product' AND objectid = 1525 AND entity = 1
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT MAX(te.ref) FROM llx_product as te WHERE te.ref < 'JV-Giant_Fathom_29_2_Pure_Red_Crest' AND  fk_product_type = 0 AND te.entity IN (1)
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT MIN(te.ref) FROM llx_product as te WHERE te.ref > 'JV-Giant_Fathom_29_2_Pure_Red_Crest' AND  fk_product_type = 0 AND te.entity IN (1)
2020-09-09 07:32:29 INFO    127.0.0.1       Product::fetch id=1529 ref= ref_ext=
2020-09-09 07:32:29 DEBUG   127.0.0.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_buy_intra, accountancy_code_buy_export, 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 llx_product WHERE rowid = 1529
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT rowid, expired, restock_date, stock, main_supplier_codename, postnord, schenker, sello_id, sello_desc_sv, sello_tosell, sello_label_sv, ms_ref, jv_ref, jo_ref, sh_ref, csn_ref, va_ref, nt_ref, pricedate_fiskekroken, pricedate_intersport, market_survey_description, price_intersport, price_fiskekroken, market_survey_date, alternative1, alternative2, picture_url, product_url, original, script_created, ean, label_en FROM llx_product_extrafields WHERE fk_object = 1529
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT price, price_ttc, price_min, price_min_ttc, price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly FROM llx_product_price WHERE entity IN (1) AND price_level=1 AND fk_product = 1529 ORDER BY date_price DESC, rowid DESC LIMIT 1
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT price, price_ttc, price_min, price_min_ttc, price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly FROM llx_product_price WHERE entity IN (1) AND price_level=2 AND fk_product = 1529 ORDER BY date_price DESC, rowid DESC LIMIT 1
2020-09-09 07:32:29 INFO    127.0.0.1       files.lib.php::dol_dir_list path=/var/lib/dolibarr-production/documents/produit/2001068406/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$"
2020-09-09 07:32:29 DEBUG   127.0.0.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 llx_ecm_files WHERE filepath = 'produit/2001068406' AND entity = 1
2020-09-09 07:32:29 DEBUG   127.0.0.1       HookManager::initHooks Loading hooks: context=productdao-path=/removeconf/class/actions_removeconf.class.php
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT
        c.rowid,
        c2v.fk_prod_attr_val,
        c2v.fk_prod_attr,
        c2v.fk_prod_combination
        FROM llx_product_attribute c LEFT JOIN llx_product_attribute_combination2val c2v ON c.rowid = c2v.fk_prod_attr
        WHERE c2v.fk_prod_combination = 4 ORDER BY c.rang ASC
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT rowid, ref, label, rang FROM llx_product_attribute WHERE rowid = 1 AND entity IN (1)
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT rowid, fk_product_attribute, ref, value FROM llx_product_attribute_value WHERE rowid = 1 AND entity IN (1)
2020-09-09 07:32:29 DEBUG   127.0.0.1       CUnits::fetchAll
2020-09-09 07:32:29 DEBUG   127.0.0.1       sql=SELECT t.rowid, t.code, t.label, t.short_label, t.unit_type, t.scale, t.active FROM llx_c_units as t WHERE (t.scale=0 AND t.unit_type = 'weight' AND t.active=1)
2020-09-09 07:32:29 INFO    127.0.0.1       --- End access to /variants/combinations.php
github-actions[bot] commented 3 years ago

This issue is stale because it has been open 1 year with no activity. If this is a bug, please comment to confirm it is still present on latest stable version. if this is a feature request, please comment to notify the request is still relevant and not yet covered by latest stable version. This issue may be closed automatically by stale bot in 10 days (you should still be able to re-open it if required).