Database Errors 2 – Query Monitor

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

Problem:

Sometimes the dashboard hangs for my project. I installed the Query Monitor plugin. It shows the following database errors caused by the sitepress-multilingual-cms plugin: "Unknown column 'jobs.ate_sync_count' in 'field list'".

Solution:

For this problem, we need to fix the DB of the site. If you encounter this problem, please open a support ticket in our forum, and we will help you with it. For reference, please specify this 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: Bug

This topic contains 10 replies, has 3 voices.

Last updated by Itamar 1 year, 9 months ago.

Assisted by: Itamar.

Author	Posts
October 19, 2023 at 10:31 am #14613897
gatisP-2	Hello! Sometimes the dashboard hangs for my project. I installed the Query Monitor plugin. It shows the following database errors caused by the sitepress-multilingual-cms plugin: "Unknown column 'jobs.ate_sync_count' in 'field list'". Can you help me fix this?
October 19, 2023 at 1:02 pm #14615383
George Botsev WPML Supporter since 02/2014 Languages: English (English ) Timezone: Europe/Sofia (GMT+03:00)	Hello! The missing field is a sympthom of your site not having properly executed the update logic that adds the field. That is a fairly old field that was added, but in order to be of better assistance you should provide us with temporary access to your site - so that we can verify the database table structure.
October 22, 2023 at 11:55 am #14630623
Itamar WPML Supporter since 02/2016 Languages: English (English ) Timezone: Asia/Jerusalem (GMT+03:00)	Hi, and thanks for the access details. I'll continue to help you with this issue. I can access your site's WP admin. However, I cannot access your site with FTP. I get the following error. Error: Connection timed out after 20 seconds of inactivity Error: Failed to retrieve directory listing We need to investigate the issue by inspecting the DB of your site. Please proceed with the following. 1. Correct your site's FTP access details so we can access your site with FTP. (For this, you can edit the previous private reply.) 2. Allow us to install the Adminer script (hidden link) so we can inspect the DB of your site. Regards, Itamar.
October 23, 2023 at 8:24 am #14634151
gatisP-2	Hi, thanks for the reply. I reset the ftp access data. I can connect. Please try now. Ragrds, Gatis
October 23, 2023 at 8:56 am #14634633
Itamar WPML Supporter since 02/2016 Languages: English (English ) Timezone: Asia/Jerusalem (GMT+03:00)	Hi, Gatis. I'm sorry, but I still get the same error when accessing your site with FTP. Alternatively, please allow us to install a WordPress DB plugin like https://wordpress.org/plugins/wp-phpmyadmin-extension/.
October 23, 2023 at 9:26 am #14635077
gatisP-2	Yes, please install the WordPress DB plugin. Thanks!
October 23, 2023 at 9:51 am #14635681
Itamar WPML Supporter since 02/2016 Languages: English (English ) Timezone: Asia/Jerusalem (GMT+03:00)	Thanks. I installed the DB plugin and escalated this issue to our second-tier supporters. When I have their reply, I'll update you here. Thank you for your patience. Itamar.
October 23, 2023 at 10:23 am #14636579
gatisP-2	Hello! Thank you! I still get database 2 errors Query Monitor plugins : WPML\T\A\Jobs::getJobsWithStatus() wp-content/plugins/sitepress-multilingual-cms/classes/ATE/Jobs.php:64 WPML\T\A\Jobs::getJobsToSync() wp-content/plugins/sitepress-multilingual-cms/classes/ATE/Jobs.php:71 WPML\T\A\Loader::getData() wp-content/plugins/sitepress-multilingual-cms/classes/ATE/Loader.php:94 WPML\FP\Right->map() wp-content/plugins/sitepress-multilingual-cms/vendor/wpml/fp/core/Either.php:207 WPML\FP\Right->chain() wp-content/plugins/sitepress-multilingual-cms/vendor/wpml/fp/core/Either.php:257 WPML\FP\Promise->resolve() wp-content/plugins/sitepress-multilingual-cms/vendor/wpml/fp/core/Promise.php:24 WPML\L\W\Hooks::WPML\L\W\{closure}() wp-content/plugins/sitepress-multilingual-cms/vendor/wpml/wp/classes/Hooks.php:50 do_action('wp_loaded') wp-includes/plugin.php:517 Plugin: sitepress-multilingual-cms 'Unknown column 'jobs.ate_sync_count' in 'field list' Can it significantly affect the performance of the page? Attached is a screenshot. Regards, Gatis
October 23, 2023 at 2:33 pm #14639287
Itamar WPML Supporter since 02/2016 Languages: English (English ) Timezone: Asia/Jerusalem (GMT+03:00)	Hi, Gatis. Our second-tier supporter tried to correct this problem on your site but was blocked without sufficient permissions for this DB user. Please see the attached screenshot. Our second-tier supporter wrote: The MySQL user does NOT have the ability to alter the table, and we cannot add the missing column. The user should be granted the ability to alter tables: GRANT ALTER ON DATABASE TO 'USER@localhost'; Can you please check this and allow us to make this DB change? ** Important! Please make a DB backup before you allow us to proceed.**
October 23, 2023 at 5:04 pm #14640281
gatisP-2	Hi, i give you phpMyAdmin link -> hidden link Username and pasword same as ftp Regards, Gatis
October 24, 2023 at 4:19 am #14641911
Itamar WPML Supporter since 02/2016 Languages: English (English ) Timezone: Asia/Jerusalem (GMT+03:00)	Thanks, Gatis. We've run the required SQL to add the missing column "ate_sync_count". I'll give the details in the following private message.
October 24, 2023 at 4:35 am #14642035
gatisP-2	Thank Yoy! Issue was resolved.