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.

This topic contains 2 replies, has 2 voices.

Last updated by Lauren 1 year ago.

Assigned support staff: Lauren.

Author Posts
October 11, 2018 at 6:26 pm #2809458

lisaS-6

I am trying to:
The site has three languages: English (primary), French, German. Pages are built with a custom ACF page builder. We have used the same approach on other sites without problem. On this site there are 12 post types. When we add additional post types as translatable no post meta is copied to a translated page. Unmarking the post types does not restore proper functionality.

I have tried many things, including deactivating all the plugins/themes that I could. The issue is not anywhere in code that I can find after several days of troubleshooting. It exists somewhere in the database. I have proven this with a fresh install of the project working, then importing the db of the live site and the issue shows again.

ALL post meta is ignored, not just ACF fields. In fact the ACF field names are copied, but not their data, or any other post meta.

To replicate the issue:
- Create a new page
- Add some post meta (ACF blocks)
- Save
- Create a translation in any language
- Click to overwrite with English content
ACF shows up, but no content.

Note: This behavior only happens after saving settings for making other post types translatable.

What could be causing this?

I do see a lot of db errors in the log
-staging_wordpress_1 | [Thu Oct 11 18:24:29.822236 2018] [:error] [pid 181] [client 172.22.0.2:44254] WordPress database error Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=' for query SELECT st.status, l.code, st.translator_id, st.translation_service, i.trid\n\t\t\t\tFROM wp_icl_languages l\n\t\t\t\tLEFT JOIN wp_icl_translations i\n\t\t\t\t\tON l.code = i.language_code\n\t\t\t\tJOIN wp_icl_translation_status st\n\t\t\t\t\tON i.translation_id = st.translation_id\n\t\t\t\tWHERE l.active = 1\n\t\t\t\t\tAND i.trid IN ( 2018 )\n\t\t\t\t\tOR i.trid IS NULL made by WP_List_Table->display, WP_List_Table->display_rows_or_placeholder, WP_Posts_List_Table->display_rows, WP_Posts_List_Table->_display_rows_hierarchical, WP_Posts_List_Table->single_row, WP_List_Table->single_row_columns, WP_Posts_List_Table->column_default, do_action('manage_pages_custom_column'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_Custom_Columns->add_content_for_posts_management_column, WPML_Post_Status_Display->get_status_html, apply_filters('wpml_link_to_translation'), WP_Hook->apply_filters, WPML_TM_Translation_Status_Display->filter_status_link, WPML_TM_Translation_Status_Display->maybe_load_stats, WPML_TM_Translation_Status_Display->load_stats, referer: /wp-admin/update-core.php
-staging_wordpress_1 | [Thu Oct 11 18:24:29.842577 2018] [:error] [pid 181] [client 172.22.0.2:44254] WordPress database error Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=' for query SELECT st.status, l.code, st.translator_id, st.translation_service, i.trid\n\t\t\t\tFROM wp_icl_languages l\n\t\t\t\tLEFT JOIN wp_icl_translations i\n\t\t\t\t\tON l.code = i.language_code\n\t\t\t\tJOIN wp_icl_translation_status st\n\t\t\t\t\tON i.translation_id = st.translation_id\n\t\t\t\tWHERE l.active = 1\n\t\t\t\t\tAND i.trid IN ( 3863 )\n\t\t\t\t\tOR i.trid IS NULL made by WP_List_Table->display, WP_List_Table->display_rows_or_placeholder, WP_Posts_List_Table->display_rows, WP_Posts_List_Table->_display_rows_hierarchical, WP_Posts_List_Table->single_row, WP_List_Table->single_row_columns, WP_Posts_List_Table->column_default, do_action('manage_pages_custom_column'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_Custom_Columns->add_content_for_posts_management_column, WPML_Post_Status_Display->get_status_html, apply_filters('wpml_link_to_translation'), WP_Hook->apply_filters, WPML_TM_Translation_Status_Display->filter_status_link, WPML_TM_Translation_Status_Display->maybe_load_stats, WPML_TM_Translation_Status_Display->load_stats, referer: /wp-admin/update-core.php
-staging_wordpress_1 | [Thu Oct 11 18:24:29.862940 2018] [:error] [pid 181] [client 172.22.0.2:44254] WordPress database error Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=' for query SELECT st.status, l.code, st.translator_id, st.translation_service, i.trid\n\t\t\t\tFROM wp_icl_languages l\n\t\t\t\tLEFT JOIN wp_icl_translations i\n\t\t\t\t\tON l.code = i.language_code\n\t\t\t\tJOIN wp_icl_translation_status st\n\t\t\t\t\tON i.translation_id = st.translation_id\n\t\t\t\tWHERE l.active = 1\n\t\t\t\t\tAND i.trid IN ( 2130 )\n\t\t\t\t\tOR i.trid IS NULL made by WP_List_Table->display, WP_List_Table->display_rows_or_placeholder, WP_Posts_List_Table->display_rows, WP_Posts_List_Table->_display_rows_hierarchical, WP_Posts_List_Table->single_row, WP_List_Table->single_row_columns, WP_Posts_List_Table->column_default, do_action('manage_pages_custom_column'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_Custom_Columns->add_content_for_posts_management_column, WPML_Post_Status_Display->get_status_html, apply_filters('wpml_link_to_translation'), WP_Hook->apply_filters, WPML_TM_Translation_Status_Display->filter_status_link, WPML_TM_Translation_Status_Display->maybe_load_stats, WPML_TM_Translation_Status_Display->load_stats, referer: /wp-admin/update-core.php
-staging_wordpress_1 | [Thu Oct 11 18:24:29.878715 2018] [:error] [pid 181] [client 172.22.0.2:44254] WordPress database error Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=' for query SELECT st.status, l.code, st.translator_id, st.translation_service, i.trid\n\t\t\t\tFROM wp_icl_languages l\n\t\t\t\tLEFT JOIN wp_icl_translations i\n\t\t\t\t\tON l.code = i.language_code\n\t\t\t\tJOIN wp_icl_translation_status st\n\t\t\t\t\tON i.translation_id = st.translation_id\n\t\t\t\tWHERE l.active = 1\n\t\t\t\t\tAND i.trid IN ( 2137 )\n\t\t\t\t\tOR i.trid IS NULL made by WP_List_Table->display, WP_List_Table->display_rows_or_placeholder, WP_Posts_List_Table->display_rows, WP_Posts_List_Table->_display_rows_hierarchical, WP_Posts_List_Table->single_row, WP_List_Table->single_row_columns, WP_Posts_List_Table->column_default, do_action('manage_pages_custom_column'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_Custom_Columns->add_content_for_posts_management_column, WPML_Post_Status_Display->get_status_html, apply_filters('wpml_link_to_translation'), WP_Hook->apply_filters, WPML_TM_Translation_Status_Display->filter_status_link, WPML_TM_Translation_Status_Display->maybe_load_stats, WPML_TM_Translation_Status_Display->load_stats, referer: /wp-admin/update-core.php
-staging_wordpress_1 | [Thu Oct 11 18:24:29.895922 2018] [:error] [pid 181] [client 172.22.0.2:44254] WordPress database error Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=' for query SELECT st.status, l.code, st.translator_id, st.translation_service, i.trid\n\t\t\t\tFROM wp_icl_languages l\n\t\t\t\tLEFT JOIN wp_icl_translations i\n\t\t\t\t\tON l.code = i.language_code\n\t\t\t\tJOIN wp_icl_translation_status st\n\t\t\t\t\tON i.translation_id = st.translation_id\n\t\t\t\tWHERE l.active = 1\n\t\t\t\t\tAND i.trid IN ( 971 )\n\t\t\t\t\tOR i.trid IS NULL made by WP_List_Table->display, WP_List_Table->display_rows_or_placeholder, WP_Posts_List_Table->display_rows, WP_Posts_List_Table->_display_rows_hierarchical, WP_Posts_List_Table->single_row, WP_List_Table->single_row_columns, WP_Posts_List_Table->column_default, do_action('manage_pages_custom_column'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_Custom_Columns->add_content_for_posts_management_column, WPML_Post_Status_Display->get_status_html, apply_filters('wpml_link_to_translation'), WP_Hook->apply_filters, WPML_TM_Translation_Status_Display->filter_status_link, WPML_TM_Translation_Status_Display->maybe_load_stats, WPML_TM_Translation_Status_Display->load_stats, referer: /wp-admin/update-core.php
-staging_wordpress_1 | [Thu Oct 11 18:24:29.912221 2018] [:error] [pid 181] [client 172.22.0.2:44254] WordPress database error Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=' for query SELECT st.status, l.code, st.translator_id, st.translation_service, i.trid\n\t\t\t\tFROM wp_icl_languages l\n\t\t\t\tLEFT JOIN wp_icl_translations i\n\t\t\t\t\tON l.code = i.language_code\n\t\t\t\tJOIN wp_icl_translation_status st\n\t\t\t\t\tON i.translation_id = st.translation_id\n\t\t\t\tWHERE l.active = 1\n\t\t\t\t\tAND i.trid IN ( 978 )\n\t\t\t\t\tOR i.trid IS NULL made by WP_List_Table->display, WP_List_Table->display_rows_or_placeholder, WP_Posts_List_Table->display_rows, WP_Posts_List_Table->_display_rows_hierarchical, WP_Posts_List_Table->single_row, WP_List_Table->single_row_columns, WP_Posts_List_Table->column_default, do_action('manage_pages_custom_column'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_Custom_Columns->add_content_for_posts_management_column, WPML_Post_Status_Display->get_status_html, apply_filters('wpml_link_to_translation'), WP_Hook->apply_filters, WPML_TM_Translation_Status_Display->filter_status_link, WPML_TM_Translation_Status_Display->maybe_load_stats, WPML_TM_Translation_Status_Display->load_stats, referer: /wp-admin/update-core.php
-staging_wordpress_1 | [Thu Oct 11 18:24:29.931270 2018] [:error] [pid 181] [client 172.22.0.2:44254] WordPress database error Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=' for query SELECT st.status, l.code, st.translator_id, st.translation_service, i.trid\n\t\t\t\tFROM wp_icl_languages l\n\t\t\t\tLEFT JOIN wp_icl_translations i\n\t\t\t\t\tON l.code = i.language_code\n\t\t\t\tJOIN wp_icl_translation_status st\n\t\t\t\t\tON i.translation_id = st.translation_id\n\t\t\t\tWHERE l.active = 1\n\t\t\t\t\tAND i.trid IN ( 3541 )\n\t\t\t\t\tOR i.trid IS NULL made by WP_List_Table->display, WP_List_Table->display_rows_or_placeholder, WP_Posts_List_Table->display_rows, WP_Posts_List_Table->_display_rows_hierarchical, WP_Posts_List_Table->single_row, WP_List_Table->single_row_columns, WP_Posts_List_Table->column_default, do_action('manage_pages_custom_column'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_Custom_Columns->add_content_for_posts_management_column, WPML_Post_Status_Display->get_status_html, apply_filters('wpml_link_to_translation'), WP_Hook->apply_filters, WPML_TM_Translation_Status_Display->filter_status_link, WPML_TM_Translation_Status_Display->maybe_load_stats, WPML_TM_Translation_Status_Display->load_stats, referer: /wp-admin/update-core.php
-staging_wordpress_1 | [Thu Oct 11 18:24:29.949299 2018] [:error] [pid 181] [client 172.22.0.2:44254] WordPress database error Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=' for query SELECT st.status, l.code, st.translator_id, st.translation_service, i.trid\n\t\t\t\tFROM wp_icl_languages l\n\t\t\t\tLEFT JOIN wp_icl_translations i\n\t\t\t\t\tON l.code = i.language_code\n\t\t\t\tJOIN wp_icl_translation_status st\n\t\t\t\t\tON i.translation_id = st.translation_id\n\t\t\t\tWHERE l.active = 1\n\t\t\t\t\tAND i.trid IN ( 979 )\n\t\t\t\t\tOR i.trid IS NULL made by WP_List_Table->display, WP_List_Table->display_rows_or_placeholder, WP_Posts_List_Table->display_rows, WP_Posts_List_Table->_display_rows_hierarchical, WP_Posts_List_Table->single_row, WP_List_Table->single_row_columns, WP_Posts_List_Table->column_default, do_action('manage_pages_custom_column'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_Custom_Columns->add_content_for_posts_management_column, WPML_Post_Status_Display->get_status_html, apply_filters('wpml_link_to_translation'), WP_Hook->apply_filters, WPML_TM_Translation_Status_Display->filter_status_link, WPML_TM_Translation_Status_Display->maybe_load_stats, WPML_TM_Translation_Status_Display->load_stats, referer: /wp-admin/update-core.php
-staging_wordpress_1 | [Thu Oct 11 18:24:29.967022 2018] [:error] [pid 181] [client 172.22.0.2:44254] WordPress database error Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=' for query SELECT st.status, l.code, st.translator_id, st.translation_service, i.trid\n\t\t\t\tFROM wp_icl_languages l\n\t\t\t\tLEFT JOIN wp_icl_translations i\n\t\t\t\t\tON l.code = i.language_code\n\t\t\t\tJOIN wp_icl_translation_status st\n\t\t\t\t\tON i.translation_id = st.translation_id\n\t\t\t\tWHERE l.active = 1\n\t\t\t\t\tAND i.trid IN ( 1999 )\n\t\t\t\t\tOR i.trid IS NULL made by WP_List_Table->display, WP_List_Table->display_rows_or_placeholder, WP_Posts_List_Table->display_rows, WP_Posts_List_Table->_display_rows_hierarchical, WP_Posts_List_Table->single_row, WP_List_Table->single_row_columns, WP_Posts_List_Table->column_default, do_action('manage_pages_custom_column'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_Custom_Columns->add_content_for_posts_management_column, WPML_Post_Status_Display->get_status_html, apply_filters('wpml_link_to_translation'), WP_Hook->apply_filters, WPML_TM_Translation_Status_Display->filter_status_link, WPML_TM_Translation_Status_Display->maybe_load_stats, WPML_TM_Translation_Status_Display->load_stats, referer: /wp-admin/update-core.php
-staging_wordpress_1 | [Thu Oct 11 18:24:29.978930 2018] [:error] [pid 181] [client 172.22.0.2:44254] WordPress database error Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=' for query SELECT st.status, l.code, st.translator_id, st.translation_service, i.trid\n\t\t\t\tFROM wp_icl_languages l\n\t\t\t\tLEFT JOIN wp_icl_translations i\n\t\t\t\t\tON l.code = i.language_code\n\t\t\t\tJOIN wp_icl_translation_status st\n\t\t\t\t\tON i.translation_id = st.translation_id\n\t\t\t\tWHERE l.active = 1\n\t\t\t\t\tAND i.trid IN ( 2001 )\n\t\t\t\t\tOR i.trid IS NULL made by WP_List_Table->display, WP_List_Table->display_rows_or_placeholder, WP_Posts_List_Table->display_rows, WP_Posts_List_Table->_display_rows_hierarchical, WP_Posts_List_Table->single_row, WP_List_Table->single_row_columns, WP_Posts_List_Table->column_default, do_action('manage_pages_custom_column'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_Custom_Columns->add_content_for_posts_management_column, WPML_Post_Status_Display->get_status_html, apply_filters('wpml_link_to_translation'), WP_Hook->apply_filters, WPML_TM_Translation_Status_Display->filter_status_link, WPML_TM_Translation_Status_Display->maybe_load_stats, WPML_TM_Translation_Status_Display->load_stats, referer: /wp-admin/update-core.php
-staging_wordpress_1 | 172.22.0.2 - - [11/Oct/2018:18:24:28 +0000] "GET /wp-admin/edit.php?post_type=page HTTP/1.1" 200 23093 "/wp-admin/update-core.php" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/11.1 Safari/605.1.15"
-staging_wordpress_1 | 172.22.0.2 - - [11/Oct/2018:18:24:28 +0000] "GET /wp-content/uploads/2018/10/cropped-favicon__-32x32.png HTTP/1.1" 404 90265 "/wp-admin/edit.php?post_type=page" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/11.1 Safari/605.1.15"
-staging_wordpress_1 | 172.22.0.2 - - [11/Oct/2018:18:24:30 +0000] "GET /wp-content/plugins/wds-sso/assets/js/wds-sso-deactivate.js?ver=1539282269 HTTP/1.1" 200 906 "/wp-admin/edit.php?post_type=page" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/11.1 Safari/605.1.15"
-staging_wordpress_1 | [Thu Oct 11 18:24:30.365216 2018] [:error] [pid 176] [client 172.22.0.2:44282] WordPress database error Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=' for query SELECT st.status, l.code, st.translator_id, st.translation_service, i.trid\n\t\t\t\tFROM wp_icl_languages l\n\t\t\t\tLEFT JOIN wp_icl_translations i\n\t\t\t\t\tON l.code = i.language_code\n\t\t\t\tJOIN wp_icl_translation_status st\n\t\t\t\t\tON i.translation_id = st.translation_id\n\t\t\t\tWHERE l.active = 1\n\t\t\t\t\tAND 1=1\n\t\t\t\t\tOR i.trid IS NULL made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, SitePress->init, do_action('wpml_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, wpml_tm_load, WPML_Translation_Management->load, WPML_TM_Post_Edit_Notices_Factory->create, wpml_tm_load_status_display_filter, WPML_TM_Translation_Status_Display->init, WPML_TM_Translation_Status_Display->maybe_preload_stats, WPML_TM_Translation_Status_Display->load_stats, referer: /wp-admin/edit.php?post_type=page
-staging_wordpress_1 | 172.22.0.2 - - [11/Oct/2018:18:24:30 +0000] "POST /wp-admin/admin-ajax.php HTTP/1.1" 200 588 "/wp-admin/edit.php?post_type=page" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/11.1 Safari/605.1.15"

