Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?

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
Registered User
Posts: 2745
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?

Post by warmweer » Sat Sep 21, 2019 9:08 am

WWu777 wrote:
Sat Sep 21, 2019 7:33 am
I fixed the table "phpbb_search_wordlist" several times already, using the instructions here:

viewtopic.php?p=10485205#p10485205

But every time I do that, I keep getting the same error again about that same table "phpbb_search_wordlist". Anyone know why? How do I stop this recurring error?
If fixing the searchtables doesn't work with the standard methods, why waste time on it, they can be rebuilt from within phpBB.
Your posts_table is the problem. I that is unrecoverable then your only option is to restore the latest working backup.

There's a slight possibility that you're reached the max database size alloted, if that's the case then your host may be able to increase the allowance after which a table repair may allow a certain recovery. But messing around with innodb tables (in phpMyAdmin you can see which database engine is used) is best left over to people who really know what they're doing).

An interesting aspect of the innodb engine is that if a table is corrupt, it may seem empty but it isn't necessarily empty (that would have to be investigated). As long as it hasn't been established that your table is unrecoverable, don't manipulate it - some data has been lost but perhaps 95% or more is still recoverable.

Still, your best bet is that your host has a recent backup which they can restore. (But the tone in your mail isn't going to help your case).
My board's not broken, it just went peculiar

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

Re: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?

Post by WWu777 » Mon Sep 23, 2019 8:49 pm

Would this guy's code here fix my forum, if entered into the SQL query or command?

viewtopic.php?p=13650736#p13650736

I'm not sure what that code does, but he claimed it rebuilt his phpbb_posts tables and phpbb_topic tables.

I have two questions:

1. What would cause the phpbb_posts table to eject all data? It makes no sense. What could cause it to automatically delete the data in the posts, if you never commanded it to delete data or to drop the tables? Have any of you ever seen this kind of thing happen before?

2. Can a database or SQL programmer simply write a script to reattach the data to the tables? Is that possible? Perhaps several scripts? Do webhost companies usually have database experts or programmers in their staff, or would they have to contract outside help for that sort of thing?

Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 25388
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier
Contact:

Re: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?

Post by Paul » Mon Sep 23, 2019 8:58 pm

You should not just run a randomly found query that you have no clue about what it is doing.

I highly suggest you look for someone that can manage your server, and help you fixes these problems. You clearly have not the required knowledge yourself to run the VPS yourself, and as such you should really not be doing that.
Without looking at the system, it is very hard to tell why it would keep crashing, and also outside the scope of this forum. These errors are most likely not caused by phpBB but more on how your server is setup, or limitations from your VPS.
Knock knock
Race condition
Who's there?

My BlogMy Photosmy phpBB Extensionscustom phpBB work & Development

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

Re: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?

Post by WWu777 » Mon Sep 23, 2019 9:04 pm

warmweer wrote:
Sat Sep 21, 2019 9:08 am
WWu777 wrote:
Sat Sep 21, 2019 7:33 am
I fixed the table "phpbb_search_wordlist" several times already, using the instructions here:

viewtopic.php?p=10485205#p10485205

But every time I do that, I keep getting the same error again about that same table "phpbb_search_wordlist". Anyone know why? How do I stop this recurring error?
If fixing the searchtables doesn't work with the standard methods, why waste time on it, they can be rebuilt from within phpBB.
Your posts_table is the problem. I that is unrecoverable then your only option is to restore the latest working backup.

There's a slight possibility that you're reached the max database size alloted, if that's the case then your host may be able to increase the allowance after which a table repair may allow a certain recovery. But messing around with innodb tables (in phpMyAdmin you can see which database engine is used) is best left over to people who really know what they're doing).

An interesting aspect of the innodb engine is that if a table is corrupt, it may seem empty but it isn't necessarily empty (that would have to be investigated). As long as it hasn't been established that your table is unrecoverable, don't manipulate it - some data has been lost but perhaps 95% or more is still recoverable.

