hello... i have install joomla 3.6.4 and virtuemart 3.0.18. vm come from 1.1.9 migration (paid component) , language is italian, i have an issue with some categories pages and i dont know how to solve.
pages are refer to filter plugin url... i accept suggestions to solve this problem.
sorry for my bad english and thank you in advance for your time :-D
i have 404 with this error:
Unknown column 'Array' in 'where clause' SQL=SELECT l.`virtuemart_product_id` FROM `#__virtuemart_products_it_it` as l JOIN `#__virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `#__virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` LEFT JOIN `#__virtuemart_categories_it_it` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id` LEFT JOIN `#__virtuemart_product_manufacturers` ON p.`virtuemart_product_id` = `#__virtuemart_product_manufacturers`.`virtuemart_product_id` LEFT JOIN `#__virtuemart_manufacturers_it_it` as m ON m.`virtuemart_manufacturer_id` = `#__virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` LEFT JOIN `#__virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` LEFT JOIN `#__virtuemart_product_shoppergroups` ON p.`virtuemart_product_id` = `#__virtuemart_product_shoppergroups`.`virtuemart_product_id` LEFT OUTER JOIN `#__virtuemart_shoppergroups` as s ON s.`virtuemart_shoppergroup_id` = `#__virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id` WHERE ( p.`published`="1" AND `pc`.`virtuemart_category_id` IN (861) AND ( s.`virtuemart_shoppergroup_id`= "1" OR s.`virtuemart_shoppergroup_id` IS NULL ) AND `#__virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = Array) group by p.`virtuemart_product_id` ORDER BY p.`virtuemart_product_id` ASC LIMIT 0, 999
This is strange, the `virtuemart_manufacturer_id` is an array, but we set this param as int. This is really vm3.0.18?
Hello!
Suddenly I've met some similar problem.
How did you solve your situation?
My broken SQL looks like:
Unknown column 'Array' in 'where clause'
SQL=SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id`
FROM `#__virtuemart_products` as p
INNER JOIN `#__virtuemart_products_ru_ru` as l using (`virtuemart_product_id`)
LEFT JOIN `#__virtuemart_product_manufacturers` ON p.`virtuemart_product_id` = `#__virtuemart_product_manufacturers`.`virtuemart_product_id`
WHERE ( `#__virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = Array)
group by p.`virtuemart_product_id`
ORDER BY p.virtuemart_product_id DESC
LIMIT 0, 10