Table ’emga25_0125sam.PfJ018_trp_gettext_fr_fr’ doesn’t exist

  • Hi everyone, i cloned a website that was in English (with french – spanish – german translation).. to create another one in french..that will be translated in a future.

    So I had a lot of character problems after this.. and I decided remove the tables following this link: https://translatepress.com/docs/developers/delete-all-translations-and-plugin-data/

    Now I get error TranslatePress encountered SQL errors. Check out the errors.:

    Logged errors

    These are the most recent 5 errors logged by TranslatePress:

    1last_errorTable ’emga25_0125sam.PfJ018_trp_gettext_fr_fr’ doesn’t existdisable_automatic_translationsYesurlhttps://chaletrosablanche.ch/wp-admin/admin-ajax.php?action=as_async_request_queue_runner&nonce=c366d2b3ecdetailsError running insert_gettext_strings()last_querySELECT option_value FROM PfJ018_options WHERE option_name = ‘home’ LIMIT 1date_time2025-03-06 07:19:05timestamp1741245545

    2last_errorTable ’emga25_0125sam.PfJ018_trp_gettext_fr_fr’ doesn’t existdisable_automatic_translationsYesurlhttps://chaletrosablanche.ch/wp-admin/admin-ajax.php?action=as_async_request_queue_runner&nonce=c366d2b3ecdetailsError running insert_gettext_strings()last_queryINSERT INTO PfJ018_trp_gettext_fr_fr ( original, translated, domain, status, plural_form, original_id ) VALUES ( ‘Upgrade to PRO today and get access to automatic word-count based insert locations.’, ”, ‘insert-headers-and-footers’, ‘0’, ‘0’, ‘0’)date_time2025-03-06 07:19:00timestamp1741245540

    3last_errorTable ’emga25_0125sam.PfJ018_trp_gettext_fr_fr’ doesn’t existdisable_automatic_translationsYesurlhttps://chaletrosablanche.ch/wp-admin/admin-ajax.php?action=as_async_request_queue_runner&nonce=c366d2b3ecdetailsError running insert_gettext_strings()last_queryINSERT INTO PfJ018_trp_gettext_fr_fr ( original, translated, domain, status, plural_form, original_id ) VALUES ( ‘Word-based content locations are a PRO feature’, ”, ‘insert-headers-and-footers’, ‘0’, ‘0’, ‘0’)date_time2025-03-06 07:19:00timestamp1741245540

    4last_errorTable ’emga25_0125sam.PfJ018_trp_gettext_fr_fr’ doesn’t existdisable_automatic_translationsYesurlhttps://chaletrosablanche.ch/wp-admin/admin-ajax.php?action=as_async_request_queue_runner&nonce=c366d2b3ecdetailsError running insert_gettext_strings()last_queryINSERT INTO PfJ018_trp_gettext_fr_fr ( original, translated, domain, status, plural_form, original_id ) VALUES ( ‘Upgrade to PRO today and insert snippets anywhere on your site using CSS selectors to target any HTML element.’, ”, ‘insert-headers-and-footers’, ‘0’, ‘0’, ‘0’)date_time2025-03-06 07:19:00timestamp1741245540

    5last_errorTable ’emga25_0125sam.PfJ018_trp_gettext_fr_fr’ doesn’t existdisable_automatic_translationsYesurlhttps://chaletrosablanche.ch/wp-admin/admin-ajax.php?action=as_async_request_queue_runner&nonce=c366d2b3ecdetailsError running insert_gettext_strings()last_queryINSERT INTO PfJ018_trp_gettext_fr_fr ( original, translated, domain, status, plural_form, original_id ) VALUES ( ‘Insert Anywhere by CSS Selector is a Premium feature’, ”, ‘insert-headers-and-footers’, ‘0’, ‘0’, ‘0’)date_time2025-03-06 07:19:00timestamp1741245540

    What could I do ?

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

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support Alex

    (@alexcozmoslabs)

    Hi,

    Go to Settings -> TranslatePress -> General tab and Save Settings. This will regenerate the _trp_gettext_ tables using your current SQL server.

    Thread Starter greenative

    (@greenative)

    Hi Alex,

    I did it.. but as french is NOW the first language.. it doesn’t create this table: PfJ018_trp_gettext_fr_fr

    How can I do, I tried to delete plugin, delete database and entries, but then when I reinstall I get the error directly.

    Plugin Support Alex

    (@alexcozmoslabs)

    Hi,

    The gettext table is created for the default language as well.
    What you can do is to access your database and looking for _trp_gettext_fr_fr table. When you identify it, you can just drop it, then go to Settings -> TranslatePress -> General tab and Save Settings. This should regenerate the detected gettext string, thus that _trp_gettext_fr_fr table as well.

    Kind Regards,

    Thread Starter greenative

    (@greenative)

    I have not this table created.. even If I save, I dont get it in DB… NOw I have another errors:

    Logged errors

    These are the most recent 5 errors logged by TranslatePress:

    1last_errorUnknown character set: ‘utf8mb4_unicode_ci’disable_automatic_translationsYesurlhttps://chaletrosablanche.ch/wp-admin/options.phpdetailsError creating gettext strings tableslast_queryCREATE TABLE PfJ018_trp_gettext_en_gb( id bigint(20) AUTO_INCREMENT NOT NULL PRIMARY KEY, original longtext NOT NULL, translated longtext, domain longtext, status int(20), original_id bigint(20), plural_form int(20), UNIQUE KEY id (id) ) DEFAULT CHARACTER SET utf8mb4_unicode_cidate_time2025-03-08 01:57:06timestamp1741399026

    2last_errordisable_automatic_translationsYesurlhttps://chaletrosablanche.ch/wp-admin/options.phpdetailsError creating regular strings tableslast_querySHOW TABLES LIKE ‘PfJ018_trp_dictionary_fr_fr_en_gb’date_time2025-03-08 01:57:06timestamp1741399026

    3last_errorTable ’emga25_0125sam.PfJ018_trp_dictionary_fr_fr_en_gb’ doesn’t existdisable_automatic_translationsYesurlhttps://chaletrosablanche.ch/wp-admin/options.phpdetailsError creating regular tableslast_queryCREATE INDEX block_type ON PfJ018_trp_dictionary_fr_fr_en_gb (block_type);date_time2025-03-08 01:57:06timestamp1741399026

    4last_errorUnknown character set: ‘utf8mb4_unicode_ci’disable_automatic_translationsYesurlhttps://chaletrosablanche.ch/wp-admin/options.phpdetailsError creating gettext strings tableslast_queryCREATE TABLE PfJ018_trp_gettext_fr_fr( id bigint(20) AUTO_INCREMENT NOT NULL PRIMARY KEY, original longtext NOT NULL, translated longtext, domain longtext, status int(20), original_id bigint(20), plural_form int(20), UNIQUE KEY id (id) ) DEFAULT CHARACTER SET utf8mb4_unicode_cidate_time2025-03-08 01:57:06timestamp1741399026

    5last_errorTable ’emga25_0125sam.PfJ018_trp_gettext_fr_fr’ doesn’t existdisable_automatic_translationsYesurlhttps://chaletrosablanche.ch/2023/favicon.icodetailsError running insert_gettext_strings()last_queryINSERT INTO PfJ018_trp_gettext_fr_fr ( original, translated, domain, status, plural_form, original_id ) VALUES ( ‘Support’, ”, ‘rocket’, ‘0’, ‘0’, ‘0’)date_time2025-03-08 01:57:03timestamp1741399023

    IS there a way to reset 100% the plugin and reinstall it without to get those errors ?

    Thread Starter greenative

    (@greenative)

    Or could I create the table manually, do you have the format?

Viewing 5 replies - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.