Hikashop Dashboard: Error 1054 Unknown Column

  • Posts: 284
  • Thank you received: 6
8 years 3 months ago #246570

-- 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

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
8 years 3 months ago #246573

Hi,

It comes from the MySQL query of one of your reports.
Go in Orders>Reports and disable the reports one by one to find the culprit.
Then, try creating it again and see if you get the error again.
If you do, please provide a screenshot of the settings of the report so that we can try reproducing the problem.

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

  • Posts: 284
  • Thank you received: 6
8 years 3 months ago #246627

It was this report: Five best categories over the last two weeks
Clicking on this report, even when it is unpublished, causes that same error.

Since I don't know what selections made that report I can't exactly recreate it.

Last edit: 8 years 3 months ago by MSTACE.

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

  • Posts: 4747
  • Thank you received: 644
  • MODERATOR
8 years 3 months ago #246661

Hello,

Theorically, if the report is unpublished and the issue still here it's notlink...
And so, which reasons leads you to tell that this is this report the root issue ?
If when you switch off ALL reports, does the issue is still here ?

Awaiting news from you.

Regards

Last edit: 8 years 3 months ago by Philip.

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

Time to create page: 0.059 seconds
Powered by Kunena Forum