existing site broken with sql_lay.php errors help

Nuke Cadet Joined: Feb 09, 2003 Posts: 1 Location: USA

I have not changed anything in my site and started getting the sql-layer.php error below. Can someone help me understand how to fix it. I have tried the posts here and they do not work or even the line number match up. The error codes are in the top middle column.

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /export/home5/oregonsldc/public_html/oregonffa/public_html/phpnuke55/html/includes/sql_layer.php on line 235

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /export/home5/oregonsldc/public_html/oregonffa/public_html/phpnuke55/html/includes/sql_layer.php on line 494

I have deactivated modules and blocks and still no fix.

To see please go to http://www.oregonffa.com

thanks

Posted: Sun Feb 09, 2003 7:56 pm

Open sql_layer.php and change lines 234-237 to:

Code:

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

Upload the modified sql_layer.php file and you should know get a more datailed error. Also grab Analyzer from our downloads section.