500 - JDatabaseMySQL::query: 1054 -

  • Posts: 14
  • Thank you received: 0
11 years 8 months ago #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.

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
11 years 8 months ago #94381

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 or Create an account to join the conversation.

  • Posts: 14
  • Thank you received: 0
11 years 8 months ago #94394

Fixed, thanks

Attachments:
Last edit: 11 years 8 months ago by Khalid Al Hassan.

Please Log in or Create an account to join the conversation.

Time to create page: 0.057 seconds
Powered by Kunena Forum