14-01-2022, 07:19 PM
(14-01-2022, 05:23 PM)E.N. Wrote:(14-01-2022, 03:33 PM)Neowise Wrote: okay. I think i found the issue.
But.. the fix is a big change. I'll need to do a site backup before doing this, so i can revert if it messes up.
Cool, glad you found it
If it's a big fix I honestly wouldn't bother. It's not a big deal, just wondered if was simple to sort
Well, its something that needs updated.
The database currently talks in utf8 and the emojis have more data attached to them than you can fit in a standard utf8 slot, so when you try to write these imojis into the db it gets lost.
The fix is to upgrade the db to utf8 + 4 bits.
The fix is simple. Just run a conversion.
But i need to insure nobody is using the db when it is being updated, and way to insure that it close the site temporarily. Need to insure that if anything goes wrong i can undo, therefore a backup is needed.
That’s all that makes it big.
Big, as in needs to be scheduled, not big difficult!