[Skip to main content](#vessel-content) # Error on report 1064 You have an error in your SQL syntax; check the manual that ## - **[joris85](/forum/user/28344-joris85 "View joris85's Profile")** - [![joris85's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar28344.jpg)](/forum/user/28344-joris85 "View joris85's Profile") Topic Author - [ Offline](/forum/user/28344-joris85) Less More - Posts: 190 - Thank you received: 9 - - 9 years 5 months ago [\#270567](#270567) by [joris85](/forum/user/28344-joris85 "View joris85's Profile") *[Error on report 1064 You have an error in your SQL syntax; check the manual that](/forum/36-reports-statistics/890443-error-on-report-1064-you-have-an-error-in-your-sql-syntax-check-the-manual-that#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?")* was created by *[joris85](/forum/user/28344-joris85 "View joris85's Profile")* -- url of the page with the problem -- : [ waterline.nl](https://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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTA0NDMtZXJyb3Itb24tcmVwb3J0LTEwNjQteW91LWhhdmUtYW4tZXJyb3ItaW4teW91ci1zcWwtc3ludGF4LWNoZWNrLXRoZS1tYW51YWwtdGhhdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[joris85](/forum/user/28344-joris85 "View joris85's Profile")** - [![joris85's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar28344.jpg)](/forum/user/28344-joris85 "View joris85's Profile") Topic Author - [ Offline](/forum/user/28344-joris85) Less More - Posts: 190 - Thank you received: 9 - - 9 years 5 months ago [\#270568](#270568) by [joris85](/forum/user/28344-joris85 "View joris85's Profile") Replied by *[joris85](/forum/user/28344-joris85 "View joris85's Profile")* on topic *[Error on report 1064 You have an error in your SQL syntax; check the manual that](/forum/36-reports-statistics/890443-error-on-report-1064-you-have-an-error-in-your-sql-syntax-check-the-manual-that#270568 "-- 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 ![:-)](/media/kunena/emoticons/3.png ":-)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTA0NDMtZXJyb3Itb24tcmVwb3J0LTEwNjQteW91LWhhdmUtYW4tZXJyb3ItaW4teW91ci1zcWwtc3ludGF4LWNoZWNrLXRoZS1tYW51YWwtdGhhdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26400 - Thank you received: 4080 - - [](http://obsi.dev) - 9 years 5 months ago [\#270569](#270569) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Error on report 1064 You have an error in your SQL syntax; check the manual that](/forum/36-reports-statistics/890443-error-on-report-1064-you-have-an-error-in-your-sql-syntax-check-the-manual-that#270569 "-- 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?")* 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. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTA0NDMtZXJyb3Itb24tcmVwb3J0LTEwNjQteW91LWhhdmUtYW4tZXJyb3ItaW4teW91ci1zcWwtc3ludGF4LWNoZWNrLXRoZS1tYW51YWwtdGhhdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[joris85](/forum/user/28344-joris85 "View joris85's Profile")** - [![joris85's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar28344.jpg)](/forum/user/28344-joris85 "View joris85's Profile") Topic Author - [ Offline](/forum/user/28344-joris85) Less More - Posts: 190 - Thank you received: 9 - - 9 years 5 months ago - 9 years 5 months ago [\#270762](#270762) by [joris85](/forum/user/28344-joris85 "View joris85's Profile") Replied by *[joris85](/forum/user/28344-joris85 "View joris85's Profile")* on topic *[Error on report 1064 You have an error in your SQL syntax; check the manual that](/forum/36-reports-statistics/890443-error-on-report-1064-you-have-an-error-in-your-sql-syntax-check-the-manual-that#270762 "-- 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?")* 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](https://www.dropbox.com/s/n6ekptae6ks655c/Screenshot%202017-06-01%2012.06.44.png?dl=0) Do you have any idea? > Credentials removed for your own safety ! Last edit: 9 years 5 months ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile"). Reason: removing credentials for your own safety !! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTA0NDMtZXJyb3Itb24tcmVwb3J0LTEwNjQteW91LWhhdmUtYW4tZXJyb3ItaW4teW91ci1zcWwtc3ludGF4LWNoZWNrLXRoZS1tYW51YWwtdGhhdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26400 - Thank you received: 4080 - - [](http://obsi.dev) - 9 years 5 months ago [\#270776](#270776) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Error on report 1064 You have an error in your SQL syntax; check the manual that](/forum/36-reports-statistics/890443-error-on-report-1064-you-have-an-error-in-your-sql-syntax-check-the-manual-that#270776 "-- 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?")* 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. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTA0NDMtZXJyb3Itb24tcmVwb3J0LTEwNjQteW91LWhhdmUtYW4tZXJyb3ItaW4teW91ci1zcWwtc3ludGF4LWNoZWNrLXRoZS1tYW51YWwtdGhhdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[joris85](/forum/user/28344-joris85 "View joris85's Profile")** - [![joris85's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar28344.jpg)](/forum/user/28344-joris85 "View joris85's Profile") Topic Author - [ Offline](/forum/user/28344-joris85) Less More - Posts: 190 - Thank you received: 9 - - 9 years 5 months ago [\#270857](#270857) by [joris85](/forum/user/28344-joris85 "View joris85's Profile") Replied by *[joris85](/forum/user/28344-joris85 "View joris85's Profile")* on topic *[Error on report 1064 You have an error in your SQL syntax; check the manual that](/forum/36-reports-statistics/890443-error-on-report-1064-you-have-an-error-in-your-sql-syntax-check-the-manual-that#270857 "-- 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?")* We will try that, thanks! I will not add the credentials again ![:-)](/media/kunena/emoticons/3.png ":-)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTA0NDMtZXJyb3Itb24tcmVwb3J0LTEwNjQteW91LWhhdmUtYW4tZXJyb3ItaW4teW91ci1zcWwtc3ludGF4LWNoZWNrLXRoZS1tYW51YWwtdGhhdD90bXBsPW1hcmtkb3du) 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.057 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)