TranslatePress encountered SQL errors. Check out the errors.

  • Resolved ppeter12

    (@ppeter12)


    5 years, 11 months ago

    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 to see the link]

Viewing 1 replies (of 1 total)
  • Denis

    (@sdenis)

    5 years, 11 months ago

    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.