HELP! user table crash

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
mk264
Registered User
Posts: 11
Joined: Mon Jan 22, 2007 3:24 am
Contact:

HELP! user table crash

Post by mk264 »

Hi
My forum user table has crashed and I am getting the error below:
phpBB : Critical Error

Code: Select all

Error doing DB query userdata row fetch

DEBUG MODE

SQL Error : 1194 Table 'u' is marked as crashed and should be repaired

SELECT u.* FROM phpbb_users u, phpbb_sessions_keys k WHERE u.user_id = 3 AND u.user_active = 1 AND k.user_id = u.user_id AND k.key_id = '4f85a69fc07dd77214f424c6031a0287'

Line : 89
File : sessions.php 
Any ideas of what may have caused this and/or how I can find how to fix it?
mdvaldosta
Registered User
Posts: 353
Joined: Sat Mar 26, 2005 12:26 am
Contact:

Re: HELP! user table crash

Post by mdvaldosta »

Sometimes it just happens... server crashing, getting hard rebooted, etc. Run a repair using phpmyadmin. Sometimes have to do it twice.
espicom
Registered User
Posts: 17905
Joined: Wed Dec 22, 2004 1:14 am
Location: Woodstock, IL

Re: HELP! user table crash

Post by espicom »

And, if you don't have phpmyadmin, the first link in my signature explains how to fix it.
Jeff
Fixing 1016/1030/1034 Errors | (obsolete link) | MySQL 4.1/5.x Client Error | phpBBv2 Logo in ACP
Support requests via PM are ignored!
"To be fully alive is to feel that everything is possible." - Eric Hoffer
Locked

Return to “2.0.x Support Forum”