-
[RESOLVED] SQL Error
Anyone see this before.
phpBB : Critical Error
Error creating new session
DEBUG MODE
SQL Error : 1016 Can't open file: 'phpbb_sessions.MYI'. (errno: 145)
INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES ('3bf7af01fc9b400ec21bbf75b38ab472', -1, 1189907200, 1189907200, '445a7905', 0, 0, 0)
Line : 188
File : sessions.php
How does one recover from this? Is there a program that will restore normal ops? Is this just a corruption or a hacking??
This is on a friends site and I know next to nothing about this.
-
Maybe this will help out.
http://www.phpbb.com/community/viewtopic.php?t=259967
Then add this.
(errno: 145) = Table was marked as crashed and should be repaired.
-
show this to your 'friend' :rolleyes:
MySQL Error - Can't open file: 'something.MYD'. (errno: 145)
The following error may occur with a MySQL database table:
Can't open file: 'TableName.MYD'. (errno: 145)
This error usually means the 'TableName' table has become corrupt. From our experience, it appears the error commonly affects a table used for storing sessions and may occur the webs site/database has used up all allocated disk space. Additional disk space will normally need to be allocated.
Also, run the following SQL query using phpMyAdmin:
REPAIR TABLE TableName
This will often fix the table.
-
The corrupted site is now back up. Thanks for the help.