This thread is resolved. Here is a description of the problem and solution.
Problem: You are developing a site using the Houzez theme and WPML plugin and encountering a database error when adding new properties. The error message indicates an unknown column 'ate_sync_count' in 'field list', with error code 1054. Solution: If you're experiencing this issue, we recommend you first perform a full site backup. Then, log in to your database using a tool like PHPMyAdmin and execute the following SQL query to add the missing column:
ALTER TABLE `wp_icl_translate_job` ADD `ate_sync_count` int unsigned NULL DEFAULT '0' AFTER `automatic`;
After running this query, check if the issue persists.
This solution might be irrelevant if it's outdated or not applicable to your case. We highly 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 continues, please open a new support ticket at WPML support forum.
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.
Background of the issue:
I am developing a site using the Houzez theme and WPML plugin. I keep encountering a database error when adding new properties. The error is related to the 'sitepress-multilingual-cms' plugin. The error message is: Unknown column 'ate_sync_count' in 'field list'. The error code is 1054. The query causing the error is: SELECT translations.translation_id, translations.element_type, translations.element_id, translations.trid, translations.language_code, translations.source_language_code, (SELECT element_id FROM wp_icl_translations as originalTranslation WHERE originalTranslation.trid = translations.trid and originalTranslation.source_language_code IS NULL ) as original_doc_id, NULLIF(translations.source_language_code, '') IS NULL AS original, translation_status.rid, translation_status.status, translation_status.translator_id, translation_status.needs_update, translation_status.review_status, translation_status.translation_service, translation_status.batch_id, translation_status.timestamp, translation_status.tp_id, translation_status.ate_comm_retry_count, jobs.max_job_id as job_id, jobs.translated, jobs.editor, jobs.editor_job_id, jobs.automatic, jobs.ate_sync_count FROM wp_icl_translations as translations LEFT JOIN wp_icl_translation_status translation_status ON translation_status.translation_id = translations.translation_id LEFT JOIN (SELECT MAX(job_id) as max_job_id, translated, editor, editor_job_id, automatic, ate_sync_count, rid FROM wp_icl_translate_job GROUP BY job_id ) as jobs ON jobs.rid = translation_status.rid WHERE translations.trid IN (SELECT trid FROM wp_icl_translations WHERE (element_id = 21734 AND element_type = 'post_') OR (element_id = 21732 AND element_type = 'post_') OR (element_id = 21724 AND element_type = 'post_') OR (element_id = 21712 AND element_type = 'post_') OR (element_id = 21711 AND element_type = 'post_') OR (element_id = 21656 AND element_type = 'post_') OR (element_id = 21636 AND element_type = 'post_') OR (element_id = 21623 AND element_type = 'post_') OR (element_id = 21592 AND element_type = 'post_') OR (element_id = 19151 AND element_type = 'post_') OR (element_id = 20050 AND element_type = 'post_') OR (element_id = 20339 AND element_type = 'post_') OR (element_id = 20381 AND element_type = 'post_') OR (element_id = 20367 AND element_type = 'post_') OR (element_id = 20419 AND element_type = 'post_') OR (element_id = 21233 AND element_type = 'post_') OR (element_id = 20389 AND element_type = 'post_') OR (element_id = 19604 AND element_type = 'post_') OR (element_id = 19700 AND element_type = 'post_') OR (element_id = 19372 AND element_type = 'post_') OR (element_id = 19219 AND element_type = 'post_') OR (element_id = 19312 AND element_type = 'post_') OR (element_id = 21322 AND element_type = 'post_') OR (element_id = 21272 AND element_type = 'post_') OR (element_id = 20275 AND element_type = 'post_') OR (element_id = 20385 AND element_type = 'post_') OR (element_id = 19788 AND element_type = 'post_') OR (element_id = 20383 AND element_type = 'post_') OR (element_id = 20411 AND element_type = 'post_') OR (element_id = 20405 AND element_type = 'post_') OR (element_id = 20401 AND element_type = 'post_') OR (element_id = 20387 AND element_type = 'post_') OR (element_id = 20184 AND element_type = 'post_') OR (element_id = 20282 AND element_type = 'post_') OR (element_id = 20254 AND element_type = 'post_') OR (element_id = 20151 AND element_type = 'post_') OR (element_id = 19941 AND element_type = 'post_') OR (element_id = 19907 AND element_type = 'post_') OR (element_id = 19876 AND element_type = 'post_') OR (element_id = 20393 AND element_type = 'post_') OR (element_id = 19666 AND element_type = 'post_') OR (element_id = 19565 AND element_type = 'post_') OR (element_id = 19524 AND element_type = 'post_') OR (element_id = 19460 AND element_type = 'post_') OR (element_id = 19449 AND element_type = 'post_') OR (element_id = 19240 AND element_type = 'post_') OR (element_id = 19177 AND element_type = 'post_') OR (element_id = 19128 AND element_type = 'post_') OR (element_id = 18926 AND element_type = 'post_') OR (element_id = 18871 AND element_type = 'post_') OR (element_id = 18727 AND element_type = 'post_') OR (element_id = 20415 AND element_type = 'post_') OR (element_id = 20409 AND element_type = 'post_') OR (element_id = 20417 AND element_type = 'post_') OR (element_id = 18224 AND element_type = 'post_') OR (element_id = 20421 AND element_type = 'post_') OR (element_id = 17981 AND element_type = 'post_') OR (element_id = 20423 AND element_type = 'post_') OR (element_id = 20413 AND element_type = 'post_') OR (element_id = 20407 AND element_type = 'post_') OR (element_id = 20403 AND element_type = 'post_') OR (element_id = 20399 AND element_type = 'post_') OR (element_id = 20397 AND element_type = 'post_') OR (element_id = 20395 AND element_type = 'post_') OR (element_id = 20391 AND element_type = 'post_') OR (element_id = 20425 AND element_type = 'post_') ) AND 1 = 1. Caller: WPMLEATranslationsRepository::appendResult() wp-content/plugins/sitepress-multilingual-cms/vendor/wpml/core-api/core/TranslationsRepository.php:118 WPMLEATranslationsRepository::preloadForPosts() wp-content/plugins/sitepress-multilingual-cms/vendor/wpml/core-api/core/TranslationsRepository.php:47 WPML_Custom_Columns->preloadTranslationData() wp-content/plugins/sitepress-multilingual-cms/classes/menu-elements/class-wpml-custom-columns.php:209 do_action('manage_pages_custom_column') wp-includes/plugin.php:517 WP_Posts_List_Table->column_default() wp-admin/includes/class-wp-posts-list-table.php:1371 WP_List_Table->single_row_columns() wp-admin/includes/class-wp-list-table.php:1802 WP_Posts_List_Table->single_row() wp-admin/includes/class-wp-posts-list-table.php:1437 WP_Posts_List_Table->_display_rows_hierarchical() wp-admin/includes/class-wp-posts-list-table.php:941 WP_Posts_List_Table->display_rows() wp-admin/includes/class-wp-posts-list-table.php:813 WP_List_Table->display_rows_or_placeholder() wp-admin/includes/class-wp-list-table.php:1712 WP_List_Table->display() wp-admin/includes/class-wp-list-table.php:1639. Here is screenshot hidden link
Welcome to the WPML support forum. I will do my best to help you to resolve the issue.
It looks like somehow the *ate_sync_count* column of *_icl_translate_job* table is missing. So please login to your database (using a tool like PHPMyAdmin) after a full site backup and run the following query. Then make sure the bug exists or not.
ALTER TABLE `wp_icl_translate_job`
ADD `ate_sync_count` int unsigned NULL DEFAULT '0' AFTER `automatic`;
Thank you for the updates. Please note that I have opened a new ticket for the undefined array key issue. As per our support policies, we can address only one issue per ticket. This approach helps us serve you better and avoid discussing multiple problems within a single ticket. I will respond to the new ticket shortly. Thank you for your understanding.
