Error 1064 when selecting second language

GK User
Mon Apr 06, 2015 7:24 pm
Hi,
I've installed quicstart package for Gavic Storefront template. I made a second language setup, everything looked good, flags showed up, but when I went to preview my site with second language (Estonian) I got this error. Where or how could I find a solution for this issue? What might be wrong? Site is: www.finehair.eu
User avatar
Fresh Boarder

GK User
Tue Apr 07, 2015 7:34 am
Hello,

Your issue is caused by fact that you have no products in your second language and the NSP GK5 module is unable to show products (tables are empty). Please create products in your new language or disable the NSP GK5 module instances for this language.
User avatar
Administrator

GK User
Tue Apr 07, 2015 5:54 pm
Hi,
I tried to add a product from admin, but could not save new product, the button for SAVE does not work. Then I went to database and created two products, but the problem still exists. I also copied this SQL script what is pointed in error message. The script is:
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 fine_virtuemart_products_et_ee AS content LEFT JOIN fine_virtuemart_product_categories AS category ON category.virtuemart_product_id = content.virtuemart_product_id LEFT JOIN fine_virtuemart_product_manufacturers AS manufacturer_x ON content.virtuemart_product_id = manufacturer_x.virtuemart_product_id LEFT JOIN fine_virtuemart_manufacturers_et_ee AS manufacturer ON manufacturer_x.virtuemart_manufacturer_id = manufacturer.virtuemart_manufacturer_id LEFT JOIN fine_virtuemart_products AS contentR ON contentR.virtuemart_product_id = content.virtuemart_product_id LEFT JOIN fine_virtuemart_product_shoppergroups AS psgroup ON psgroup.virtuemart_product_id = content.virtuemart_product_id LEFT JOIN fine_virtuemart_shoppergroups AS sgroup ON sgroup.virtuemart_shoppergroup_id = psgroup.virtuemart_shoppergroup_id WHERE contentR.product_parent_id = 0 AND contentR.published = 1 AND ( category.virtuemart_category_id = ) ORDER BY contentR.created_on ASC LIMIT 0,8;

in the last line I added category id what does exists in my database, but script returned empty, so it seems like there is a problem somwhere in database scripts ? any ideas?
User avatar
Fresh Boarder

GK User
Wed Apr 08, 2015 1:21 pm
The back-end problem seems to be a bug in VirtueMart - please consult it with the VM support. Regarding the Query issue - it won't work, because you haven't created a category so the category id at the end of query is empty and your products are referencing to categories in the other language.
User avatar
Administrator


cron