Hello,
When I am trying to associate a product to a supplier I receive the following error:
Unknown column ‘unitcharges’ in ‘field list’ sql=UPDATE llx_product_fournisseur_price SET fk_user = 1 , ref_fourn = ‘test001’, price = 2, quantity = 1, remise_percent = 1, remise = 0, unitprice = 2, unitcharges = 0, fk_availability = 0, entity = 1, tva_tx = 0, default_vat_code=null, info_bits = 0, charges = 0, delivery_time_days = 30, supplier_reputation = NULL WHERE rowid = 18
Also:
Supplier prices (1)
Dolibarr has detected a technical error.
This information can be useful for diagnostic purposes (you can set option $dolibarr_main_prod to ‘1’ to remove such notices):
Date: 20200805121112
Dolibarr: 7.0.5
Level of features: 0
PHP: 7.0.33
Server: LiteSpeed
OS: Linux server62.romania-webhosting.com 3.10.0-962.3.2.lve1.5.27.el7.x86_64 #1 SMP Sat Nov 30 02:18:52 EST 2019 x86_64
UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.105 Safari/537.36
Requested URL: /dolibarr/htdocs/product/fournisseurs.php?id=961
Referer: http://erp.allengra.eu/dolibarr/htdocs/product/fournisseurs.php?id=961&action=add_price
Menu manager: auguria_menu.php
Database type manager: mysqli
Latest database access request error: SELECT s.nom as supplier_name, s.rowid as fourn_id, pfp.rowid as product_fourn_pri_id, pfp.ref_fourn, pfp.fk_product as product_fourn_id, pfp.fk_supplier_price_expression, pfp.price, pfp.quantity, pfp.unitprice, pfp.remise_percent, pfp.remise, pfp.tva_tx, pfp.fk_availability, pfp.charges, pfp.unitcharges, pfp.info_bits, pfp.delivery_time_days, pfp.supplier_reputation FROM llx_product_fournisseur_price as pfp, llx_societe as s WHERE pfp.entity IN (1) AND pfp.fk_soc = s.rowid AND s.status=1 AND pfp.fk_product = 961 ORDER BY s.nom ASC
Return code for latest database access request error: DB_ERROR_NOSUCHFIELD
Information for latest database access request error: Unknown column ‘pfp.unitcharges’ in ‘field list’
Thank you very much!
