Title: TranslatePress encountered SQL errors. Check out the errors.
Last modified: June 24, 2020

---

# TranslatePress encountered SQL errors. Check out the errors.

 *  Resolved [ppeter12](https://wordpress.org/support/users/ppeter12/)
 * (@ppeter12)
 * [5 years, 11 months ago](https://wordpress.org/support/topic/translatepress-encountered-sql-errors-check-out-the-errors/)
 * Hi!
 * how could I fix this errors?
 * ogged errors
 * These are the most recent 5 errors logged by TranslatePress:
 * 1
    last_error_reindex_original_ids Table ‘wp_innovr_db0.wp_trp_dictionary_de_de_’
   doesn’t exist date_time 2020-06-24 09:47:02 timestamp 1592992022 2 last_error_insert_original_strings
   Table ‘wp_innovr_db0.wp_trp_dictionary_de_de_’ doesn’t exist date_time 2020-06-
   24 09:46:59 timestamp 1592992019 3 last_error disable_automatic_translations 
   Yes details Missing table wp_trp_gettext_en_us . To regenerate tables, try going
   to Settings->TranslatePress->General tab and Save Settings. date_time 2020-05-
   28 23:20:33 timestamp 1590708033 4 last_error disable_automatic_translations 
   Yes details Missing table wp_trp_gettext_en_us . To regenerate tables, try going
   to Settings->TranslatePress->General tab and Save Settings. date_time 2020-05-
   15 12:58:57 timestamp 1589547537 5 last_error disable_automatic_translations 
   Yes details Missing table wp_trp_gettext_en_us . To regenerate tables, try going
   to Settings->TranslatePress->General tab and Save Settings. date_time 2020-02-
   22 01:23:31 timestamp 1582334611
 * thx
    Peter
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Ftranslatepress-encountered-sql-errors-check-out-the-errors%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 1 replies (of 1 total)

 *  [Denis](https://wordpress.org/support/users/sdenis/)
 * (@sdenis)
 * [5 years, 11 months ago](https://wordpress.org/support/topic/translatepress-encountered-sql-errors-check-out-the-errors/#post-13028715)
 * Hello,
 * If TranslatePress detects something wrong when executing queries on your database,
   it instantly disables the Automatic Translation feature in order to avoid any
   extra charging by Google/DeepL. Automatic Translation needs to be manually turned
   on after you solve the issues.
 * The SQL errors detected can occur for various reasons including missing tables,
   missing permissions for the SQL user to create tables or perform other operations,
   problems after a site migration or changes to SQL server configuration.
 * What you can do in this situation:
 * Plan A.
    Go to Settings -> TranslatePress -> General tab and Save Settings. This
   will regenerate the tables using your current SQL settings. Check if no more 
   errors occur while browsing your website in a translated language. Look at the
   timestamps of the errors to make sure you are not seeing the old errors. Only
   the most recent 5 errors are displayed.
 * Plan B.
    If your problem isn’t solved, try the following steps: 1. Create a backup
   of your database 2. Create a copy of each translation table where you encounter
   errors. You can copy the table within the same database (trp_dictionary_en_us_es_es_COPY
   for example) — perform this step only if you want to keep the current translations
   3. Remove the trouble tables by executing the DROP function on them 4. Go to 
   Settings -> TranslatePress -> General tab and Save Settings. This will regenerate
   the tables using your current SQL server. 5. Copy the relevant content from the
   duplicated tables (trp_dictionary_en_us_es_es_COPY for example) in the newly 
   generated table (trp_dictionary_en_us_es_es) — perform this step only if you 
   want to keep the current translations 6. Test it to see if everything is working.
   If something went wrong, you can restore the backup that you’ve made at the first
   step. Check if no more errors occur while browsing your website in a translated
   language. Look at the timestamps of the errors to make sure you are not seeing
   the old errors. Only the most recent 5 errors are displayed.
 * Plan C.
    If your problem still isn’t solved, try asking your hosting about your
   errors. The most common issue is missing permissions for the SQL user, such as
   the Create Tables permission.
 * Kind regards,

Viewing 1 replies (of 1 total)

The topic ‘TranslatePress encountered SQL errors. Check out the 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/)

 * 1 reply
 * 2 participants
 * Last reply from: [Denis](https://wordpress.org/support/users/sdenis/)
 * Last activity: [5 years, 11 months ago](https://wordpress.org/support/topic/translatepress-encountered-sql-errors-check-out-the-errors/#post-13028715)
 * Status: resolved