PC-Forums


What happened

Wooster

  • Administrator
  • Full Member
  • *****
    • Posts: 224
on: October 02, 2018, 08:50:32 AM
The old boards database got corrupted at some point in the last year or so, possibly leading to the site slow downs and outages.
When we attempted to repair it, we lost it completely.
(The backups only contained a memberlist of a few regulars and about 50 old spam accounts)


[PCF]Falcs

  • Jr. Member
  • **
    • Posts: 64
Reply #1 on: October 02, 2018, 04:02:30 PM
Trying to think what the other threads were to strt them again but cant remember i know there was a funny websites one a tv one a film one food books virgin media......


richietog

  • Full Member
  • ***
    • Posts: 140
Reply #2 on: October 03, 2018, 05:35:49 PM
Isn’t there some kind of cross-injection protection script in place, getting slightly miffed of all these resets


Wooster

  • Administrator
  • Full Member
  • *****
    • Posts: 224
Reply #3 on: October 03, 2018, 06:58:12 PM
I think the problem had been there since the last full reset from the older Vanilla forum, or from the drive issue it suffered from a couple of years ago.
Every database backup in the last year or two is about 6MB (too small for the amount of data it should hold), but the old Vanilla database was 60MB (more like it).

As Loughor pointed out, Cruel Coppinger (Boomsling) secured 1GB of server space from Inception Hosting for Free, so it's a gift horse and we don't pay for support.

I don't deal with databases on regular basis, but I know how they work and how to make backups, so not sure if the corrupt database was running off a cache somewhere to compensate for the corruption (which might explain the mad slowdowns and outages).

Upshot is, I could have gone back a few months and we'd get the same problems, gone back a few years, to when no-one would have remembered their usernames or passwords on a platform that was seriously out of date....or bite the bullet and start afresh, which turned out to be the only option due to the necessity of deleting the old database to try and do a recovery/upgrade.

« Last Edit: October 03, 2018, 07:00:46 PM by Wooster »


Glamdring

  • Administrator
  • Full Member
  • *****
    • Posts: 146
Reply #4 on: October 03, 2018, 10:56:40 PM
What happened this evening?


Wooster

  • Administrator
  • Full Member
  • *****
    • Posts: 224
Reply #5 on: October 03, 2018, 11:47:11 PM
I happened.

I was sending CC all the server and forum login details for future reference and had to regenerate a new pass for the database.
When you do that, the forum can't access it unless you modify one of the .php files...and I forgot to do it.

This isn't my day job you know... :angel: