| View previous topic :: View next topic |
| Author |
Message |
Moonlight-Flower
Tux's lil' helper
Joined: 15 Sep 2003
Posts: 135
|
 Posted: Fri Jul 23, 2004 12:11 pm Post subject: phpBB2 Problems suddenly! |
 |
|
Earlier today, my phpBB2 boards started... acting wierd. And now I can't access the boards at all, giving this error:
| Code: | phpBB : Critical Error
Could not obtain lastvisit data from user table
DEBUG MODE
SQL Error : 1016 Can't open file: 'phpbb_users.MYI'. (errno: 145)
SELECT * FROM phpbb_users WHERE user_id = 3
Line : 68
File : /home/httpd/htdocs/phpBB2/includes/sessions.php |
I'm using apache, and other PHP pages on the server work fine, it's just this board that isn't working. MySQL apparantly is up and running, and I have a few other stuff using it that have no problems. I've tried searching from the file phpbb_users.MYI but I haven't seen anything of the sort.
Does anyone know of a way to fix this? And how would such a strange condition happen anyways? |
|
| Back to top |
|
 |
kashani
Advocate
Joined: 02 Sep 2002
Posts: 2032
Location: San Francisco
|
| Posted: Fri Jul 23, 2004 4:16 pm Post subject: |
|
|
Hmm, it's possible that your database might have been corrupted. Log into mysql and do the following
show databases;
use <phpbb-databse>; # or what ever it's called
show tables;
select * from <some-table> limit 10;
this will atleast verify that the db is there and it works.
kashani
_________________
Will personally fix your server in exchange for motorcycle related shop tools in good shape. |
|
| Back to top |
|
|
Moonlight-Flower
Tux's lil' helper
Joined: 15 Sep 2003
Posts: 135
|
| Posted: Fri Jul 23, 2004 4:20 pm Post subject: |
|
|
Well... I assume this doesn't work (used phpMyAdmin to check just now...)
| Code: | Can't open file: 'phpbb_users.MYI'. (errno: 145)
Error
SQL-query :
SHOW KEYS FROM `phpbb_users`
MySQL said:
#1016 - Can't open file: 'phpbb_users.MYI'. (errno: 145) |
So, essentially the same thing. When looking at the big dump of tables under phpbb, I see that it's reported as "in use" despite the obvious impossibility of it... perhaps that's part of the problem? |
|
| Back to top |
|
|
kashani
Advocate
Joined: 02 Sep 2002
Posts: 2032
Location: San Francisco
|
| Posted: Fri Jul 23, 2004 4:47 pm Post subject: |
|
|
If you can run myisamchk from phpmyadmin go ahead and do that. Ideally you'd be doing this while mysql is shut down or you could get away with it if you know nothing is trying to read or write to the phpbb database.
myisamchk --help
and you'll probably want to run myisamchk -r phpbb_users.MYI or use -o if -r doesn't work.
kashani
_________________
Will personally fix your server in exchange for motorcycle related shop tools in good shape. |
|
| Back to top |
|
|
|
Networking & Security
