Skip to content Skip to sidebar

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

Problem:
If you're experiencing issues with a search form from the Real Homes theme not displaying in Spanish on a specific page, despite working correctly on another, the issue might be related to database corruption.
Solution:
First, ensure you have a backup of your site. If the problem persists, you might need to run a SQL query to fix a corrupted database table. Here's the query you might need:

ALTER TABLE `gzjbzwdm_icl_string_packages`<br />CHANGE `post_id` `post_id` bigint(20) NULL AFTER `view_link`;

Make sure to replace 'gzjbzwdm_icl_string_packages' with the actual table name in your database. After running this query, try sending the page for translation again.

If this solution does not resolve your issue or seems irrelevant due to being outdated or not applicable to your case, we highly recommend checking related known issues, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If problems persist, please open a new support ticket.

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 20 replies, has 1 voice.

Last updated by Dražen 4 months ago.

Assisted by: Dražen.

Author Posts
May 14, 2025 at 6:07 am #17030143

Dražen
Supporter

Languages: English (English )

Timezone: Europe/Zagreb (GMT+02:00)

Hello Kaur,

seems the issue was corrupted DB table. This is SQL query we run and it fixes the issue:

-

ALTER TABLE `gzjbzwdm_icl_string_packages`
CHANGE `post_id` `post_id` bigint(20) NULL AFTER `view_link`;

Please run the same on your live website from hosting phpmyadmin, just make sure that the name of the table is correct and change it the query above if needed.

Then you can send page for translation and translate.

Please make sure to create a backup before doing any actions, just in case.

Regards,
Drazen

May 14, 2025 at 10:58 am #17031768

kaurM

Hi Drazen,

I performed a database update and sent the page for translation again, but the result remains the same. The search form is still not translated.

Could you please assist me with this issue?

Thank you!

May 14, 2025 at 1:06 pm #17032412

Dražen
Supporter

Languages: English (English )

Timezone: Europe/Zagreb (GMT+02:00)

Hello,

I also tried it also but it seems it is not working on your dev site.

Let me recheck with our 2nd tier if anything else is needed.

Regards,
Drazen

May 14, 2025 at 1:58 pm #17032797

Dražen
Supporter

Languages: English (English )

Timezone: Europe/Zagreb (GMT+02:00)

Hello,

The problem was the string package. Since DB had some tables corrupted from before, it also caused some entries to be corrupted.

We had to run actions to make the post_id the same as the actual ID, image attached. So for ID 49 we set post_id the same as the name value.

Then we saved the page and reopened it ATE - the translation is now available and translated.

Regards,
Drazen

image1.png
May 15, 2025 at 12:00 pm #17036687

kaurM

Thank you very much for your assistance; everything seems to be working now.

Could you confirm if this was a one-time issue, or should I expect similar problems when adding new languages in the future?

Additionally, I have a follow-up question. I noticed that the Elementor editor is constantly reloading. Can you provide any insights on what might be causing this? This issue did not occur before I added the WPML plugin.

I have emptied all possible caches. Might this be something that was needed for testing purposes?

Thank you for your help!

May 15, 2025 at 12:05 pm #17036701

Dražen
Supporter

Languages: English (English )

Timezone: Europe/Zagreb (GMT+02:00)

Hello,

issue was due some DB corruption, so it should not happen anymore now that is fixed.

As for Elementor issue, I am not sure what do you mean. I tried to edit with Elementor and it works fine for me.

If issue still happens for you I would advise checking on another device, and with WPML disabled to confirm it is related to WPML. If you still need our help, let me know and I can open new ticket for you or you can open new chat via support link.

Regards,
Drazen