[Resolved] Translation Management dashboard fails to load once I enable a 30th language (SQL error due to wrong...

Hi Andrey,

Thanks for taking a look and for the suggestions. I’ve just gone through each of your steps:

Switched to a default theme
I deactivated my theme and activated Twenty Twenty-One, with only the core WPML plugins enabled. The issue still persists.

Deactivated all non-WPML plugins
I left WPML and WPML String Translation active, and deactivated everything else (including caching, SEO, and custom code snippets). No change in behavior.

Checked the REST API
Just to clarify, my staging site has the REST API fully enabled. I can see all of the WPML-specific endpoints. I’ve confirmed that nothing in my .htaccess or server configuration is blocking it, and I’m running the latest WordPress (6.8.1).

Database tables
I inspected the database and I do see the icl_translations, icl_string_translations and related tables, so those appear to exist.

At this point I’m out of ideas—do you have any further troubleshooting steps?

Hey Andrew,

I dug into the REST endpoint code and pinpointed the culprit in
vendor/wpml/wpml/src/Infrastructure/WordPress/Component/Item/Application/Query/SearchQuery/QueryBuilder/ManyLanguagesStrategy/SearchPopulatedTypesQueryBuilder.php.

The problem is that, after dynamically using $wpdb->prefix for the posts and source_t joins, the code then hard-codes:

LEFT JOIN wp_icl_translations target_t
LEFT JOIN wp_icl_translation_status target_ts

Because our database prefix is gkg3R9t_, those wp_… table names don’t exist. We need to replace those two lines with:

global $wpdb;
$prefix = $wpdb->prefix;

LEFT JOIN {$prefix}icl_translations target_t
LEFT JOIN {$prefix}icl_translation_status target_ts

That change aligns all the joins to use our real prefix and will eliminate the “table doesn’t exist” errors in Translation Management.

EDIT: We have around 14.000 pages, maybe that has something to do with it? Didn't verify that.

Thanks!

Thanks a lot for your help and for escalating the issue to the development team. I really appreciate the support. Have a great weekend as well!