Product search is not working - mod_virtuemart_search

[jurdygeorge]

Hi

In my site, the Product Search [mod_virtuemart_search ] is not working. If searching for product( whether search is name or SKU ) it shows 'Your search returned 0 results.'.

I had gone through the forum and could see so many people have the same issue. Somebody get fixed it but they don't know how it happened and YOOsearch is not working in VM. Tried with SEF off and no results.

Site URL : http://rbgdistributors.com/
Attaching the module config settings screen shot.

How can I fix this? Pls help...

Thanks
Jurdy

[attachment cleanup by admin]

[Forrest]

Do you have the Virtuemart Extended Search Plugin enabled and configured?

[jurdygeorge]

yes,configured [attached screen shot] . But the product search shows the same message '
Your search returned 0 results.
'

What I have to do next ?

Thanks

Jurdy

[attachment cleanup by admin]

[Forrest]

Is this a problem with just the mod? Or when you try another search on the actual search page you get the same problem?

[jurdygeorge]

I enabled mod_search and that is working. So I disabled the mod_virtuemart_search temporarily. Once it get working I'll enable this.

Whats wrong with the mod_virtuemart_search. Is it a problem with module or my configuration ?

Expecting we can get it working soon.

Thanks 
Jurdy

[Forrest]

Might try the nightly build of VM, and upload the mod files? I use mod_YooSearch for all my sites, so I'm of no help.

[jacarp212]

I have this same issue. This thread says it is solved, but I don't see a fix. Can anyone help me, please? I search for anything and I get 0 results.

[Forrest]

This is not a solved topic. Use the mod_search instead of mod_virturemart_search.

[tom]

I had this working  3 weeks ago, and now it does work. I don't think anything  has changed.
It used to find products and list them with the thumbnail and prices, now it just says:Your search returned 0 results.

I have uninstalled and reinstalled both mod virtuemart search and Virtuemart Extended Search Plugin.

i have Add suffix to URLs turned off.

Could it be a setting  in  the Products list?

UPDATE: it does work if i search for 1 or 2 letters ie: a or ab, z etc.. but no more??

[tom]

FIXED:
i turned on  debug i VM and saw a mysql error:
500 - JDatabaseMySQL::query: 1104 - The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=#



Fixed.
thanks to this post:
http://forum.virtuemart.net/index.php?topic=62207.30

in the Joomla file mysql.php (libraries>joomla>databse>databse)
I found a line which says:
$this->setQuery( "SET sql_mode = 'MYSQL40'" );
(around line 153).
UNDER this line I added:
$this->setQuery( "SET OPTION SQL_BIG_SELECTS=1" );

so it now reads:
$this->setQuery( "SET sql_mode = 'MYSQL40'" );
         $this->setQuery( "SET OPTION SQL_BIG_SELECTS=1" );
         $this->query();

blimey!

[plant802]

Hmm..I have same problem - 500 - JDatabaseMySQL::query: 1064 errors and this:

"...UPDATE: it does work if i search for 1 or 2 letters ie: a or ab, z etc.. but no more??..."

But the update to the mysql.php file did not help. Anyone else find anything?

[plant802]

Also, below is what is being spit back at me. Can anyone help or point me in the right direction?

=============

500 - JDatabaseMySQL::query: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 25 SQL=SELECT COUNT(DISTINCT `jos_vm_product`.`product_sku`) as num_rows FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`) LEFT JOIN `jos_vm_product_price` ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id` WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id` AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id` AND ( (`jos_vm_product`.`product_name` LIKE '%Jazz%' OR (`jos_vm_product`.`product_artist` LIKE '%Jazz%' OR `jos_vm_product`.`product_url` LIKE '%Jazz%' OR `jos_vm_category`.`category_name` LIKE '%Jazz%' OR `jos_vm_product`.`product_sku` LIKE '%Jazz%' OR `jos_vm_product`.`product_s_desc` LIKE '%Jazz%' OR `jos_vm_product`.`product_desc` LIKE '%Jazz%') ) and ( (`jos_vm_product`.`product_name` LIKE '%Sun%' OR (`jos_vm_product`.`product_artist` LIKE '%Sun%' OR `jos_vm_product`.`product_url` LIKE '%Sun%' OR `jos_vm_category`.`category_name` LIKE '%Sun%' OR `jos_vm_product`.`product_sku` LIKE '%Sun%' OR `jos_vm_product`.`product_s_desc` LIKE '%Sun%' OR `jos_vm_product`.`product_desc` LIKE '%Sun%') ) AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id` AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL) AND `jos_vm_shopper_group`.`default` = 1 AND `product_parent_id`=0 AND `product_publish`='Y' AND `category_publish`='Y' AND product_in_stock > 0

[cmss]

Thank you for posting the solution with the big result setting!