Error: 1064 You have an error in your SQL syntax; check the ....

  • Posts: 5
  • Thank you received: 0
  • Hikashop Business
5 hours 36 minutes ago #370374

-- HikaShop version -- : 6.3
-- Joomla version -- : 3.9
-- PHP version -- : 7.3
-- Browser(s) name and version -- : Firefox 140.7.0esr (64-Bit)
-- Error-message(debug-mod must be tuned on) -- : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '*, SUM(prod.order_product_quantity) AS total FROM #__hikashop_order AS a L...' at line 1

Sorry for the Joomla version :-( . I am trying to update a intranet website with many plugins. During the update of Hikashop I found this error when I choose in joomla - Administrator -> Komponents->Hikashop:

administrator/index.php?option=com_hikashop

1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '*, SUM(prod.order_product_quantity) AS total FROM #__hikashop_order AS a L...' at line 1

This is not really an upgrade problem from version 3.5.1 to 5.0.4 to 6.3 which I did.
The error was already there before. The shop seems to work....

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

  • Posts: 85055
  • Thank you received: 13871
  • MODERATOR
2 hours 29 minutes ago #370376

Hi,

Can you please activate the "debug system" setting of the Joomla configuration page and try again ?
It should display more information on the page with the error.
Please provide the extra information and we should be able to tell you what to do.

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

Time to create page: 0.053 seconds
Powered by Kunena Forum