Something very strange going on...

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
s.dot
Tranquility In Moderation
Posts: 5001
Joined: Sun Feb 06, 2005 7:18 pm
Location: Indiana

Something very strange going on...

Post by s.dot »

Last night when I went to bed, everything was working fine. Then when I go to view private messages on my site this morning I get this error :

Warning: mysql_query(): Unable to save result set in /home/scottttt/public_html/viewprivatemessages.php on line 100

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/scottttt/public_html/viewprivatemessages.php on line 102

I haven't changed anything in the database, and haven't changed any coding.

When I type the query into PHPMyAdmin, I get this error

#1030 - Got error 134 from table handler

Also, when I try to open a different table in PHPMyAdmin I get this error:

Error
SQL-query:

SHOW KEYS FROM `whorated` ;


MySQL said:

#1016 - Can't open file: 'whorated.MYI'. (errno: 145)
User avatar
Weirdan
Moderator
Posts: 5978
Joined: Mon Nov 03, 2003 6:13 pm
Location: Odessa, Ukraine

Post by Weirdan »

Code: Select all

weirdan@office:~$ perror 134
Error code 134:  Unknown error: 134
134 = Record was already deleted (or record file crashed)
weirdan@office:~$ perror 145
Error code 145:  Unknown error: 145
145 = Table was marked as crashed and should be repaired
Looks like the filesystem (or db files) on db server got corrupted.
Post Reply