Issue Plesk Migrator and Xenforo 2.1 Emojis

[Gatuno123]

Hi.

I used Plesk Migrator to migrate a forum that works with Xenforo 2.1, and the emojis have disappeared, you only see a question mark.

I think there is some problem when migrating tables with the format UTF8mb4 with Plesk Migrator.

This is the Xenforo help page for emojis:

Emoji support - XenForo 2 Manual

Regards.

 

[IgorG]

Have you tried to troubleshoot it with backup logs? Any related errors there?

 

[Gatuno123]

No errors occur. The migration process is successful.

[2019-06-30 18:24:31.306|32634] INFO: => foro_ansiedad Restore database
[2019-06-30 18:24:31.306|32634] INFO: Request is ready for: PMM_PROFILE_LOG=/opt/psa/PMM/rsessions/20190630182423647/profile.log PLESK_RESTORE_MODE=1 PLESK_DISABLE_PROVISIONING= LANG=en_US.UTF-8 ALLO
W_WEAK_PASSWORDS= /opt/psa/admin/plib/api-cli/database.php '--update' 'foro_ansiedad' '-domain' '(deleted).com' '-type' 'mysql' '-ignore-nonexistent-options'
[2019-06-30 18:24:31.317|32634] INFO: HTTP status code is: 200
[2019-06-30 18:24:31.319|32634] INFO: Request is ready for: echo '<?xml version="1.0"?>
<database-info><database name="foro_ansiedad" charset="utf8" version="10.0.38" collation="utf8_general_ci" guid="e462836b-2024-4c7a-b577-82c753dff9c1_db_2" type="mysql" id="2" deployer-action="update
">
<db-server type="mysql">
<host>localhost</host>
<port>3306</port>
</db-server>
<dbuser default="false" id="2" name="foro_ansiedad" deployer-action="update">
<password type="sym">(deleted)</password>
<acl>
<allowed-host>localhost</allowed-host>
</acl>
<privileges>
<privilege granted="false" name="File"/>
<privilege granted="true" name="Select"/>
<privilege granted="true" name="Insert"/>
<privilege granted="true" name="Update"/>
<privilege granted="true" name="Delete"/>
<privilege granted="true" name="Create"/>
<privilege granted="true" name="Drop"/>
<privilege granted="true" name="References"/>
<privilege granted="true" name="Index"/>
<privilege granted="true" name="Alter"/>
<privilege granted="true" name="Create Temporary Tables"/>
<privilege granted="true" name="Lock Tables"/>
<privilege granted="true" name="Create View"/>
<privilege granted="true" name="Show View"/>
<privilege granted="true" name="Create Routine"/>
<privilege granted="true" name="Alter Routine"/>
<privilege granted="true" name="Execute"/>
<privilege granted="true" name="Event"/>
<privilege granted="true" name="Trigger"/>
</privileges>
</dbuser>
<related-sites/>
</database></database-info>
' | PMM_PROFILE_LOG=/opt/psa/PMM/rsessions/20190630182423647/profile.log PLESK_RESTORE_MODE=1 PLESK_DISABLE_PROVISIONING= LANG=en_US.UTF-8 ALLOW_WEAK_PASSWORDS= /opt/psa/admin/bin/backup_restore_help
er '--restore-database' '(deleted).com' '-ignore-nonexistent-options'
[2019-06-30 18:24:31.319|32634] INFO: HTTP status code is: 100
[2019-06-30 18:24:31.333|32634] INFO: HTTP status code is: 200

 

[Gatuno123]

FYI.

After migration, you have to manually export the database in utf8mb4 format on the old server and import it on the new one. With this, emojis are not lost when moving a Xenforo-based forum to another server with Plesk Migrator.

Old server -> mysqldump -u root -p forum_database --default-character-set=utf8mb4 --result-file=forum_database.sql

New server -> mysql -u root -p forum_database < forum_database.sql