Database table "phpbb_posts" corrupted regularly. How to fix?

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
User avatar
3Di
Former Team Member
Posts: 14995
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: Database table "phpbb_posts" corrupted regularly. How to fix?

Post by 3Di »

Well, i did lurk at this topic and I didn't see any SRT answered, but that could be my fault .. like it is for sure that I didn't see we are into the 3.0 forums, so extensions = MODs. ;) Sorry. ;)

How can you run it? Simply follow the instructions, here..
* Usage:
* Download and unzip the file, upload it to your Board's root (i.e.: http://www.mydomain.com/phpBB3/)
* Point your browser to i.e.: http://www.mydomain.com/phpBB3/right_install.php) and follow instructions.
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
:studio_microphone: Premium extensions @ The Studio

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 51194
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Database table "phpbb_posts" corrupted regularly. How to fix?

Post by stevemaury »

WWu777 wrote:
stevemaury wrote:There is no "DOS". Do you have a command line interface?
I think so. I see a box that says SQL Query. Is this it? See screenshot below. If so, I get error messages when I try to run that command mentioned above.
Untitled.png
The correct query is REPAIR TABLE phpbb_posts
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)

Slackervaara
Registered User
Posts: 195
Joined: Thu Feb 28, 2008 7:46 am

Re: Database table "phpbb_posts" corrupted regularly. How to fix?

Post by Slackervaara »

I also have a huge phpbb_posts table and when I optimize it freezes, because it locks the table. This leads that the site does not work. It works again after 5-7 minutes and during this time the table has been optimized.

User avatar
Lumpy Burgertushie
Registered User
Posts: 67382
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Database table "phpbb_posts" corrupted regularly. How to fix?

Post by Lumpy Burgertushie »

don't optimize it, repair it.

and, I would assume that for a large table it may take that long and it should lock the table while it is doing the work. having your board not working for 5 minutes is no big deal.

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?

Slackervaara
Registered User
Posts: 195
Joined: Thu Feb 28, 2008 7:46 am

Re: Database table "phpbb_posts" corrupted regularly. How to fix?

Post by Slackervaara »

No, he shall repair of course, but I told how a huge table works. It get locked on such operations and you have to wait at least 5-7 minutes until the process is completed. I also thinks that the web host can repair it in a more efficent way from command line from MySQL with some extra options for difficult cases.

User avatar
Mick
Support Team Member
Support Team Member
Posts: 22282
Joined: Fri Aug 29, 2008 9:49 am
Location: Cardiff

Re: Database table "phpbb_posts" corrupted regularly. How to fix?

Post by Mick »

The host should do it in any case it's their problem.
"The more connected we get the more alone we become" - Kyle Broflovski

Please read: “Am I In The Right Place?” before posting.

WWu777
Registered User
Posts: 624
Joined: Tue Aug 14, 2007 12:40 pm
Contact:

Re: Database table "phpbb_posts" corrupted regularly. How to fix?

Post by WWu777 »

stevemaury wrote:
WWu777 wrote:
stevemaury wrote:There is no "DOS". Do you have a command line interface?
I think so. I see a box that says SQL Query. Is this it? See screenshot below. If so, I get error messages when I try to run that command mentioned above.
Untitled.png
The correct query is REPAIR TABLE phpbb_posts
Ok thanks. I repaired that table using the command above in phpmyadmin. After the long repair, I checked all the tables and still got this error message:

Code: Select all

happier2_HappierAbroad.phpbb_posts
check
warning
Size of indexfile is: 331706368      Should be: 33...
What does that mean? Any idea?

Anyway, so I optimize all the tables and then ran another check, and this time that table check out to be OK.

So for now, it looks to be fixed. But I'm sure in a week or two, this problem will come back again. Anyone have any idea what it is? What does size of indexfile mean? And why can't it be corrected permanently?

Is this something minor that won't grow to be a bigger problem?

WWu777
Registered User
Posts: 624
Joined: Tue Aug 14, 2007 12:40 pm
Contact:

Re: Database table "phpbb_posts" corrupted regularly. How to fix?

Post by WWu777 »

Mick wrote:The host should do it in any case it's their problem.
You're dreaming right? lol. When I asked them to repair it before, they said, "Sorry, but it's not our job to repair databases. It is your job to fix them. If you can't, then hire a database professional. Our job is only to provide hosting and make sure your server runs ok. Beyond that is not our responsibility."

Well what did you expect them to say? Come on. This is the real world. Not an ideal world. lol

WWu777
Registered User
Posts: 624
Joined: Tue Aug 14, 2007 12:40 pm
Contact:

Re: Database table "phpbb_posts" corrupted regularly. How to fix?

Post by WWu777 »

3Di wrote:Well, i did lurk at this topic and I didn't see any SRT answered, but that could be my fault .. like it is for sure that I didn't see we are into the 3.0 forums, so extensions = MODs. ;) Sorry. ;)

