* *

News

Frontpage is fixed! HUZZAH!.  Click for info.

Keep in mind that you must register an account, and be logged in to view any content on this site.

Erinn Timer

Time
Erinn Time 14:58
Local 01:34
Server 01:34
Moongate Prior G16 [ + / - ]
11:11 Tir Chonaill
12:22 Dunbarton
13:33 Emain Macha
14:44 Bangor
14:44 Emain Macha
16:66 Emain Macha

Ceo in days.

Price [ + / - ]
01:12 Emain Macha - Island in South Pathway
01:48 Sen Mag 5th house from West
Rua [ + / - ]
01:39 Resting
02:15 Resting

Discord

Join us on Discord!

Themes





Author Topic: Site Fixes, Odds and Ends Report  (Read 2171 times)

0 Members and 1 Guest are viewing this topic.

Offline The Proffessor

Site Fixes, Odds and Ends Report
« on: August 04, 2016, 03:44:18 AM »
Hello everyone.

Prepare for a wall of text, but I figure it's best to explain all that happened...lol

--------------------------------------------------------------------------------------------

As some of you might be aware, we suffered a minor catastrophic failure a week ago caused by human error (I won't name who, but it wasn't me...lol). The basic gist is that all users who hadn't logged in in over a year were deleted from the user database, including Serif, the site owner and several other critical user accounts.

What we thought would take several days and a call to Serif and possibly our website host, fortunately didn't take quite as long, but was quite the interesting feat.

I was able to piece together various parts from various databases to restore the users that got wiped. For a while, this caused all new users since February of this year to be wiped, so with more database Frankensteining, I was able to splice together more database segments to restore those users. The next day it was brought to my attention that, since some of the splices were from February, many users were having problems with their account information being outdated, and quite possibly, some users weren't able to log in, as their passwords would be the ones they had back in February. Round 3 of database alchemy later, everything user account related should be restored. Boy, what an interesting few days...lol

All that's left now is restoring their posts. So, for the time being, some posts may show the username, but have "guest" underneath them, and not show any avatar/signature/user info, etc. SMF, instead of deleting one's posts when an account is deleted, removes the user info instead to maintain thread continuity.

So far, I've been able to restore all of the roughly 21,000 user accounts that got wiped, and roughly 60,000 of their posts over the past few days. Anyone (with the exception of a few that the database is still giving me trouble with) that had 10+ posts have had theirs restored so far. The rest will take some time, as I have to go through each user individually who lost them, and reattribute their posts.

All in all, most users won't notice anything's changed, and I suppose that's a good thing.

--------------------------------------------------------------------------------------------

The next thing I want to mention is that we're aware of some minor quirks with the files section. Previously, any upload created with a screenshot added caused a HTTP 500 error, and didn't go through. This is caused by a missing PHP feature from our webhost, and unfortunately it has to be added on the host end. Only Serif has that kind of access, so we'll have to wait patiently on that. I was able to modify the site's coding to bypass the coding that called for the feature, but as a drawback, you must have an exact-sized image, or else it will be cropped (cut off) when viewing it.

--------------------------------------------------------------------------------------------

The final specific thing that I can remember so far is that to avoid the need for major rollbacks and database dissecting, I would like to be able to make daily backups of the site's database to make sure that if something major like this happens again, we'd lose at most 1 day's worth of stuff. Unfortunately, at the moment the webhost does not appear to be configured for allowing an outside database connection, making an automatic backup of that nature impossible. This will also require Serif's intervention, so stay tuned...

--------------------------------------------------------------------------------------------

Aside from that, there's a lot of other minor odd glitches that we are aware of, but unfortunately don't have the access to address at this time. If granted the access, by all means I'll pick away at them.

Again, I figured I'd at the very least bring everyone up to speed as to what's been going on behind the scenes, so to speak. I'm known to be more of a shadow admin, making sure this place doesn't start coming apart at the seams...lol
E = mc² actually stands for Enjoyment = (Modifying the Client)². The more Mods you have, the Enjoyment increases exponentially.


Offline The Proffessor