October 11, 2018 at 6:46 pm #2809549

lisaS-6

I fixed the COLLATION errors. It did not resolve the meta not copying issue.

October 12, 2018 at 7:26 pm #2812974

Lauren
Supporter

Languages: English (English )

Timezone: America/New_York (GMT-04:00)

Thank you for contacting WPML support. I'll be happy to help you with this.

I see you are using an older version of WPML. Please update to the latest versions of all plugins.

Next, please try increasing the WP Memory Limit. Minimum requirements are 128Mb: https://wpml.org/home/minimum-requirements/

You can add this to wp-config.php to increase WP memory:

/** Memory Limit */
define('WP_MEMORY_LIMIT', '256M');
define( 'WP_MAX_MEMORY_LIMIT', '256M' );

Add it above the line /* That's all, stop editing! Happy blogging. */

Lastly, please go to WPML -> Settings. In the custom fields section, make sure that the any fields for your custom post type are set to Translate.

After these steps, please follow your steps again, and open the browser console. If the issue remains, are you seeing an errors in the console?

Please also enable the WordPress debug log. This will allow us to see if any PHP errors are being produced. More Info: https://codex.wordpress.org/Debugging_in_WordPress

1. Edit wp-config.php and insert the following lines:

define( 'WP_DEBUG', true );
define( 'WP_DEBUG_LOG', true );
define( 'WP_DEBUG_DISPLAY', false );

2. Browse to the page with the issue and/or reproduce the issue.

3. Locate the debug log in: /wp-content/debug.log

4. Paste the latest lines here. No need to paste the entire log file, just 50 lines or so will do. Please censor any sensitive information.

Thanks!

The topic ‘[Closed] Adding additional post types for translation breaks duplication’ is closed to new replies.