SQL error on home page

-- 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.

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

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.