louisN-4
we are constantly translating new products on our site and every now and then we are getting this warning
[29-Apr-2023 12:40:55 UTC] WordPress database error Table 'kidenoad_db.wp_icl_translations' doesn't exist for query
SELECT COUNT(jobs.job_id)
FROM lsk_icl_translate_job jobs
INNER JOIN lsk_icl_translation_status translation_status ON translation_status.rid = jobs.rid
INNER JOIN wp_icl_translations translations ON translations.translation_id = translation_status.translation_id
WHERE jobs.editor = 'ate' AND jobs.automatic = 1 AND translation_status.status = 2 AND translations.source_language_code = 'he'
made by do_action('wp_ajax_wpml_action'), WP_Hook->do_action, WP_Hook->apply_filters, WPML\LIB\WP\Hooks::WPML\LIB\WP\{closure}, WPML\FP\Promise->resolve, WPML\FP\Promise->resolve, WPML\FP\Promise->resolve, WPML\FP\Promise->resolve, WPML\FP\Promise->resolve, WPML\FP\Promise->resolve, WPML\FP\Right->chain, WPML\FP\Right->map, WPML\Ajax\Factory->WPML\Ajax\{closure}, WPML\FP\Just->map, WPML\FP\{closure}, call_user_func_array, WPML\Container\Container::execute, WPML\Auryn\Injector->execute, call_user_func_array, WPML\Auryn\Executable->__invoke, ReflectionMethod->invokeArgs, WPML\TM\ATE\AutoTranslate\Endpoint\CountJobsInProgress->run, WPML\TM\ATE\Jobs::getCountOfAutomaticInProgress
shall we ignore it or its an issue?
Christopher Amirian
Supporter
Languages:
English (English )
Timezone:
Asia/Yerevan (GMT+04:00)
Hi there,
Would you please create a backup of your database and follow the steps mentioned here:
https://wpml.org/forums/topic/a-problem-with-the-wpml-plugin-integration-with-all-caching-plugins/#post-13438179
Then see if you see that warning again or not. I mean newly generated ones.
Thanks.
louisN-4
before i do what you suggested, i wanted to
1. does this notification hurt us in a way we don't yet see visible on the site?
2. this only happens when server is on high load
3. if we update the wpml, would we need to implement this again?
Christopher Amirian
Supporter
Languages:
English (English )
Timezone:
Asia/Yerevan (GMT+04:00)
Hi there,
- No it is a warning and not breaking fatal error.
- There is a JOIN SQL statement use that has inevitably impact on the server and that might be when the warning shows.
- This is a temporary fix, a permanent fix will be available on the upcoming releases, so for now, yes.
Thanks.