Skip Navigation

This thread is resolved. Here is a description of the problem and solution.

Problem:
The client was unable to use the WPML translation editor to translate a page from Italian to English using Elementor. The content did not appear, and the page continued to load without showing the original content in the fields for translation.

Solution:
We recommended the client to:
1. Ensure that Elementor widgets are registered for translation as explained in our documentation: Registering Custom Elementor Widgets for Translation.
2. If the issue persists, we provided a series of SQL queries to clean up invalid records from the database and reset auto-increment values. The client should:
- Make sure to have a complete database backup.
- Run the following SQL queries to delete invalid records:

DELETE FROM `wp_borgo23_icl_mo_files_domains` WHERE id = 0;<br />DELETE FROM `wp_borgo23_icl_strings` WHERE id = 0;<br />DELETE FROM `wp_borgo23_icl_string_packages` WHERE ID = 0;<br />DELETE FROM `wp_borgo23_icl_string_positions` WHERE id = 0;<br />DELETE FROM `wp_borgo23_icl_string_translations` WHERE id = 0;<br />DELETE FROM `wp_borgo23_icl_translate` WHERE tid = 0;<br />DELETE FROM `wp_borgo23_icl_translate_job` WHERE job_id = 0;

- If no errors occur, run the following queries to alter tables:

SET sql_mode = '';<br />ALTER TABLE `wp_borgo23_icl_flags` CHANGE `id` `id` INT NOT NULL AUTO_INCREMENT;<br />ALTER TABLE `wp_borgo23_icl_languages` CHANGE `id` `id` INT NOT NULL AUTO_INCREMENT;<br />ALTER TABLE `wp_borgo23_icl_languages_translations` CHANGE `id` `id` INT NOT NULL AUTO_INCREMENT;<br />ALTER TABLE `wp_borgo23_icl_mo_files_domains` CHANGE `id` `id` INT NOT NULL AUTO_INCREMENT;<br />ALTER TABLE `wp_borgo23_icl_strings` CHANGE `id` `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT;<br />ALTER TABLE `wp_borgo23_icl_string_packages` CHANGE `ID` `ID` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT;<br />ALTER TABLE `wp_borgo23_icl_string_positions` CHANGE `id` `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT;<br />ALTER TABLE `wp_borgo23_icl_string_translations` CHANGE `id` `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT;<br />ALTER TABLE `wp_borgo23_icl_translate` CHANGE `tid` `tid` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT;<br />ALTER TABLE `wp_borgo23_icl_translate_job` CHANGE `job_id` `job_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT;

- After running the queries successfully, edit the homepage with Elementor, make a minor change, update, and then attempt to translate again.

Please note that this solution might be irrelevant due to being outdated or not applicable to your case. If the issue persists, we highly recommend checking related known issues at WPML Known Issues, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If needed, do not hesitate to open a new support ticket for further assistance.

This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

Tagged: 

This topic contains 19 replies, has 2 voices.

Last updated by maraZ 1 year, 4 months ago.

Assisted by: Kor.

Author Posts
January 23, 2024 at 4:01 pm #15218204

maraZ

hi, i'm trying to open a new ticket but it doesn't work.
my problem is the same as the last ticket I entered, but even following both advices I received I can't get the translation queue to work.

January 23, 2024 at 4:16 pm #15218240

Kor
WPML Supporter since 08/2022

Languages: English (English )

Timezone: Asia/Singapore (GMT+08:00)

Thanks for your patience.

Here is the ticket and please let me know how it goes.

January 23, 2024 at 4:21 pm #15218247

maraZ

Hi, I tried to install the plugin and open the page in edit mode, exactly as recommended, but in the indicated section the message I receive is "All widgets on this page are already registered.", and if I still try to add a translation The translation queue page opens, empty.

January 23, 2024 at 4:24 pm #15218253

Kor
WPML Supporter since 08/2022

Languages: English (English )

Timezone: Asia/Singapore (GMT+08:00)

Thanks for your reply.

I will need to closely examine your website. Therefore, I will require temporary access (WP-Admin and FTP) to a test site where the problem has been replicated, if possible. This will enable me to provide better assistance and determine if any configurations need to be modified.

