You are here:  » Getting warning messages on the detail page

Support Forum



Getting warning messages on the detail page

Submitted by domfang on Sat, 2009-11-07 16:38 in

Hi David,

I just got your script, and installed at {link saved} When I go to the detail page, I got the following warning messages:

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

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

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

Can you please help me on this?

Thanks,

Dominic

Submitted by support on Sat, 2009-11-07 19:22

Hello Dominic,

From the position of the output it looks like the related products SQL has failed for some reason, but I have never come across that scenario before as it uses exactly the same SQL as search; which is of course working fine.

Please could you download the debug version of database.php, unzip and upload to /includes/, and then view the detail page again and this will reveal the SQL that is generating the error and also the MySQL error message. I've saved the URL of your site; perhaps if you could drop me an email when it's online i'll take a look...

Cheers,
David.