i can't access hikashop having error 1064

-- HikaShop version -- : 4.3.0
-- Joomla version -- : 3.9.23
-- PHP version -- : 7.2
-- Error-message(debug-mod must be tuned on) -- : An error has occurred 1064

hi

suddenly i can no longer access my hikashop dashboard in backend

this is the complete error

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 '*, SUM(prod.order_product_quantity) AS total FROM x9z8ky_hikashop_order AS a LEF' at line 1
/home/.../libraries/joomla/database/driver/mysqli.php:665

please help

thanks

Hi,

This means that there is a MySQL error with one of the widgets you've configured in your dashboard.
A widget is basically a published report. So you can go in the menu Orders>Reports, and unpublish the widgets one by one until you figure out the one causing the problem.
Then, delete it and recreate it.
If you're able to reproduce the issue, then please provide a screenshot of the settings of the report before you save it.
Alss, it would be great to get the MySQL query causing the error with such modification:
Please edit the file /libraries/joomla/database/exception/executing.php
and change the line:
parent::__construct($message, $code, $previous);
by:
parent::__construct($message.' '.$query, $code, $previous);
and this error message will also display the MySQL which generated the error, which will help us understand why this error is happening.

the problem is caused by the MAP from reports

if i unpublished it, hikashop is working fine.

so what do i do to fix the map?

thanks

Well, you have 3 solutions:
- You turn off the "dashboard" legacy setting of the HikaShop configuration to use the new dashboard we've added a while back
- You delete the report and recreate it
- You do the modification I proposed 2 months ago in my previous message and you provide the MySQL query you get with the error message when the report is published. That way, we can look into the problem and try to provide a patch.