Strange translations in the MAIN language

  • Resolved gerske

    (@gerske)


    1 year, 4 months ago

    I have also emailed support, but because others might have this problem too, I also post it here. Maybe someone has a solution.

    There is something wrong with Translatepress. I have Dutch as the main language of WordPress. We use Woocommerce. Several words are incorrectly “translated” by Translatepress to ridiculous texts (ONLY in the MAIN language).

    Some examples:
    Update basket = Agusan del Norte (in Dutch, instead of the correct “Winkelen bijwerken”)
    Basket totals = Albay
    Product = Tumbnes
    Price = Ucayali
    Quantity = Abra
    Your order = Oost-Samar
    Terms and conditions = Isabel
    Privacy conditions = Iloilo
    Returning customer? = Bukidnon
    etc.

    I know it is Translatepress, because if I deactivate that plugin the main language is normal again.

    I have switched the errors I noticed back to normal Dutch with the editor of Translatepress. But of course I’m afraid there are much more errors with this bug and that this will happen again.

    We use Translatepress for years now, and this problem occured very recently. Might be the latest version, that has a bug.

    Translatepress should never change the strings in the main language.

    Kind regards, Gerske

    • This topic was modified 1 year, 4 months ago by gerske.
    • This topic was modified 1 year, 4 months ago by gerske.
Viewing 5 replies - 16 through 20 (of 20 total)
1 2
  • Thread Starter gerske

    (@gerske)

    1 year, 4 months ago

    Yes, it was! Happy that it seems to be good on your site as well. Ciao.

    Plugin Support Denis

    (@sdenis)

    1 year, 4 months ago

    Thank you for telling us guys.
    Could you confirm this too @steponme and @ellememe if this fixed the issue you had too?

    This will help us identify any other small buggy parts that create this issue.
    Cheers,

    steponme

    (@steponme)

    1 year, 4 months ago

    Nope, no luck

    Tried to update: nothing
    Tried to deactivate/reactivate: nothing

    Database optimization did not complete successfully. We recommend restoring the original database or trying again.

    This is the message. If i try to rebuild, i get the sql error you see at my previous message.

    I would like to restore the previous database, but i do not know how to do it

    Can you help me out? My translations are shut off, right now.

    steponme

    (@steponme)

    1 year, 4 months ago

    Errore sul database di WordPress: [Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation ‘=’]
    INSERT INTO wp_trp_original_strings (original) SELECT DISTINCT ( BINARY t1.original ) FROM wp_trp_dictionary_it_it_en_us t1 LEFT JOIN wp_trp_original_strings t2 ON ( t2.original = t1.original AND t2.original = BINARY t1.original ) WHERE t2.original IS NULL AND t1.id > 0 AND t1.id <= 1000 AND LENGTH(t1.original) < 20000{“action”:”trp_update_database”,”trp_updb_action”:”original_id_insert_166″,”trp_updb_lang”:”de_DE”,”trp_updb_batch”:0,”trp_updb_nonce”:”f5a79ed71c”,”trp_update_completed”:”no”,”progress_message”:”fatto.<\/br><\/br>Inserting original strings for language de_DE…”}

    This is the error i get if i try to update

    ellememe

    (@ellememe)

    1 year, 4 months ago

    @sdenis I did try the update today. It didn’t seem to have any effect. I still have mismatch in the original language… I can’t tell if it is new ones or old ones, though.

    I checked the database earlier this week (before update), and it looks like there is an offset in the database vs TP string translation app. Some strings are duplicate, and translation in database is not the same than what’s showing in TP string translation app.

    Here are some examples:

    From what I can recall, the bug started after some translations were manually fixed using the string translation app, but not right after. Only with TP following update.

    How can I fix the database? Will I have to start afresh, losing all the work that was done? Or have to manually go through the whole database to check translations? 🙁

    P.S. The plugin is currently not active on the site, because I don’t want people to run into those strange translations while shopping…

    Hope you can figure out something with these infos…

Viewing 5 replies - 16 through 20 (of 20 total)
1 2
  • The topic ‘Strange translations in the MAIN language’ is closed to new replies.