Skip to main content

error 1054

More
12 years 4 months ago #155791 by walter
error 1054 was created by walter
-- 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.

More
12 years 4 months ago #155793 by Jerome
Replied by Jerome on topic error 1054
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.

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

Time to create page: 0.163 seconds
Powered by Kunena Forum