Skip Navigation

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

Problem:
WordPress database error Unknown column 'uuid' in 'field list' for query INSERT INTO `wp_tw_icl_translation_status`,,,
Solution:
I found this being triggered when sending jobs:

WordPress database error Unknown column 'uuid' in 'field list' for query INSERT INTO `wp_tw_icl_translation_status`,,,

Meaning that "uuid" was missing from "wp_tw_icl_translation_status" table, so I ran this query to add this column:

ALTER TABLE `wp_tw_icl_translation_status` ADD `uuid` VARCHAR(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `_prevstate`;

After this, jobs went through and I can see jobs in Translations tab

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 Jelle 7 months, 1 week ago.

Assigned support staff: Bruno Kos.

Author Posts
February 11, 2020 at 8:20 am

Jelle

Jobs rolled back

February 11, 2020 at 10:15 am
February 11, 2020 at 11:39 am #5468879

Bruno Kos
Supporter

Languages: English (English )

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

Hi,

I found this being triggered when sending jobs:

WordPress database error Unknown column 'uuid' in 'field list' for query INSERT INTO `wp_tw_icl_translation_status`,,,

Meaning that "uuid" was missing from "wp_tw_icl_translation_status" table, so I ran this query to add this column:

ALTER TABLE `wp_tw_icl_translation_status` ADD `uuid` VARCHAR(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `_prevstate`;

After this, jobs went through and I can see jobs in Translations tab. Can you give it a shot?

Regards,
Bruno Kos

February 14, 2020 at 8:26 am #5492529

Jelle

My issue is resolved now. Thank you!