Error on report 1064 You have an error in your SQL syntax; check the manual that

-- url of the page with the problem -- : waterline.nl
-- HikaShop version -- : 3.1.0
-- Joomla version -- : 3.7.2
-- PHP version -- : 7
-- Error-message(debug-mod must be tuned on) -- : 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_ AS a' at line 1

Hi Guys,

When i go to te reports and click on my sales for making a report i get this:
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_ AS a' at line 1

I updated to the newest version and fixed any database errors with Admin tools and default joomla tool.
What is going wrong here?

And i did the Hikashop database check

Hello,

Please activate the debug mode in order to have the complete query and also the incriminated file (thanks to the call stack).

Regards,

Hi Jerome,

Here is a screenshot with the debug and the error report to max.
www.dropbox.com/s/n6ekptae6ks655c/Screen...%2012.06.44.png?dl=0

Do you have any idea?

Credentials removed for your own safety !

Hello,

Please delete your report and start a new one.
Unfortunately, you break the widget/report configuration.

Regards,

PS : Please ; do not provide your credentials like that. We have a "contact us" form for private information and if we need access to your backend, be sure that we will ask for it.

We will try that, thanks!

I will not add the credentials again