Please note that it is important to have a backup for security purposes and to prevent any potential data loss. You can use the UpdraftPlus plugin (https://wordpress.org/plugins/updraftplus/) to fulfill your backup requirements.

Your upcoming reply will be treated with confidentiality and will only be visible to you and me.

✙ To resolve the issue, I may need your consent to deactivate and reactivate plugins and the theme, as well as make configuration changes on the site if necessary. This emphasizes the significance of having a backup.

January 24, 2024 at 4:47 pm #15222980

maraZ

hi, my bad.
the user was set in the main site instead of the clone.
Now it works, i've checked

Thank you and sorry for the trouble.

January 25, 2024 at 7:53 am #15224688

Kor
WPML Supporter since 08/2022

Languages: English (English )

Timezone: Asia/Singapore (GMT+08:00)

Thanks for your reply.

I could see this "strange text/code" here hidden link as shown in the attached screenshot. This is what's breaking the Advanced Translation Editor. Could you remove or replace it?

Please check your other pages and make sure you clean up these "strange text/code". Let me know how it goes.

Screenshot 2024-01-25 at 3.51.53 PM.jpg
January 25, 2024 at 8:29 am #15224789

maraZ

Hello and thanks for the reply;

the code you found was in "Home new" but is not in the other pages I listed; in any case, even by removing that code the translation doesn't work, at least for me.
once I delete the suspicious text in "Home new" from the "all pages" table in wp if I click on the "gear" icon to edit the translation, wp tries to load the advanced editor but remains blocked as per the screenshot.

For the other pages, (Wine Vinegars / Aged Condiments) unable to find any strange code, however, trying to add or edit the translation opens the translation queue showing only an empty "No data" table

I attach screenshots

translation queue.png
advanced editor.png
January 25, 2024 at 2:40 pm #15226775

Kor
WPML Supporter since 08/2022

Languages: English (English )

Timezone: Asia/Singapore (GMT+08:00)

Thanks for your reply.

Could you register a new sitekey for this site hidden link ?

The translation issue could be related to the invalid sitekey. Let me know once you've generated a new sitekey here https://wpml.org/account/sites/ and activate it here hidden link

January 25, 2024 at 3:56 pm #15227254

maraZ

Hi, i've generated a new sitekey and registered the clone site

Thank you

January 26, 2024 at 5:12 pm #15231294

Kor
WPML Supporter since 08/2022

Languages: English (English )

Timezone: Asia/Singapore (GMT+08:00)

Thanks for your patience.

We apologize for the inconvenience, but in order to proceed with troubleshooting, we kindly request a site snapshot. Alternatively, with your permission, we can create a snapshot on our own.

For this purpose, we typically recommend using the free plugin "Duplicator." If you are already familiar with how Duplicator works ( https://wordpress.org/plugins/duplicator/), please skip the following steps and simply send me the archive file you downloaded.

To assist you further, please follow these instructions:
Watch the Duplicator instructions video: hidden link

Refer to the instructions provided by WPML on how to provide supporters a copy of your site: https://wpml.org/faq/provide-supporters-copy-site/

If the archive file exceeds 400MB in size, please utilize Duplicator's file filters to exclude the cache, wp-uploads directory, media, and archive files.

Once you have the archive file, please share the link with us. You can use services such as Google Drive, Dropbox, or similar platforms as the snapshot file will likely be large.

Please note that your next reply will be private, visible only to you and me. You can paste the link to the file there. Rest assured that once the issue is resolved, I will delete the local site.

January 30, 2024 at 12:22 pm #15243255

Kor
WPML Supporter since 08/2022

Languages: English (English )

Timezone: Asia/Singapore (GMT+08:00)

Thanks for your patience.

I will have to escalate this further to our 2nd Tier Support. I will get back to you once I've feedback.

January 30, 2024 at 1:12 pm #15243906

maraZ

Thank you very much, I will wait for your feedback

February 5, 2024 at 10:10 am #15265252

maraZ

Any news?

February 5, 2024 at 10:40 am #15265334

Kor
WPML Supporter since 08/2022

Languages: English (English )

Timezone: Asia/Singapore (GMT+08:00)

Thanks for your patience.

Our second tier support checked and the issue is related to your database. There seems to be a broken table and they are still investigating this. I will get back to you once I've feedback.

February 9, 2024 at 6:50 pm #15287324

Kor
WPML Supporter since 08/2022

Languages: English (English )

Timezone: Asia/Singapore (GMT+08:00)

Thanks for your patience.

This is fixed and could you please check?