WordPress database error Unknown column 's.batch_id'

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.

WordPress 6.7 has introduced a new issue that impact translations, please update WooCommerce and WPML to the latest versions before you report issues. More about this here - https://wpml.org/errata/php-error-wp-6-7-notice-function-_load_textdomain_just_in_time-was-called/

Sun	Mon	Tue	Wed	Thu	Fri	Sat
-	9:00 – 18:00	9:00 – 18:00	9:00 – 18:00	9:00 – 18:00	9:00 – 18:00	-
-	-	-	-	-	-	-

Supporter timezone: Asia/Karachi (GMT+05:00)

This topic contains 0 replies, has 0 voices.

Last updated by Waqas Bin Hasan 3 days, 8 hours ago.

Assisted by: Waqas Bin Hasan.

Author	Posts
November 28, 2024 at 9:59 am #16453905
sasaK	Background of the issue: I was trying to execute a query to retrieve translation jobs with specific conditions, including checking overdue jobs and sending an email report. The query involves multiple joins across tables like wp_icl_translation_status, wp_icl_translations, wp_icl_translate_job, and others. The issue occurred during the execution of a scheduled event 'wpml-tm-check-overdue-jobs-event'. Symptoms: I encountered a WordPress database error: 'Unknown column 's.batch_id' in 'SELECT'' while attempting to run the query. Questions: Why am I seeing the 'Unknown column 's.batch_id'' error? How can I resolve the database error in my query?
November 28, 2024 at 10:39 am #16454324
Waqas Bin Hasan Supporter Languages: English (English ) Timezone: Asia/Karachi (GMT+05:00)	Hi, Reference to our recent chat, our team needs to take a closer look at your site. So I request temporary access (WP-Admin and FTP). So they can safely patch the DB for missing column. Your next answer will be private, to share this information safely. IMPORTANT: Please take a complete backup of the site to avoid data loss. See https://wpml.org/purchase/support-policy/privacy-and-security-when-providing-debug-information-for-support/ for details on privacy and security. Regards.