Link to a page where the issue can be seen: hidden link
I expected to see: successful save message
Instead, I got:
"Invalid character in language code"
"Invalid character in language code"
Database error:
[17-Jan-2024 18:51:53 UTC] WordPress database error ALTER command denied to user 'user'@'10.0.0.0' for table 'wp_icl_string_translations' for query ALTER TABLE wp_icl_string_translations ADD INDEX `status` ( `status` ) made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, SitePress->init, do_action('wpml_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_Upgrade_Loader->wpml_upgrade, WPML_Upgrade->run, WPML_Upgrade->run_admin, WPML_Upgrade->run_commands, WPML_Upgrade->run_command, WPML_Upgrade->maybe_run_admin, WPML_Upgrade_Run_All->run_admin, WPML\Upgrade\Commands\AddIndexToTable->run, WPML_Upgrade_Schema->add_index
[17-Jan-2024 18:51:53 UTC] WordPress database error ALTER command denied to user 'user'@'10.0.0.0' for table 'wp_icl_strings' for query ALTER TABLE wp_icl_strings ADD INDEX `string_package_id` ( `string_package_id` ) made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, SitePress->init, do_action('wpml_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_Upgrade_Loader->wpml_upgrade, WPML_Upgrade->run, WPML_Upgrade->run_admin, WPML_Upgrade->run_commands, WPML_Upgrade->run_command, WPML_Upgrade->maybe_run_admin, WPML_Upgrade_Run_All->run_admin, WPML\Upgrade\Commands\AddIndexToTable->run, WPML_Upgrade_Schema->add_index
[17-Jan-2024 18:51:53 UTC] WordPress database error Unknown column 'jobs.ate_sync_count' in 'field list' for query
SELECT jobs.rid, jobs.job_id as jobId, jobs.editor_job_id as ateJobId, jobs.automatic , translation_status.status,
translation_status.review_status, jobs.ate_sync_count > 100 as isLongstanding
FROM wp_icl_translate_job as jobs
INNER JOIN wp_icl_translation_status translation_status ON translation_status.rid = jobs.rid
INNER JOIN wp_icl_translations translations ON translation_status.translation_id = translations.translation_id
INNER JOIN wp_icl_translations parent_translations ON translations.trid = parent_translations.trid
AND parent_translations.source_language_code IS NULL
LEFT JOIN wp_posts posts ON parent_translations.element_id = posts.ID
WHERE
jobs.job_id IN (
SELECT MAX(job_id) FROM wp_icl_translate_job
GROUP BY rid
)
AND jobs.editor = 'ate'
AND ( translation_status.status IN (1,2,40) OR 1=0 )
AND translations.language_code IN ('nl','en','fr','fr-ca','de','it','ja-jp','pt-br','pt-pt','es','es-mx')
AND translations.source_language_code IS NOT NULL
AND ( posts.post_status IS NULL OR posts.post_status <> 'trash' )
made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('wp_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, WPML\LIB\WP\Hooks::WPML\LIB\WP\{closure}, WPML\FP\Promise->resolve, WPML\FP\Right->chain, WPML\FP\Right->map, WPML\TM\ATE\Loader::getData, WPML\TM\ATE\Jobs::getJobsToSync, WPML\TM\ATE\Jobs::getJobsWithStatus
[17-Jan-2024 18:51:53 UTC] WordPress database error Unknown column 'jobs.ate_sync_count' in 'field list' for query
SELECT jobs.rid, jobs.job_id as jobId, jobs.editor_job_id as ateJobId, jobs.automatic , translation_status.status,
translation_status.review_status, jobs.ate_sync_count > 100 as isLongstanding
FROM wp_icl_translate_job as jobs
INNER JOIN wp_icl_translation_status translation_status ON translation_status.rid = jobs.rid
INNER JOIN wp_icl_translations translations ON translation_status.translation_id = translations.translation_id
INNER JOIN wp_icl_translations parent_translations ON translations.trid = parent_translations.trid
AND parent_translations.source_language_code IS NULL
LEFT JOIN wp_posts posts ON parent_translations.element_id = posts.ID
WHERE
jobs.job_id IN (
SELECT MAX(job_id) FROM wp_icl_translate_job
GROUP BY rid
)
AND jobs.editor = 'ate'
AND ( translation_status.status IN (30) OR translation_status.review_status IN ( 'NEEDS_REVIEW','EDITING' ) )
AND translations.language_code IN ('nl','en','fr','fr-ca','de','it','ja-jp','pt-br','pt-pt','es','es-mx')
AND translations.source_language_code IS NOT NULL
AND ( posts.post_status IS NULL OR posts.post_status <> 'trash' )
made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('wp_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, WPML\LIB\WP\Hooks::WPML\LIB\WP\{closure}, WPML\FP\Promise->resolve, WPML\FP\Right->chain, WPML\FP\Right->map, WPML\TM\ATE\Loader::getData, WPML\TM\ATE\Jobs::getJobsWithStatus
Languages: English (English )German (Deutsch )French (Français )
Timezone: Europe/Zagreb (GMT+02:00)
Hi,
Thank you for contacting WPML support!
The error messages you're encountering in your WordPress database are indicating two different issues:
1. **Permission Issues**: The first two errors are related to permission issues. The database user 'user' does not have permission to alter tables in your database. This is evident from the errors stating "ALTER command denied to user 'user'@'10.0.0.0'". You need to ensure that the database user has the necessary privileges to modify the database schema. This typically involves granting the user `ALTER` privileges on the database.
2. **Missing Column**: The subsequent errors are related to a missing column in your database. The specific error is "Unknown column 'jobs.ate_sync_count' in 'field list'". This indicates that your query is trying to access a column named `ate_sync_count` in the `wp_icl_translate_job` table, but this column does not exist in your database schema.
To resolve these issues, you may need to do the following:
- **Update Database Privileges**: Ensure that the database user 'user' has the appropriate permissions to alter tables. This is usually done through your database management system or through a control panel provided by your hosting service.
- **Add the Missing Column**: You need to modify the `wp_icl_translate_job` table to include the `ate_sync_count` column. This can be done using an SQL statement like `ALTER TABLE wp_icl_translate_job ADD COLUMN ate_sync_count INT;` (adjust the data type and constraints according to your needs).
It's important to back up your database before making any changes to avoid any data loss.
Regards,
Bruno Kos
The topic ‘[Closed] WordPress database error Unknown column ate_sync_count in field list’ is closed to new replies.
Manage Cookie Consent
We use cookies to optimize our website and services. Your consent allows us to process data such as browsing behavior. Not consenting may affect some features.
Functional
Always active
Required for our website to operate and communicate correctly.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
We use these to analyze the statistics of our site. Collected information is completely anonymous.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
These cookies track your browsing to provide ads relevant to you.
