Some of you may notice something different about your Pokémon. This is, regrettably, not your imagination.
On January 18th at about 6 PM GMT, we had a severe database crash. I'm not 100% sure of the cause, but it appears to have been a failed backup (the irony). The Pokémon database - which is the largest we have - crashed and became corrupt. Unfortunately, its backup -also- became corrupt.
Restoring the backup table gave most of the data back, but a couple of columns were gone in many of the rows. This means all of the Pokémon were accounted for, but bits of information of many of them weren't.
This mostly affected Pokémon with IDs above 1.8 million, although some older Pokémon have also been affected. About a million Pokémon lost their data on:
- Sprite Type
All other information - including shininess, logs, name, nature and so forth, was unaffected by the crash.
Because, fortunately, data on dex numbers was kept, restoring species was a simple affair.
Through the species, it was possible to restore every Pokémon's image to a "default" state. This means HGSS (Arceus and below) or BW (Victini and above) sprites.
The days following the crash mostly consisted of the site being down while automatic restoration was attempted for several Pokémon, following this criteria:1)
Event Pokémon that were caught around when an event was active outside of their native areas;2)
Certain parcel Pokémon (mainly with unique species) as long as they were taken out of the parcel;3)
NPC Pokémon (Pinkan berries used on them were lost);4)
Special Pokémon with unique sprite+nature combinations, such as Flower Ditto;5)
Pokémon that had been traded at least once had their sprites changed to what they were at the time of the trade. EXCEPTION:
Pokémon that were traded as eggs could not be restored through this method;6)
Pokémon that have parents or children with matching natures may have had their sprite restored to that of the matching parent/child.
Because the restoration was done by a script and based on guesswork, false positives exist: Pokémon that were incorrectly restored to a certain sprite.
A great number of Pokémon did not fit any of those criteria and could not be restored through the methods listed above.
I also went through individual restoration requests from members, manually copying links to Pokémon and pasting them into a script that changed them into what was requested. This may have resulted in some Pokémon being incorrectly restored, as it was literally thousands of links and I sometimes pasted them into the wrong list.If you're looking to get one or more of your Pokémon sprites restored - either because it was done incorrectly, or because it hasn't been restored yet, please refer to the restoration request topic.
If you have any questions or anything you'd like to discuss concerning the crash, please use this topic.Swap Certificates
have been added to help people recover their retro losses from the database crash.Untradable, Unsellable
(you can get rid of them by releasing Pokémon holding them if you need/want to)
Swap Certificates, when held
by eligible Pokémon, allow you to change their sprite from HG/SS to an applicable different generation. Click the Swap Certificate icon in their information page (which will appear next to gallery/collection/etc icons) to swap the sprite.
Everyone was given enough swap certificates to change sprites for about one third
of their owned and eligible HG/SS sprites, excluding very old (2011 and older) ones. I realize this number is not enough for some people, but it's also very high for others. If you need more swap certificates I'll need you to contact me explaining the situation.
If used to change the sprite of a shiny OR to change a sprite to Green, it will bind the Pokémon to your account.Eligibility
A Pokémon is eligible to have its sprite swapped if:
- You're the OT and currently own it;
- It has never been traded (this includes trading it as an egg, before it was adopted by you, or before it was gifted to you);
- It has a HG/SS sprite;
- It existed before the crash (this includes very old ones that weren't counted for the one third calculation mentioned above);
- It's not in a pending trade.Available Sprites
Only standard (not palette swaps) sprites are available from certificates:
- Green [BINDING], Red/Blue and Yellow are available for Gen I Pokémon EXCEPT shinies (G/RB/Y sprites can't be shiny);
- Gold, Silver and Crystal are available for Gen II and below Pokémon;
- R/S, Emerald and FR/LG are available for Gen III and below Pokémon;
- D/P, D/P 2, Platinum, Pt2, HG/SS2 are available for Gen IV and below Pokémon;
- B/W is available for Pokémon that were met in Unova.
Other sprite types cannot be obtained using this method.
If you need a Pokémon restored that does not fit the above please use this topic