Re: Site Fixes, Odds and Ends Report
« Reply #1 on: August 10, 2016, 04:11:42 AM »
A quick update on the post restoration, I'm down to accounts with less than 5 posts now, so anyone with 5 or more posts should be fixed. So far so good...lol
E = mc² actually stands for Enjoyment = (Modifying the Client)². The more Mods you have, the Enjoyment increases exponentially.


Offline Archangel Playtime

Re: Site Fixes, Odds and Ends Report
« Reply #2 on: August 10, 2016, 12:14:44 PM »
But what about my 11,000 posts :(
Join me on Twitch, I stream!
^ Click to join me ^




Contact me by email: [email protected] by Skype: Playtime.xel, PM me here, or say my name in a post and I'll find you!
Quote from: Marck
[12:37:42 AM] Marck: ...
[12:37:44 AM] Marck: Adam
[12:37:50 AM] Marck: You can take over MM now, I'm freaking stupid

Offline The Proffessor

Re: Site Fixes, Odds and Ends Report
« Reply #3 on: August 10, 2016, 04:11:57 PM »
But what about my 11,000 posts :(
Yours were never lost, Playtime...lol

It was only those that hadn't logged in in over a year.
E = mc² actually stands for Enjoyment = (Modifying the Client)². The more Mods you have, the Enjoyment increases exponentially.


Offline Fl0rn

Re: Site Fixes, Odds and Ends Report
« Reply #4 on: August 10, 2016, 04:35:51 PM »
just steal his little blue squares and laugh maniacally.  also, thanks for all the effort lately prof.

Offline The Proffessor

Re: Site Fixes, Odds and Ends Report
« Reply #5 on: August 28, 2016, 12:35:27 AM »
Another update on the post restoration, I'm down to accounts with 1 or 2 posts now, so anyone with 3 or more posts should be fixed. We're getting there, only 1,226 users left to restore...lol
E = mc² actually stands for Enjoyment = (Modifying the Client)². The more Mods you have, the Enjoyment increases exponentially.


Offline Blade3575

Re: Site Fixes, Odds and Ends Report
« Reply #6 on: August 28, 2016, 11:20:24 AM »
Only 1,226 to 2,452 users left! You can do it! You can do it all night long!

Offline The Proffessor

Re: Site Fixes, Odds and Ends Report
« Reply #7 on: September 01, 2016, 06:28:14 AM »
While I was plugging away, I found another damaged section of the database. This one involved some topic information entries that got wiped. I was able to so far fix 6,080 out of 7,956 of them all in one night, as well as get down to 801 users still needing posts fixed, but they're all ones that have literally 1 post, so everyone with more than one post should be good to go now.

I think I'm gonna try to get some sleep now...the sun's already up...lol
E = mc² actually stands for Enjoyment = (Modifying the Client)². The more Mods you have, the Enjoyment increases exponentially.


Offline Archangel Playtime

Re: Site Fixes, Odds and Ends Report
« Reply #8 on: September 14, 2016, 09:13:30 AM »
just steal his little blue squares and laugh maniacally. 

Aha, but I gained another blue square! Your plan, she has failed.
Join me on Twitch, I stream!
^ Click to join me ^




Contact me by email: [email protected] by Skype: Playtime.xel, PM me here, or say my name in a post and I'll find you!
Quote from: Marck
[12:37:42 AM] Marck: ...
[12:37:44 AM] Marck: Adam
[12:37:50 AM] Marck: You can take over MM now, I'm freaking stupid

Offline Fl0rn

Re: Site Fixes, Odds and Ends Report
« Reply #9 on: September 14, 2016, 01:18:41 PM »
Aha, but I gained another blue square! Your plan, she has failed.

Oh really?  Then we should just color them white.

Offline Archangel Playtime

Re: Site Fixes, Odds and Ends Report
« Reply #10 on: September 14, 2016, 05:50:03 PM »
Oh really?  Then we should just color them white.
Might be kind of cool.  I've had blue for many years now. Although, I'd totally prefer purple :D
Join me on Twitch, I stream!
^ Click to join me ^




Contact me by email: [email protected] by Skype: Playtime.xel, PM me here, or say my name in a post and I'll find you!
Quote from: Marck
[12:37:42 AM] Marck: ...
[12:37:44 AM] Marck: Adam
[12:37:50 AM] Marck: You can take over MM now, I'm freaking stupid