Bug with searching products by sku, description... in Admin Panel

[Pizda]

When I search product by sku, description, but no result.
Virtuemart 2.0.6

SQL Queries in debug mode:

Code Select Expand

SELECT SQL_CALC_FOUND_ROWS *
  FROM `qoj62_virtuemart_products_en_gb` as l JOIN `qoj62_virtuemart_products` AS p using (`virtuemart_product_id`)
  WHERE (`product_name` LIKE "%8D66D12033%")
  group by p.`virtuemart_product_id`
  ORDER BY p.`created_on` DESC
  LIMIT 0, 10
SELECT FOUND_ROWS()
SELECT SQL_CALC_FOUND_ROWS *
  FROM `qoj62_virtuemart_products_en_gb` as l JOIN `qoj62_virtuemart_products` AS p using (`virtuemart_product_id`)
  WHERE (`product_name` LIKE "%8D66D12033%")
  group by p.`virtuemart_product_id`
  ORDER BY p.`created_on` DESC
  LIMIT 0, 10

[jenkinhill]

Why are you using such an old version of VirtueMart? It could be a bug in that version.  Versions before 2.0.10 are considered as insecure so updating is advised, 2.0.22 is about to be released.

[Pizda]

Ok, my current version now is 2.0.20. Search on description about 1000 symbols not work.

[Pizda]

Can help me with search description of products ?

[Pizda]

Ok, its work for me:
I added product_desc to this line:

Code Select Expand

var $valid_BE_search_fields = array('product_name', 'product_sku', 'product_s_desc', [b]'product_desc[/b]', '`l`.`metadesc`');

[Milbo]

yeh I think the performance hit was to big, we need to add an option, like we did for the users list