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: Exception
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? Is there any documentation that you are following? Is there a similar example that we can see? What is the link to your site? |
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 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) 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, |
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, |
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 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, |
September 21, 2023 at 1:19 pm #14439541 | |
janL-8 |
Hey, |
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, |
September 21, 2023 at 1:28 pm #14439639 | |
janL-8 |
Very good, thank you for the help! / Jan |