This thread is resolved. Here is a description of the problem and solution.
Problem:
The client encountered a PHP Fatal error on the Translations Jobs tab, indicating an issue with calling a function on a boolean value in the WPML plugin code.
Solution:
We resolved the issue by repairing the corrupted WPML tables in the database. We executed a series of SQL queries to alter the tables and set the correct auto-increment values. Here are the queries we used:
ALTER TABLE `wp_icl_translation_batches` CHANGE `id` `id` int(11) NOT NULL AUTO_INCREMENT FIRST; ALTER TABLE `wp_icl_translate_job` CHANGE `job_id` `job_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT FIRST; ALTER TABLE `wp_icl_translate` CHANGE `tid` `tid` bigint(20) unsigned NOT NULL AUTO_INCREMENT FIRST; DELETE FROM `wp_icl_strings` WHERE ((`id` = '0')); ALTER TABLE `wp_icl_strings` CHANGE `id` `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT FIRST; ALTER TABLE `wp_icl_string_batches` CHANGE `id` `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT FIRST; ALTER TABLE `wp_icl_string_packages` CHANGE `ID` `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT FIRST; ALTER TABLE `wp_icl_string_positions` CHANGE `id` `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT FIRST; ALTER TABLE `wp_icl_string_translations` CHANGE `id` `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT FIRST; ALTER TABLE `wp_icl_string_status` CHANGE `id` `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT FIRST; ALTER TABLE `wp_icl_languages_translations` CHANGE `id` `id` int(11) NOT NULL AUTO_INCREMENT FIRST; ALTER TABLE `wp_icl_languages` CHANGE `id` `id` int(11) NOT NULL AUTO_INCREMENT FIRST;
... (and similar queries for other WPML tables).
We asked the client to check if the issue was resolved after applying these changes.
Please note that this solution might be irrelevant if it's outdated or not applicable to your case. If you're still experiencing issues, we highly recommend checking the related known issues, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If the problem persists, please open a new support ticket with us.
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 4 replies, has 3 voices.
Last updated by 8 months, 2 weeks ago.
Assisted by: Bigul.