Mysql problems keeps coming on FreeBSD server!!
Hello all,
We are having very strage problem on FreeBSD server( version 5.1 ) which uses mysql 4.0.18 on it.Since yesterday we are getting so many errors of mysql_num_rows () function which says that the argument is invaild.
The problem is more severe .We have repaired the error but it keeps coming on and on .This happens Coz anything is added or deleted from table gives rise to error.
Here is whatb my /var/lib/mysql/server.err file says:
**************************************************************************
040705 06:56:47 mysqld started
040705 6:56:48 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43952
InnoDB: Doing recovery: scanned up to log sequence number 0 43952
040705 6:56:48 InnoDB: Flushing modified pages from the buffer pool...
040705 6:56:48 InnoDB: Started
/usr/local/libexec/mysqld: ready for connections.
Version: '4.0.13' socket: '/tmp/mysql.sock' port: 3306
040706 2:55:32 Note: Found 212 of 213 rows when repairing './trafficg_trafficq/trafficg_login'
040706 4:13:41 /usr/local/libexec/mysqld: Normal shutdown
040706 4:13:42 InnoDB: Starting shutdown...
040706 4:13:43 InnoDB: Shutdown completed
040706 4:13:43 /usr/local/libexec/mysqld: Shutdown Complete
040706 04:13:43 mysqld ended
***********
And this my error_log says:
[Fri Jul 2 16:43:34 2004] [error] PHP Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/trafficq/public_html/topbar.php on line 155
[Fri Jul 2 16:43:34 2004] [error] PHP Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/autosurf/public_html/member.php on line 118
[Fri Jul 2 16:43:39 2004] [error] PHP Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/autosurf/public_html/topbar.php on line 16
AND SO ON....
there are at least 10000 lines of same type...
What is problem?
CAn anybody help!!
|