When trying to search for anything, or even showing a list of products etc, the following sql error is shown on v3.9.0 - this never happened on 3.8.0>3.8.4
Can anybody help? this breaks my whole daily function of searching products.
Error Message
Return code for last database access in error: DB_ERROR_NOSUCHFIELD
Information for last database access in error: Unknown column ‘ef.priceinfo’ in ‘field list’
FULL ERROR:
Dolibarr has detected a technical error.
This is information that can help diagnostic:
Date: 20160314212026
Dolibarr: 3.9.0
Level of features: 0
PHP: 5.5.33
Server: Apache/2.4.18 (Unix)
OS: Linux web48.extendcp.co.uk 2.6.32-573.18.1.el6.x86_64 #1 SMP Wed Jan 6 11:20:49 EST 2016 x86_64
UserAgent: Mozilla/5.0 (Windows NT 10.0; rv:45.0) Gecko/20100101 Firefox/45.0
Requested Url: /workflow/product/list.php?leftmenu=product&type=0&idmenu=13308&mainmenu=products
Referer: http://domain.co.uk/workflow/product/card.php?id=696
Menu manager: auguria_menu.php
Database type manager: mysqli
Request for last database access in error: SELECT DISTINCT p.rowid, p.ref, p.label, p.barcode, p.price, p.price_ttc, p.price_base_type, p.entity, p.fk_product_type, p.duration, p.tosell, p.tobuy, p.seuil_stock_alerte, p.desiredstock, p.tobatch, p.accountancy_code_sell, p.accountancy_code_buy, p.datec as date_creation, p.tms as date_update, MIN(pfp.unitprice) as minsellprice,ef.priceinfo as options_priceinfo,ef.pricetag as options_pricetag,ef.pricefixed as options_pricefixed,ef.manuinfo as options_manuinfo,ef.manuname as options_manuname,ef.manumpn as options_manumpn,ef.manudist as options_manudist,ef.manurange as options_manurange,ef.bulkinfo as options_bulkinfo,ef.bqty as options_bqty,ef.bulkbarcode as options_bulkbarcode,ef.bulknotes as options_bulknotes,ef.partset as options_partset,ef.partsetprice as options_partsetprice,ef.partsetpc as options_partsetpc,ef.ppinfo as options_ppinfo,ef.ppsku as options_ppsku,ef.ppprivate as options_ppprivate,ef.otherinfo as options_otherinfo FROM llx_product as p LEFT JOIN llx_product_extrafields as ef on (p.rowid = ef.fk_object) LEFT JOIN llx_product_fournisseur_price as pfp ON p.rowid = pfp.fk_product WHERE p.entity IN (1) AND p.fk_product_type <> ‘1’ GROUP BY p.rowid, p.ref, p.label, p.barcode, p.price, p.price_ttc, p.price_base_type, p.fk_product_type, p.duration, p.tosell, p.tobuy, p.seuil_stock_alerte, p.desiredstock, p.datec, p.tms,ef.priceinfo,ef.pricetag,ef.pricefixed,ef.manuinfo,ef.manuname,ef.manumpn,ef.manudist,ef.manurange,ef.bulkinfo,ef.bqty,ef.bulkbarcode,ef.bulknotes,ef.partset,ef.partsetprice,ef.partsetpc,ef.ppinfo,ef.ppsku,ef.ppprivate,ef.otherinfo ORDER BY p.ref ASC LIMIT 76
Return code for last database access in error: DB_ERROR_NOSUCHFIELD
Information for last database access in error: Unknown column ‘ef.priceinfo’ in ‘field list’
