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

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 !

We will try that, thanks!

I will not add the credentials again