Wow a few fun days! I know that the downtime went longer than we anticipated, and that sucks. It sucks for you, and it sucked for me staying up 24 hours to watch it to make sure it didn't crash again ????. However, we're on the other side of that now, and I've been spending my time rewriting the way that Subeta interacts with it's database. A lot of the problems that have come up since we moved comes from moving to a newer database engine, and a newer version of PHP, from the deprecated ones we were using before. These newer versions place extra limits on what kind of "old" things can be run to increase speed, security, and error logging.

Unfortunately, a bulk of Subeta was written 15 years ago, even with pieces of it being rewritten every month. The 'core' of the site is database.php, a giant class that handles all database connections on Subeta that have been written in the last 15 years. There was work from me & alx about 8 (???) years ago to modernize it then, but a lot of the site still used the old functions.

With the move to laravel for our API (wardrobe, some parts of the forums, etc) and using a query builder for newer parts of this site, we've been writing new, performant MySQL queries that are easier to track and debug. I've spent the last little while rewriting database.php from the ground up, analyzing our old queries and routing them to the modern query builder. This has mostly been a success, but I need more testing on the site to make sure that it's working 100%.

This resolves a lot of our problems. Right now we're connecting to the database twice to run both of these, and with this change we need one database connection per page. That alone will speed up the site 2x. Running queries through the query builder also means we'll have improved analytics and details on how those queries are being run, making it easier for us to tweak queries to speed up the site. It also fixes a lot of things like our current apostrophe problem, and just lots of weird quirks.

If you feel comfortable, check out the instructions at the bottom of this post. WARNING: YOU COULD LOSE ITEMS OR OTHER THINGS YOU TRY TO MOVE so be careful not to try to put a custom item in your shop. For the most part I've already fixed all of these bugs, but you never know.

Instructions

1. Go to https://database.subeta.net
2. Browse the site
3. If you run into an error that tells you to post here, do that! 3a: If you run into a blank page or other error, first make sure that it's not broken on the main site (subeta.net) first, and then post it here. I want to make sure I'm fixing things on this branch that are broken there!

Things this does not cover:

• Things coming from the API, so the wardrobe and forums!

THANK YOU!

Pushing out a fix for the medal code!

Pushing out a fix now for the quickstock issue, and the issue had

Can you make an offer on my trade so i can try it out?

Pushing out a fix to battles now ????

frag / zapper / posts saving / other stuff is having a push fixed out now, should be out in 2-5 mintues.

Will take a look at that battle bug !

pet zapper / fragging / recycle / etc should all be working now!

Also just a note (especially for battling which should be fixed now) make sure your URL is still database.subeta.net - there are some areas of the site that will push you back to subeta.net, so you have to make sure you're on the right domain

hm.

i think that battle counts may have been reset.

gah

Those of you having battle text issues -- can you make sure that you're on database.subeta.net? I've done ten battles just now and haven't had any issues with battle text ???? Or, tell me what you're using in those battles so I can try to replicate

Ah perfect!

I'm pushing an update right now that fixes the battle quests!

Also pushing a fix for the shop search

Updates:

1. Fixed error where error messages would sometimes show up like a new page within the page

2. Fixed error with the Account Search page. If you have legacy shops, please help test that the Account Search page is fully fixed by doing an account search for an item inside your legacy shop!

Fixed the SQL error when wishlist-searching in a user shop.

Please give it a try and see if it works now? If you still encounter an error, could you please post the URL of the specific shop you are wishlist-searching, along with the error message. Thank you <3

Fixed the blank white page when leaving a comment from a user's profile. Your comment should go through now, apostrophes included, yay