[Skip to main content](#vessel-content) # Error: 1064 You have an error in your SQL syntax; check the .... ## - **[Idrian65](/forum/user/39229-idrian65 "View Idrian65's Profile")** - [![Idrian65's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/39229-idrian65 "View Idrian65's Profile") Topic Author - [ Offline](/forum/user/39229-idrian65) Less More - Posts: 14 - Thank you received: 1 - - 8 months 3 weeks ago [\#370374](#370374) by [Idrian65](/forum/user/39229-idrian65 "View Idrian65's Profile") *[Error: 1064 You have an error in your SQL syntax; check the ....](/forum/25-install-update/910100-error-1064-you-have-an-error-in-your-sql-syntax-check-the#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....")* was created by *[Idrian65](/forum/user/39229-idrian65 "View Idrian65's Profile")* -- 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 ![:-(](/media/kunena/emoticons/22.png ":-(") . 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkxMDEwMC1lcnJvci0xMDY0LXlvdS1oYXZlLWFuLWVycm9yLWluLXlvdXItc3FsLXN5bnRheC1jaGVjay10aGU/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14283 - - 8 months 3 weeks ago [\#370376](#370376) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Error: 1064 You have an error in your SQL syntax; check the ....](/forum/25-install-update/910100-error-1064-you-have-an-error-in-your-sql-syntax-check-the#370376 "-- 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....")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkxMDEwMC1lcnJvci0xMDY0LXlvdS1oYXZlLWFuLWVycm9yLWluLXlvdXItc3FsLXN5bnRheC1jaGVjay10aGU/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Idrian65](/forum/user/39229-idrian65 "View Idrian65's Profile")** - [![Idrian65's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/39229-idrian65 "View Idrian65's Profile") Topic Author - [ Offline](/forum/user/39229-idrian65) Less More - Posts: 14 - Thank you received: 1 - - 8 months 3 weeks ago [\#370387](#370387) by [Idrian65](/forum/user/39229-idrian65 "View Idrian65's Profile") Replied by *[Idrian65](/forum/user/39229-idrian65 "View Idrian65's Profile")* on topic *[Error: 1064 You have an error in your SQL syntax; check the ....](/forum/25-install-update/910100-error-1064-you-have-an-error-in-your-sql-syntax-check-the#370387 "-- 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....")* Hi, thanks for your help, here is the debug Output: maybe the error is a "legacy issue" from a previous update... JDatabaseExceptionExecuting [500] 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 tlazo_hikashop_order AS a L...' at line 1 .../libraries/joomla/database/driver/mysqli.php:665 660 // The server was not disconnected. 661 else 662 { 663 JLog::add(JText::sprintf('JLIB_DATABASE_QUERY_FAILED', $this->errorNum, $this->errorMsg), JLog::ERROR, 'database-error'); 664 665 throw new JDatabaseExceptionExecuting($query, $this->errorMsg, $this->errorNum); 666 } 667 } 668 669 return $this->cursor; 670 } Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkxMDEwMC1lcnJvci0xMDY0LXlvdS1oYXZlLWFuLWVycm9yLWluLXlvdXItc3FsLXN5bnRheC1jaGVjay10aGU/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14283 - - 8 months 3 weeks ago [\#370388](#370388) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Error: 1064 You have an error in your SQL syntax; check the ....](/forum/25-install-update/910100-error-1064-you-have-an-error-in-your-sql-syntax-check-the#370388 "-- 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....")* Hi, Do you have other information about the error on that page with the debug activated ? I would need the "call stack". Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkxMDEwMC1lcnJvci0xMDY0LXlvdS1oYXZlLWFuLWVycm9yLWluLXlvdXItc3FsLXN5bnRheC1jaGVjay10aGU/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Idrian65](/forum/user/39229-idrian65 "View Idrian65's Profile")** - [![Idrian65's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/39229-idrian65 "View Idrian65's Profile") Topic Author - [ Offline](/forum/user/39229-idrian65) Less More - Posts: 14 - Thank you received: 1 - - 8 months 3 weeks ago [\#370391](#370391) by [Idrian65](/forum/user/39229-idrian65 "View Idrian65's Profile") Replied by *[Idrian65](/forum/user/39229-idrian65 "View Idrian65's Profile")* on topic *[Error: 1064 You have an error in your SQL syntax; check the ....](/forum/25-install-update/910100-error-1064-you-have-an-error-in-your-sql-syntax-check-the#370391 "-- 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....")* Ok, in administrator/index.php i had to replace $app->execute(); with: // Execute the application. try { $app->execute(); } catch (Throwable $e) { echo '<pre>'; echo $e; echo '</pre>'; die; } Now I can see a stack trace: JDatabaseExceptionExecuting: 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 tlazo_hikashop_order AS a L...' at line 1 in /homepages/12/d82533704/htdocs/backup/20260209_intranet/libraries/joomla/database/driver/mysqli.php:665 Stack trace: \#0 /homepages/12/d82533704/htdocs/backup/20260209_intranet/libraries/joomla/database/driver.php(1701): JDatabaseDriverMysqli->execute() \#1 /homepages/12/d82533704/htdocs/backup/20260209_intranet/administrator/components/com_hikashop/classes/widget.php(1396): JDatabaseDriver->loadObjectList() \#2 /homepages/12/d82533704/htdocs/backup/20260209_intranet/administrator/components/com_hikashop/views/dashboard/view.html.php(90): hikashopWidgetClass->data(Object(stdClass)) \#3 /homepages/12/d82533704/htdocs/backup/20260209_intranet/administrator/components/com_hikashop/views/dashboard/view.html.php(26): dashboardViewDashboard->widgets() \#4 /homepages/12/d82533704/htdocs/backup/20260209_intranet/administrator/components/com_hikashop/views/dashboard/view.html.php(17): dashboardViewDashboard->listing(NULL) \#5 /homepages/12/d82533704/htdocs/backup/20260209_intranet/libraries/src/MVC/Controller/BaseController.php(672): dashboardViewDashboard->display() \#6 /homepages/12/d82533704/htdocs/backup/20260209_intranet/administrator/components/com_hikashop/helpers/helper.php(2649): Joomla\CMS\MVC\Controller\BaseController->display(false, false) \#7 /homepages/12/d82533704/htdocs/backup/20260209_intranet/administrator/components/com_hikashop/helpers/helper.php(2358): hikashopController->display() \#8 /homepages/12/d82533704/htdocs/backup/20260209_intranet/libraries/src/MVC/Controller/BaseController.php(710): hikashopController->listing() \#9 /homepages/12/d82533704/htdocs/backup/20260209_intranet/administrator/components/com_hikashop/helpers/helper.php(2627): Joomla\CMS\MVC\Controller\BaseController->execute('listing') \#10 /homepages/12/d82533704/htdocs/backup/20260209_intranet/administrator/components/com_hikashop/hikashop.php(75): hikashopController->execute('listing') \#11 /homepages/12/d82533704/htdocs/backup/20260209_intranet/libraries/src/Component/ComponentHelper.php(402): require_once('/homepages/12/d...') \#12 /homepages/12/d82533704/htdocs/backup/20260209_intranet/libraries/src/Component/ComponentHelper.php(377): Joomla\CMS\Component\ComponentHelper::executeComponent('/homepages/12/d...') \#13 /homepages/12/d82533704/htdocs/backup/20260209_intranet/libraries/src/Application/AdministratorApplication.php(101): Joomla\CMS\Component\ComponentHelper::renderComponent('com_hikashop') \#14 /homepages/12/d82533704/htdocs/backup/20260209_intranet/libraries/src/Application/AdministratorApplication.php(159): Joomla\CMS\Application\AdministratorApplication->dispatch() \#15 /homepages/12/d82533704/htdocs/backup/20260209_intranet/libraries/src/Application/CMSApplication.php(196): Joomla\CMS\Application\AdministratorApplication->doExecute() \#16 /homepages/12/d82533704/htdocs/backup/20260209_intranet/administrator/index.php(52): Joomla\CMS\Application\CMSApplication->execute() \#17 {main} Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkxMDEwMC1lcnJvci0xMDY0LXlvdS1oYXZlLWFuLWVycm9yLWluLXlvdXItc3FsLXN5bnRheC1jaGVjay10aGU/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14283 - - 8 months 3 weeks ago [\#370397](#370397) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Error: 1064 You have an error in your SQL syntax; check the ....](/forum/25-install-update/910100-error-1064-you-have-an-error-in-your-sql-syntax-check-the#370397 "-- 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....")* Hi, Thanks, that's exactly what we needed. We have analyzed the issue. It seems to come from a SQL syntax conflict with your version of MariaDB regarding the use of "SELECT *" combined with "GROUP BY" in the dashboard map widget. We have added a patch for this in the latest build of HikaShop 6.3.0. Please download the install package of HikaShop 6.3.0 again from our website and install it over your current version. This will apply the patch and it should fix the error. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkxMDEwMC1lcnJvci0xMDY0LXlvdS1oYXZlLWFuLWVycm9yLWluLXlvdXItc3FsLXN5bnRheC1jaGVjay10aGU/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Idrian65](/forum/user/39229-idrian65 "View Idrian65's Profile")** - [![Idrian65's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/39229-idrian65 "View Idrian65's Profile") Topic Author - [ Offline](/forum/user/39229-idrian65) Less More - Posts: 14 - Thank you received: 1 - - 8 months 3 weeks ago [\#370400](#370400) by [Idrian65](/forum/user/39229-idrian65 "View Idrian65's Profile") Replied by *[Idrian65](/forum/user/39229-idrian65 "View Idrian65's Profile")* on topic *[Error: 1064 You have an error in your SQL syntax; check the ....](/forum/25-install-update/910100-error-1064-you-have-an-error-in-your-sql-syntax-check-the#370400 "-- 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....")* Thank you, the error is vanished. But I can't see a right Main Hika shop page. Please find an image attached. No further error messages on the screen only at the bottom: Notice: Undefined variable: region in /homepages/12/d82533704/htdocs/backup/20260209_intranet/administrator/components/com_hikashop/views/dashboard/tmpl/map.php on line 74 Recoverable fatal error: Object of class stdClass could not be converted to string in /homepages/12/d82533704/htdocs/backup/20260209_intranet/administrator/components/com_hikashop/views/dashboard/tmpl/map.php on line 75 But I think that is not the reason for the view. - [ ![Hika_shop_main_side.png](/forum/attachment/61215) ](/forum/attachment/61215 "..._main_side.png") [ ](/forum/attachment/61215?download=1 "..._main_side.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkxMDEwMC1lcnJvci0xMDY0LXlvdS1oYXZlLWFuLWVycm9yLWluLXlvdXItc3FsLXN5bnRheC1jaGVjay10aGU/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14283 - - 8 months 3 weeks ago [\#370402](#370402) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Error: 1064 You have an error in your SQL syntax; check the ....](/forum/25-install-update/910100-error-1064-you-have-an-error-in-your-sql-syntax-check-the#370402 "-- 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....")* Hi, Thanks for the feedback on that other error. We found and fixed this issue too. The map widget template had a code structure problem following modifications in the last version of HikaShop. Please download the latest build of HikaShop 6.3.0 again and install it over your current version. This will apply both patches (for the SQL error and for these map widget errors). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkxMDEwMC1lcnJvci0xMDY0LXlvdS1oYXZlLWFuLWVycm9yLWluLXlvdXItc3FsLXN5bnRheC1jaGVjay10aGU/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Idrian65](/forum/user/39229-idrian65 "View Idrian65's Profile")** - [![Idrian65's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/39229-idrian65 "View Idrian65's Profile") Topic Author - [ Offline](/forum/user/39229-idrian65) Less More - Posts: 14 - Thank you received: 1 - - 8 months 3 weeks ago [\#370408](#370408) by [Idrian65](/forum/user/39229-idrian65 "View Idrian65's Profile") Replied by *[Idrian65](/forum/user/39229-idrian65 "View Idrian65's Profile")* on topic *[Error: 1064 You have an error in your SQL syntax; check the ....](/forum/25-install-update/910100-error-1064-you-have-an-error-in-your-sql-syntax-check-the#370408 "-- 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....")* Thank you very much for the quick help! The main page works again, great. The following user(s) said Thank You: [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkxMDEwMC1lcnJvci0xMDY0LXlvdS1oYXZlLWFuLWVycm9yLWluLXlvdXItc3FsLXN5bnRheC1jaGVjay10aGU/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.091 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)