title: VirtueMart Search Error
body: <p>So I am after updating Virtuemart and I am getting this error when I look for a particular product on a clients site:</p>
  
  <blockquote>
    <p>vmError: exeSortSearchListQuery Unknown column 'p.product_sku' in 'where clause' </p>
  </blockquote>
  
  <pre><code>SQL=SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id` 
  FROM `tqmux_virtuemart_products` as p 
  INNER JOIN `tqmux_virtuemart_products_en_gb` as l 
    using (`virtuemart_product_id`) 
  LEFT JOIN `tqmux_virtuemart_product_manufacturers` 
     ON p.`virtuemart_product_id` = `tqmux_virtuemart_product_manufacturers`.`virtuemart_product_id` 
  WHERE ((`l`.product_name LIKE "%anya%" 
          OR `product_sku` LIKE "%anya%" 
          OR `l`.`slug` LIKE "%anya%" 
          OR `l`.product_s_desc LIKE "%anya%" 
          OR `l`.`metadesc` LIKE "%anya%" 
          OR `p.product_sku` LIKE "%anya%" 
          OR `c.category_name` LIKE "%anya%" 
          OR `c.category_description` LIKE "%anya%" 
          OR `m.mf_name` LIKE "%anya%" 
          OR `p.product_name` LIKE "%anya%" 
          OR `p.product_s_desc` LIKE "%anya%") 
     AND `tqmux_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = 1    
     AND p.`virtuemart_vendor_id` = "1" ) 
   group by p.`virtuemart_product_id` 
   ORDER BY p.`created_on` DESC, `virtuemart_product_id` DESC 
   LIMIT 0, 20
  </code></pre>
  
  <p>Can anyone help me? Thanks.</p>
  
  <p>UPDATE</p>
  
  <p><a href="https://i.stack.imgur.com/QYnAy.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QYnAy.png" alt="enter image description here"></a></p>