error 1054

  • Posts: 22
  • Thank you received: 0
11 years 1 week ago #155791

-- url of the page with the problem -- : www.todo-plantillas.com/index.php/tienda
-- HikaShop version -- : 2.3.0
-- Joomla version -- : 3.3.0
-- PHP version -- : 5.3.28
-- Browser(s) name and version -- : chrome
-- Error-message(debug-mod must be tuned on) -- : Error_message

Unknown column 'a.category_ordering' in 'order clause' SQL=SELECT DISTINCT b.* FROM ts_hikashop_product_category AS a LEFT JOIN ts_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) AND (b.product_access = 'all' OR b.product_access LIKE '%,9,%') ORDER BY a.category_ordering ASC LIMIT 72, 24

Please help

Thanks

Walter

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

  • Posts: 26234
  • Thank you received: 4036
  • MODERATOR
11 years 1 week ago #155793

Hi,

You have a wrong value in your session for the ordering and it results a query error.
Please logout from your website and clean your browser cookies. It will reset the values and you will retrieve a good working page.

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

Time to create page: 0.057 seconds
Powered by Kunena Forum