I’m using a AWS Lightsail server. I recommend it as an easy and inexpensive way to spin up a VPS.
Like like an old broken analog clock, I have a chance of eventually being right on this someday and actually helping someone. Check to make sure your database charset collation is set to utf8mb4 so it can accept 4-byte characters. I’ve been using utf8mb4_unicode_ci.
I’ve been testing a bunch of different Concrete themes have needed to reset with new install numerous times. Personally, I find it more convent to use the webpage install method for that. At least on Concrete v8, I found the pre-install tests didn’t alert me to an incorrect database collation or user permissions not being correct. Either of these can cause the install to fail with some sql errors. A newly created database user may not have some permissions granted by default.
- Structure
** REFERENCE
** LOCK TABLES
** INDEX
** CREATE TEMPORARY TABLES