[Skip to main content](#vessel-content) # i can't access hikashop having error 1064 ## - **[ronron](/forum/user/40399-ronron "View ronron's Profile")** - [![ronron's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/bad_baby.jpg)](/forum/user/40399-ronron "View ronron's Profile") Topic Author - [ Offline](/forum/user/40399-ronron) Less More - Posts: 490 - Thank you received: 2 - - 5 years 10 months ago [\#326782](#326782) by [ronron](/forum/user/40399-ronron "View ronron's Profile") *[i can't access hikashop having error 1064](/forum/25-install-update/901387-i-cant-access-hikashop-having-error-1064#326782 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.23 -- PHP version -- : 7.2 -- Error-message(debug-mod must be tuned on) -- : An error has occurred 1064 hi suddenly i can no longer access my hikashop dashboard in backend this is the complete error 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 '*, SUM(prod.order_product_quantity) AS total FROM x9z8ky_hikashop_order AS a LEF' at line 1 /home/.../libraries/joomla/database/driver/mysqli.php:665 please help thanks")* was created by *[ronron](/forum/user/40399-ronron "View ronron's Profile")* -- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.23 -- PHP version -- : 7.2 -- Error-message(debug-mod must be tuned on) -- : An error has occurred 1064 hi suddenly i can no longer access my hikashop dashboard in backend this is the complete error 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 '*, SUM(prod.order_product_quantity) AS total FROM x9z8ky_hikashop_order AS a LEF' at line 1 /home/.../libraries/joomla/database/driver/mysqli.php:665 please help thanks [ ![Error1064YouhaveanerrorinyourSQLsyntaxcheckthemanualthatcorrespondstoyourMySQLserverversionfortheright2020-12-0123-29-11_2020-12-01.jpg](/forum/attachment/51293) ](/forum/attachment/51293 "...2020-12-01.jpg") - [ ![Error1064YouhaveanerrorinyourSQLsyntaxcheckthemanualthatcorrespondstoyourMySQLserverversionfortheright2020-12-0123-29-11_2020-12-01.jpg](/forum/attachment/51293) ](/forum/attachment/51293 "...2020-12-01.jpg") [ ](/forum/attachment/51293?download=1 "...2020-12-01.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzkwMTM4Ny1pLWNhbi10LWFjY2Vzcy1oaWthc2hvcC1oYXZpbmctZXJyb3ItMTA2ND90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 5 years 10 months ago [\#326783](#326783) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[i can't access hikashop having error 1064](/forum/25-install-update/901387-i-cant-access-hikashop-having-error-1064#326783 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.23 -- PHP version -- : 7.2 -- Error-message(debug-mod must be tuned on) -- : An error has occurred 1064 hi suddenly i can no longer access my hikashop dashboard in backend this is the complete error 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 '*, SUM(prod.order_product_quantity) AS total FROM x9z8ky_hikashop_order AS a LEF' at line 1 /home/.../libraries/joomla/database/driver/mysqli.php:665 please help thanks")* Hi, This means that there is a MySQL error with one of the widgets you've configured in your dashboard. A widget is basically a published report. So you can go in the menu Orders>Reports, and unpublish the widgets one by one until you figure out the one causing the problem. Then, delete it and recreate it. If you're able to reproduce the issue, then please provide a screenshot of the settings of the report before you save it. Alss, it would be great to get the MySQL query causing the error with such modification: Please edit the file /libraries/joomla/database/exception/executing.php and change the line: parent::__construct($message, $code, $previous); by: parent::__construct($message.' '.$query, $code, $previous); and this error message will also display the MySQL which generated the error, which will help us understand why this error is happening. The following user(s) said Thank You: [wrina iamwe](/forum/user/34481-wrina-iamwe "View wrina iamwe's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzkwMTM4Ny1pLWNhbi10LWFjY2Vzcy1oaWthc2hvcC1oYXZpbmctZXJyb3ItMTA2ND90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ronron](/forum/user/40399-ronron "View ronron's Profile")** - [![ronron's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/bad_baby.jpg)](/forum/user/40399-ronron "View ronron's Profile") Topic Author - [ Offline](/forum/user/40399-ronron) Less More - Posts: 490 - Thank you received: 2 - - 5 years 8 months ago [\#328848](#328848) by [ronron](/forum/user/40399-ronron "View ronron's Profile") Replied by *[ronron](/forum/user/40399-ronron "View ronron's Profile")* on topic *[i can't access hikashop having error 1064](/forum/25-install-update/901387-i-cant-access-hikashop-having-error-1064#328848 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.23 -- PHP version -- : 7.2 -- Error-message(debug-mod must be tuned on) -- : An error has occurred 1064 hi suddenly i can no longer access my hikashop dashboard in backend this is the complete error 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 '*, SUM(prod.order_product_quantity) AS total FROM x9z8ky_hikashop_order AS a LEF' at line 1 /home/.../libraries/joomla/database/driver/mysqli.php:665 please help thanks")* the problem is caused by the MAP from reports if i unpublished it, hikashop is working fine. so what do i do to fix the map? thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzkwMTM4Ny1pLWNhbi10LWFjY2Vzcy1oaWthc2hvcC1oYXZpbmctZXJyb3ItMTA2ND90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 5 years 8 months ago [\#328864](#328864) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[i can't access hikashop having error 1064](/forum/25-install-update/901387-i-cant-access-hikashop-having-error-1064#328864 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.23 -- PHP version -- : 7.2 -- Error-message(debug-mod must be tuned on) -- : An error has occurred 1064 hi suddenly i can no longer access my hikashop dashboard in backend this is the complete error 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 '*, SUM(prod.order_product_quantity) AS total FROM x9z8ky_hikashop_order AS a LEF' at line 1 /home/.../libraries/joomla/database/driver/mysqli.php:665 please help thanks")* Well, you have 3 solutions: - You turn off the "dashboard" legacy setting of the HikaShop configuration to use the new dashboard we've added a while back - You delete the report and recreate it - You do the modification I proposed 2 months ago in my previous message and you provide the MySQL query you get with the error message when the report is published. That way, we can look into the problem and try to provide a patch. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzkwMTM4Ny1pLWNhbi10LWFjY2Vzcy1oaWthc2hvcC1oYXZpbmctZXJyb3ItMTA2ND90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) 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.141 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)