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.