Table ‘wp_trp_gettext_id_id’ is marked as crashed and should be repaired]

  • Resolved andremahendra

    (@andremahendra)


    2 years, 9 months ago

    my site showing this error :
    Table 'wp_trp_gettext_id_id' is marked as crashed and should be repaired]

    i tried to repair the DB using phpMyAdmin repair table, after did that my translated page crash.

    do you guys have any clue to solve my problem?
    thanks!

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

Viewing 1 replies (of 1 total)

  • Hello there,

    Thanks for reaching out to us!

    We deeply apologize for the delayed response.

    There has been a great load on our support team in the past few days, but such a long reply time is very uncommon.

    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:

    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.

    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.

    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.

    Let me know if any of this help with your issue!

    Kind Regards

Viewing 1 replies (of 1 total)
  • The topic ‘Table ‘wp_trp_gettext_id_id’ is marked as crashed and should be repaired]’ is closed to new replies.

Tags