Skip Navigation

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

Problem:

The advanced translator only shows the title of the page with an error in the debug log.

WordPress database error Unknown column 'wrap_tag' in 'field list' for query
SELECT id, name, value, wrap_tag, type, title
FROM wp_icl_strings
WHERE string_package_id=18
ORDER BY location, id ASC made by shutdown_action_hook, do_action('shutdown')

Solution:

1- Take a database backup
2- Run the following query

ALTER TABLE wp_icl_strings 
ADD `location` BIGINT unsigned NULL AFTER `string_package_id`,
ADD `wrap_tag` VARCHAR( 16 ) NOT NULL AFTER `location`;

3- Update the page in the default language
4- Update the Translation

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 13 replies, has 3 voices.

Last updated by janL-8 1 year, 5 months ago.

Assisted by: Osama Mersal.

Author Posts
September 19, 2023 at 12:21 pm #14419349

janL-8

Tell us what you are trying to do?
Trying to translate pages into finnish from swedish

Is there any documentation that you are following?
Sure, nothing solves my problem

Is there a similar example that we can see?
Attached image

What is the link to your site?
hidden link

Screenshot 2023-09-19 at 15.20.13.png
September 20, 2023 at 12:10 am #14425707

Bobby
Supporter

Languages: English (English )

Timezone: America/Los_Angeles (GMT-08:00)

While you are waiting for one of my colleagues to take this ticket and work on it, let me provide you with the first debugging steps

- Edit your page in the default language
- Make a small change and update
- Access the translation now

Do you see the page content now?

IF you still do not see the content please share with us how you create/add this page content, is it done by a page builder or ACF fields?

September 20, 2023 at 7:24 am #14426905

janL-8

Hello, it did not work, same problem persists. I did the pages in Elementor, for some reason it also says block and classic editor.

September 20, 2023 at 7:45 am #14427123

Osama Mersal
Supporter

Languages: English (English ) Arabic (العربية )

Timezone: Africa/Cairo (GMT+02:00)

Hi,

I'm Osama from WPML forums support. I'll be glad to help you today.

I would need to look closely at your site, so I would need to request temporary access (WP-Admin and FTP)
– preferably to a test site where the problem has been replicated if possible –
in order to be of better help and check if some configurations might need to be changed.

Your next answer will be private, which means only you and I can access it.

❌ Please backup your database and website ❌

✙ I would need your permission to de-activate and re-activate the Plugins and the Theme and change configurations on the site. This is also a reason the backup is critical.

✙ I also need your permission to take a local copy of your site to debug the issue without affecting your live site.

Best regards,

September 20, 2023 at 8:39 am #14427633

Osama Mersal
Supporter

Languages: English (English ) Arabic (العربية )

Timezone: Africa/Cairo (GMT+02:00)

Hi,

Thanks for the access details. I checked the settings and ran the troubleshooting functions with no luck.

I need your permission to install the Duplicator plugin and take a local copy of your site to debug the issue without affecting your live site.

Best regards,
Osama

September 20, 2023 at 8:40 am #14427647

janL-8

You have my permission to do so, thank you!

September 20, 2023 at 10:01 am #14428621

Osama Mersal
Supporter

Languages: English (English ) Arabic (العربية )

Timezone: Africa/Cairo (GMT+02:00)

Hi,

Thanks for your permission. I've consulted our 2nd tier support team regarding the issue and will update you as soon as I get their reply.

Best regards,
Osama

September 21, 2023 at 1:02 pm #14439243

janL-8

Hey, did we move forward with this? Has it maybe something to do with the classic and and block editors listed as editors under the pages in wordpress?

September 21, 2023 at 1:07 pm #14439255

Osama Mersal
Supporter

Languages: English (English ) Arabic (العربية )

Timezone: Africa/Cairo (GMT+02:00)

Hi,

Thanks for your patience. I've just received our 2nd tier support reply. Please check the following steps:

1- Take a database backup
2- Run the following query

ALTER TABLE wp2h_icl_strings 
ADD `location` BIGINT unsigned NULL AFTER `string_package_id`,
ADD `wrap_tag` VARCHAR( 16 ) NOT NULL AFTER `location`;

After that, please update the page in the default language and try to translate it.

Best regards,
Osama

September 21, 2023 at 1:19 pm #14439541

janL-8

Hey,
I did the query. What do you mean by update the page? Nothing has changed, same problem.

September 21, 2023 at 1:22 pm #14439563

Osama Mersal
Supporter

Languages: English (English ) Arabic (العربية )

Timezone: Africa/Cairo (GMT+02:00)

Hi,

Please edit the page in the default language and click the update button. After that, click on the "Snining Arrows" icon to open the translation editor.

Best regards,

September 21, 2023 at 1:25 pm #14439615

janL-8

Well, that's very nice, now it works! What did we do?

September 21, 2023 at 1:27 pm #14439625

Osama Mersal
Supporter

Languages: English (English ) Arabic (العربية )

Timezone: Africa/Cairo (GMT+02:00)

Hi,

It's great to hear that the issue is fixed 🙂 . The problem was in this table because it didn't have two attributes, so the query added them.

Please don't hesitate to open a new ticket if you face any other issues. We are always happy to help you.

Have a great day!

Best regards,
Osama

September 21, 2023 at 1:28 pm #14439639

janL-8

Very good, thank you for the help!

/ Jan