News:

Support the VirtueMart project and become a member

Main Menu

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

Started by JtouchMobile.com, December 20, 2011, 17:11:13 PM

Previous topic - Next topic

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


Author of Jtouch - Mobile solution for Joomla & VirtueMart
http://www.jtouchmobile.com

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!
Author of Jtouch - Mobile solution for Joomla & VirtueMart
http://www.jtouchmobile.com

Studio 42

Hi
QuoteAND `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...

Quote from: mark001 on December 21, 2011, 16:24:37 PM
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

Quote from: Electrocity on December 23, 2011, 10:57:07 AM
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