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.
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 »

Paul wrote:
Tue Dec 18, 2018 3:16 pm
Don't change table types to innodb, it most likely will cause data loss.
Hmm, I didn't think about that. I was under the impression that ALTER created a new table and only removed the originating table after succesful ALTER.
Apologies for giving a bad/dangerous suggestion.
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 »

Before I checked with CHECK TABLE phpbb_posts;. Problem is size: in use.
I also checked with CHECK TABLE phpbb_posts EXTENDED;. That works.

cache/ is empty and config.php is

Code: Select all

@define('PHPBB_INSTALLED', true);
@define('DEBUG', true);
@define('DEBUG_EXTRA', true);

@define('PHPBB_DISPLAY_LOAD_TIME', true);
@define('PHPBB_ENVIRONMENT', 'production');
@define('DEBUG_CONTAINER', true);
But still: Fatal error: Maximum execution time of 30 seconds exceeded in /vendor/s9e/text-formatter/src/Configurator.php on line 3654. What to do?


And config.yml does not existed:
@define('PHPBB_ENVIRONMENT', 'development');

Code: Select all

InvalidArgumentException in FileLocator.php line 67:
The file "development/config.yml" does not exist (in: /config).
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 51600
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 »

Only your host can fix this.
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 »

InterISP sais no thanks.


Solution: config.php

Code: Select all

ini_set('max_execution_time', '300');
ini_set('max_file_uploads', '300');
ini_set('memory_limit', '512M');
ini_set('post_max_size', '64M');
ini_set('upload_max_filesize', '64M');
set_time_limit('300');
Thanks to me ;)
Post Reply

Return to “[3.2.x] Support Forum”