Mysql and PHP problem

yunus.raza · 08-28-2006, 07:18 AM

Hi,

I have been running my PHP-Nuke site on my Red Hat 7.3 for quite some years now.

All of a sudden i am seeing the following error at the top of my page. Site however is working fine. But i want to remove this error as it doesnt looks good on the site, which is a part of Intranet of the company.

The error at the top of the page looks like this:

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

What shall i do to fix this issue??

Thanks
Yunus

nephish · 08-28-2006, 07:56 AM

i usually get this when i have a syntax error in my php code, like a mis-spelled table name, and what-not.
mysql_num_rows will have an argument in it that matches a query you ran.

like this

Code:

$query = mysql_query("SELECT `name` FROM `customers` WHERE `age` > 35 ");
$how_many = mysql_num_rows($query); // tells how many customers are over 35 years old

Just check those lines in the script in the error output message and make sure that everything is set up right.

leandean · 08-29-2006, 12:44 AM

A corrupted table will also cause this error. Run mysqlcheck and if it shows an error run mysql> fix table <name>.

yunus.raza · 08-29-2006, 03:02 AM

Yes it was a table issue.

I ran "mysqlcheck -A" and found that one of the table had issue like the following:

nuke.nuke_stats_hour
warning : Table is marked as crashed
warning : Size of datafile is: 249856 Should be: 249850
error : got error: -1 when reading datafile at record: 24985
error : Corrupt

Then i ran "mysqlcheck -r <dbname>" and the problem got solved.

Thanks both of you in giving me idea to solve this problem.

Cheers
Yunus