• Resolved haj12

    (@haj12)


    Hello support,

    I have been using your plugin for translating my website from English to Arabic, yesterday the plugin did not work properly, the page has mixed translation both Arabic and English at the same time.

    and this is the error that I get

    `last_error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ” at line 1 intext:”Plugin: Translate Multilingual sites – TranslatePress” more:
    disable_automatic_translations Yes
    details Error running insert_gettext_strings()

    Please advice me, it is really important for my work.

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

Viewing 1 replies (of 1 total)
  • Plugin Support Anghel Emanuel

    (@anghelemanuel99)

    Hello there,

    Thank you for letting us know about this!

    `f 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.

    Let me know about this!

    Kind Regards,

Viewing 1 replies (of 1 total)
  • The topic ‘TranslatePress errors’ is closed to new replies.