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
February 12, 2024 at 7:51 am #15291153

maraZ

Hi where i can check the solution?

February 12, 2024 at 9:36 am #15291751

Kor
WPML Supporter since 08/2022

Languages: English (English )

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

Thanks for your reply.

There isn't a fixed solution since this is related to the database. However, we have used the SQL query below to fix it.

To fix this follow these steps:-

Make sure you have complete DB backup
First run this query to delete invalid records

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

If all good you see no error then run these queries

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

If queries are successful with no error. Edit the home page with with Elementor do minor change and update, then translate again. This should work this time.

February 13, 2024 at 1:52 pm #15297887

maraZ

Hi,
I tried; the first set of commands gave no problems, but in the second case php my admin gives me the error that is in the attached file.
I tried to do a translation anyway and it doesn't work. it even gives me critical wordpress error.

Screenshot 2024-02-13 145011.png
February 13, 2024 at 6:08 pm #15299132

Kor
WPML Supporter since 08/2022

Languages: English (English )

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

Thanks for your reply.

As I've mentioned earlier, I've already applied the fix for you and I'm able to use the Advanced Translation Editor on your elementor pages without issues. Have you given it a try?

February 14, 2024 at 4:09 pm #15303521

maraZ

After at least three unsuccessful attempts, I succeeded.

I would like to thank all of you for your patience and professionalism.
You went above and beyond the call of duty, we thank you from the bottom of our hearts.