Database issues: Resolved!

We've resolved most of the issues stemming from yesterdays database troubles. The only areas of the site that we found effected were very, very old (battle and major drills, primarily) and no data was lost, just changed for a few moments. Our database went through a (required) software update that shouldn't have caused any problems....... and yet here we are 🥲.

In old portions of the site we saved things to the database as ENUM ("enumeration") which means that it has a set number of options. In most situations you'd have it create options like ENABLED, DISABLED, kind of like a toggle. We used it a little differently and instead of ENABLED/DISABLED, we used 1/0. There is a native method for doing that though ('number') and this was finally the point where our database was fed up with these old areas of the site incorrectly using this method. Instead of gently changing the field type, it changed the field type and added one to each field. So, a battle weapon that had a field called hidden got changed to 1 instead of 0, making it hidden to all of you on the site (but still there!).

Hopefully this little explanation helps reason some of the race against time that we're constantly in on Subeta.

Posted by Keith

07/26/22 1:14 pm Leave Comment

Comment Comments are disabled for this post!