My WEbsites got an Error right up top

christian · **My WEbsites got an Error right up top -** 03-19-2003, 04:02 PM

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/somewhat/public_html/includes/sql_layer.php on line 253

that is what i get on top at

http://www.somewhatlucky.com

please help, i went to the error and it talks about rows in mysql, something that i have no idea what its talking about, i just need to get rid of it..

Martin · 03-19-2003, 05:36 PM

I would start by disabling one block at a time to see if one of them (the ones you added) is the problem. Then try the modules one at a time (also the ones you added).

dar63 · 03-19-2003, 05:48 PM

Try disabling banners.

christian · 03-20-2003, 02:04 AM

still no luck, any other advice?

Martin · 03-20-2003, 10:18 AM

It's possible one of your database tables has lost data. What is the newest addition to your database you added which included a database installer.php or sql file?

mikem · 03-20-2003, 04:41 PM

Turn on debugging to better understand the error

open
Open sql_layer.php go to around line 300 and change:

Code:

case "MySQL": 
$row = mysql_fetch_row($res); 
return $row; 
break;;

to this

Code:

case "MySQL": 
if ($row = mysql_fetch_row($res)) { 
return $row; 
} else { 
print (mysql_error()); 
} 
break;;

mikem