 | Critical error at my site |  |
Posted: 11/14/2006 12:54 AM |
|
|
|
|
|
| Citation |
| Posts |
2152 |
| Word Cnt. |
78,257 |
| BDay |
Jun 15 |
| Sign |
Gemini |
| Sex |
 |
|
|
|
Joined: Apr 22, 2005
Local time: 6:32 PM
Location: Upside down
|

|
|
|
|
 |
Just tried going to my site and got the following error. Is this an error that will fix itself, or do I need to contact my host?
| Code:
|
phpBB : Critical Error
Error doing DB query userdata row fetch
DEBUG MODE
SQL Error : 1105 File './theaussi_phpb1/phpbb_users.MYD' not found (Errcode: 2)
SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = '4ac431801929c439e111e55a6d590e4d' AND u.user_id = s.session_user_id
Line : 323
File : sessions.php
|
|
|
|
 |
 |
| Back to Top |
|
|
 | Re: Critical error at my site |  |
Posted: 11/14/2006 1:26 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
 |
|
|
|
Joined: Sep 25, 2004
Local time: 4:32 AM
Location: St Pete, FL
|

|
|
|
|
 |
Look in your database to make sure that the phpbb_users table still exists and if so, whether you can read data from it. This might be the sign of a corrupt table...
 |
|
|
 |
 |
| Back to Top |
|
|
 | Re: Critical error at my site |  |
Posted: 11/14/2006 1:32 AM |
|
|
|
|
|
| Citation |
| Posts |
2152 |
| Word Cnt. |
78,257 |
| BDay |
Jun 15 |
| Sign |
Gemini |
| Sex |
 |
|
|
|
Joined: Apr 22, 2005
Local time: 6:32 PM
Location: Upside down
|

|
|
|
|
 |
Here is a screen shot of what it shows
 |
|
|
 |
 |
| Back to Top |
|
|
 | Re: Critical error at my site |  |
Posted: 11/14/2006 1:45 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
 |
|
|
|
Joined: Sep 25, 2004
Local time: 4:32 AM
Location: St Pete, FL
|

|
|
|
|
 |
Try this. Check the phpbb_users table on the right panel...
Then scroll down and select to Repair the table:
If that doesn't work, your host will probably have to fix this problem...
 |
|
|
 |
 |
| Back to Top |
|
|
 | Re: Critical error at my site |  |
Posted: 11/14/2006 2:04 AM |
|
|
|
|
|
| Citation |
| Posts |
2152 |
| Word Cnt. |
78,257 |
| BDay |
Jun 15 |
| Sign |
Gemini |
| Sex |
 |
|
|
|
Joined: Apr 22, 2005
Local time: 6:32 PM
Location: Upside down
|

|
|
|
|
 |
| Didn't work, but I did email the host earlier but like usual, no response from them |
|
|
 |
 |
| Back to Top |
|
|
 | Re: Critical error at my site |  |
Posted: 11/14/2006 2:12 AM |
|
|
|
|
|
| Citation |
| Posts |
2152 |
| Word Cnt. |
78,257 |
| BDay |
Jun 15 |
| Sign |
Gemini |
| Sex |
 |
|
|
|
Joined: Apr 22, 2005
Local time: 6:32 PM
Location: Upside down
|

|
|
|
|
 |
Site is now back online  |
|
|
 |
 |
| Back to Top |
|
|
 | Re: Critical error at my site |  |
Posted: 11/14/2006 2:14 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
 |
|
|
|
Joined: Sep 25, 2004
Local time: 4:32 AM
Location: St Pete, FL
|

|
|
|
|
 |
Great! So did the host fix the problem or did repairing the table do the trick???
 |
|
|
 |
 |
| Back to Top |
|
|
 | Re: Critical error at my site |  |
Posted: 11/14/2006 2:23 AM |
|
|
|
|
|
| Citation |
| Posts |
2152 |
| Word Cnt. |
78,257 |
| BDay |
Jun 15 |
| Sign |
Gemini |
| Sex |
 |
|
|
|
Joined: Apr 22, 2005
Local time: 6:32 PM
Location: Upside down
|

|
|
|
|
 |
host did. they said
| Quote:
|
|
This is to inform you that we have fixed the database issue
|
|
|
|
 |
 |
| Back to Top |
|
|
 | Re: Critical error at my site |  |
Posted: 11/14/2006 2:55 AM |
|
|
|
|
|
| Citation |
| Posts |
2152 |
| Word Cnt. |
78,257 |
| BDay |
Jun 15 |
| Sign |
Gemini |
| Sex |
 |
|
|
|
Joined: Apr 22, 2005
Local time: 6:32 PM
Location: Upside down
|

|
|
|
|
 |
| All of todays posts are gone grrrrr. I did a backup a few hours ago but won't some mods need to be reinstalled? |
|
|
 |
 |
| Back to Top |
|
|
 | Re: Critical error at my site |  |
Posted: 11/14/2006 3:10 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
 |
|
|
|
Joined: Sep 25, 2004
Local time: 4:32 AM
Location: St Pete, FL
|

|
|
|
|
 |
I bet the phpbb_posts and phpbb_post_text tables are messed up too. Your host should repair all of your tables, not just the phpbb_users table...
MODs are installed into your phpBB files on your FTP Server, not into your database. Some MODs modify your database though, but I'm sure your host should be able to repair your database so that nothing is lost...
 |
|
|
 |
 |
| Back to Top |
|
|
 | Information |  |
|