Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted April 26, 20187 yr In announcing the 4.3 upgrade (4.3.1) to my forum, I posted a few emoji under the "emoji now supported!" sub-heading, proudly announcing support. The emoji showed up just fine in the post. I can edit the post and add them back in, in fact. ?♂️ and ?? and ?️ were among them. But when I hit submit, they showed up like this: I'm using the latest version of Safari on the latest version of macOS, which supports emoji quite well. So what is causing the issue? My forums_posts table has a "post" row with UTF-8 encoding. Should that have been converted to something else? Do other rows need to be converted to something else, too? P.S. The emoji seem to work here, at IPS.
April 26, 20187 yr Author 4 minutes ago, opentype said: You need utf8mb4 (for the suite and the MySQL tables), not just utf8. Yeah, I just upgraded the posts row in the forums_posts and that seems to work. The question is then why didn't the upgrade scripts properly do this for me? I imagine there are lots of other parts where this is needed - blog posts, blog comments, gallery image comments, status updates… PMs… etc. Thank you @opentype.
April 26, 20187 yr Author The issue I have now is that I cannot find the script or converter to run the upgrade to utf8mb4 on all the appropriate tables.
April 26, 20187 yr 3 minutes ago, iacas said: The issue I have now is that I cannot find the script or converter to run the upgrade to utf8mb4 on all the appropriate tables. The option is in the ACP - can't remember where and can't locate now because all my DBs are already converted.
April 26, 20187 yr Author Thank you. 8 minutes ago, Nathan Explosion said: The option is in the ACP - can't remember where and can't locate now because all my DBs are already converted. In this topic… A user suggested it was in the sidebar. But my sidebar doesn't have an "Enable utf8mb4" script. ?
April 26, 20187 yr Quote Dear IPS, I want to convert my database to utf8mb4 but the option to do so isn't available in the ACP. Please help Thanks,
April 26, 20187 yr Author @Nathan Explosion, thank you, and yes, I've already filed the support request: ? I appreciate it.
April 26, 20187 yr Make sure you conf_global doesn’t claim you have mb4 enabled, when that’s not actually the case. 'sql_utf8mb4' => true,
April 26, 20187 yr Author 1 hour ago, opentype said: Make sure you conf_global doesn’t claim you have mb4 enabled, when that’s not actually the case. 'sql_utf8mb4' => true, Yeah that was it. Support was pretty quick about it. Thank you.
Archived
This topic is now archived and is closed to further replies.