Skip Navigation

Home › Support › English Support › [Resolved] Database error Table '.wp_icl_translations' doesn't exist for query

[Resolved] Database error Table '.wp_icl_translations' doesn't exist for query

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: 

This topic contains 1 reply, has 2 voices.

Last updated by Mateus Getulio 1 year, 8 months ago.

Assisted by: Mateus Getulio.

Author Posts
June 7, 2023 at 9:07 am #13783443

nicolas-jarneB

Hi guys,

recently I had an issue with Pods plugin and its auto templates. Finally could fix it, as mentioned in a ticked I opened before for that problem:

https://wpml.org/forums/topic/issue-with-pods-only-showing-template-in-one-language/

Right now, auto templates are working fine; but I encountered a new error: my site is breaking after navitating a couple of Pods pages. I attach an screenshot of that error.

So I went to our server logs and found this error, everytime my site breaks:

WordPress database error Table 'tribuntu_TL6NZMLB.wp_icl_translations' doesn't exist for query
SELECT COUNT(jobs.job_id)
FROM w47fa_icl_translate_job jobs
INNER JOIN w47fa_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 = 'es'
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

Do you know what's does this mean and how can I fix it?

Thanks a lot in advance,
June 7, 2023 at 6:55 pm #13788791

Mateus Getulio
Supporter

Languages: English (English ) Portuguese (Brazil) (Português )

Timezone: America/Sao_Paulo (GMT-03:00)

Hello there,

Welcome to our support forum. I’ll be happy to assist you with this!

We've found some edge cases where this error is fixed by following these instructions to recreate the icl_tables:

- Make a full backup of your site (files and database)
- Please add this code to the bottom of the functions.php file in your theme's root folder

function wpml_fix_missing_icl_tables() {
    
    if( function_exists( 'icl_sitepress_activate' ) )
    
        icl_sitepress_activate();
    
}
    
add_action( 'wp_footer', 'wpml_fix_missing_icl_tables' );

- Visit your site's homepage at least one time
- Remove the code

Once you complete these steps, then you have to remove the keys "wpml_string_table_ok_for_mo_import" and "wpml_notices" from the options table (by default wp_options, where "wp_" is your database prefix), and all errors should be gone.

Please give it a try and let us know if it works for you. We're looking forward to your reply. Thanks!

Kind regards,
Mateus.