Table comments: Table './text/phpbb_posts' is marked as crashed and last (automatic?) repair failed

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
TheDani
Registered User
Posts: 356
Joined: Tue Apr 10, 2012 12:48 pm

Table comments: Table './text/phpbb_posts' is marked as crashed and last (automatic?) repair failed

Post by TheDani »

I suddenly crashed my phpbb_posts on phpMyAdmin. Similar MySQL table is marked as crashed and last (automatic?) repair failed, but there is CLI (command line).

Table comments: Table './text/phpbb_posts' is marked as crashed and last (automatic?) repair failed

phpMyAdmin, ANALYZE TABLE 'phpbb_posts';
  • Table './text/phpbb_posts' is marked as crashed and last (automatic?) repair failed
  • Table 'phpbb_posts' is marked as crashed and last (automatic?) repair failed
    Corrupt
phpMyAdmin, CHECK TABLE 'phpbb_posts';
  • Table is marked as crashed and last repair failed
  • Size of datafile is: 214134524 Should be: 0
  • Record-count is not ok; is 562662 Should be: 0
  • Found 562662 key parts. Should be: 0

phpMyAdmin, REPAIR TABLE 'phpbb_posts';
  • Table Op Msg_type Msg_text
  • phpbb_posts repair error Can't create new tempfile: './text/phpbb_posts.TMD'
  • phpbb_posts repair status Operation failed
phpMyAdmin, OPTIMIZE TABLE 'phpbb_posts';
  • Table './text/phpbb_posts' is marked as crashed and last (automatic?) repair failed
  • Table 'phpbb_posts' is marked as crashed and last (automatic?) repair failed
    Corrupt
Host with InterISP.net, so no CLI, only Inter ISP Control panel, FTP and phpMyAdmin.

What can I do?
User avatar
Mick
Support Team Member
Support Team Member
Posts: 22849
Joined: Fri Aug 29, 2008 9:49 am
Location: Watching cricket probably.

Re: Table comments: Table './text/phpbb_posts' is marked as crashed and last (automatic?) repair failed

Post by Mick »

Do you have a backup?
"The more connected we get the more alone we become" - Kyle Broflovski©
TheDani
Registered User
Posts: 356
Joined: Tue Apr 10, 2012 12:48 pm

Re: Table comments: Table './text/phpbb_posts' is marked as crashed and last (automatic?) repair failed

Post by TheDani »

2013 years ago, so no.
User avatar
Mick
Support Team Member
Support Team Member
Posts: 22849
Joined: Fri Aug 29, 2008 9:49 am
Location: Watching cricket probably.

Re: Table comments: Table './text/phpbb_posts' is marked as crashed and last (automatic?) repair failed

Post by Mick »

Does your host?
"The more connected we get the more alone we become" - Kyle Broflovski©
TheDani
Registered User
Posts: 356
Joined: Tue Apr 10, 2012 12:48 pm

Re: Table comments: Table './text/phpbb_posts' is marked as crashed and last (automatic?) repair failed

Post by TheDani »

I think yes, but I rather don't have InterISP "support"...
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 51597
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Table comments: Table './text/phpbb_posts' is marked as crashed and last (automatic?) repair failed

Post by stevemaury »

Try this SQL:

Code: Select all

REPAIR TABLE phpbb_posts
If that does not work, try:

Code: Select all

REPAIR TABLE phpbb_posts USE_FRM
Backup the posts table before trying either query.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 26854
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier
Contact:

Re: Table comments: Table './text/phpbb_posts' is marked as crashed and last (automatic?) repair failed

Post by Paul »

As you already tried repairing and it failed the only thing that you can do is contacting your host and give them the errors you get, both the ones from your forum as well as the one you get when repairing.

Do not restore a backup, there should be no need for that at all.
Knock knock
Race condition
Who's there?

My BlogMy Photosmy phpBB Extensionscustom phpBB work & Development
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 51597
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Table comments: Table './text/phpbb_posts' is marked as crashed and last (automatic?) repair failed

Post by stevemaury »

I don't believe he has tried a repair. The "automatic" repair failed. But contacting the host is nonetheless a good idea. The USE_FRM parameter is not without dangers.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
TheDani
Registered User
Posts: 356
Joined: Tue Apr 10, 2012 12:48 pm

Re: Table comments: Table './text/phpbb_posts' is marked as crashed and last (automatic?) repair failed

Post by TheDani »

A little bit annoying. Translate:

We can not help you anymore. You have access to the control panel that contains mySQL and phpMyAdmin and what it takes to make changes yourself.
"support". (Sendt 14th, now it's 18th.)
User avatar
warmweer
Jr. Extension Validator
Posts: 5585
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium

Re: Table comments: Table './text/phpbb_posts' is marked as crashed and last (automatic?) repair failed

Post by warmweer »

TheDani wrote:
Tue Dec 18, 2018 10:39 am
A little bit annoying. Translate:

We can not help you anymore. You have access to the control panel that contains mySQL and phpMyAdmin and what it takes to make changes yourself.
"support". (Sendt 14th, now it's 18th.)
Sometimes altering a table from MyISAM to InnoDB miraculously solves the problem, even copying the table.

also read
https://dev.mysql.com/doc/refman/8.0/en ... nance.html for MyISAM
and
https://forums.cpanel.net/resources/inn ... guide.395/ for InnoDB
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.
TheDani
Registered User
Posts: 356
Joined: Tue Apr 10, 2012 12:48 pm

Re: Table comments: Table './text/phpbb_posts' is marked as crashed and last (automatic?) repair failed

Post by TheDani »

But how? No command line and no backup and no support.
User avatar
warmweer
Jr. Extension Validator
Posts: 5585
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium

Re: Table comments: Table './text/phpbb_posts' is marked as crashed and last (automatic?) repair failed

Post by warmweer »

TheDani wrote:
Tue Dec 18, 2018 12:37 pm
But how? No command line and no backup and no support.
You said you have phpMyAdmin. :idea:
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.
User avatar
3Di
Former Team Member
Posts: 16039
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: Table comments: Table './text/phpbb_posts' is marked as crashed and last (automatic?) repair failed

Post by 3Di »

To request support for our extensions you can also contact me here: phpBB Studio

Please PM me only to request paid works. Thx. Want to compensate me for my interest? Donate
My development's activity º PhpStorm's proud user º Extensions, Scripts, MOD porting, Update/Upgrades
🚀 Looking for a specific feature or alternative option? We will rock you! 🚀
Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 26854
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier
Contact:

Re: Table comments: Table './text/phpbb_posts' is marked as crashed and last (automatic?) repair failed

Post by Paul »

Are you still getting this error when running repair table phpbb_posts:

Code: Select all

Can't  create new tempfile: './text/phpbb_posts.TMD']
?


If so, you need to contact your host, provide the error, and tell you want level 2 support to look into it. This is something you can't fix yourself.

Don't change table types to innodb, it most likely will cause data loss.
Knock knock
Race condition
Who's there?

My BlogMy Photosmy phpBB Extensionscustom phpBB work & Development
User avatar
Lumpy Burgertushie
Registered User
Posts: 68194
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Table comments: Table './text/phpbb_posts' is marked as crashed and last (automatic?) repair failed

Post by Lumpy Burgertushie »

and when they fix it for you. immediately find a new host. the one you have is completely useless.

actually, even if they won't fix it for you, make a complete backup ( files and database ) and find a new host and move your board as soon as you can.


robert
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.3 Styles by PlanetStyles.net

If nobody is in the forest, does a tree really fall?
Post Reply

Return to “[3.2.x] Support Forum”