VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: amlil71 on July 13, 2016, 00:20:38 AM

Title: 1054 - Unknown column 'Array' in 'where clause' SQL=SELECT SQL_CALC_FOUND_ROWS
Post by: amlil71 on July 13, 2016, 00:20:38 AM
Hello,

since i have  installed VM 3.0.17 on joomla 3.5 i have this error on all my category page when i want to add the first product of the category page

1054 - 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_fr_fr` as l using (`virtuemart_product_id`) LEFT JOIN `#__virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id` LEFT JOIN `#__virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` WHERE ( `pc`.`virtuemart_category_id` = Array AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`="1" ) group by p.`virtuemart_product_id` ORDER BY `pc`.`ordering` ASC, `product_name` ASC LIMIT 0, 12


i don't know how to solve this problem.

Thank you.

regards.
Title: Re: 1054 - Unknown column 'Array' in 'where clause' SQL=SELECT SQL_CALC_FOUND_ROWS
Post by: amlil71 on July 13, 2016, 13:16:05 PM
Hello i resolve my problem. Thank you. regards.
Title: Re: 1054 - Unknown column 'Array' in 'where clause' SQL=SELECT SQL_CALC_FOUND_ROWS
Post by: cipax on October 28, 2016, 16:11:17 PM
hi... i have same issue... please could you share your solution.
thanks in advane
stefano
Title: Re: 1054 - Unknown column 'Array' in 'where clause' SQL=SELECT SQL_CALC_FOUND_ROWS
Post by: borro on December 23, 2016, 14:10:23 PM
Quote from: amlil71 on July 13, 2016, 13:16:05 PM
Hello i resolve my problem. Thank you. regards.
Hello.
Would you tell us what you did, please?
Title: Re: 1054 - Unknown column 'Array' in 'where clause' SQL=SELECT SQL_CALC_FOUND_ROWS
Post by: Studio 42 on December 23, 2016, 14:38:06 PM
Quote from: borro on December 23, 2016, 14:10:23 PM
Quote from: amlil71 on July 13, 2016, 13:16:05 PM
Hello i resolve my problem. Thank you. regards.
Hello.
Would you tell us what you did, please?
Certainly on updating to 3.0.18