How can you run it? Simply follow the instructions, here..
* Usage:
* Download and unzip the file, upload it to your Board's root (i.e.: http://www.mydomain.com/phpBB3/)
* Point your browser to i.e.: http://www.mydomain.com/phpBB3/right_install.php) and follow instructions.
Ok I did it. Using the code here right?
https://gist.github.com/3D-I/3dd7e3f7bf1fb5fc5261

Like I said earlier, here are the results I got:

http://www.happierabroad.com/forum/right_install.php
Congratulations!
Your CONSTANTS file belongs to phpBB 3.0.12
Your DB says you are running phpBB 3.0.12
Your PHP version says you are running PHP 5.4.28
The following stats are just for information purposes at the present time
The file config.php exists, size: 425 bytes
Available stream wrappers: https, ftps, compress.zlib, php, file, glob, data, http, ftp, phar, zip
PHP module json: loaded
PHP module getimagesize: loaded
[phpBB Debug] PHP Warning: in file [ROOT]/right_install.php on line 178: array_combine(): Both parameters should have an equal number of elements
Return to index page
General Error
One or more styles uploaded are for a different version of phpBB
or the uploaded style/s have been wrongly uploaded, check the styles folders.

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/right_install.php
LINE: 180
CALL: trigger_error()
It looks like there is some error in the right_install.php file. Do you know what it is.

User avatar
Mick
Support Team Member
Support Team Member
Posts: 22282
Joined: Fri Aug 29, 2008 9:49 am
Location: Cardiff

Re: Database table "phpbb_posts" corrupted regularly. How to fix?

Post by Mick »

WWu777 wrote:You're dreaming right?
Nope. If I'm paying for a service and it doesn't work and they won't sort it out I would seriously start looking for another host. What happens if it's a memory or other hardware problem that's causing the failure, how are you supposed to sort that out?
WWu777 wrote:Our job is only to provide hosting and make sure your server runs ok
Part of their hosting package is to supply a working database right? Every time I remember seeing such (continual) issues it's been down to the host in the end.
"The more connected we get the more alone we become" - Kyle Broflovski

Please read: “Am I In The Right Place?” before posting.

Slackervaara
Registered User
Posts: 195
Joined: Thu Feb 28, 2008 7:46 am

Re: Database table "phpbb_posts" corrupted regularly. How to fix?

Post by Slackervaara »

You got warning of the index file. I know it possible to remove the index file and recreate it again. I have done this with MySQLDumper, but I don't rememberhow I did it, but it was possible. The index file is greater than the content in phpbb_posts.

User avatar
3Di
Former Team Member
Posts: 14995
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: Database table "phpbb_posts" corrupted regularly. How to fix?

Post by 3Di »

WWu777 wrote: It looks like there is some error in the right_install.php file. Do you know what it is.
Yes.
One or more styles uploaded are for a different version of phpBB
or the uploaded style/s have been wrongly uploaded, check the styles folders.
And yes, that was fixed into the new version not yet shared, though.
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
:studio_microphone: Premium extensions @ The Studio

WWu777
Registered User
Posts: 624
Joined: Tue Aug 14, 2007 12:40 pm
Contact:

Re: Database table "phpbb_posts" corrupted regularly. How to fix?

Post by WWu777 »

Mick wrote:
WWu777 wrote:You're dreaming right?
Nope. If I'm paying for a service and it doesn't work and they won't sort it out I would seriously start looking for another host. What happens if it's a memory or other hardware problem that's causing the failure, how are you supposed to sort that out?
WWu777 wrote:Our job is only to provide hosting and make sure your server runs ok
Part of their hosting package is to supply a working database right? Every time I remember seeing such (continual) issues it's been down to the host in the end.
I've told them that before. When I do, their response is that their server is working properly and that I have no evidence that it is not. And that unless I do, the most probable cause is bad coding in the phpbb forum script. They will tell me to contact phpbb support.

Their argument is that there is no valid evidence that their server is the cause of the corruption. You gotta look at it from their side too. They will not believe that their server is the problem without valid evidence. They aren't stupid. They aren't just going to believe anything you tell them without evidence. Unless I can prove it's their servers that's the problem, they have a valid right to demand valid evidence.

You seem a bit idealistic. The world is not like that. There are two sides to every story.

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 51194
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Database table "phpbb_posts" corrupted regularly. How to fix?

Post by stevemaury »

In any event, phpBB has nothing to do with the database. phpBB can use many different databases, none of which were written by phpBB. The fact that millions of phpBB installations are running properly. most with MySQL databases, would seem to indicate it is not a phpBB problem. Get a new host.
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)

User avatar
Mick
Support Team Member
Support Team Member
Posts: 22282
Joined: Fri Aug 29, 2008 9:49 am
Location: Cardiff

Re: Database table "phpbb_posts" corrupted regularly. How to fix?

Post by Mick »

Just another thought, it won't be "servers" it will probably be one database server. Ask them to move your database to another server, they can do that very quickly. If the issue goes away you will know for sure then. If I was a server admin that's what I'd do.
"The more connected we get the more alone we become" - Kyle Broflovski

Please read: “Am I In The Right Place?” before posting.

Locked

Return to “[3.0.x] Support Forum”