issue with flags after site migration | ww.wp.xz.cn

Resolved ohmykomu
(@ohmykomu)

1 year, 2 months ago

Had to migrate to another webhost with duplicator plugin and after I’m getting translatepress errors, as well as the language switcher flags not working. For the most part these redirect to https://komudesigns.com/wp-admin/remote. Can’t switch to swedish site from english. I had to work around this with an icon plugin and custom links to the main page, but what can I do to fix it/the rest? Translations seems to be working as they should.

most errors look like this:

1

last_errorIllegal mix of collations for operation ‘in’disable_automatic_translationsYesurlhttps://komudesigns.com/wp-admin/admin-ajax.phpdetailsError running get_string_rows()last_querySELECT id, original, translated, status, block_type, original_id FROM www_trp_dictionary_sv_se_en_gb WHERE original IN ( ‘https://komudesigns.com/wp-content/uploads/2024/10/hussif1.jpg’, ‘https://komudesigns.com/wp-content/uploads/2024/10/hussif2.jpg’, ‘https://komudesigns.com/wp-content/uploads/2024/10/hussif3.jpg’, ‘????’, ‘View full-screen image gallery’ )date_time2025-03-24 14:40:20timestamp1742827220

I have force language custom links on, and tried to optimize the database in debug.

The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)

Plugin Support Anca
(@ancavictoria)

1 year, 2 months ago

Hello,

Could you please try the shortcode language switcher and the floating language switcher to see if the issue with the flags persists: https://translatepress.com/docs/settings/#language-switcher?
Please also make sure you’re using the latest versions of TranslatePress.

➜ last_errorIllegal mix of collations for operation
Could you tell me what collation you have right now on your database? Try to access it and see if you can change it with utf8mb4_general_ci. Here are some tips: https://mediatemple.net/community/products/dv/204403914/default-mysql-character-set-and-collation. Also, be sure the collation is the same for all _trp_ tables columns.

Kind regards,

Anca

Thread Starter ohmykomu
(@ohmykomu)

1 year, 2 months ago

hi, none of the last two links work. Where in the database/MySQL do i see what collation I have? And what should it be? I have never edited my database.

Plugin Support Anca
(@ancavictoria)

1 year, 1 month ago

Hello,

I apologize for the delayed response!

Here is another article with information about database collation: https://www.interserver.net/tips/kb/changing-the-database-collation-in-phpmyadmin/
Try to access it and see if you can change it with utf8mb4_general_ci.

Let me know how this goes.

Kind regards,

Thread Starter ohmykomu
(@ohmykomu)

1 year, 1 month ago

changed all trp tables to that collation and I’m still getting the same errors

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘issue with flags after site migration’ is closed to new replies.

Tags

translation error

4 replies
2 participants
Last reply from: ohmykomu
Last activity: 1 year, 1 month ago
Status: resolved