simple search problem

[thehandyman]

Hi,

Advanced search works fine, as expected, but simple search does not. I got the following error returned:


Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/finger/fingerfittingproducts.com/squirrelcart/functions/get_records.func on line 16

Any suggestions on how to fix this?

Thanks!

[thehandyman]

P.S. error_reporting is (E_ALL ^ E_NOTICE)

[Jamie]

Hi,

That error is very generic and difficult to troubleshoot by itself. Can you give us some more information? We need:

URL to your cart page
exact text you are searching for
version of the cart you are running

If you do not want to post it here, you can do it via a helpdesk ticket.

Thanks,
Jamie

[thehandyman]

URL: http://d14440.u323.jbandassociates.com/cart.php

Searching for text "9000" (without the quotes). This number appears both in the product description and keyword field of one of the products.

Ver. 1.0.9

Thanks!

[thehandyman]

<bump>

[Jamie]

We can see the problem happening. We will need more information to troubleshoot this. Please open a helpdesk ticket, and provide the following:

URL to this post for reference
URL to your cart page
Cart admin account and password
FTP account and password

Thanks,
Jamie

[thehandyman]

Done, thanks.

[Jamie]

OK...I forgot about this one. It's a bug. There is a workaround posted in this bug report.

http://www.ldev.com/forums/showthread.php?s=&threadid=384&highlight=search

It is not the final fix, but will make it work OK.

Thanks,
Jamie