Skip Navigation

Home › Support › English Support › [Resolved] wp_icl_string_batches table does not exist

[Resolved] wp_icl_string_batches table does not exist

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

Problem:
You are encountering a database error indicating that the 'wp_icl_string_batches' table does not exist. This error is logged during queries involving several related tables.
Solution:
First, ensure you have a staging site to test the following solution and avoid running it directly on a production website. You need to create the missing table by running the following SQL code. Please adjust the prefix according to your database configuration:

CREATE TABLE `wp_icl_string_batches` (
    `id` BIGINT(20) UNSIGNED AUTO_INCREMENT,
    `string_id` BIGINT(20) UNSIGNED NOT NULL,
    `batch_id` BIGINT(20) UNSIGNED NOT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

If this solution does not resolve your issue or seems outdated, we recommend checking related known issues at https://wpml.org/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.

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

Last updated by sissiB 1 week ago.

Assisted by: Dražen.

Author Posts
February 26, 2025 at 11:16 am #16750632

sissiB

Background of the issue:
I am trying to resolve an error related to a missing table in the database, specifically the 'wp_icl_string_batches' table. This issue was identified in the debug.log file.

Symptoms:
I encountered a WordPress database error indicating that the table 'xxx_db1.xxx_p_icl_string_batches' doesn't exist. The error occurs during a query involving several tables such as 'xxx_p_icl_translate_job', 'xxx_p_icl_translation_status', and 'xxx_p_icl_translations'. The error is logged multiple times with details about the query and the functions involved.

Questions:
Why does the 'wp_icl_string_batches' table not exist?
How can I resolve the database error related to the missing table?
February 26, 2025 at 11:24 am #16750702

Dražen
Supporter

Languages: English (English )

Timezone: Europe/Zagreb (GMT+01:00)

Hello,

you went away so I have created a ticket.

Please make sure you have a staging site to test this, do not run it on a production website.

Try to run the next SQL code to create a missing table. Note the prefix might be different and you need to adjust the code:

CREATE TABLE `wp_icl_string_batches` (
    `id` BIGINT(20) UNSIGNED AUTO_INCREMENT,
    `string_id` BIGINT(20) UNSIGNED NOT NULL,
    `batch_id` BIGINT(20) UNSIGNED NOT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

Let me know how it goes and if you need further my help.

Regards,
Drazen
March 2, 2025 at 12:10 pm #16765420

sissiB

creating the table manually fixed the issue.