Author Topic: 1054 - Unknown column 'Array' in 'where clause' SQL=SELECT SQL_CALC_FOUND_ROWS  (Read 1458 times)

amlil71

  • Beginner
  • *
  • Posts: 38
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.

amlil71

  • Beginner
  • *
  • Posts: 38
Hello i resolve my problem. Thank you. regards.

cipax

  • Beginner
  • *
  • Posts: 2
  • A beginner
hi... i have same issue... please could you share your solution.
thanks in advane
stefano

borro

  • Jr. Member
  • **
  • Posts: 207
  • Wish you happiness!
    • web developing, web design
  • VirtueMart Version: a few
Hello i resolve my problem. Thank you. regards.
Hello.
Would you tell us what you did, please?
Wish you happiness!

Studio 42

  • Contributing Developer
  • Sr. Member
  • *
  • Posts: 4330
  • Joomla & Virtuemart developper
    • Studio 42 - Virtuemart & Joomla extentions
  • VirtueMart Version: 2.6 & 3
Hello i resolve my problem. Thank you. regards.
Hello.
Would you tell us what you did, please?
Certainly on updating to 3.0.18