[Skip to main content](#vessel-content) # error message ## - **[wollini2001](/forum/user/50452-wollini2001 "View wollini2001's Profile")** - [![wollini2001's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/50452-wollini2001 "View wollini2001's Profile") Topic Author - [ Offline](/forum/user/50452-wollini2001) Less More - Posts: 35 - Thank you received: 3 - - 9 years 1 week ago [\#281767](#281767) by [wollini2001](/forum/user/50452-wollini2001 "View wollini2001's Profile") *[error message](/forum/25-install-update/892625-error-message#281767 "-- HikaShop version -- : 3.2.0 -- Joomla version -- : 3.8.1 -- PHP version -- : 7.0 -- Browser(s) name and version -- : Firefox 56.0 -- 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 ' CONCAT('',prod.order_product_name, ' - ' ,c.category_name) as type FROM #__h' at line 1 Hi, I was in the control panel of Hikashop and tried to edit the window "sales of the month", because it shows nothing, but have orders. But suddenly I get this error message when I click in the control panel of 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 ' CONCAT('',prod.order_product_name, ' - ' ,c.category_name) as type FROM #__h' at line 1 screen: imgur.com/a/mO6F4 What can I do? I need urgently help please. Thanks in advance Simone")* was created by *[wollini2001](/forum/user/50452-wollini2001 "View wollini2001's Profile")* -- HikaShop version -- : 3.2.0 -- Joomla version -- : 3.8.1 -- PHP version -- : 7.0 -- Browser(s) name and version -- : Firefox 56.0 -- 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 ' CONCAT('',prod.order_product_name, ' - ' ,c.category_name) as type FROM #__h' at line 1 Hi, I was in the control panel of Hikashop and tried to edit the window "sales of the month", because it shows nothing, but have orders. But suddenly I get this error message when I click in the control panel of 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 ' CONCAT('',prod.order_product_name, ' - ' ,c.category_name) as type FROM #__h' at line 1 screen: imgur.com/a/mO6F4 What can I do? I need urgently help please. Thanks in advance Simone - [ ![errormessage.JPG](/forum/attachment/41205) ](/forum/attachment/41205 "errormessage.JPG") [ ](/forum/attachment/41205?download=1 "errormessage.JPG") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5MjYyNS1lcnJvci1tZXNzYWdlP3RtcGw9bWFya2Rvd24=) 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") - [ Away](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26396 - Thank you received: 4078 - - [](http://obsi.dev) - 9 years 1 week ago [\#281784](#281784) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[error message](/forum/25-install-update/892625-error-message#281784 "-- HikaShop version -- : 3.2.0 -- Joomla version -- : 3.8.1 -- PHP version -- : 7.0 -- Browser(s) name and version -- : Firefox 56.0 -- 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 ' CONCAT('',prod.order_product_name, ' - ' ,c.category_name) as type FROM #__h' at line 1 Hi, I was in the control panel of Hikashop and tried to edit the window "sales of the month", because it shows nothing, but have orders. But suddenly I get this error message when I click in the control panel of 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 ' CONCAT('',prod.order_product_name, ' - ' ,c.category_name) as type FROM #__h' at line 1 screen: imgur.com/a/mO6F4 What can I do? I need urgently help please. Thanks in advance Simone")* Hello, Like that it's difficult to know what is the SQL error exactly. But I have to guess that it might be related to the "type" alias. So you should edit the HikaShop "widget.php" class and replace the line: Code: $fieldtype.=' as type'; by Code: $fieldtype.=' as `type`'; And I hope that it would fix the issue. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5MjYyNS1lcnJvci1tZXNzYWdlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[wollini2001](/forum/user/50452-wollini2001 "View wollini2001's Profile")** - [![wollini2001's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/50452-wollini2001 "View wollini2001's Profile") Topic Author - [ Offline](/forum/user/50452-wollini2001) Less More - Posts: 35 - Thank you received: 3 - - 9 years 1 week ago [\#281832](#281832) by [wollini2001](/forum/user/50452-wollini2001 "View wollini2001's Profile") Replied by *[wollini2001](/forum/user/50452-wollini2001 "View wollini2001's Profile")* on topic *[error message](/forum/25-install-update/892625-error-message#281832 "-- HikaShop version -- : 3.2.0 -- Joomla version -- : 3.8.1 -- PHP version -- : 7.0 -- Browser(s) name and version -- : Firefox 56.0 -- 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 ' CONCAT('',prod.order_product_name, ' - ' ,c.category_name) as type FROM #__h' at line 1 Hi, I was in the control panel of Hikashop and tried to edit the window "sales of the month", because it shows nothing, but have orders. But suddenly I get this error message when I click in the control panel of 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 ' CONCAT('',prod.order_product_name, ' - ' ,c.category_name) as type FROM #__h' at line 1 screen: imgur.com/a/mO6F4 What can I do? I need urgently help please. Thanks in advance Simone")* Thank you for your response. Unfortunately, it didn't fix the issue. Now the error differs a little: 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 ' CONCAT('',prod.order_product_name, ' - ' ,c.category_name) as `type` FROM chdg4' at line 1 Could you help me if I would give you access to the backend? Regards, Simone Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5MjYyNS1lcnJvci1tZXNzYWdlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[wollini2001](/forum/user/50452-wollini2001 "View wollini2001's Profile")** - [![wollini2001's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/50452-wollini2001 "View wollini2001's Profile") Topic Author - [ Offline](/forum/user/50452-wollini2001) Less More - Posts: 35 - Thank you received: 3 - - 9 years 1 week ago - 9 years 1 week ago [\#281860](#281860) by [wollini2001](/forum/user/50452-wollini2001 "View wollini2001's Profile") Replied by *[wollini2001](/forum/user/50452-wollini2001 "View wollini2001's Profile")* on topic *[error message](/forum/25-install-update/892625-error-message#281860 "-- HikaShop version -- : 3.2.0 -- Joomla version -- : 3.8.1 -- PHP version -- : 7.0 -- Browser(s) name and version -- : Firefox 56.0 -- 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 ' CONCAT('',prod.order_product_name, ' - ' ,c.category_name) as type FROM #__h' at line 1 Hi, I was in the control panel of Hikashop and tried to edit the window "sales of the month", because it shows nothing, but have orders. But suddenly I get this error message when I click in the control panel of 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 ' CONCAT('',prod.order_product_name, ' - ' ,c.category_name) as type FROM #__h' at line 1 screen: imgur.com/a/mO6F4 What can I do? I need urgently help please. Thanks in advance Simone")* hi, I could solve the problem. There must be an error in the report: Sales this month. I removed this report and after that it worked again and I could create a new report: Sales this month. Regards, Simone Last edit: 9 years 1 week ago by [wollini2001](/forum/user/50452-wollini2001 "View wollini2001's Profile"). The following user(s) said Thank You: [Philip](/forum/user/34318-philip "View Philip's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5MjYyNS1lcnJvci1tZXNzYWdlP3RtcGw9bWFya2Rvd24=) 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") - [ Away](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26396 - Thank you received: 4078 - - [](http://obsi.dev) - 9 years 1 week ago [\#281844](#281844) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[error message](/forum/25-install-update/892625-error-message#281844 "-- HikaShop version -- : 3.2.0 -- Joomla version -- : 3.8.1 -- PHP version -- : 7.0 -- Browser(s) name and version -- : Firefox 56.0 -- 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 ' CONCAT('',prod.order_product_name, ' - ' ,c.category_name) as type FROM #__h' at line 1 Hi, I was in the control panel of Hikashop and tried to edit the window "sales of the month", because it shows nothing, but have orders. But suddenly I get this error message when I click in the control panel of 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 ' CONCAT('',prod.order_product_name, ' - ' ,c.category_name) as type FROM #__h' at line 1 screen: imgur.com/a/mO6F4 What can I do? I need urgently help please. Thanks in advance Simone")* Hello, Right now, it could be better if we can have the complete SQL query. If you don't know how to extract that information ; providing the "report" configuration will help us to reproduce. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5MjYyNS1lcnJvci1tZXNzYWdlP3RtcGw9bWFya2Rvd24=) 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.051 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)