[Skip to main content](#vessel-content) # SQL error on home page ## - **[ajit.neos](/forum/user/37765-ajit-neos "View ajit.neos's Profile")** - [![ajit.neos's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/37765-ajit-neos "View ajit.neos's Profile") Topic Author - [ Offline](/forum/user/37765-ajit-neos) Less More - Posts: 2 - Thank you received: 0 - - 11 years 4 months ago [\#206115](#206115) by [ajit.neos](/forum/user/37765-ajit-neos "View ajit.neos's Profile") *[SQL error on home page](/forum/3-bug-report/877765-sql-error-on-home-page#206115 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.4 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : 1064, You have an error in your sql syntaxCHECK THE MANUAL THAT CORRESPONDS TO YOUR MYSQL SERVER VERSION FOR THE RIGHT SYNTAX TO USE NEAR ') AND CATEGORY.CATEGORY_PUBLISHED = '1' ORDER BY CONTENT.PRODUCT_ID AS' AT LINE 19 SQL=SELECT DISTINCT CONTENT.PRODUCT_ID AS ID, CONTENT.PRODUCT_ALIAS AS ALIAS, CONTENT.PRODUCT_MSRP AS PRODUCT_MSRP, CATEGORY.CATEGORY_ID AS CID, CATEGORY.CATEGORY_NAME AS CAT_NAME, CATEGORY.CATEGORY_ALIAS AS CAT_ALIAS FROM TLMW3_HIKASHOP_PRODUCT AS CONTENT LEFT JOIN TLMW3_HIKASHOP_PRODUCT_CATEGORY AS CATEGORY_XREF ON CATEGORY_XREF.PRODUCT_ID = CONTENT.PRODUCT_ID LEFT JOIN TLMW3_HIKASHOP_CATEGORY AS CATEGORY ON CATEGORY_XREF.CATEGORY_ID = CATEGORY.CATEGORY_ID WHERE () AND CATEGORY.CATEGORY_PUBLISHED = '1' ORDER BY CONTENT.PRODUCT_ID ASC Hi there, A client of mine recently updated their hikashop component and this has caused the home page to throw an error (#1064). I have checked the Database inside Joomla (Extension manager) as well as checked the database inside Hikashop, both showing up as OK. Any ideas on how to fix this? I've gone through similar threads to this one and all the changes recommended on that has already been implemented into this version of Hikashop. URL of site - hardy.realstrategy.net.nz URL of page that works - hardy.realstrategy.net.nz/about and any other page Thanks in advance")* was created by *[ajit.neos](/forum/user/37765-ajit-neos "View ajit.neos's Profile")* -- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.4 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : 1064, You have an error in your sql syntaxCHECK THE MANUAL THAT CORRESPONDS TO YOUR MYSQL SERVER VERSION FOR THE RIGHT SYNTAX TO USE NEAR ') AND CATEGORY.CATEGORY_PUBLISHED = '1' ORDER BY CONTENT.PRODUCT_ID AS' AT LINE 19 SQL=SELECT DISTINCT CONTENT.PRODUCT_ID AS ID, CONTENT.PRODUCT_ALIAS AS ALIAS, CONTENT.PRODUCT_MSRP AS PRODUCT_MSRP, CATEGORY.CATEGORY_ID AS CID, CATEGORY.CATEGORY_NAME AS CAT_NAME, CATEGORY.CATEGORY_ALIAS AS CAT_ALIAS FROM TLMW3_HIKASHOP_PRODUCT AS CONTENT LEFT JOIN TLMW3_HIKASHOP_PRODUCT_CATEGORY AS CATEGORY_XREF ON CATEGORY_XREF.PRODUCT_ID = CONTENT.PRODUCT_ID LEFT JOIN TLMW3_HIKASHOP_CATEGORY AS CATEGORY ON CATEGORY_XREF.CATEGORY_ID = CATEGORY.CATEGORY_ID WHERE () AND CATEGORY.CATEGORY_PUBLISHED = '1' ORDER BY CONTENT.PRODUCT_ID ASC Hi there, A client of mine recently updated their hikashop component and this has caused the home page to throw an error (#1064). I have checked the Database inside Joomla (Extension manager) as well as checked the database inside Hikashop, both showing up as OK. Any ideas on how to fix this? I've gone through similar threads to this one and all the changes recommended on that has already been implemented into this version of Hikashop. URL of site - hardy.realstrategy.net.nz URL of page that works - hardy.realstrategy.net.nz/about and any other page Thanks in advance Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84Nzc3NjUtc3FsLWVycm9yLW9uLWhvbWUtcGFnZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 11 years 4 months ago [\#206129](#206129) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[SQL error on home page](/forum/3-bug-report/877765-sql-error-on-home-page#206129 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.4 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : 1064, You have an error in your sql syntaxCHECK THE MANUAL THAT CORRESPONDS TO YOUR MYSQL SERVER VERSION FOR THE RIGHT SYNTAX TO USE NEAR ') AND CATEGORY.CATEGORY_PUBLISHED = '1' ORDER BY CONTENT.PRODUCT_ID AS' AT LINE 19 SQL=SELECT DISTINCT CONTENT.PRODUCT_ID AS ID, CONTENT.PRODUCT_ALIAS AS ALIAS, CONTENT.PRODUCT_MSRP AS PRODUCT_MSRP, CATEGORY.CATEGORY_ID AS CID, CATEGORY.CATEGORY_NAME AS CAT_NAME, CATEGORY.CATEGORY_ALIAS AS CAT_ALIAS FROM TLMW3_HIKASHOP_PRODUCT AS CONTENT LEFT JOIN TLMW3_HIKASHOP_PRODUCT_CATEGORY AS CATEGORY_XREF ON CATEGORY_XREF.PRODUCT_ID = CONTENT.PRODUCT_ID LEFT JOIN TLMW3_HIKASHOP_CATEGORY AS CATEGORY ON CATEGORY_XREF.CATEGORY_ID = CATEGORY.CATEGORY_ID WHERE () AND CATEGORY.CATEGORY_PUBLISHED = '1' ORDER BY CONTENT.PRODUCT_ID ASC Hi there, A client of mine recently updated their hikashop component and this has caused the home page to throw an error (#1064). I have checked the Database inside Joomla (Extension manager) as well as checked the database inside Hikashop, both showing up as OK. Any ideas on how to fix this? I've gone through similar threads to this one and all the changes recommended on that has already been implemented into this version of Hikashop. URL of site - hardy.realstrategy.net.nz URL of page that works - hardy.realstrategy.net.nz/about and any other page Thanks in advance")* Hi, Please turn on the Joomla debug mode and set the debug level to "maximum" in order to have more informations, to know from where this request is executed. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84Nzc3NjUtc3FsLWVycm9yLW9uLWhvbWUtcGFnZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ajit.neos](/forum/user/37765-ajit-neos "View ajit.neos's Profile")** - [![ajit.neos's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/37765-ajit-neos "View ajit.neos's Profile") Topic Author - [ Offline](/forum/user/37765-ajit-neos) Less More - Posts: 2 - Thank you received: 0 - - 11 years 4 months ago [\#206271](#206271) by [ajit.neos](/forum/user/37765-ajit-neos "View ajit.neos's Profile") Replied by *[ajit.neos](/forum/user/37765-ajit-neos "View ajit.neos's Profile")* on topic *[SQL error on home page](/forum/3-bug-report/877765-sql-error-on-home-page#206271 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.4 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : 1064, You have an error in your sql syntaxCHECK THE MANUAL THAT CORRESPONDS TO YOUR MYSQL SERVER VERSION FOR THE RIGHT SYNTAX TO USE NEAR ') AND CATEGORY.CATEGORY_PUBLISHED = '1' ORDER BY CONTENT.PRODUCT_ID AS' AT LINE 19 SQL=SELECT DISTINCT CONTENT.PRODUCT_ID AS ID, CONTENT.PRODUCT_ALIAS AS ALIAS, CONTENT.PRODUCT_MSRP AS PRODUCT_MSRP, CATEGORY.CATEGORY_ID AS CID, CATEGORY.CATEGORY_NAME AS CAT_NAME, CATEGORY.CATEGORY_ALIAS AS CAT_ALIAS FROM TLMW3_HIKASHOP_PRODUCT AS CONTENT LEFT JOIN TLMW3_HIKASHOP_PRODUCT_CATEGORY AS CATEGORY_XREF ON CATEGORY_XREF.PRODUCT_ID = CONTENT.PRODUCT_ID LEFT JOIN TLMW3_HIKASHOP_CATEGORY AS CATEGORY ON CATEGORY_XREF.CATEGORY_ID = CATEGORY.CATEGORY_ID WHERE () AND CATEGORY.CATEGORY_PUBLISHED = '1' ORDER BY CONTENT.PRODUCT_ID ASC Hi there, A client of mine recently updated their hikashop component and this has caused the home page to throw an error (#1064). I have checked the Database inside Joomla (Extension manager) as well as checked the database inside Hikashop, both showing up as OK. Any ideas on how to fix this? I've gone through similar threads to this one and all the changes recommended on that has already been implemented into this version of Hikashop. URL of site - hardy.realstrategy.net.nz URL of page that works - hardy.realstrategy.net.nz/about and any other page Thanks in advance")* Hi, here is the information from max debugging Error 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 ') AND category.category_published = '1' ORDER BY content.product_id AS' at line 19 SQL=EXPLAIN SELECT DISTINCT content.product_id AS id, content.product_alias AS alias, content.product_msrp AS product_msrp, category.category_id AS cid, category.category_name AS cat_name, category.category_alias AS cat_alias FROM tlmw3_hikashop_product AS content LEFT JOIN tlmw3_hikashop_product_category AS category_xref ON category_xref.product_id = content.product_id LEFT JOIN tlmw3_hikashop_category AS category ON category_xref.category_id = category.category_id WHERE () AND category.category_published = '1' ORDER BY content.product_id ASC Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/modules/mod_news_pro_gk5/data_sources/com_hikashop/model.php:237 JROOT/modules/mod_news_pro_gk5/helper.php:108 JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:32 JROOT/libraries/cms/module/helper.php:190 JROOT/modules/mod_tabs_gk5/tmpl/module.php:21 JROOT/modules/mod_tabs_gk5/helper.php:213 JROOT/modules/mod_tabs_gk5/tmpl/default.php:35 JROOT/modules/mod_tabs_gk5/helper.php:202 JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php:24 JROOT/libraries/cms/module/helper.php:190 JROOT/libraries/joomla/document/html/renderer/module.php:103 JROOT/libraries/joomla/document/html/renderer/modules.php:43 JROOT/libraries/joomla/document/html/html.php:411 JROOT/libraries/joomla/document/html/html.php:697 JROOT/libraries/joomla/document/html/html.php:477 JROOT/libraries/cms/application/cms.php:1059 JROOT/libraries/cms/application/site.php:729 JROOT/libraries/cms/application/cms.php:258 JROOT/index.php:40 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84Nzc3NjUtc3FsLWVycm9yLW9uLWhvbWUtcGFnZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 11 years 4 months ago [\#206309](#206309) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[SQL error on home page](/forum/3-bug-report/877765-sql-error-on-home-page#206309 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.4 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : 1064, You have an error in your sql syntaxCHECK THE MANUAL THAT CORRESPONDS TO YOUR MYSQL SERVER VERSION FOR THE RIGHT SYNTAX TO USE NEAR ') AND CATEGORY.CATEGORY_PUBLISHED = '1' ORDER BY CONTENT.PRODUCT_ID AS' AT LINE 19 SQL=SELECT DISTINCT CONTENT.PRODUCT_ID AS ID, CONTENT.PRODUCT_ALIAS AS ALIAS, CONTENT.PRODUCT_MSRP AS PRODUCT_MSRP, CATEGORY.CATEGORY_ID AS CID, CATEGORY.CATEGORY_NAME AS CAT_NAME, CATEGORY.CATEGORY_ALIAS AS CAT_ALIAS FROM TLMW3_HIKASHOP_PRODUCT AS CONTENT LEFT JOIN TLMW3_HIKASHOP_PRODUCT_CATEGORY AS CATEGORY_XREF ON CATEGORY_XREF.PRODUCT_ID = CONTENT.PRODUCT_ID LEFT JOIN TLMW3_HIKASHOP_CATEGORY AS CATEGORY ON CATEGORY_XREF.CATEGORY_ID = CATEGORY.CATEGORY_ID WHERE () AND CATEGORY.CATEGORY_PUBLISHED = '1' ORDER BY CONTENT.PRODUCT_ID ASC Hi there, A client of mine recently updated their hikashop component and this has caused the home page to throw an error (#1064). I have checked the Database inside Joomla (Extension manager) as well as checked the database inside Hikashop, both showing up as OK. Any ideas on how to fix this? I've gone through similar threads to this one and all the changes recommended on that has already been implemented into this version of Hikashop. URL of site - hardy.realstrategy.net.nz URL of page that works - hardy.realstrategy.net.nz/about and any other page Thanks in advance")* Hi, That's what I was thinking, it is not a core HikaShop MySQL request, but it is coming from an external module. It seems to be the module mod_tabs_gk5 or mod_news_pro_gk5 which is causing this issue, so please contact the module provider. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84Nzc3NjUtc3FsLWVycm9yLW9uLWhvbWUtcGFnZT90bXBsPW1hcmtkb3du) 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.276 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)