-- url of the page with the problem -- :
www.grocerbob.com/
-- HikaShop version -- : 2.6.3
-- Joomla version -- : 3.6.0
-- PHP version -- : 5.6.23
-- Error-message(debug-mod must be tuned on) -- : 1054 Unknown column 'a.user_created' in 'where clause' SQL=SELECT *, SUM(order_product_quantity) as Total FROM #__hikashop_order as a LEFT JOIN #__hikashop_order_product as prod ON a.order_id=prod.order_id LEFT JOIN #__hikashop_product AS p ON p.product_id=prod.product_id LEFT JOIN #__hikashop_product_category as cat ON cat.product_id=p.product_id OR cat.product_id=p.product_parent_id LEFT JOIN #__hikashop_category as c ON cat.category_id=c.category_id WHERE a.user_created > 1451606400 AND a.user_created
Anytime you try to go to the Hikashop Dashboard in the Admin area, it creates this error:
1054 Unknown column 'a.user_created' in 'where clause' SQL=SELECT *, SUM(order_product_quantity) as Total FROM #__hikashop_order as a LEFT JOIN #__hikashop_order_product as prod ON a.order_id=prod.order_id LEFT JOIN #__hikashop_product AS p ON p.product_id=prod.product_id LEFT JOIN #__hikashop_product_category as cat ON cat.product_id=p.product_id OR cat.product_id=p.product_parent_id LEFT JOIN #__hikashop_category as c ON cat.category_id=c.category_id WHERE a.user_created > 1451606400 AND a.user_created < 1469695997 GROUP BY c.category_id ORDER BY Total DESC LIMIT 10
