When I search product by sku, description, but no result.
Virtuemart 2.0.6
SQL Queries in debug mode:
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
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.
Ok, my current version now is 2.0.20. Search on description about 1000 symbols not work.
Can help me with search description of products ?
Ok, its work for me:
I added product_desc to this line:
var $valid_BE_search_fields = array('product_name', 'product_sku', 'product_s_desc', [b]'product_desc[/b]', '`l`.`metadesc`');
yeh I think the performance hit was to big, we need to add an option, like we did for the users list