TranslatePress SQL Error

  • Resolved nopeco

    (@nopeco)


    2 years, 9 months ago

    Hello.

    After migrating the web, Translatepress displays an SQL error message.

    The web is translated correctly, except on a specific page. I have verified that when activating a social plugin on a specific page, the translation is disabled on that page. I’ve tried other social media plugins and the same thing happens. I did NOT have this problem before migrating the page. I need help!

    The last 5 errors it shows are the following:

    1.
    WordPress Database Error: The query could not be performed because it contains invalid data.
    disable_automatic_translations YES
    URL:https://trinijove.org/es/actualitat
    Details: Error running insert_strings()
    Date Time: 2022-02-07 23:00:51
    Timestamp 1644274851

    2.
    WordPress Database Error: The query could not be performed because it contains invalid data.
    disable_automatic_translations YES
    URL:https://trinijove.org/es/actualitat
    Details: Error running get_untranslated_strings()
    Date Time: 2022-02-07 23:00:51
    Timestamp 1644274851

    3.
    WordPress Database Error: The query could not be performed because it contains invalid data.
    disable_automatic_translations YES
    URL:https://trinijove.org/es/actualitat
    Details: Error running get_existing_translations()
    Data Time: 2022-02-07 23:00:51
    Timestamp 1644274851

    4.
    WordPress Database Error: The query could not be performed because it contains invalid data.
    disable_automatic_translations YES
    URL:https://trinijove.org/es/actualitat
    Details: Error running insert_strings()
    Data Time: 2022-02-07 22:59:37
    Timestamp: 1644274777

    5.
    WordPress Database Error: The query could not be performed because it contains invalid data.
    disable_automatic_translations YES
    URL:https://trinijove.org/es/actualitat
    Details: Error running get_untranslated_strings()
    Data time: 2022-02-07 22:59:37
    Timestamp: 1644274777

    ***

    I have already tried the following:

    -TranslatePres/ Settings/ General/ Save changes.

    -I have also tried removing some tables related to the failing page.

    -I have also checked the UTF8 language in the tables

    -I have also tried activating the Advanced options 1 by 1.

    Nothing has worked, I don’t know what to do. The page is from a client and needs it fixed as soon as possible.

    Thanks!

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

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

    (@anghelemanuel99)

    Hello there,

    Thank you for letting us know about your problem!

    At the moment we try to investigate from where these errors come.

    Also,at the moment our team try to investigate the other issue that you opened to us and we will continue the discussion there.

    Have a great day!

    Kind Regards,

    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!

    Plugin Support Alex

    (@alexcozmoslabs)

    Our developers still investigate those SQL errors and their cause of them. This may be the reason why the strings are not detected in Translation Editor for https://trinijove.org/actualitat/ page because I just tested with the Feed Them Social plugin on my instance but the issue wasn’t replicable.
    There are chances that this issue to be fixed in the next version of our plugin, although we don’t guarantee that.

    Thread Starter nopeco

    (@nopeco)

    Hello.

    Thanks for your answer.

    So what is the problem? Can I do something?

    The website is for a client. The client has paid for translation services and needs their page fully translated.

    I’m waiting for new updates, please, I need the problem to be solved.

    Plugin Support Alex

    (@alexcozmoslabs)

    Hi,

    Please, update to the latest version of TranslatePress. Our developers manage to fix the SQL errors in the latest version of the plugin and now it should work just fine.

    Thread Starter nopeco

    (@nopeco)

    Hello.

    I have updated to the latest version and indeed the problem has been solved.

    Thank you very very much!!!

    Plugin Support Alex

    (@alexcozmoslabs)

    Hi,

    Glad to know is working now.

    Best Regards,

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘TranslatePress SQL Error’ is closed to new replies.

Tags