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
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.
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+
Thanks!
Did you make customize query?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''
Why your query use cp.level >= 0?
Try delete cp.level >= 0
That's a good way.
Don't forget to refresh ocmod cache after each extension change! admin>extensions>modifications top right blue button.
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+
Thanks!
Who is online
Users browsing this forum: Semrush [Bot] and 18 guests