Table 's' is marked as crashed and should be repaired [1194]

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Ideas Centre

Table 's' is marked as crashed and should be repaired [1194]

Postby GarlicBread » Mon Feb 11, 2008 7:57 pm

Had a server timeout earlier tonight, but now it's back up and running, trying to visit the forum index page, I see the following error message.

Any idea what it is - and more importantly how to fix/repair; Table 's' as noted?!

Code: Select all
General Error
SQL ERROR [ mysql4 ]

Table 's' is marked as crashed and should be repaired [1194]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
GarlicBread
Registered User
 
Posts: 29
Joined: Sat Aug 09, 2003 12:01 pm

Re: Table 's' is marked as crashed and should be repaired [1194]

Postby zeroK » Mon Feb 11, 2008 8:03 pm

With following SQL statement:

Code: Select all
REPAIR TABLE s;


You can do things like that for example with phpMyAdmin.
Image My weblog | gamerslog.com | No support via PM or ICQ or email - If you don't know a term or a program mentioned in a post -> Google is your friend
User avatar
zeroK
Former Team Member
 
Posts: 20964
Joined: Sun Jan 20, 2002 7:36 pm
Location: Klagenfurt / Austria

Re: Table 's' is marked as crashed and should be repaired [1194]

Postby GarlicBread » Mon Feb 11, 2008 8:27 pm

zeroK wrote:With following SQL statement:

Code: Select all
REPAIR TABLE s;


You can do things like that for example with phpMyAdmin.


Cheers for that zeroK, all sorted :)
GarlicBread
Registered User
 
Posts: 29
Joined: Sat Aug 09, 2003 12:01 pm

Re: Table 's' is marked as crashed and should be repaired [1194]

Postby magicinthedesert » Thu Oct 16, 2008 3:29 am

This was a great help! Thank you.
Succesfully create and manage your small business website with WordPress Academy
Custom solutions for website design & marketing
Learn about meditation and Yoga
User avatar
magicinthedesert
Registered User
 
Posts: 1
Joined: Thu Oct 16, 2008 3:27 am

Re: Table 's' is marked as crashed and should be repaired [1194]

Postby forumstaemme » Mon Jan 26, 2009 6:35 pm

I've got the same problem. Unfortunately, it doesn't work with the REPAIR command.
Used PHPMyAdmin but table s doesn't exist.. that's what the error message says.

For sure I'm just too dumb to enter the command correctly - can someone please help me with that?
forumstaemme
Registered User
 
Posts: 1
Joined: Mon Jan 26, 2009 6:30 pm

Re: Table 's' is marked as crashed and should be repaired [1194]

Postby RMcGirr83 » Mon Jan 26, 2009 6:52 pm

No, no, no :)

You should do it like this

Code: Select all
REPAIR TABLE name_of_crashed_table;


where "name_of_crashed_table" is the name of the table that is crashed (eg, phpbb_users for example).
User avatar
RMcGirr83
Former Team Member
 
Posts: 16042
Joined: Wed Jun 22, 2005 4:33 pm
Location: Connecticut USA
Name: Rich McGirr

Re: Table 's' is marked as crashed and should be repaired [1194]

Postby AlanRT » Mon Oct 19, 2009 6:47 pm

Wanted to add my experience from today.

I received the same error message. In my case, the name of the crashed table was also 's.'

Table 's' does not exist in the List of Tables. I fixed the problem in PHPMyAdmin by selecting > Structure, then Check All, then Repair. All tables were OK except for the phpbb_posts table, which indicated it had been changed from 187,575 to 187,576.

After that, our Forums were restored.
User avatar
AlanRT
Registered User
 
Posts: 41
Joined: Sun Aug 17, 2008 9:00 pm

Re: Table 's' is marked as crashed and should be repaired [1194]

Postby TimJBart » Tue Dec 29, 2009 11:20 am

AlanRT wrote:Wanted to add my experience from today.

I received the same error message. In my case, the name of the crashed table was also 's.'

Table 's' does not exist in the List of Tables. I fixed the problem in PHPMyAdmin by selecting > Structure, then Check All, then Repair. All tables were OK except for the phpbb_posts table, which indicated it had been changed from 187,575 to 187,576.

After that, our Forums were restored.


Thank you, this is what fixed it for me as well. It was the _Sessions table which had a warning, and was changed from 16 entires to 13.
User avatar
TimJBart
Registered User
 
Posts: 279
Joined: Mon Jan 28, 2002 8:24 pm


Return to 3.0.x Support Forum

Who is online

Users browsing this forum: Adam_Nox, Kevin Clark, Marshalrusty, omgili [Bot] and 96 guests