Smiles test

[holymannn]

https://forum.vbulletin.com/articles...database-tools

I suggest waiting until after 5.6.3 is released though. There is an updated conversion script in 5.6.3.

Hi Wayne, i have converted my forum to 5.6.3. can share how to convert to UTF8MB4 using conversion scripts in 5.6.3? thanks

[Wayne Luke]

https://forum.vbulletin.com/articles...database-tools

[holymannn]

https://forum.vbulletin.com/articles...database-tools

Hi Wayne,

I did the conversion scripts 2 months and everything looks good. Emoticon is function without any issue.

Just today, i move my forum to new hosting. the forum is running well. But Emoticon is not working probably now. Alll the inserted Emoticon has become ????. Also the new post, emoticon return as ???.

This is how i did mysql dump my database "mysqldump --opt -Q -u dpp_dmin56 -p dpp_vb563 > backup_vb563_20201108.sql" from old hosting. Then restore "mysql -u dpp_admin56 -p dpp_vb563 < backup_vb563_20201108.sql" on new hosting. Then copy everything files from /forum to new hosting. then point my domain to new server.

Old database is version: 5.6.49 and new database is version: 5.7.32. Both on colation : utf8mb4_unicode_ci
old server php 7.3 and new server php 7.4
vbulletin version is 5.6.3

What could be the possible issue?

[Wayne Luke]

What could be the possible issue?

In MySQL 5.7, the default character set and collation on a new installation is latin1 and latin1_general_ci. If this is the default of the server and vBulletin is talking to the server in Latin1, UTF-8 characters can be lost. This is in addition to the database's character set and collation.

What is the new server's default character set, collation, and server connection settings for the server? Your hosting provider can supply this information.

[holymannn]

In MySQL 5.7, the default character set and collation on a new installation is latin1 and latin1_general_ci. If this is the default of the server and vBulletin is talking to the server in Latin1, UTF-8 characters can be lost. This is in addition to the database's character set and collation.

What is the new server's default character set, collation, and server connection settings for the server? Your hosting provider can supply this information.

Hi Wayne, thanks for the direction, below is the server setting between old are new. When I duplicate the database to new server it has became utf8_unicode_ci. May I know how to change it to utf8mb_general_ci? Thanks

Old server setting


new server setting

[holymannn]

In MySQL 5.7, the default character set and collation on a new installation is latin1 and latin1_general_ci. If this is the default of the server and vBulletin is talking to the server in Latin1, UTF-8 characters can be lost. This is in addition to the database's character set and collation.

What is the new server's default character set, collation, and server connection settings for the server? Your hosting provider can supply this information.

on my test server I changed the database character set to utf8mb4_general_ci. After that I can post the emoticon without issue on new post, however my previous posts with emoticon remain ????.

anyways to salvage my previous lost emoticon data?

[Wayne Luke]

Reimport the data and make sure that the character set is utf8mb4 when exported and then imported again.