VM2.0.0 + J173: Product search on front-end?!

[JtouchMobile.com]

Hallo,

This is not a bug, just a question for you, VM team 

Seem that with this query:

===
SELECT SQL_CALC_FOUND_ROWS * FROM `k64fy_virtuemart_products_en_gb` as l JOIN `k64fy_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `k64fy_virtuemart_product_categories` ON p.`virtuemart_product_id` = `k64fy_virtuemart_product_categories`.`virtuemart_product_id` LEFT JOIN `k64fy_virtuemart_categories_en_gb` as c ON c.`virtuemart_category_id` = `k64fy_virtuemart_product_categories`.`virtuemart_category_id` LEFT JOIN `k64fy_virtuemart_product_manufacturers` ON p.`virtuemart_product_id` = `k64fy_virtuemart_product_manufacturers`.`virtuemart_product_id` LEFT JOIN `k64fy_virtuemart_manufacturers_en_gb` as m ON m.`virtuemart_manufacturer_id` = `k64fy_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` LEFT JOIN `k64fy_virtuemart_product_shoppergroups` ON p.`virtuemart_product_id` = `k64fy_virtuemart_product_shoppergroups`.`virtuemart_product_id` LEFT OUTER JOIN `k64fy_virtuemart_shoppergroups` as s ON s.`virtuemart_shoppergroup_id` = `k64fy_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id` WHERE ( `product_sku` LIKE "%%" OR `product_name` LIKE "%%" AND `k64fy_virtuemart_product_categories`.`virtuemart_category_id` = -2 AND (s.`virtuemart_shoppergroup_id`= "2" OR ISNULL(s.`virtuemart_shoppergroup_id`) )) group by p.`virtuemart_product_id` ORDER BY p.virtuemart_product_id ASC
===

Will return all products whatever the value of virtuemart_category_id ?
It happens when I try to call this function
===
$VirtueMartModelProduct->sortSearchListQuery(false,$virtuemart_category_id,false,false);
===
But form another front-end extensions

[mark001]

Hi,

Joomla! 1.5.25 + VM2.0 "stable?"
There is no any message if a serach keyword is shorter than 4 characters. If I'll type 4 characters keywords I'm getting results but if I'll type 3 characters word I'm getting only catergories - no message like "Sorry, your keyword is too short".

I understand VM team is under a lot of pressure but I'm working with VM2 from Monday night and each hour I'm finding new bugs. Sorry guys but maybe you released it to early? It should be still in alpha or beta phase but not stable!

Thanks!

[JtouchMobile.com]

@mark001: I think that these will have a lot of developers want to use a "stable" version, and here it is, then -> more bugs found -> more (wish) bug report to this VM forum -> speeding on find/fix bugs -> more "stable" to the Product?!
Just for fun, friend!

[Studio 42]

Hi

AND `k64fy_virtuemart_product_categories`.`virtuemart_category_id` = -2

How you can get a "-2" ?
Self made query, hacked core ?
Or simply on using standard search...

Hi,

Joomla! 1.5.25 + VM2.0 "stable?"
There is no any message if a serach keyword is shorter than 4 characters. If I'll type 4 characters keywords I'm getting results but if I'll type 3 characters word I'm getting only catergories - no message like "Sorry, your keyword is too short".

I understand VM team is under a lot of pressure but I'm working with VM2 from Monday night and each hour I'm finding new bugs. Sorry guys but maybe you released it to early? It should be still in alpha or beta phase but not stable!

Thanks!

It's no chars limit to 3 you can use an empty string and must have result.

[mark001]

It's no chars limit to 3 you can use an empty string and must have result.

Hi,

please, belive me I got no results or any message like "No results found or keyword to short". If this is about an override can you please let me know when can I add an information about no results?
I'm using J!1.5.25 and VM2.0.

Thanks!

[Studio 42]

I have add a fix in last SVN files