Database errors

  • Resolved thalakus

    (@thalakus)


    3 years ago

    Hello together,
    I Translatepress reported me some errors. I deleted the exact url below for google but it’s indicated in the “Link to the page you need help with:”

    1
last_error	WordPress database error: Could not perform query because it contains invalid data.
disable_automatic_translations	Ja
url	/en/wp-json/wp/v2/pages/72
details	Error running insert_strings()
date_time	2022-02-23 15:29:02
timestamp	1645630142
2
last_error	WordPress database error: Could not perform query because it contains invalid data.
disable_automatic_translations	Ja
url	/en/wp-json/wp/v2/pages/72
details	Error running get_untranslated_strings()
date_time	2022-02-23 15:29:02
timestamp	1645630142
3
last_error	WordPress database error: Could not perform query because it contains invalid data.
disable_automatic_translations	Ja
url	/en/wp-json/wp/v2/pages/72
details	Error running get_existing_translations()
date_time	2022-02-23 15:29:02
timestamp	1645630142
4
last_error	WordPress database error: Could not perform query because it contains invalid data.
disable_automatic_translations	Ja
url	/en/wp-json/wp/v2/pages/72
details	Error running insert_strings()
date_time	2022-02-23 15:29:01
timestamp	1645630141
5
last_error	WordPress database error: Could not perform query because it contains invalid data.
disable_automatic_translations	Ja
url	/en/wp-json/wp/v2/pages/72
details	Error running get_untranslated_strings()
date_time	2022-02-23 15:29:01
timestamp	1645630141

    I can’t trigger it manually. Not even if I click through all pages and pictures.
    But I did notice something:
    1. this page triggers it: https://www.deadlinkchecker.com/website-dead-link-checker.asp
    when I check for broken links, afterwards these errors are shown in my dashboard.

    2. if I’m looking into a page on my guestbook (gwolle-gb), that uses smileys, it shows the following in the console: Notice: TranslatePress trp-ajax request uses fall back to admin ajax.
    This just occurs if there are smileys used. on other guestbook-pages without smileys it doesnt show this message.

    • This topic was modified 3 years ago by thalakus.

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter thalakus

    (@thalakus)

    Now I found out that visiting mydomain/en/wp-json/wp/v2/pages/72/ triggers the error.
    This is exactly a page of the guestbook.

    So might the error lie here that translatepress can’t deal with emojis?

    • This reply was modified 3 years ago by thalakus.
    Dragos

    (@dragosvrejiu)

    Hello,

    It seems that the problem is related to upgrading to WordPress 5.9 version.

    We are already working on finding a solution to the “Could not perform query because it contains invalid data.” problem. To give some context on when this happens, it gets triggered when trying to find translations for the strings found in the loaded HTML page. It indicates that the text in the original HTML contains one or more problematic characters such as an invalid encoding for the table charset.

    Only certain pages containing that specific type of text are affected. Some translations may be missing on these pages, showing the original language content instead.

    Best regards,

    Thread Starter thalakus

    (@thalakus)

    Hi Dragos,
    thanks for your feedback! Glad to hear that my page won’t explode :))

    So I’m keeping calm and looking forward the fix ??

    have a great day!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Database errors’ is closed to new replies.