Manufacturer Link Error

ThemeBurn SupportForumsOpenCart ThemesTechnopolis OpenCart ThemeManufacturer Link Error

This topic has been marked as resolved.

Hi

I got issue likes bellow when click manufacturers/brands link:

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 =0 AND p.manufacturer_id = ’40”
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(203): 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(23): start(‘catalog’)
#18 {main}

Please help me

Thanks
Joseph

[hidepost]
http://glodok.us/store/index.php?route=product/manufacturer#S

October 21, 2016 at 1:19 pm #52357

Can you please change to the default OpenCart theme, and then try to open manufacturer/brand to see if the same error occurs ?

Regards,
ThemeBurn team

October 21, 2016 at 4:00 pm #52362

Themeburn or default themes return with error.

What your suggestion?

October 21, 2016 at 7:42 pm #52383

Hi,

Since the error is appearing when using the default theme too, then it should not be there related. You can try to disable theme modification in Admin > Extensions to find out if a specific ocmod can be the problem.

BR,
ThemeBurn team

October 27, 2016 at 12:25 am #52538

I just see this post, and I check my manufacture link. The link is doesn’t work, but no errors. How I can resolve this?

October 27, 2016 at 10:55 am #52542

Solved, the manufacturer link error caused by one of my modul.

@Thexwarrior
Have you choose the brand on product admin?
Also check it on default theme.

October 28, 2016 at 2:04 pm #52617

@thexwarrior

We’ve checked your website and all brand links seem to work fine. Can you please confirm?

BR,
ThemeBurn team

October 30, 2016 at 9:38 pm #52671

This happened after update
on the simple theme of all the works as well on your template does not work now ??

Fatal error: ‘The event “viewSlot:products_listing.product” has no “product_settings_context” parameter.’
in /home/seogro00/big-market.com.ua/www/system/vendor/BurnEngine/library/vendor/sfEvent.php:137
Stack trace:
#0 system/vendor/BurnEngine/catalog/plugin/ProductPlugin.php(380): sfEvent->offsetGet(‘product_setting…’)
#1 system/vendor/BurnEngine/library/vendor/sfEventDispatcher.php(76): Theme_Catalog_ProductPlugin->productListingLayout(Object(TB_ViewSlotEvent))
#2 system/vendor/BurnEngine/library/ViewSlot.php(127): sfEventDispatcher->notify(Object(TB_ViewSlotEvent))
#3 system/vendor/BurnEngine/library/ViewDataBag.php(198): TB_ViewSlot->stop(false, false)
#4 system/vendor/BurnEngine/library/ViewDataBag.php(219): TB_ViewDataBag->slotStop(false)
#5 system/storage/modification/catalog/view/theme/BurnEngine/template/product/manufacturer_info.tpl(155): TB_ViewDataBag->slotStopEcho()
#6 vqmod/vqcache/vq2-system_storage_modification_system_engine_loader.php(110): require(‘/home/seogro00/…’)
#7 system/storage/modification/catalog/controller/product/manufacturer.php(536): Loader->view(‘BurnEngine/temp…’, Array)
#8 [internal function]: ControllerProductManufacturer->info(Array)
#9 vqmod/vqcache/vq2-system_storage_modification_system_engine_action.php(46): call_user_func(Array, Array)
#10 vqmod/vqcache/vq2-system_storage_modification_system_engine_front.php(53): Action->execute(Object(Registry))
#11 vqmod/vqcache/vq2-system_storage_modification_system_engine_front.php(48): Front->execute(Object(Action))
#12 index.php(278): Front->dispatch(Object(Action), Object(Action))
#13 {main}
Fatal error: Call to a member function get() on a non-object in /home/seogro00/big-market.com.ua/www/index.php on line 101

  • This reply was modified 2723 days ago by  Vlad.
 Vlad
November 3, 2016 at 10:16 pm #52770

Hi,

Thanks for reporting this problem! We’ve attached a fix that will eliminate it. You need to extract the zip into your store root folder.

BR,
ThemeBurn team

November 3, 2016 at 11:15 pm #52772

Thank you very much, it helped.
Thank you.

 Vlad
November 4, 2016 at 12:14 am #52776

I have all manufacturer links show error. Also it not show manufacturer logos homepage.

  • This reply was modified 2721 days ago by  abc015.
 abc015
November 6, 2016 at 12:48 pm #52829

TB Support, thanks for fix.

November 6, 2016 at 7:23 pm #52834

@abc015

The fix is attached in our previous reply here:

http://support.themeburn.com/topic/manufacturer-link-error/#post-52772

BR,
ThemeBurn team

November 8, 2016 at 10:15 pm #52890
Viewing 13 posts - 1 through 13 (of 13 total)
  • You must be logged in to reply to this topic.