Still, your best bet is that your host has a recent backup which they can restore. (But the tone in your mail isn't going to help your case).
Well the phpbb_search_wordlist table keeps resulting in error messages every time I submit a post, but even when it does the post still sometimes gets submitted. Why is this happening? I don't want to touch anything else while Bluehost is still trying to repair it.

I'm afraid the latest backup they said, is September 20, which is two days after the crash and no good.

Do webhosts usually make unofficial backups for this sort of emergency? Do they also have database experts that can repair them?

They mentioned on the phone today that my max SQL connections is set too low, at 500 or something. what is that about? How do I change that and what is that about? How many max SQL connections am I supposed to set it to?

Also should I upgrade my php version from 5.6 to 5.7? In my WHM I got a message saying php 5.6 will no longer be supported by Centos 7. What is that about? And what version MYSQL should I upgrade to? Every time I try to upgrade these things, my forum crashes so I gotta be careful about these things and plus I don't understand them either. Any suggestions?

Btw, yes my tables are MyISAM tables. Someone earlier here said MyISAM tables are easier to repair right? I saw them in phpmyadmin. Well how does one go about repairing them? What would an expert do? Wouldn't he have to put it back together like a jigsaw puzzle with thousands of pieces? Or can he just write a script to automate the process?

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

Re: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?

Post by 3Di » Mon Sep 23, 2019 9:20 pm

WWu777 wrote:
Mon Sep 23, 2019 8:49 pm
I have two questions:
Judging by all the posts created so far on a repetition basis, they seem to me to be about a hundred, the ones you've done so far.

The answers as I have already told you, you can find them on google and paying an expert.

Here we can not help you with problems of your server and your host, ask them.
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
👨‍🏫 | Take a tour to | The Studio | 👨‍🏫

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

Re: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?

Post by WWu777 » Mon Sep 23, 2019 9:21 pm

Would this code regenerate my phpbb_posts table?

Code: Select all

update phpbb_posts set poster_id=(select user_id from phpbb_users where user_type=2 and username='Anonymous') where not exists (select 1 from phpbb_users where user_id=poster_id);
I found it here: viewtopic.php?p=12967720#p12967720

Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 25388
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier
Contact:

Re: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?

Post by Paul » Mon Sep 23, 2019 9:25 pm

WWu777 wrote:
Mon Sep 23, 2019 9:21 pm
Would this code regenerate my phpbb_posts table?

Code: Select all

update phpbb_posts set poster_id=(select user_id from phpbb_users where user_type=2 and username='Anonymous') where not exists (select 1 from phpbb_users where user_id=poster_id);
I found it here: viewtopic.php?p=12967720#p12967720
Did you actually read the replies you just got? ;)
Knock knock
Race condition
Who's there?

My BlogMy Photosmy phpBB Extensionscustom phpBB work & Development

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

Re: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?

Post by WWu777 » Thu Sep 26, 2019 9:45 am

Paul wrote:
Mon Sep 23, 2019 9:25 pm
WWu777 wrote:
Mon Sep 23, 2019 9:21 pm
Would this code regenerate my phpbb_posts table?

Code: Select all

update phpbb_posts set poster_id=(select user_id from phpbb_users where user_type=2 and username='Anonymous') where not exists (select 1 from phpbb_users where user_id=poster_id);
I found it here: viewtopic.php?p=12967720#p12967720
Did you actually read the replies you just got? ;)
Yes of course i read every reply. However my key questions above, which are very logical and questions that logical star trek characters would ask too, have been dodged. Why? If you guys dont know then just say so.

You did the same thing above. I asked a question and you dodged it. I just wanted to know if that code was applicable to my situation. Its a yes or no question. Very simple. Why so evasive? Illogical as Spock would say.

Btw i found this how to article for repairing databases with advanced commands and queries. Will it help me? See below. If so which of the queries may help?

https://severalnines.com/database-blog/ ... o-i-do-now

Also what about this stellar database repair software i found below, which claims to be the best? Will it restore my missing forum posts?

