[hfactor66]

These

The good news is these duplicated stats were not caused by this issue. There's a known bug where suspending all of a users' stats does not suspend their sitewide score.

I'm going to do a backup of the database, and then re-enable submissions. Hopefully nothing will break. :)

EDIT: Submissions are up. \o/

TO SUBMISSIONS!!!

[GerbilSoft]

Unfortunately it still seems to be broken. Some newly-submitted stats are showing the wrong queue entry.

[GerbilSoft]

It seems that some newly-submitted stats had out-of-range stat ID numbers. I'm going to go through the code tomorrow to figure out why this is happening.

I tested it with a single stat for SA2 and that seems to have worked correctly, so maybe it only triggers with large batches.

EDIT: I'll need two or more people who have stats to submit to be in #soniccenter tomorrow (2014/10/13) at around 8 PM 9 PM EDT in order to test the submissions system. (If you submitted stats after I re-enabled submissions earlier today, those stats were deleted due to the rollback. You can help me figure out what's going on by going to #soniccenter tomorrow.)

EDIT 2: [2014/10/13 11:31 AM EDT] I won't be home until around 8:40 PM, so I'll be doing tests at 9 PM tonight.

EDIT 3: [2014/10/13 08:32 PM EDT] Make that 10 PM; extra stuff came up.

[GerbilSoft]

Looks like there won't be enough people around with stats tonight.

I'll be home at around 9-9:30 PM tomorrow (2014/10/14). I need at least two or three people with multiple stats to submit.

[hfactor66]

Looks like there won't be enough people around with stats tonight.

I'll be home at around 9-9:30 PM tomorrow (2014/10/14). I need at least two or three people with multiple stats to submit.

If you're looking for people with stat to submit I've got about 20-30+ stats to submit. lol I've been buuuusy...

[GerbilSoft]

Looks like there won't be enough people around with stats tonight.

I'll be home at around 9-9:30 PM tomorrow (2014/10/14). I need at least two or three people with multiple stats to submit.

If you're looking for people with stat to submit I've got about 20-30+ stats to submit.

Can you go to #soniccenter ?

[hfactor66]

Looks like there won't be enough people around with stats tonight.

I'll be home at around 9-9:30 PM tomorrow (2014/10/14). I need at least two or three people with multiple stats to submit.

If you're looking for people with stat to submit I've got about 20-30+ stats to submit.

Can you go to #soniccenter ?

where can I find #soniccenter? :/ I'd be happy to help if I can find it

[hfactor66]

Click

You just need a username, and you should get there instantly.

thanks :)

[GerbilSoft]

Looks like this batch of submissions worked. Still not sure why the previous one borked horribly.

I'll still need to do more testing, so get some more stats ready for tomorrow at around 9:30 PM EDT. (I'll also get the stats I saved from before that had to be deleted due to the queue table shenanigans.)

[DarkPolarNight]

I've got multiple stats to submit, and will be around at that time tomorrow if it'll help.

[The Kid .130.]

If you need stats then i'll be able to help out. I should be around

[GerbilSoft]

Looks like submissions are working well in limited testing. Tomorrow I'll do a full backup and re-enable submissions globally again.

[DarkPolarNight]

Nice work on getting the site fixed up GerbilSoft! =) (with nearly 300 stats submitted in 3hrs-without errors, it’s safe to say you’ve fixed it! :D )

[CriticalCyd]

Nice job Gerbil. From what I've heard time was a resource you had little of, but in the end you still got this thing up and running again, so thanks for the hard work!

[GerbilSoft]

TSC is back up, along with submissions. The problem this morning was a failing HDD in the server's RAID-1 array, combined with a stupid RAID controller that doesn't handle it gracefully. The HDD has been replaced.

If anyone encounters any issues with submissions not being processed, please let me know immediately. (either here or on #soniccenter)

[kirbymastah]

legit. Thanks a lot for the hard work gerbil!!! I've heard there were a lot more issues than it seemed from the outside so I really appreciate it!

[SB737]

Hey gerbil thanks for fixing TSC, I know you don't have much free time so I personally appreciate the work you put it into sorting it out :)