[Skip to main content](#vessel-content)
# Profile for ajit.neos
##
[](/forum/user/37765-ajit-neos "View ajit.neos's Profile")
**[ Offline](/forum/user/37765-ajit-neos)**
- **User Type:** User
- **Register Date:** 25 Jun 2015
- **Last login:** 11 years 4 months ago
- **Time Zone:** UTC +0:00
- **Local Time:** 00:20
- **Posts:** 2
- **Profile views:** 36
- **Gender:** Unknown
- **Birthdate:** Unknown
- Posts
# ajit.neos recent posts (2 messages )
All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year
| [ ](#forumbottom) | Subject | Replies / Views | Last Post | [ ](#forumtop) |
|---|---|---|---|---|
| [](/forum/3-bug-report/877765-sql-error-on-home-page#206271) | [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") Category: [Bug Report](/forum/3-bug-report "Please report any bugs or errors here.") Topic started 11 years 4 months ago, by [ajit.neos](/forum/user/37765-ajit-neos "View ajit.neos's Profile") [Last Post](/forum/3-bug-report/877765-sql-error-on-home-page#206309 "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.") 11 years 4 months ago by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") | Replies:3 Views:925 | [Last Post](/forum/3-bug-report/877765-sql-error-on-home-page#206309 "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.") by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") 11 years 4 months ago |
| [](/forum/3-bug-report/877765-sql-error-on-home-page#206115) | [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") Category: [Bug Report](/forum/3-bug-report "Please report any bugs or errors here.") Topic started 11 years 4 months ago, by [ajit.neos](/forum/user/37765-ajit-neos "View ajit.neos's Profile") [Last Post](/forum/3-bug-report/877765-sql-error-on-home-page#206309 "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.") 11 years 4 months ago by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") | Replies:3 Views:925 | [Last Post](/forum/3-bug-report/877765-sql-error-on-home-page#206309 "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.") by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") 11 years 4 months ago |
[](/forum/topics/feed/mode-topics?format=feed&type=rss)
Time to create page: 0.107 seconds
[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
[](#top)