[Skip to main content](#vessel-content) # Error in category view after upgrading to 2.3.5 ## - **[Kees](/forum/user/34087-kees "View Kees's Profile")** - [![Kees's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34087-kees "View Kees's Profile") Topic Author - [ Offline](/forum/user/34087-kees) Less More - Posts: 6 - Thank you received: 0 - - 11 years 9 months ago - 11 years 9 months ago [\#187199](#187199) by [Kees](/forum/user/34087-kees "View Kees's Profile") *[Error in category view after upgrading to 2.3.5](/forum/25-install-update/874337-error-in-category-view-after-upgrading-to-2-3-5#187199 "-- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3 Hello, After upgrading Hikashop from 2.3.3 to 2.3.5 (on a test-site) the category view and the product view gives the error: Fatal error: Call to undefined method RuntimeException::get() in /..../libraries/legacy/error/error.php on line 533 Linking to 1 product gives no error. I've searched the forum and via Google but do not see this message / error at after upgrading to 2.3.5 In which direction should I look for the solution Thanks")* was created by *[Kees](/forum/user/34087-kees "View Kees's Profile")* -- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3 Hello, After upgrading Hikashop from 2.3.3 to 2.3.5 (on a test-site) the category view and the product view gives the error: Fatal error: Call to undefined method RuntimeException::get() in /..../libraries/legacy/error/error.php on line 533 Linking to 1 product gives no error. I've searched the forum and via Google but do not see this message / error at after upgrading to 2.3.5 In which direction should I look for the solution Thanks Last edit: 11 years 9 months ago by [Kees](/forum/user/34087-kees "View Kees's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3NDMzNy1lcnJvci1pbi1jYXRlZ29yeS12aWV3LWFmdGVyLXVwZ3JhZGluZy10by0yLTMtNT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 11 years 9 months ago [\#187218](#187218) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Error in category view after upgrading to 2.3.5](/forum/25-install-update/874337-error-in-category-view-after-upgrading-to-2-3-5#187218 "-- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3 Hello, After upgrading Hikashop from 2.3.3 to 2.3.5 (on a test-site) the category view and the product view gives the error: Fatal error: Call to undefined method RuntimeException::get() in /..../libraries/legacy/error/error.php on line 533 Linking to 1 product gives no error. I've searched the forum and via Google but do not see this message / error at after upgrading to 2.3.5 In which direction should I look for the solution Thanks")* Hi, The fatal error you got is not coming from HikaShop but from Joomla. It will be interesting to got the call stack to know why the Joomla error system is called. But about the fatal error ; it's not HikaShop. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3NDMzNy1lcnJvci1pbi1jYXRlZ29yeS12aWV3LWFmdGVyLXVwZ3JhZGluZy10by0yLTMtNT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[korzo](/forum/user/34428-korzo "View korzo's Profile")** - [![korzo's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar34428.png)](/forum/user/34428-korzo "View korzo's Profile") - [ Offline](/forum/user/34428-korzo) Less More - Posts: 193 - Thank you received: 76 - - 11 years 9 months ago [\#187239](#187239) by [korzo](/forum/user/34428-korzo "View korzo's Profile") Replied by *[korzo](/forum/user/34428-korzo "View korzo's Profile")* on topic *[Error in category view after upgrading to 2.3.5](/forum/25-install-update/874337-error-in-category-view-after-upgrading-to-2-3-5#187239 "-- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3 Hello, After upgrading Hikashop from 2.3.3 to 2.3.5 (on a test-site) the category view and the product view gives the error: Fatal error: Call to undefined method RuntimeException::get() in /..../libraries/legacy/error/error.php on line 533 Linking to 1 product gives no error. I've searched the forum and via Google but do not see this message / error at after upgrading to 2.3.5 In which direction should I look for the solution Thanks")* 1. Append ?template=protostar to url of page giving this error and try to open it. (e.g. [ yoursite.com/category?template=protostar](http://yoursite.com/category?template=protostar)) I saw similar error coming from error.php of custom template. 2. If your test site is on localhost, [ enable](https://docs.joomla.org/Edit_PHP.INI_File_for_XDebug) [ xDebug](https://www.youtube.com/watch?v=SEcDhbPTZds) and you will get better error messages with call stack. 3. In the file libraries/legacy/error/error.php add following code right above line 533 Code: echo '<pre>';var_dump( debug_backtrace());die(); This will print call stack and you will be able to find out where this error is coming from. Don't forget to remove this code when you are done. The following user(s) said Thank You: [Jerome](/forum/user/80-jerome "View Jerome's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3NDMzNy1lcnJvci1pbi1jYXRlZ29yeS12aWV3LWFmdGVyLXVwZ3JhZGluZy10by0yLTMtNT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Kees](/forum/user/34087-kees "View Kees's Profile")** - [![Kees's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34087-kees "View Kees's Profile") Topic Author - [ Offline](/forum/user/34087-kees) Less More - Posts: 6 - Thank you received: 0 - - 11 years 9 months ago [\#187256](#187256) by [Kees](/forum/user/34087-kees "View Kees's Profile") Replied by *[Kees](/forum/user/34087-kees "View Kees's Profile")* on topic *[Error in category view after upgrading to 2.3.5](/forum/25-install-update/874337-error-in-category-view-after-upgrading-to-2-3-5#187256 "-- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3 Hello, After upgrading Hikashop from 2.3.3 to 2.3.5 (on a test-site) the category view and the product view gives the error: Fatal error: Call to undefined method RuntimeException::get() in /..../libraries/legacy/error/error.php on line 533 Linking to 1 product gives no error. I've searched the forum and via Google but do not see this message / error at after upgrading to 2.3.5 In which direction should I look for the solution Thanks")* Hello @Jerome The entire site is continuing well (with forum, events etc). Only the link to the HikaShop category view gives the error @Korzo The link to the category view is .../com_hikashop & view = category & layout = Listing & Itemid = 153 If I put it the Itemid on152, I get the correct categories... (.../com_hikashop & view = category & layout = Listing & Itemid = 152) If I choose one of the categories I get the same error message again I have echo '<pre>'; var_dump (debug_backtrace ()); that (); placed in the code as suggested and a part of the call stack: array(2) { [0]=> & Object (RuntimeException) # 690 (7) { ["message": protected] => string (301) "Unknown column 'a.product_name' in 'order clause' SQL = SELECT DISTINCT b. * FROM test_hikashop_product_category AS a LEFT JOIN test_hikashop_product AS b ON a.product_id = b.product_id WHERE b.product_published = 1 AND b. product_type = 'main' AND a.category_id IN (2) ORDER BY a.product_name ASC LIMIT 0, 20 ' I hope you can help me further with this information. Thanks! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3NDMzNy1lcnJvci1pbi1jYXRlZ29yeS12aWV3LWFmdGVyLXVwZ3JhZGluZy10by0yLTMtNT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[korzo](/forum/user/34428-korzo "View korzo's Profile")** - [![korzo's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar34428.png)](/forum/user/34428-korzo "View korzo's Profile") - [ Offline](/forum/user/34428-korzo) Less More - Posts: 193 - Thank you received: 76 - - 11 years 9 months ago [\#187265](#187265) by [korzo](/forum/user/34428-korzo "View korzo's Profile") Replied by *[korzo](/forum/user/34428-korzo "View korzo's Profile")* on topic *[Error in category view after upgrading to 2.3.5](/forum/25-install-update/874337-error-in-category-view-after-upgrading-to-2-3-5#187265 "-- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3 Hello, After upgrading Hikashop from 2.3.3 to 2.3.5 (on a test-site) the category view and the product view gives the error: Fatal error: Call to undefined method RuntimeException::get() in /..../libraries/legacy/error/error.php on line 533 Linking to 1 product gives no error. I've searched the forum and via Google but do not see this message / error at after upgrading to 2.3.5 In which direction should I look for the solution Thanks")* Could you copy/paste whole output? Also try this URL: index.php?option=com_hikashop&view=category&layout=listing&Itemid=153&template=protostar Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3NDMzNy1lcnJvci1pbi1jYXRlZ29yeS12aWV3LWFmdGVyLXVwZ3JhZGluZy10by0yLTMtNT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Kees](/forum/user/34087-kees "View Kees's Profile")** - [![Kees's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34087-kees "View Kees's Profile") Topic Author - [ Offline](/forum/user/34087-kees) Less More - Posts: 6 - Thank you received: 0 - - 11 years 9 months ago [\#187270](#187270) by [Kees](/forum/user/34087-kees "View Kees's Profile") Replied by *[Kees](/forum/user/34087-kees "View Kees's Profile")* on topic *[Error in category view after upgrading to 2.3.5](/forum/25-install-update/874337-error-in-category-view-after-upgrading-to-2-3-5#187270 "-- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3 Hello, After upgrading Hikashop from 2.3.3 to 2.3.5 (on a test-site) the category view and the product view gives the error: Fatal error: Call to undefined method RuntimeException::get() in /..../libraries/legacy/error/error.php on line 533 Linking to 1 product gives no error. I've searched the forum and via Google but do not see this message / error at after upgrading to 2.3.5 In which direction should I look for the solution Thanks")* Hi I had already changed the template but this has no effect (the error persists) The entire output is more than 2000 lines....The main error-message is: 1054 - Unknown column 'a.product_name' in 'order clause' SQL=SELECT DISTINCT b.* FROM test_hikashop_product_category AS a LEFT JOIN test_hikashop_product AS b ON a.product_id=b.product_id WHERE b.product_published=1 AND b.product_type = 'main' AND a.category_id IN (17) ORDER BY a.product_name ASC LIMIT 0, 20 Today I will make a full backup of the production site and perform the upgrade again. Further help is welcome Thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3NDMzNy1lcnJvci1pbi1jYXRlZ29yeS12aWV3LWFmdGVyLXVwZ3JhZGluZy10by0yLTMtNT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[speru](/forum/user/26914-speru "View speru's Profile")** - [![speru's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/26914-speru "View speru's Profile") - [ Offline](/forum/user/26914-speru) Less More - Posts: 20 - Thank you received: 1 - - - [](https://starwoodsystems.com/) - 11 years 9 months ago [\#187283](#187283) by [speru](/forum/user/26914-speru "View speru's Profile") Replied by *[speru](/forum/user/26914-speru "View speru's Profile")* on topic *[Error in category view after upgrading to 2.3.5](/forum/25-install-update/874337-error-in-category-view-after-upgrading-to-2-3-5#187283 "-- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3 Hello, After upgrading Hikashop from 2.3.3 to 2.3.5 (on a test-site) the category view and the product view gives the error: Fatal error: Call to undefined method RuntimeException::get() in /..../libraries/legacy/error/error.php on line 533 Linking to 1 product gives no error. I've searched the forum and via Google but do not see this message / error at after upgrading to 2.3.5 In which direction should I look for the solution Thanks")* Hi I have the same error after upgrading to 2.3.5 business Joomla 2.5.28 PHP 5.4.36 Error: 500 - JDatabaseMySQL::query: 1054 - Unknown column 'a.product_name' in 'order clause' SQL=SELECT DISTINCT b.* FROM hzlt_hikashop_product_category AS a LEFT JOIN hzlt_hikashop_product AS b ON a.product_id=b.product_id WHERE b.product_published=1 AND b.product_type = 'main' AND a.category_id IN (16) AND (b.product_access = 'all' OR b.product_access LIKE '%,1,%') ORDER BY a.product_name ASC LIMIT 0, 40 Again, any ideas? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3NDMzNy1lcnJvci1pbi1jYXRlZ29yeS12aWV3LWFmdGVyLXVwZ3JhZGluZy10by0yLTMtNT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 11 years 9 months ago [\#187297](#187297) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Error in category view after upgrading to 2.3.5](/forum/25-install-update/874337-error-in-category-view-after-upgrading-to-2-3-5#187297 "-- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3 Hello, After upgrading Hikashop from 2.3.3 to 2.3.5 (on a test-site) the category view and the product view gives the error: Fatal error: Call to undefined method RuntimeException::get() in /..../libraries/legacy/error/error.php on line 533 Linking to 1 product gives no error. I've searched the forum and via Google but do not see this message / error at after upgrading to 2.3.5 In which direction should I look for the solution Thanks")* Hi, Please edit the file "components/com_hikashop/views/product/view.html.php" and replace Code: if(empty($defaultParams['add_to_wishlist'])) $defaultParams['add_to_wishlist'] = 0; if($this->params->get('product_order', 'ordering') == 'ordering') $table = 'a'; By Code: if(empty($defaultParams['add_to_wishlist'])) $defaultParams['add_to_wishlist'] = 0; And also Code: if($this->params->get('show_quantity_field', '0') == '1') $this->params->set('show_quantity_field', 1); if((int)$this->params->get('limit') == 0) $this->params->set('limit', 1); By Code: if($this->params->get('show_quantity_field', '0') == '1') $this->params->set('show_quantity_field', 1); if((int)$this->params->get('limit') == 0) $this->params->set('limit', 1); if($this->params->get('product_order', 'ordering') == 'ordering') $table = 'a'; It will fix the SQL error while using a product listing module without any configuration. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. The following user(s) said Thank You: [speru](/forum/user/26914-speru "View speru's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3NDMzNy1lcnJvci1pbi1jYXRlZ29yeS12aWV3LWFmdGVyLXVwZ3JhZGluZy10by0yLTMtNT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Kees](/forum/user/34087-kees "View Kees's Profile")** - [![Kees's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34087-kees "View Kees's Profile") Topic Author - [ Offline](/forum/user/34087-kees) Less More - Posts: 6 - Thank you received: 0 - - 11 years 9 months ago [\#187314](#187314) by [Kees](/forum/user/34087-kees "View Kees's Profile") Replied by *[Kees](/forum/user/34087-kees "View Kees's Profile")* on topic *[Error in category view after upgrading to 2.3.5](/forum/25-install-update/874337-error-in-category-view-after-upgrading-to-2-3-5#187314 "-- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3 Hello, After upgrading Hikashop from 2.3.3 to 2.3.5 (on a test-site) the category view and the product view gives the error: Fatal error: Call to undefined method RuntimeException::get() in /..../libraries/legacy/error/error.php on line 533 Linking to 1 product gives no error. I've searched the forum and via Google but do not see this message / error at after upgrading to 2.3.5 In which direction should I look for the solution Thanks")* Hello Jerome That works, thanks! what do you mean with: > while using a product listing module without any configuration. For the production site, I'll wait until version 2.3.6 or did you make the adjustment in the current package? Thanks for the quick fix! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3NDMzNy1lcnJvci1pbi1jYXRlZ29yeS12aWV3LWFmdGVyLXVwZ3JhZGluZy10by0yLTMtNT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 11 years 9 months ago [\#187318](#187318) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Error in category view after upgrading to 2.3.5](/forum/25-install-update/874337-error-in-category-view-after-upgrading-to-2-3-5#187318 "-- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3 Hello, After upgrading Hikashop from 2.3.3 to 2.3.5 (on a test-site) the category view and the product view gives the error: Fatal error: Call to undefined method RuntimeException::get() in /..../libraries/legacy/error/error.php on line 533 Linking to 1 product gives no error. I've searched the forum and via Google but do not see this message / error at after upgrading to 2.3.5 In which direction should I look for the solution Thanks")* Hi, For the moment the best is to patch the website. I don't have the possibility to update the HikaShop 2.3.5 package for the moment ; I'll see with Nicolas if we patch the package or if we release a 2.3.6 sooner. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3NDMzNy1lcnJvci1pbi1jYXRlZ29yeS12aWV3LWFmdGVyLXVwZ3JhZGluZy10by0yLTMtNT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.305 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)