[Skip to main content](#vessel-content) # 500 - JDatabaseMySQL::query: 1054 - ## - **[Khalid Al Hassan](/forum/user/14321-khalid-al-hassan "View Khalid Al Hassan's Profile")** - [![Khalid Al Hassan's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/14321-khalid-al-hassan "View Khalid Al Hassan's Profile") Topic Author - [ Offline](/forum/user/14321-khalid-al-hassan) Less More - Posts: 14 - Thank you received: 0 - - 13 years 7 months ago [\#94366](#94366) by [Khalid Al Hassan](/forum/user/14321-khalid-al-hassan "View Khalid Al Hassan's Profile") *[500 - JDatabaseMySQL::query: 1054 -](/forum/2-general-talk-about-hikashop/79269-500-jdatabasemysql-query-1054#94366 "Suddenly started getting this error while using the HIKASHOP Category module. Here is the error below 500 - JDatabaseMySQL::query: 1054 - Unknown column 'a.inherit' in 'order clause' SQL=SELECT a.* FROM jml_hikashop_category AS a WHERE a.category_parent_id = 21 AND a.category_published=1 AND (a.category_access = 'all' OR a.category_access LIKE '%,1,%') ORDER BY a.inherit ASC LIMIT 0, 20 You may not be able to visit this page because of: an out-of-date bookmark/favourite a search engine that has an out-of-date listing for this site a mistyped address you have no access to this page The requested resource was not found. An error has occurred while processing your request. Please try one of the following pages: Home Page If difficulties persist, please contact the System Administrator of this site and report the error below.. JDatabaseMySQL::query: 1054 - Unknown column 'a.inherit' in 'order clause' SQL=SELECT a.* FROM jml_hikashop_category AS a WHERE a.category_parent_id = 21 AND a.category_published=1 AND (a.category_access = 'all' OR a.category_access LIKE '%,1,%') ORDER BY a.inherit ASC LIMIT 0, 20 Call stack # Function Location 1 JSite->dispatch() /home2/intrins4/public_html/flavorvapor/index.php:42 2 JComponentHelper::renderComponent() /home2/intrins4/public_html/flavorvapor/includes/application.php:197 3 JComponentHelper::executeComponent() /home2/intrins4/public_html/flavorvapor/libraries/joomla/application/component/helper.php:351 4 require_once() /home2/intrins4/public_html/flavorvapor/libraries/joomla/application/component/helper.php:383 5 hikashopController->execute() /home2/intrins4/public_html/flavorvapor/components/com_hikashop/hikashop.php:69 6 JController->execute() /home2/intrins4/public_html/flavorvapor/administrator/components/com_hikashop/helpers/helper.php:1212 7 hikashopController->listing() /home2/intrins4/public_html/flavorvapor/libraries/joomla/application/component/controller.php:761 8 hikashopController->display() /home2/intrins4/public_html/flavorvapor/administrator/components/com_hikashop/helpers/helper.php:981 9 JController->display() /home2/intrins4/public_html/flavorvapor/administrator/components/com_hikashop/helpers/helper.php:1224 10 CategoryViewCategory->display() /home2/intrins4/public_html/flavorvapor/libraries/joomla/application/component/controller.php:722 11 CategoryViewCategory->listing() /home2/intrins4/public_html/flavorvapor/components/com_hikashop/views/category/view.html.php:22 12 hikashopCategoryClass->getChilds() /home2/intrins4/public_html/flavorvapor/components/com_hikashop/views/category/view.html.php:251 13 JDatabase->loadObjectList() /home2/intrins4/public_html/flavorvapor/administrator/components/com_hikashop/classes/category.php:449 14 JDatabaseMySQL->execute() /home2/intrins4/public_html/flavorvapor/libraries/joomla/database/database.php:1100 15 JError::raiseError() /home2/intrins4/public_html/flavorvapor/libraries/joomla/database/database/mysql.php:555 16 JError::raise() /home2/intrins4/public_html/flavorvapor/libraries/joomla/error/error.php:251 I really dont know what to do with HIKASHOP I seem to be having so many problems with this component. Please help, with all the problems I've been having with HIKASHOP I've only had 4 HRS of sleep since monday.")* was created by *[Khalid Al Hassan](/forum/user/14321-khalid-al-hassan "View Khalid Al Hassan's Profile")* Suddenly started getting this error while using the HIKASHOP Category module. Here is the error below 500 - JDatabaseMySQL::query: 1054 - Unknown column 'a.inherit' in 'order clause' SQL=SELECT a.* FROM jml_hikashop_category AS a WHERE a.category_parent_id = 21 AND a.category_published=1 AND (a.category_access = 'all' OR a.category_access LIKE '%,1,%') ORDER BY a.inherit ASC LIMIT 0, 20 You may not be able to visit this page because of: an out-of-date bookmark/favourite a search engine that has an out-of-date listing for this site a mistyped address you have no access to this page The requested resource was not found. An error has occurred while processing your request. Please try one of the following pages: Home Page If difficulties persist, please contact the System Administrator of this site and report the error below.. JDatabaseMySQL::query: 1054 - Unknown column 'a.inherit' in 'order clause' SQL=SELECT a.* FROM jml_hikashop_category AS a WHERE a.category_parent_id = 21 AND a.category_published=1 AND (a.category_access = 'all' OR a.category_access LIKE '%,1,%') ORDER BY a.inherit ASC LIMIT 0, 20 Call stack \# Function Location 1 JSite->dispatch() /home2/intrins4/public_html/flavorvapor/index.php:42 2 JComponentHelper::renderComponent() /home2/intrins4/public_html/flavorvapor/includes/application.php:197 3 JComponentHelper::executeComponent() /home2/intrins4/public_html/flavorvapor/libraries/joomla/application/component/helper.php:351 4 require_once() /home2/intrins4/public_html/flavorvapor/libraries/joomla/application/component/helper.php:383 5 hikashopController->execute() /home2/intrins4/public_html/flavorvapor/components/com_hikashop/hikashop.php:69 6 JController->execute() /home2/intrins4/public_html/flavorvapor/administrator/components/com_hikashop/helpers/helper.php:1212 7 hikashopController->listing() /home2/intrins4/public_html/flavorvapor/libraries/joomla/application/component/controller.php:761 8 hikashopController->display() /home2/intrins4/public_html/flavorvapor/administrator/components/com_hikashop/helpers/helper.php:981 9 JController->display() /home2/intrins4/public_html/flavorvapor/administrator/components/com_hikashop/helpers/helper.php:1224 10 CategoryViewCategory->display() /home2/intrins4/public_html/flavorvapor/libraries/joomla/application/component/controller.php:722 11 CategoryViewCategory->listing() /home2/intrins4/public_html/flavorvapor/components/com_hikashop/views/category/view.html.php:22 12 hikashopCategoryClass->getChilds() /home2/intrins4/public_html/flavorvapor/components/com_hikashop/views/category/view.html.php:251 13 JDatabase->loadObjectList() /home2/intrins4/public_html/flavorvapor/administrator/components/com_hikashop/classes/category.php:449 14 JDatabaseMySQL->execute() /home2/intrins4/public_html/flavorvapor/libraries/joomla/database/database.php:1100 15 JError::raiseError() /home2/intrins4/public_html/flavorvapor/libraries/joomla/database/database/mysql.php:555 16 JError::raise() /home2/intrins4/public_html/flavorvapor/libraries/joomla/error/error.php:251 I really dont know what to do with HIKASHOP I seem to be having so many problems with this component. Please help, with all the problems I've been having with HIKASHOP I've only had 4 HRS of sleep since monday. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5MjY5LTUwMC1qZGF0YWJhc2VteXNxbC1xdWVyeS0xMDU0P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86321 - Thank you received: 14279 - - 13 years 7 months ago [\#94381](#94381) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[500 - JDatabaseMySQL::query: 1054 -](/forum/2-general-talk-about-hikashop/79269-500-jdatabasemysql-query-1054#94381 "Suddenly started getting this error while using the HIKASHOP Category module. Here is the error below 500 - JDatabaseMySQL::query: 1054 - Unknown column 'a.inherit' in 'order clause' SQL=SELECT a.* FROM jml_hikashop_category AS a WHERE a.category_parent_id = 21 AND a.category_published=1 AND (a.category_access = 'all' OR a.category_access LIKE '%,1,%') ORDER BY a.inherit ASC LIMIT 0, 20 You may not be able to visit this page because of: an out-of-date bookmark/favourite a search engine that has an out-of-date listing for this site a mistyped address you have no access to this page The requested resource was not found. An error has occurred while processing your request. Please try one of the following pages: Home Page If difficulties persist, please contact the System Administrator of this site and report the error below.. JDatabaseMySQL::query: 1054 - Unknown column 'a.inherit' in 'order clause' SQL=SELECT a.* FROM jml_hikashop_category AS a WHERE a.category_parent_id = 21 AND a.category_published=1 AND (a.category_access = 'all' OR a.category_access LIKE '%,1,%') ORDER BY a.inherit ASC LIMIT 0, 20 Call stack # Function Location 1 JSite->dispatch() /home2/intrins4/public_html/flavorvapor/index.php:42 2 JComponentHelper::renderComponent() /home2/intrins4/public_html/flavorvapor/includes/application.php:197 3 JComponentHelper::executeComponent() /home2/intrins4/public_html/flavorvapor/libraries/joomla/application/component/helper.php:351 4 require_once() /home2/intrins4/public_html/flavorvapor/libraries/joomla/application/component/helper.php:383 5 hikashopController->execute() /home2/intrins4/public_html/flavorvapor/components/com_hikashop/hikashop.php:69 6 JController->execute() /home2/intrins4/public_html/flavorvapor/administrator/components/com_hikashop/helpers/helper.php:1212 7 hikashopController->listing() /home2/intrins4/public_html/flavorvapor/libraries/joomla/application/component/controller.php:761 8 hikashopController->display() /home2/intrins4/public_html/flavorvapor/administrator/components/com_hikashop/helpers/helper.php:981 9 JController->display() /home2/intrins4/public_html/flavorvapor/administrator/components/com_hikashop/helpers/helper.php:1224 10 CategoryViewCategory->display() /home2/intrins4/public_html/flavorvapor/libraries/joomla/application/component/controller.php:722 11 CategoryViewCategory->listing() /home2/intrins4/public_html/flavorvapor/components/com_hikashop/views/category/view.html.php:22 12 hikashopCategoryClass->getChilds() /home2/intrins4/public_html/flavorvapor/components/com_hikashop/views/category/view.html.php:251 13 JDatabase->loadObjectList() /home2/intrins4/public_html/flavorvapor/administrator/components/com_hikashop/classes/category.php:449 14 JDatabaseMySQL->execute() /home2/intrins4/public_html/flavorvapor/libraries/joomla/database/database.php:1100 15 JError::raiseError() /home2/intrins4/public_html/flavorvapor/libraries/joomla/database/database/mysql.php:555 16 JError::raise() /home2/intrins4/public_html/flavorvapor/libraries/joomla/error/error.php:251 I really dont know what to do with HIKASHOP I seem to be having so many problems with this component. Please help, with all the problems I've been having with HIKASHOP I've only had 4 HRS of sleep since monday.")* Hi, It means that in the configuration "category ordering" option, you selected "inherit". This means that you want the category listing ordering to be ordered based on a main configuration setting, but this option is already the main configuration setting so the system gets confused. Simply change that option to something else that "inherit" and it will work. It's not that HikaShop has a bugs but that you don't use it as you should. We'll change the code for next version so that you can get that it woks even if you configure it like that. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5MjY5LTUwMC1qZGF0YWJhc2VteXNxbC1xdWVyeS0xMDU0P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[Khalid Al Hassan](/forum/user/14321-khalid-al-hassan "View Khalid Al Hassan's Profile")** - [![Khalid Al Hassan's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/14321-khalid-al-hassan "View Khalid Al Hassan's Profile") Topic Author - [ Offline](/forum/user/14321-khalid-al-hassan) Less More - Posts: 14 - Thank you received: 0 - - 13 years 7 months ago - 13 years 7 months ago [\#94394](#94394) by [Khalid Al Hassan](/forum/user/14321-khalid-al-hassan "View Khalid Al Hassan's Profile") Replied by *[Khalid Al Hassan](/forum/user/14321-khalid-al-hassan "View Khalid Al Hassan's Profile")* on topic *[500 - JDatabaseMySQL::query: 1054 -](/forum/2-general-talk-about-hikashop/79269-500-jdatabasemysql-query-1054#94394 "Suddenly started getting this error while using the HIKASHOP Category module. Here is the error below 500 - JDatabaseMySQL::query: 1054 - Unknown column 'a.inherit' in 'order clause' SQL=SELECT a.* FROM jml_hikashop_category AS a WHERE a.category_parent_id = 21 AND a.category_published=1 AND (a.category_access = 'all' OR a.category_access LIKE '%,1,%') ORDER BY a.inherit ASC LIMIT 0, 20 You may not be able to visit this page because of: an out-of-date bookmark/favourite a search engine that has an out-of-date listing for this site a mistyped address you have no access to this page The requested resource was not found. An error has occurred while processing your request. Please try one of the following pages: Home Page If difficulties persist, please contact the System Administrator of this site and report the error below.. JDatabaseMySQL::query: 1054 - Unknown column 'a.inherit' in 'order clause' SQL=SELECT a.* FROM jml_hikashop_category AS a WHERE a.category_parent_id = 21 AND a.category_published=1 AND (a.category_access = 'all' OR a.category_access LIKE '%,1,%') ORDER BY a.inherit ASC LIMIT 0, 20 Call stack # Function Location 1 JSite->dispatch() /home2/intrins4/public_html/flavorvapor/index.php:42 2 JComponentHelper::renderComponent() /home2/intrins4/public_html/flavorvapor/includes/application.php:197 3 JComponentHelper::executeComponent() /home2/intrins4/public_html/flavorvapor/libraries/joomla/application/component/helper.php:351 4 require_once() /home2/intrins4/public_html/flavorvapor/libraries/joomla/application/component/helper.php:383 5 hikashopController->execute() /home2/intrins4/public_html/flavorvapor/components/com_hikashop/hikashop.php:69 6 JController->execute() /home2/intrins4/public_html/flavorvapor/administrator/components/com_hikashop/helpers/helper.php:1212 7 hikashopController->listing() /home2/intrins4/public_html/flavorvapor/libraries/joomla/application/component/controller.php:761 8 hikashopController->display() /home2/intrins4/public_html/flavorvapor/administrator/components/com_hikashop/helpers/helper.php:981 9 JController->display() /home2/intrins4/public_html/flavorvapor/administrator/components/com_hikashop/helpers/helper.php:1224 10 CategoryViewCategory->display() /home2/intrins4/public_html/flavorvapor/libraries/joomla/application/component/controller.php:722 11 CategoryViewCategory->listing() /home2/intrins4/public_html/flavorvapor/components/com_hikashop/views/category/view.html.php:22 12 hikashopCategoryClass->getChilds() /home2/intrins4/public_html/flavorvapor/components/com_hikashop/views/category/view.html.php:251 13 JDatabase->loadObjectList() /home2/intrins4/public_html/flavorvapor/administrator/components/com_hikashop/classes/category.php:449 14 JDatabaseMySQL->execute() /home2/intrins4/public_html/flavorvapor/libraries/joomla/database/database.php:1100 15 JError::raiseError() /home2/intrins4/public_html/flavorvapor/libraries/joomla/database/database/mysql.php:555 16 JError::raise() /home2/intrins4/public_html/flavorvapor/libraries/joomla/error/error.php:251 I really dont know what to do with HIKASHOP I seem to be having so many problems with this component. Please help, with all the problems I've been having with HIKASHOP I've only had 4 HRS of sleep since monday.")* Fixed, thanks - [ ![Untitled_2013-03-13.png](/forum/attachment/9094) ](/forum/attachment/9094 "...2013-03-13.png") [ ](/forum/attachment/9094?download=1 "...2013-03-13.png") Last edit: 13 years 7 months ago by [Khalid Al Hassan](/forum/user/14321-khalid-al-hassan "View Khalid Al Hassan's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5MjY5LTUwMC1qZGF0YWJhc2VteXNxbC1xdWVyeS0xMDU0P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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.088 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)