Widescreen Gaming Forum
http://www.wsgf.org/phpBB3/

Oops WSGF had a phpBB database issue
http://www.wsgf.org/phpBB3/viewtopic.php?f=84&t=25331
Page 1 of 1

Author:  Delphium [ 27 Feb 2013, 01:29 ]
Post subject:  Oops WSGF had a phpBB database issue

Unfortunately our host had a RAID array failure on our box. Once the box came back up, we then found that we had significant database corruption in phpBB, our forums.

We are working on a mix of recovery and rebuilding. We have a solid backup of the Drupal database, but have found that we don't have a good backup of the phpBB.
Our staff is actively working to rebuild and fix the corruption.

EDIT:
Unfortunately until this is resolved we have needed to disable any new users from registering with us, although we hope to enable this very soon, our existing members are welcome to login and post as normal.
We have re-enabled user registration.

Author:  Brett [ 27 Feb 2013, 01:35 ]
Post subject:  Re: Oops WSGF had a phpBB database issue

Woops. My intention was to reply to the post and offer my help with this issue (sysadmin specializing in dealing with such issues here). I'm willing to volunteer my time for what I believe to be a good cause, can the relevant person contact me? :)

Author:  GeneralAdmission [ 27 Feb 2013, 03:49 ]
Post subject:  Re: Oops WSGF had a phpBB database issue

Hello aftli,

Thanks for your very generous offer. I am not one of the relevant team members to handle your request, but you could try PMing skipclarke, Delphium, or CrackerJackMack. I don't know how much, if any, assistance they might need, but I'm sure they would appreciate your offer nonetheless.

Cheers,
GA

Author:  Delphium [ 27 Feb 2013, 11:12 ]
Post subject:  Re: Oops WSGF had a phpBB database issue

aftil, thank you kindly for the offer, we don't have much to go on for the restore, however if you think you have some mad skillz to save our ass then I would be welcome to take you up on your offer of assistance, please feel free to drop by our IRC channel on irc.wsgf.org #wsgf where us admins are in live chat, also please PM me or the other admins.

IRC if you are able to join us, might be best to discuss in a live chat, you can use our Java IRC client (located in top menu) to join us if you don't have something installed already.

Author:  CrackerJackMack [ 02 Mar 2013, 01:47 ]
Post subject:  Re: Oops WSGF had a phpBB database issue

To further prevent this fiasco the phpbb3 database is now being backed up along side the existing drupal backups and being uploaded to a different provider. In addition, we've split the mysql instances between two virtual servers with drupal on one, and phpbb3 on the other. These two servers are also replicating each other's to one another for a more 'down VM' situation. This should alleviate any lost posts in case this ever happens again. Thanks to 'Brett' in IRC for looking over the configs to make sure we didn't do anything stupid in terms of replication.

Author:  LuckyNoS7evin [ 02 Mar 2013, 02:58 ]
Post subject:  Re: Oops WSGF had a phpBB database issue

I know you probably have a lot to do but I think that drupal articles that were "cross-posted" into phpBB in the 4 weeks of lost forum stuff now point to incorrect forum posts.

An example is the Crysis 3 article points to Win8 and NV Surround Guide: Working vs. Gaming Modes in the forum.

Guessing it's based on topicid which was correct but as that topic was lost now points to the wrong one.

I'm not telling that is the issue just think it is as I've had the same sort of stuff happen in my work as a developer

Author:  CrackerJackMack [ 02 Mar 2013, 04:30 ]
Post subject:  Re: Oops WSGF had a phpBB database issue

LuckyNoS7evin wrote:
I know you probably have a lot to do but I think that drupal articles that were "cross-posted" into phpBB in the 4 weeks of lost forum stuff now point to incorrect forum posts.

An example is the Crysis 3 article points to Win8 and NV Surround Guide: Working vs. Gaming Modes in the forum.

Guessing it's based on topicid which was correct but as that topic was lost now points to the wrong one.

I'm not telling that is the issue just think it is as I've had the same sort of stuff happen in my work as a developer



Psh, We picked the best topic to match up with the content! :lolno:

Page 1 of 1 All times are UTC [ DST ]
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/