storefront multilanguage site - error 1064 (NSP5 conflict)

GK User
Thu Jan 15, 2015 4:19 pm
Hi, I have a problem with multilanguage storefront site.
I installed quickstart in spanish, english, italian following this article:
https://www.gavick.com/documentation/jo ... art#vm3-j3
and everything works: the website had backend and frontend in spanish.

The website has only the sample data, before changing them I'm trying to install everything for the multilanguage site.
So I installed FaLang and I added english and italian languages in VirtueMart and in the "manage languages" > content I set those 3 languages.
But in the frontend when I switch from spanish (the default language) to italian or english I have an error 1046.
After reading many posts on your forum, I decided to unpublish all the NSP5 modules and everything works fine! So please tell me if there's a solution for it or if I have to not use the NSP5.

Here's the text for the 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 ') ORDER BY CONTENTR.CREATED_ON ASC LIMIT 0,8' AT LINE 40 SQL=SELECT DISTINCT CONTENT.VIRTUEMART_PRODUCT_ID AS ID, CONTENT.PRODUCT_NAME AS TITLE, CONTENT.PRODUCT_DESC AS TEXT, CONTENTR.MODIFIED_ON AS DATE, CONTENTR.CREATED_ON AS DATE_PUBLISH, CONTENTR.PRODUCT_SPECIAL AS FEATURED, MANUFACTURER.MF_NAME AS MANUFACTURER, MANUFACTURER.VIRTUEMART_MANUFACTURER_ID AS MANUFACTURER_ID FROM DDUPI_VIRTUEMART_PRODUCTS_IT_IT AS CONTENT LEFT JOIN DDUPI_VIRTUEMART_PRODUCT_CATEGORIES AS CATEGORY ON CATEGORY.VIRTUEMART_PRODUCT_ID = CONTENT.VIRTUEMART_PRODUCT_ID LEFT JOIN DDUPI_VIRTUEMART_PRODUCT_MANUFACTURERS AS MANUFACTURER_X ON CONTENT.VIRTUEMART_PRODUCT_ID = MANUFACTURER_X.VIRTUEMART_PRODUCT_ID LEFT JOIN DDUPI_VIRTUEMART_MANUFACTURERS_IT_IT AS MANUFACTURER ON MANUFACTURER_X.VIRTUEMART_MANUFACTURER_ID = MANUFACTURER.VIRTUEMART_MANUFACTURER_ID LEFT JOIN DDUPI_VIRTUEMART_PRODUCTS AS CONTENTR ON CONTENTR.VIRTUEMART_PRODUCT_ID = CONTENT.VIRTUEMART_PRODUCT_ID LEFT JOIN DDUPI_VIRTUEMART_PRODUCT_SHOPPERGROUPS AS PSGROUP ON PSGROUP.VIRTUEMART_PRODUCT_ID = CONTENT.VIRTUEMART_PRODUCT_ID LEFT JOIN DDUPI_VIRTUEMART_SHOPPERGROUPS AS SGROUP ON SGROUP.VIRTUEMART_SHOPPERGROUP_ID = PSGROUP.VIRTUEMART_SHOPPERGROUP_ID WHERE CONTENTR.PRODUCT_PARENT_ID = 0 AND CONTENTR.PUBLISHED = 1 AND ( ) ORDER BY CONTENTR.CREATED_ON ASC LIMIT 0,8;

I'm in a hurry because the site as to be ready next week...
The frontend link is here here

Thanks.
User avatar
Senior Boarder

GK User
Thu Jan 15, 2015 5:33 pm
just a quick note: I changed installation path and if you want to see the frontend pls write me I will give you user and password.
User avatar
Senior Boarder

GK User
Sat Jan 17, 2015 1:56 pm
Has someone seen this post? There is a conflict in Storefront, I think is due to the News Pro GK5 module in the multilanguage version of the template.
Thanks for your help.
User avatar
Senior Boarder

teitbite
Sat Jan 17, 2015 4:49 pm
Hi

Please check what table suffixes You have in Your database. Still a default should be en_gb, becuase it's the suffix where a default content is being used. But if You do not want to use it, just remove the vm content and make sure all module sources are change to different suffixes.

Or You can just make installation again but while selecting English (United Kingdom) during installation. I found this method much easier.
User avatar
Moderator


cron