https://www.stellarinfo.com/blog/best-s ... till-date/

https://www.stellarinfo.com/sql-recovery.php

Please give me honest serious answers, not sarcastic remarks. Thanks.
Last edited by WWu777 on Thu Sep 26, 2019 2:55 pm, edited 1 time in total.

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

Re: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?

Post by WWu777 » Thu Sep 26, 2019 9:56 am

3Di wrote:
Mon Sep 23, 2019 9:20 pm
WWu777 wrote:
Mon Sep 23, 2019 8:49 pm
I have two questions:
Judging by all the posts created so far on a repetition basis, they seem to me to be about a hundred, the ones you've done so far.

The answers as I have already told you, you can find them on google and paying an expert.

Here we can not help you with problems of your server and your host, ask them.
Ok well i searched online and found some companies that specialise in data recovery, called data recovery specialists. Some of them mention databases as one of the things they can recover. Would these services be able to restore my forum?

https://www.24hourdata.com/data-recover ... a-recovery

http://www.databankservices.com/

https://www.gillware.com/data-recovery- ... pecialist/

http://www.elcotronics.com.au/services.html

https://trcdatarecovery.com/server-reco ... l-database

Could they help me remotely? It seems i have no choice. Because bluehost cant do anything without a backup and is llimited in what they can do.
Last edited by WWu777 on Thu Sep 26, 2019 1:38 pm, edited 1 time in total.

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

Re: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?

Post by 3Di » Thu Sep 26, 2019 10:01 am

