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

  • Posts: 190
  • Thank you received: 9
6 years 10 months ago #270567

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

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

  • Posts: 190
  • Thank you received: 9
6 years 10 months ago #270568

And i did the Hikashop database check :-)

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

  • Posts: 26000
  • Thank you received: 4004
  • MODERATOR
6 years 10 months ago #270569

Hello,

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

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 190
  • Thank you received: 9
6 years 10 months ago #270762

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 !

Last edit: 6 years 10 months ago by Jerome. Reason: removing credentials for your own safety !!

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

  • Posts: 26000
  • Thank you received: 4004
  • MODERATOR
6 years 10 months ago #270776

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.

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 190
  • Thank you received: 9
6 years 10 months ago #270857

We will try that, thanks!

I will not add the credentials again :-)

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

Time to create page: 0.059 seconds
Powered by Kunena Forum