Problem: Unable to translate the Post or Page from Translation Editor
Solution: While translating a Post or Page from Translation Editor we will be directed to WPML>>Translations page. It was happening because of mixed collation of Database tables and String Translation tables are missing in the database. It worked fine after the following steps.
1) Upgrade to the latest version of WPML plugins(3.7 series)
2) Upgrade WooCommerce to the latest version
3) Upgrade WPBakery Visual Composer to the latest version
4) Change the DB collation of your Database and table to *utf8mb4_unicode_ci* like the following. Becuase now your tables having mixed DB collation.
# For each database:
ALTER DATABASE database_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
# For each table:
ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
Check the following tutorial for more details and example.
[php]
https://mathiasbynens.be/notes/mysql-utf8mb4
5) Then add the following code in functions.php of your theme
[php]
function wpml_fix_missing_icl_tables() {
if( function_exists( 'icl_sitepress_activate' ) )
icl_sitepress_activate();
}
add_action( 'wp_footer', 'wpml_fix_missing_icl_tables' );
6) Visit the home page, then confirm in your database that String Translation tables are created
7) After that, you can remove the above code from functions.php of your theme
8) Then run the following query in Database to add a missing field to icl_translation_status table. Replace *your-db-prefix* with your Database prefix for an example wp.
ALTER TABLE `*your-db-prefix*_icl_translation_status` ADD `batch_id` INT(11) NOT NULL AFTER `translation_service`;
9) Please check you can translate a Post/Page/Product
Relevant Documentation: https://mathiasbynens.be/notes/mysql-utf8mb4