WWu777 wrote:
Thu Sep 26, 2019 9:56 am
Could they help me remotely? It seems i have no choice. Because bluehost cant do anything without a backup and is llimited in what they can do.
WWu777 wrote:
Thu Sep 26, 2019 9:45 am
Please give me honest serious answers, not sarcastic remarks. Thanks.
WWu777 wrote:
Thu Sep 26, 2019 9:45 am
If you guys dont know then just say so.
We don`t know.
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
👨‍🏫 | Take a tour to | The Studio | 👨‍🏫

User avatar
david63
Registered User
Posts: 16540
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?

Post by david63 » Thu Sep 26, 2019 10:28 am

WWu777 wrote:
Thu Sep 26, 2019 9:56 am
Would these services be able to restore my forum?
You can only but ask.
WWu777 wrote:
Thu Sep 26, 2019 9:45 am
Also what about this stellar database repair software i found below, which claims to be the best? Will it restore my missing forum posts?
Beware of these services some are very limited in what they can do and many only report on what the problem is until you pay.

As for restoring your posts - they can only do that if they are still there.
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored

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

Re: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?

Post by WWu777 » Thu Sep 26, 2019 10:47 am

Bluehost case managers finally replied to me. See below. Unfortunately they seem unable or unwilling to do anything unless i have a backup for them.
Hello Winston,

Thank you for reaching back out to us. We sincerely apologize for the troubles that you have been experiencing with your forum. We attempted to call the number on file, and were told you were not available.

When we began our investigation on the 20th it was unclear as to the scope of your problems beyond the error message you were receiving inside your control panel, and the crashed tables.

By the time we started looking into the matter on the 20th there were no crashed tables and the forum appeared to be functioning as it should when we visited http://www.happierabroad.com/forum/. We do truly regret that tables crashed leading to the loss of content. It is tragic to have lost the data you and your visitors had put into the site.

It appears that your server is not currently configured to make backups. You or your administrator might have chosen to do this due to the lack of space on your drive, which is understandable, however, does leave your sites to this type of risk.

The crashed tables were most likely precipitated by the heavy server load caused by the increase in traffic you have been receiving as of late. We actually noticed really heavy server loads during our investigation. Having been able to monitor your server during this heavy load, we were able to see the same thing that was reported in our last email to you.

You can see an example of your server's heavy loads from today below:

Sep 20 (UTC) runq-sz plist-sz ldavg-1 ldavg-5 ldavg-15
10:10:15 AM 379 1211 400.04 341.91 214.05
10:20:07 AM 407 1045 403.36 395.73 303.37
10:30:05 AM 380 1202 400.98 408.51 354.46
10:40:04 AM 402 1220 408.10 410.69 381.83
10:50:06 AM 417 1050 397.55 405.69 393.50
11:00:05 AM 378 1203 399.75 333.34 339.02
11:10:07 AM 296 1180 408.75 395.73 369.91
11:20:08 AM 334 1216 399.81 390.75 379.24
11:30:03 AM 415 1052 411.46 408.97 394.52
11:40:23 AM 348 1212 403.19 404.69 398.78
11:50:06 AM 217 1232 409.11 404.19 400.63
12:00:01 PM 8 426 205.68 352.08 385.23


The site was receiving thousands of hits to your PHP service, primarily from IP's beginning in 159.138.*, which comes from what appears to be a Huawei hosting company. We blackholed this IP range on your server for a period of time to allow for the server load to go down. The server returned to normal levels though it did cause some for your tables to crash again, which have since been repaired.

We removed the blackhole in the event that you are expecting this traffic from these ranges of IP's. If you feel this traffic to be malicious in nature you can request that we block the IP range, or additionally you can also blackhole the IP range by running the following command as the root user:

root@server.happierabroad.com [~]# ip route add blackhole 159.138.0.0/16

As you mentioned in your recent contact with us you are looking to restore your database from a backup. As you or your administrator had the backups disabled, there are no server generated backups to restore from.

If you have any manually created backups to restore from please let us know right away and we would be more than happy to assist you in getting your database backup restored.

Going Forward we strongly urge you to either add additional storage to be mounted to /backup so that you can start utilizing the automatic backups provided by your server's cPanel software -or- manually backup your databases and files periodically, downloading them to a local location.

You can easily download a backup of your databases from within your control panel:

User-added image
User-added image

If you do decide to purchase additional storage you can enable your backups from within your WHM panel:

User-added image

Once enabled to can set your configuration:

User-added image

We have scoured through your server to find any random backup you might had made at some point prior to the table crash. We were unable to find any to speak of. Again, in the event you have your own backup we would love to help you in any way we can to help you restore your database.

In the meantime, please feel free to contact us if there are any additional questions or concerns There is also a survey at the bottom of the email.

Regards,
Richie J.

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

Re: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?

Post by WWu777 » Thu Sep 26, 2019 10:53 am

david63 wrote:
Thu Sep 26, 2019 10:28 am
WWu777 wrote:
Thu Sep 26, 2019 9:56 am
Would these services be able to restore my forum?
You can only but ask.
WWu777 wrote:
Thu Sep 26, 2019 9:45 am
Also what about this stellar database repair software i found below, which claims to be the best? Will it restore my missing forum posts?
Beware of these services some are very limited in what they can do and many only report on what the problem is until you pay.

As for restoring your posts - they can only do that if they are still there.
I dont mind paying if it will fix my problem and restore my database.

Even if my posts are not there, remember that many programs can recover deleted files, by rescrambling empty space to get them back. Ive used those programs before to recover deleted images and videos and audio files too. So i know they work from firsthand experience. Thus it must be possible to recover deleted data or files if software can do it. Right?

Technical problems always have technical solutions. Its just a matter of paying the expense and doing the work and finding the technical know how right?

User avatar
david63
Registered User
Posts: 16540
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?

Post by david63 » Thu Sep 26, 2019 12:04 pm

WWu777 wrote:
Thu Sep 26, 2019 10:53 am
Ive used those programs before to recover deleted images and videos and audio files too.
On a Linux server?
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored

User avatar
WelshPaul
Registered User
Posts: 329
Joined: Tue Aug 19, 2014 2:09 pm

Re: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?

Post by WelshPaul » Thu Sep 26, 2019 12:32 pm

Prepare your pocket. This type of recover cost really high.

Post Reply

Return to “[3.2.x] Support Forum”