Manufacturer Links Fatal Error

Hi

I am newbie just want to start my store with opencart versin 2.3.0.2.

I dont know when the issue strating, when I go to manufacturer pages, then click the brand name, I got this error.


Fatal error: 'Error: Unknown column 'cp.level' in 'where clause'
Error No: 1054
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.level >=0 AND p.manufacturer_id = '110''
in /home/glodoku/public_html/store/system/library/db/mysqli.php:40
Stack trace:
#0 system/storage/modification/system/library/db.php(30): DB\MySQLi->query('SELECT COUNT(DI...', Array)
#1 vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php(631): DB->query('SELECT COUNT(DI...')
#2 [internal function]: ModelCatalogProduct->getTotalProducts(Array)
#3 vqmod/vqcache/vq2-system_storage_modification_system_engine_loader.php(200): call_user_func_array(Array, Array)
#4 [internal function]: Loader->{closure}(Array, Array)
#5 system/engine/proxy.php(25): call_user_func_array(Object(Closure), Array)
#6 vqmod/vqcache/vq2-system_storage_modification_catalog_controller_product_manufacturer.php(201): Proxy->__call('getTotalProduct...', Array)
#7 vqmod/vqcache/vq2-system_storage_modification_catalog_controller_product_manufacturer.php(201): Proxy->getTotalProducts(Array)
#8 [internal function]: ControllerProductManufacturer->info()
#9 vqmod/vqcache/vq2-system_storage_modification_system_engine_action.php(51): call_user_func_array(Array, Array)
#10 catalog/controller/startup/router.php(25): Action->execute(Object(Registry))
#11 [internal function]: ControllerStartupRouter->index()
#12 vqmod/vqcache/vq2-system_storage_modification_system_engine_action.php(51): call_user_func_array(Array, Array)
#13 system/storage/modification/system/engine/front.php(37): Action->execute(Object(Registry))
#14 system/storage/modification/system/engine/front.php(32): Front->execute(Object(Action))
#15 system/framework.php(103): Front->dispatch(Object(Action), Object(Action))
#16 vqmod/vqcache/vq2-system_startup.php(124): require_once('/home/glodoku/p...')
#17 index.php(25): start('catalog')
#18 {main}

I try to restore database of manufacturer only but error still persist.

Anyone can help me pelase?

Regrads
Joseph

Hello,
You installed an extension that causes this.
I'd say uninstall it and verify it was created for your exact oc version and if so, contact the developer.

josephwsa wrote:
Fatal error: 'Error: Unknown column 'cp.level' in 'where clause'
Error No: 1054
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.level >=0 AND p.manufacturer_id = '110''

Did you make customize query?
Why your query use cp.level >= 0?
Try delete cp.level >= 0

Yes I install several modul, but I dont know which one cause this.

Should I disabled or modul and then test it one by one?

That's a good way.
Don't forget to refresh ocmod cache after each extension change! admin>extensions>modifications top right blue button.