Title: Translatepress image errors Last modified: April 11, 2025 --- # Translatepress image errors * Resolved [ohmykomu](https://wordpress.org/support/users/ohmykomu/) * (@ohmykomu) * [1 year, 1 month ago](https://wordpress.org/support/topic/translatepress-image-errors/) * I keep getting errors like: * **last_error**Illegal mix of collations for operation ‘in’**disable_automatic_translations** Yes**url**[https://komudesigns.com/wp-admin/admin-ajax.php](https://komudesigns.com/wp-admin/admin-ajax.php)** details**Error running get_string_rows()**last_query**SELECT 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/2025/03/0.kd_.Frodiga.blommor.jpg’](https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.jpg’);,‘ [https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.nr_.jpg’](https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.nr_.jpg’);,‘ [https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.ec_.jpg’](https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.ec_.jpg’);,‘ [https://komudesigns.com/wp-content/uploads/2025/02/Frodiga.blommor.orig_.jpg’](https://komudesigns.com/wp-content/uploads/2025/02/Frodiga.blommor.orig_.jpg’);,‘ [https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.jpg’](https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.jpg’);,‘ [https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.nr_.jpg’](https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.nr_.jpg’);,‘ [https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.ec_.jpg’](https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.ec_.jpg’);,‘ [https://komudesigns.com/wp-content/uploads/2025/02/Frodiga.blommor.orig_.jpg’](https://komudesigns.com/wp-content/uploads/2025/02/Frodiga.blommor.orig_.jpg’);,‘ [https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.jpg’](https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.jpg’);,‘ [https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.nr_.jpg’](https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.nr_.jpg’);,‘ [https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.ec_.jpg’](https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.ec_.jpg’);,‘ [https://komudesigns.com/wp-content/uploads/2025/02/Frodiga.blommor.orig_.jpg’](https://komudesigns.com/wp-content/uploads/2025/02/Frodiga.blommor.orig_.jpg’);,‘ [https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.jpg’](https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.jpg’);,‘ [https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.nr_.jpg’](https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.nr_.jpg’);,‘ [https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.ec_.jpg’](https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.ec_.jpg’);,‘ [https://komudesigns.com/wp-content/uploads/2025/02/Frodiga.blommor.orig_.jpg’](https://komudesigns.com/wp-content/uploads/2025/02/Frodiga.blommor.orig_.jpg’);,‘ [https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor-120×120.jpg’](https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor-120×120.jpg’);,‘ [https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.nr_-120×120.jpg’](https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.nr_-120×120.jpg’);,‘ [https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.ec_-120×120.jpg’](https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.ec_-120×120.jpg’);,‘ [https://komudesigns.com/wp-content/uploads/2025/02/Frodiga.blommor.orig_-120×120.jpg’](https://komudesigns.com/wp-content/uploads/2025/02/Frodiga.blommor.orig_-120×120.jpg’);,‘????’,‘ View full-screen image gallery’ )**date_time**2025-04-11 01:07:47**timestamp** 1744333667 * After a hosting change. I’ve made sure that all trp databases have the same collation, see [https://snipboard.io/ae1bV7.jpg](https://snipboard.io/ae1bV7.jpg) for example. I’ve done A, B and C on the error page, deleting all the problem lines (did not copy, do not need them translated). But they keep regenerating. Can I manually disable translatepress from trying to work with these? It’s only ever the wp- content/uploads that cause an issue. * I tried putting [https://komudesigns.com/wp-content/uploads/](https://komudesigns.com/wp-content/uploads/) in exclude strings and pages>Exclude Paths From Translation but it doesn’t seem to help. Please advice - This topic was modified 1 year, 1 month ago by [ohmykomu](https://wordpress.org/support/users/ohmykomu/). * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Ftranslatepress-image-errors%2F%3Foutput_format%3Dmd&locale=en_US) to see the link]_ Viewing 3 replies - 1 through 3 (of 3 total) * Plugin Support [Anca](https://wordpress.org/support/users/ancavictoria/) * (@ancavictoria) * [1 year, 1 month ago](https://wordpress.org/support/topic/translatepress-image-errors/#post-18417426) * Hello, Please change the collation of your ‘trp_*’ database tables to utf8mb4_general_ci. This adjustment may resolve the problem you’re encountering. * To exclude **external links/files/images**, you will need to download and activate this plugin on your site: [https://translatepress.com/download/1288661/?tmstv=1727704348](https://translatepress.com/download/1288661/?tmstv=1727704348). Then, in its settings (WordPress ➜ Settings ➜ TranslatePress Cleanup Database), add the desired exclusion ([https://komudesigns.com/wp-content/uploads/ ](https://komudesigns.com/wp-content/uploads/)) and click Start Database Cleanup. For example: “apple” will delete all records of strings found in the database that contain it like “Ana has an apple”. So use with caution.By using this plugin, these entries will be deleted and will not be re-added to the database.IMPORTANT: Please make sure to make a database backup before performing this on the live site. * Let me know how this goes. * Kind regards, * Anca * Thread Starter [ohmykomu](https://wordpress.org/support/users/ohmykomu/) * (@ohmykomu) * [1 year, 1 month ago](https://wordpress.org/support/topic/translatepress-image-errors/#post-18436125) * Hi, it didn’t help. I am still getting the same errors despite changing the database collation for trp tables to utf8mb4_general_ci, and using the plugin as advised. I have saved changes on the first settings page as well. I am still getting errors like this (for all images when i browse, they all look the same. * **last_error**Illegal mix of collations for operation ‘in’ **disable_automatic_translations** Yes**url**[https://komudesigns.com/wp-admin/admin-ajax.php](https://komudesigns.com/wp-admin/admin-ajax.php)** details**Error running get_string_rows()**last_query**SELECT 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/2025/03/0.kd-brunblomster.jpg’](https://komudesigns.com/wp-content/uploads/2025/03/0.kd-brunblomster.jpg’);,‘ [https://komudesigns.com/wp-content/uploads/2025/03/0.kd-brunblomster.n.jpg’](https://komudesigns.com/wp-content/uploads/2025/03/0.kd-brunblomster.n.jpg’);,‘ [https://komudesigns.com/wp-content/uploads/2025/02/brunblomster.orig_.jpg’](https://komudesigns.com/wp-content/uploads/2025/02/brunblomster.orig_.jpg’);,‘ [https://komudesigns.com/wp-content/uploads/2025/03/0.kd-brunblomster.jpg’](https://komudesigns.com/wp-content/uploads/2025/03/0.kd-brunblomster.jpg’);,‘ [https://komudesigns.com/wp-content/uploads/2025/03/0.kd-brunblomster.n.jpg’](https://komudesigns.com/wp-content/uploads/2025/03/0.kd-brunblomster.n.jpg’);,‘ [https://komudesigns.com/wp-content/uploads/2025/02/brunblomster.orig_.jpg’](https://komudesigns.com/wp-content/uploads/2025/02/brunblomster.orig_.jpg’);,‘ [https://komudesigns.com/wp-content/uploads/2025/03/0.kd-brunblomster.jpg’](https://komudesigns.com/wp-content/uploads/2025/03/0.kd-brunblomster.jpg’);,‘ [https://komudesigns.com/wp-content/uploads/2025/03/0.kd-brunblomster.n.jpg’](https://komudesigns.com/wp-content/uploads/2025/03/0.kd-brunblomster.n.jpg’);,‘ [https://komudesigns.com/wp-content/uploads/2025/02/brunblomster.orig_.jpg’](https://komudesigns.com/wp-content/uploads/2025/02/brunblomster.orig_.jpg’);,‘ [https://komudesigns.com/wp-content/uploads/2025/03/0.kd-brunblomster.jpg’](https://komudesigns.com/wp-content/uploads/2025/03/0.kd-brunblomster.jpg’);,‘ [https://komudesigns.com/wp-content/uploads/2025/03/0.kd-brunblomster.n.jpg’](https://komudesigns.com/wp-content/uploads/2025/03/0.kd-brunblomster.n.jpg’);,‘ [https://komudesigns.com/wp-content/uploads/2025/02/brunblomster.orig_.jpg’](https://komudesigns.com/wp-content/uploads/2025/02/brunblomster.orig_.jpg’);,‘ [https://komudesigns.com/wp-content/uploads/2025/03/0.kd-brunblomster-600×600-120×120.jpg’](https://komudesigns.com/wp-content/uploads/2025/03/0.kd-brunblomster-600×600-120×120.jpg’);,‘ [https://komudesigns.com/wp-content/uploads/2025/03/0.kd-brunblomster.n-120×120.jpg’](https://komudesigns.com/wp-content/uploads/2025/03/0.kd-brunblomster.n-120×120.jpg’);,‘ [https://komudesigns.com/wp-content/uploads/2025/02/brunblomster.orig_-120×120.jpg’](https://komudesigns.com/wp-content/uploads/2025/02/brunblomster.orig_-120×120.jpg’);,‘????’,‘ View full-screen image gallery’ )**date_time**2025-04-25 14:22:24**timestamp** 1745590944 * Thread Starter [ohmykomu](https://wordpress.org/support/users/ohmykomu/) * (@ohmykomu) * [1 year ago](https://wordpress.org/support/topic/translatepress-image-errors/#post-18445737) * can someone please help? Same errors still. Hosting can’t do anything. Uninstalling the plugin and installing it again just reloads the old stuff. I really don’t want to have to delete the database tables and start from scratch again. Viewing 3 replies - 1 through 3 (of 3 total) The topic ‘Translatepress image errors’ is closed to new replies. * ![](https://ps.w.org/translatepress-multilingual/assets/icon.svg?rev=3166541) * [TranslatePress - Translate Multilingual sites with AI Translation](https://wordpress.org/plugins/translatepress-multilingual/) * [Frequently Asked Questions](https://wordpress.org/plugins/translatepress-multilingual/#faq) * [Support Threads](https://wordpress.org/support/plugin/translatepress-multilingual/) * [Active Topics](https://wordpress.org/support/plugin/translatepress-multilingual/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/translatepress-multilingual/unresolved/) * [Reviews](https://wordpress.org/support/plugin/translatepress-multilingual/reviews/) ## Tags * [error logs](https://wordpress.org/support/topic-tag/error-logs/) * 4 replies * 2 participants * Last reply from: [ohmykomu](https://wordpress.org/support/users/ohmykomu/) * Last activity: [1 year ago](https://wordpress.org/support/topic/translatepress-image-errors/#post-18445737) * Status: resolved