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?