I've read that this is a very popular error. I need to use NSP with virtuemart categories to get the latest products.
My website default's language is pt-PT and virtuemart has the same language configured.
Nevertheless I get the error
VirtueMart is not installed or any VirtueMart categories are available (current language: en_gb).
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 'OR category.virtuemart_category_id = 387 OR category.virtuemart_category_id = 38' at line 39 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 #__virtuemart_products_pt_pt AS content LEFT JOIN #__virtuemart_product_categories AS category ON category.virtuemart_product_id = content.virtuemart_product_id LEFT JOIN #__virtuemart_product_manufacturers AS manufacturer_x ON content.virtuemart_product_id = manufacturer_x.virtuemart_product_id LEFT JOIN #__virtuemart_manufacturers_pt_pt AS manufacturer ON manufacturer_x.virtuemart_manufacturer_id = manufacturer.virtuemart_manufacturer_id LEFT JOIN #__virtuemart_products AS contentR ON contentR.virtuemart_product_id = content.virtuemart_product_id LEFT JOIN #__virtuemart_product_shoppergroups AS psgroup ON psgroup.virtuemart_product_id = content.virtuemart_product_id LEFT JOIN #__virtuemart_shoppergroups AS sgroup ON sgroup.virtuemart_shoppergroup_id = psgroup.virtuemart_shoppergroup_id WHERE contentR.published = 1 AND ( category.virtuemart_category_id = 274 OR category.virtuemart_category_id = 271 OR category.virtuemart_category_id = 273 OR (...)
I only need it to work in pt-PT, but I already tried to add en-GB in virtuemart configuration (tables where created) but the problem persists.
If I configure pt_PT in VM language override the error changes to
1146
Table 'XXX.#__virtuemart_categories_pt_PT' doesn't exist SQL=SELECT DISTINCT c.virtuemart_category_id AS CID FROM #__virtuemart_product_categories AS cx LEFT JOIN #__virtuemart_categories_pt_PT AS c ON cx.virtuemart_category_id = c.virtuemart_category_id LEFT JOIN #__virtuemart_products_pt_PT AS content ON cx.virtuemart_product_id = content.virtuemart_product_id LEFT JOIN #__virtuemart_categories AS cat ON c.virtuemart_category_id = cat.virtuemart_category_id WHERE ( 1=1 )
I don't know what to try anymore...
