Regarding missing scores
FFR Community,
On April 9th, Velocity made an error in a script which resulted in a large amount of valid scores being dropped from the database when they should not have. The only scores affected were those where the combined “Perfect + Good + Average + Miss + Boo” were greater than the amount of notes in the song. The exact problem was that “Boo” should not have been included in this check. AAAs and incomplete scores were not affected by this mistake.
The following scores have been recovered:
• Complete database backup made on October 24, 2014
• All scores recorded from: April. 7th, April. 8th, and April 9th.
• noname219′s efforts to collect archives from external sources will also fill a number of missing scores.
• Saved replays
We will be continuing to recover these over the next few days:
• 10th Official Tournament dashboard scores
Additionally, we will be able to manually recover any scores submitted to the Score Recovery Form. These steps will restore a large portion of the lost scores, but will not account for any scores recorded between October 25, 2014 through April 6, 2015.
–Zageron
52 Responses to “Regarding missing scores”
You must be logged in or registered to post a comment.
Posted at 1:09am on April 10th, 2015
FFR has reached terminal velocity.
Posted at 1:11am on April 10th, 2015
SHOTS FIRED?
Posted at 1:26am on April 10th, 2015
okay so now that ffr is back up (pun intended), I just want to give my two cents
I personally think that it’s fucking embarrassing that you restored from a database made in October, and that changes were being actively implemented on live site. I get that scripting errors occur; I’ve made scripting errors and nuked shit too but it’s been in a test environment with a robust backup plan.
What does that say for the future of FFR if there aren’t apparent safeguards? What would have been your game plan if it wasn’t just scores that got deleted?
This was handled quickly, and handled well, but goddamn, you’re literally telling us that you don’t have a backup of the last 6 months?
Posted at 1:41am on April 10th, 2015
Bodybuilding vs. Powerlifting/Strongman vs. eSports — a casual analysis
Posted at 1:42am on April 10th, 2015
#Pray4Fission
Posted at 5:43am on April 10th, 2015
I love how I started playing actively on the site in late October. My Fcs went from 697 to 225 and none of my scores will be recovered. I think I might be the one that got one of the biggest knockback. Amazing.
Posted at 6:47am on April 10th, 2015
8 days too late~
Posted at 7:27am on April 10th, 2015
Well my fc’s went from 1280~ > 825 and those songs that got wiped arent really my piece of cake… And since this game is pretty much only played for the statistics I kinda lost the last bit of joy of playing this shit…
Posted at 7:37am on April 10th, 2015
Meh, im ok with this. Fcs dont matter anymore since raw is implemented and now i have something to do, go through and legit play all the songs again.
didnt like some of my scores anyways
Posted at 7:55am on April 10th, 2015
What choof said. This is unbelievably dumb. Even low-key office documents get backed up, but you fail to have any kind of backup facility for the scores of hundreds of thousands of players? Wow. I worked hard to get the absolute best scores I could get on every single song and now hundreds of song scores are gone or will get set back to much worse mash FCs I got last year. Good job.
Posted at 9:05am on April 10th, 2015
Only powermashers suffered. 5/5
Posted at 9:11am on April 10th, 2015
… Disregard my last comment
I have like half of my scores wiped /,,/
Posted at 11:46am on April 10th, 2015
Really sucked to get FC scores that had like 10-50 goods and only a few boos to get destroyed
I had songs with 1 or 2 boos that were FC’s and blackflags…
Gone
Posted at 12:35pm on April 10th, 2015
fcs dont matter anymore anyways. but yeah i lost a good amount of booflags and double booflags too, oh well, scores can be gotten again
Posted at 2:35pm on April 10th, 2015
good thing i havent played this game since october…
2007
Posted at 3:53pm on April 10th, 2015
So if i saved a couple replays between October 25, 2014 and April 6, 2015, then the score will automatically be updated sometime?
Posted at 4:26pm on April 10th, 2015
^^^^^ Or do I have to submit the scores?
Posted at 4:35pm on April 10th, 2015
Everything mentioned besides the Score Recovery Form will be automatically restored.
Posted at 4:47pm on April 10th, 2015
Okay, thank you. That’s what I thought but it didn’t mention that the replay scores hadn’t been added yet, so I just wanted to clarify.
Posted at 5:12pm on April 10th, 2015
This is some ol bullshit
Posted at 6:57pm on April 10th, 2015
fucking lol
Posted at 7:06pm on April 10th, 2015
Average rank went from 299 to 1,308. 400 FCs gone. Good thing I really started getting back into FFR in November so that nothing I’ve accomplished makes any difference. Scores in the top 4 that I’ll probably never manage again. Also was trying to get the 100% public songs played token… My god.
Posted at 7:57pm on April 10th, 2015
ALL my FC’s gone :l
Posted at 9:01pm on April 10th, 2015
FCs 120 -> 71
Tier Points ~150 -> 18
great
Posted at 9:50pm on April 10th, 2015
Holy shit. Spent the last few months trying to FC all of the hip hop songs, was down to the last two and now this. No database backup for 6 months? Hire some new god damn DBAs.
Posted at 3:28am on April 11th, 2015
haven’t been here in a while but fucking lol’d at october 2014 backup
you guys fucked up big time
Posted at 3:41am on April 11th, 2015
This is a stupid question but how does that overwriting from October 2014 batch work? Are you going to overwrite only the missing scores or just the scores which were better in October?
Posted at 9:33am on April 11th, 2015
Incompetence at its best, plz die in a car accident Velo.
Posted at 9:52am on April 11th, 2015
If you want to make it easier on yourself, you can right click the graph at the end of a replay (R^3) just like you would normally so you can submit those screenshots to the Recovery Form.
Posted at 10:03am on April 11th, 2015
dang phil!
Posted at 2:05pm on April 11th, 2015
I started playing again in January after taking a 4 year hiatus. Fucking great.
Posted at 2:52pm on April 11th, 2015
This is fucking bullshit.
Posted at 5:21pm on April 11th, 2015
I’ve really play FFR since the 17th february 2015, so 850 songs, 140 Fc’s and lot’s of time to spend again on this game … OK, i will, but i’ll take a break before…
Posted at 5:38pm on April 11th, 2015
agh fuckkk
Posted at 12:08am on April 12th, 2015
Sad day
Posted at 5:34am on April 12th, 2015
considering all the good Velocity’s done for ffr, you can’t really stay mad at him. That being said, nice one Velocity.
I haven’t played in a while, now I hope I haven’t played since October =/
Posted at 9:10am on April 12th, 2015
How long until that database backup from October gets implemented? If I played the song recently, will it get overwritten by a better score from October? I don’t want to clean up my ranks if they’d get overwritten by a lower score.
Posted at 9:13am on April 12th, 2015
Nvm it’s done lol
Posted at 9:41am on April 12th, 2015
Everyone makes mistakes, and this shit’s free right?
So I can’t complain.
Posted at 10:15am on April 12th, 2015
On the forum for this problem, noname mentioned using webcache links to look up scores that you’d saved before this crash. Any chance I could submit those pictures to the Score Recovery Form? (i.e. picture of the webcache for Across Rooftops would show I had a 19-1-0-5)
Posted at 7:50pm on April 12th, 2015
For the creepers, the backup has been restored. We will continue working on restoring other archive sources over the next few days and make another post on completion.
Posted at 11:36pm on April 12th, 2015
2015-04-10 : 16:25 to 20:55, 21:46 to 21:49
2015-04-11 : 00:29 to 02:03, 16:19 to 19:51
2015-04-12 : 22:00 to 23:56
= 11h37 +1h for setting/zipping/sending data (total files : 1343, raw size : 2,94 Go, zip size : 354 Mo)
Posted at 2:32pm on April 13th, 2015
can you take my word for 1-0-0-1 on love hurts and 4-0-0-1 on go beyond? i remember clearly getting those but i got no proof
Posted at 2:35pm on April 13th, 2015
also 3g on infinity cosmo and http://www.flashflashrevolution.com/profile/klimtkiller/replay/299004/
Posted at 9:10pm on April 13th, 2015
I guess the database doesn’t have a recycle bin
Posted at 3:50am on April 14th, 2015
@klimtkiller : I double checked and you should recover those scores once my backups are applied
Posted at 2:24pm on April 14th, 2015
Noname should get promoted for doing all of this.
Posted at 10:35am on April 16th, 2015
What is the status on where recovery is at now?
Posted at 4:48am on April 18th, 2015
i didnt save a replay of my 4-0-0-1 on you time DX
Posted at 6:06am on April 23rd, 2015
I guess an error has been made: replays of songs played with rates are now in the leaderboards, example: http://www.flashflashrevolution.com/levelstats.php?level=1214 .
Posted at 2:40am on April 26th, 2015
i dont care what FFR throws at me, you cant keep this beastness down.