Post by josephwsa » Fri Oct 28, 2016 7:24 am

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

Newbie

Posts

Joined
Mon Oct 17, 2016 9:18 pm

Post by artcore » Fri Oct 28, 2016 3:33 pm

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.

Attn: I no longer provide OpenCart extensions, nor future support - this includes forum posts.
Reason: OpenCart version 3+ ;D

Thanks!


User avatar
Active Member

Posts

Joined
Tue Jul 09, 2013 4:13 am
Location - The Netherlands

Post by opencartboost » Fri Oct 28, 2016 3:34 pm

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

Active Member

Posts

Joined
Thu Jul 09, 2015 5:59 am

Post by josephwsa » Fri Oct 28, 2016 6:59 pm

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?

Newbie

Posts

Joined
Mon Oct 17, 2016 9:18 pm

Post by artcore » Fri Oct 28, 2016 7:16 pm

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

Attn: I no longer provide OpenCart extensions, nor future support - this includes forum posts.
Reason: OpenCart version 3+ ;D

Thanks!


User avatar
Active Member

Posts

Joined
Tue Jul 09, 2013 4:13 am
Location - The Netherlands
Who is online

Users browsing this forum: No registered users and 29 guests