Open hyanwong opened 4 months ago
Looks like it's triggered by searching for 4-byte emojis. I think in this case the query string was:
searchFor='🐅', language='en-IN,en-GB;q=0.9,en-US;q=0.8,en;q=0.7,te;q=0.6'
And indeed, 🐅 is encoded as %F0%9F%90%85
And you can trigger the error by going to
I think all searchable columns should probably be utf8mb4 (not utf8mb3). We should probably add stuff to https://github.com/OneZoom/OZtree/blob/main/OZprivate/ServerScripts/SQL/create_db_indexes.sql to set the default encoding of character data in the tour
table to utf8mb4
, and also perform the check in tests/site_setup/test_database_settings.py
?
There's an error like this in the logs. I assume we have the wrong collation setting on one of the columns in the
tour
table on production.Looks like it is triggered by visiting
/tour/search.json?query=%F0%9F%90%85
(referred from https://www.onezoom.org/life/@Mammalia=244265?otthome=%40%3D770311)