You are here:  » Search query problem

Support Forum



Search query problem

Submitted by wilkins on Wed, 2006-09-06 15:34 in

Hi

At present we are setting our site, up to now we have had very little error messages, however we have just started on a new sub domain and when we use the search fuction we get

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/utodayno/public_html/fashionandlingerie/includes/database.php on line 21

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/utodayno/public_html/fashionandlingerie/includes/database.php on line 26

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/utodayno/public_html/fashionandlingerie/includes/database.php on line 21

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/utodayno/public_html/fashionandlingerie/includes/database.php on line 26

Warning: Cannot modify header information - headers already sent by (output started at /home/utodayno/public_html/fashionandlingerie/includes/database.php:21) in /home/utodayno/public_html/fashionandlingerie/html/header.php on line 6

The search is http://www.fashionandlingerie.4utoday.co.uk/search.php?q=jeans

I have just deleted the database and re installed it but its still doing the same, this is the same install on the same server as

tours.4utoday.co.uk
music.4utoday.co.uk

Both of which have the same files installed.

Has anyone come across this?

Thanks

Brent

Submitted by support on Wed, 2006-09-06 16:20

Hi Brent,

It looks like that site has $config_useRewrite set to True, but there is no .htaccess file.

On the new installations, make sure that you have copied htaccess.txt to .htaccess, and it should then work!

Cheers,
David.

Submitted by marco@flapper on Tue, 2008-04-01 07:43

Hi there,

I'm having the same problem. there is a .htaccess file. I've checked that. The weird thing is that the error message only occurs when the search returns no results.

Submitted by support on Tue, 2008-04-01 11:07

Hello Marco,

I'll email you the debug version of database.php that will show which query is causing the error.

Cheers,
David.