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

Started by Pizda, July 08, 2013, 23:05:03 PM

Previous topic - Next topic

Pizda

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

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.
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Pizda

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

Pizda


Pizda

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`');

Milbo

yeh I think the performance hit was to big, we need to add an option, like we did for the users list
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/