You are here:  » no results found

Support Forum



no results found

Submitted by kajoku on Thu, 2007-08-09 02:34 in

Hi David, a simple question please.

I just uploaded 4 new feeds for this site http://applemac.deal-snatcher.com/

After doing a search http://applemac.deal-snatcher.com/search.php?q=apple+iMac&Submit=Search

as I usually do it said "no results found" and displayed nothing. In my admin section for the feeds it does not show the product count as it used to. Any ideas please.

Any suggestions will be appreciated.

Regards
ken

Submitted by support on Thu, 2007-08-09 09:44

Hi Ken,

This sounds like you may have hit MySQL's "50% rule" regarding words that are not indexed. This can happen sometimes on sites that are very specific and certain words appear in almost every product name.

The solution is to use the original search method for all queries instead of the full text index. To do this, look for the following code on line 63 of search.php:

if (strlen($parts[0]) > 3)

...and change this to:

if (0)

This will force the original search method for all queries and should return exact match results (spaces ignored) as expected.

Hope this helps,
Cheers,
David.

Submitted by kajoku on Thu, 2007-08-09 11:37

Hi again, I made the changes you suggested but it still doesnt work. I have a feeling it has something to do with my feeds. What can you suggest please as it was working fine before. What I have done recently is to upload up to date feeds. But in the admin area it doesn't have a product quantity displayed.

Can you please make any suggestions.

Thank you
Ken

Submitted by support on Thu, 2007-08-09 12:56

Hello Ken,

That sounds like the format of the feed might have changed. To check this, re-register the feed. Normally, of course, you do not need to do this, but this is what it sounds like at the moment.

If that doesn't work, check that the feed has actually got products in it. It is not unusual for a merchant or affiliate network's feed generator to have a temporary problem, and you end up downloading an empty feed! Check the size, and if possible view the file to confirm that it looks ok...

Cheers,
David.

Submitted by kajoku on Thu, 2007-08-09 14:59

ok I will try that and let you know. Thank you

Submitted by kajoku on Thu, 2007-08-09 16:00

Thanks David its working fine now.
Ken

Submitted by kajoku on Thu, 2007-08-09 16:02

Thanks David its working fine now, I did not have to carry out the previous edit. Had to carefully match the price fields in all the feeds.

:)

Regards
K