Need testers for some big changes on staging

Chalrytharendir, yup, we're ignoring avatars. I haven't moved them over and don't plan to, for these tests. It's irrelevant to the database and won't be affected at all. As for the emoji issue you brought up, I accidentally ran the conversion script on forum titles twice, which is what caused that. It's a big part of why we'll do one more data dump, and follow the steps I'll follow on prod to the letter, so we know exactly what the result will be. You can avatars entirely, and you can ignore emoji issues in forum titles for now (until the data load).

Can you not automate running the conversion scrip on all 'text' columns of all tables? That way it is guaranteed to not run twice and will, presumably, cover every possible place it might be needed?

Maybe see Data Dictionary Schema?

I have a HUGE sql file I've been compiling for this project. It already has all the conversion queries in there. But I accidentally just hit one twice. It happens during development, and thus why I want to do the data load when we're done with bugs to make sure the script works as a standalone.

So I'll just ping here again, how are folks feeling about the state of staging. Should we move to a data load and make a bigger ask for quick checks? Plan the rollout?

Yes, move on to the next phase

Ok, I'll do a data dump in the next hour, as well as the updated sql steps, and lets see what happens.

Data is loaded with the latest scripts. Lets all take a look, then I'll post on discord for people to peruse. So far things look ok to me?

Most of the things I have tested look good so far.

• I don't know if the fliptoken issue was resolved, I did not test them (never used them), but I can still only flip them once. [ref]

• The previously mentioned [ref] Numenera character sheet that changed to Star Wars FFG after editing now does not let me Save the sheet at all.

Both fixed. The fliptoken issue was something I did and never added to the sql script, and the Numenera char sheet was a long standing issue that I couldn't figure out until I started playing with your character. The way it saved itemized lists (abilities) was too short for the database (needed more characters).

Both issues appear fixed. I have not found anything else broken.

I'm feeling good about this. If there are still more bugs, they'll likely be small things. Nothing that will stop people from playing, but will need adjustment. Update is scheduled for next week.