modifications to reports are giving SQL errors, dashboard not available now

  • Posts: 170
  • Thank you received: 8
  • Hikashop Essential
5 years 1 month ago #311620

-- HikaShop version -- : 4.2.1
-- Joomla version -- : 3.9.11
-- PHP version -- : 7.0.33
-- Browser(s) name and version -- : chrome
-- Error-message(debug-mod must be tuned on) -- : An error has occurred.
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM #__hikashop_order AS a WHERE a.order_type='sale' AND a.order_status IN (' at line 1
Return to Control Panel

Can't access the dashboard after making a change to the comparison sales data, get sql syntax error. Any ideas?

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
5 years 1 month ago #311622

Hi,

First, you can disable the report via the Orders>Reports menu.
That way, it won't appear as a widget on the dashboard and thus won't crash the dashboard.
Then, you can create a new report and publish it once it's working like you want.
Also, you might want to try to reproduce the issue and provide a screenshot of the settings of the report just before you save it (after you save it, the report edition page will crash as it will also run the report so you won't be able to do a screenshot of the settings once you have the issue with the report.

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

Time to create page: 0.050 seconds
Powered by Kunena Forum