Title: Can’t update the database successfully Last modified: April 7, 2023 --- # Can’t update the database successfully * Resolved [beezwings](https://wordpress.org/support/users/beezwings/) * (@beezwings) * [3 years, 4 months ago](https://wordpress.org/support/topic/cant-update-the-database-successfully/) * Hi, I’m still not able to update the database without the error. Can you please see the original thread? Thanks! * [https://wordpress.org/support/topic/cant-optimize-database-after-plugin-upgrade/#post-16239975](https://wordpress.org/support/topic/cant-optimize-database-after-plugin-upgrade/#post-16239975) Viewing 12 replies - 1 through 12 (of 12 total) * Plugin Support [Alex](https://wordpress.org/support/users/alexcozmoslabs/) * (@alexcozmoslabs) * [3 years, 4 months ago](https://wordpress.org/support/topic/cant-update-the-database-successfully/#post-16636277) * Hi, I will reach out our dev team and try to come up with more details for that issue next week. * Thread Starter [beezwings](https://wordpress.org/support/users/beezwings/) * (@beezwings) * [3 years, 4 months ago](https://wordpress.org/support/topic/cant-update-the-database-successfully/#post-16636664) * Amazing, thanks!! * Plugin Support [Alex](https://wordpress.org/support/users/alexcozmoslabs/) * (@alexcozmoslabs) * [3 years, 4 months ago](https://wordpress.org/support/topic/cant-update-the-database-successfully/#post-16641365) * Could you tell me at what message the optimization process stops? * Plugin Support [Alex](https://wordpress.org/support/users/alexcozmoslabs/) * (@alexcozmoslabs) * [3 years, 4 months ago](https://wordpress.org/support/topic/cant-update-the-database-successfully/#post-16641987) * Also, can you tell me what values the following operations have? trp_updated_database_original_id_insert_166trp_updated_database_original_id_cleanup_166trp_updated_database_gettext_original_id_updatetrp_updated_database_gettext_original_id_inserttrp_updated_database_gettext_original_id_cleanup * The ones that remains with “no” means were not executed. * However, TranslatePress will work even those are not exectured, so don’t worry if you will find them with “no”. Moreover, you can try see what collation you have for your tables. You should have **utf8mb4_general_ci**. If not, please make these settings and run again the optimization process. * Thread Starter [beezwings](https://wordpress.org/support/users/beezwings/) * (@beezwings) * [3 years, 4 months ago](https://wordpress.org/support/topic/cant-update-the-database-successfully/#post-16649217) * I don’t actually get any messages at all. It just says “Updating TranslatePress tables” with dots slowly filling across the the screen, and after about two hours, it just stops. * Thread Starter [beezwings](https://wordpress.org/support/users/beezwings/) * (@beezwings) * [3 years, 4 months ago](https://wordpress.org/support/topic/cant-update-the-database-successfully/#post-16649346) * trp_updated_database_original_id_insert_166: yes trp_updated_database_original_id_cleanup_166: yestrp_updated_database_gettext_original_id_update: notrp_updated_database_gettext_original_id_insert: notrp_updated_database_gettext_original_id_cleanup: no * I’m not sure where the table collation options are located; could you let me know how to change that and if it’s safe to change it? * Thanks! * Thread Starter [beezwings](https://wordpress.org/support/users/beezwings/) * (@beezwings) * [3 years, 4 months ago](https://wordpress.org/support/topic/cant-update-the-database-successfully/#post-16650029) * I updated the wp-config.php to include the **utf8mb4_general_ci** in the collate tables area, but still the same thing * Plugin Support [Alex](https://wordpress.org/support/users/alexcozmoslabs/) * (@alexcozmoslabs) * [3 years, 4 months ago](https://wordpress.org/support/topic/cant-update-the-database-successfully/#post-16650668) * Hi, * **_— I’m not sure where the table collation options are located; could you let me know how to change that and if it’s safe to change it? _** * Please, check the following for more details: [https://mediatemple.net/community/products/dv/204403914/default-mysql-character-set-and-collation](https://mediatemple.net/community/products/dv/204403914/default-mysql-character-set-and-collation). * Thread Starter [beezwings](https://wordpress.org/support/users/beezwings/) * (@beezwings) * [3 years, 3 months ago](https://wordpress.org/support/topic/cant-update-the-database-successfully/#post-16658002) * I did that and the issue is the same. How long should the update take? I left my computer for over an hour, but it still just hangs once the dots cross the screen. * Plugin Support [Alex](https://wordpress.org/support/users/alexcozmoslabs/) * (@alexcozmoslabs) * [3 years, 3 months ago](https://wordpress.org/support/topic/cant-update-the-database-successfully/#post-16710557) * Hi, * For some reason, just gettext translation tables fail — most of gettext transactions come from plugin/theme .po/.mo files in the popular languages. If you know you don’t have many translations added manually for gettext strings, you can DROP all these gettext tables (with trp_gettext prefix) from your database then go to Settings->TranslatePress->General tab -> Save settings. This will regenerate those tables, and then should not have issues anymore with DB Update. The gettext translations will be regenerated gradually, where the translations exist, and if you use automatic translation will be translated the rest of ones also. * Thread Starter [beezwings](https://wordpress.org/support/users/beezwings/) * (@beezwings) * [3 years, 3 months ago](https://wordpress.org/support/topic/cant-update-the-database-successfully/#post-16720544) * Thank you! This finally resolved everything!! * Plugin Support [Alex](https://wordpress.org/support/users/alexcozmoslabs/) * (@alexcozmoslabs) * [3 years, 3 months ago](https://wordpress.org/support/topic/cant-update-the-database-successfully/#post-16722139) * Glad to know that. * Also, I was wondering, since you have been using TranslatePress for a while now, will it be too much to ask for you to leave a review on [https://wordpress.org/support/plugin/translatepress-multilingual/reviews/](https://wordpress.org/support/plugin/translatepress-multilingual/reviews/)? One or two sentences will do it and it may help us to reach more people as well as get feedback from existing users. * We have also a [Youtube channel](https://www.youtube.com/c/TranslatePressWordPressTranslationPlugin) that you might find useful. Viewing 12 replies - 1 through 12 (of 12 total) The topic ‘Can’t update the database successfully’ 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/) * 12 replies * 2 participants * Last reply from: [Alex](https://wordpress.org/support/users/alexcozmoslabs/) * Last activity: [3 years, 3 months ago](https://wordpress.org/support/topic/cant-update-the-database-successfully/#post-16722139) * Status: resolved