Skip Navigation

Home › Support › English Support › [Resolved] Duplicate entry '1616-de' for key 'wp_icl_translations.trid_lang' for query UPDATE `wp_icl_translations`

[Resolved] Duplicate entry '1616-de' for key 'wp_icl_translations.trid_lang' for query UPDATE `wp_icl_translations`

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 5 replies, has 2 voices.

Last updated by Laura 1 year, 10 months ago.

Assisted by: Laura.

Author Posts
January 26, 2023 at 11:44 am

frankM-36

Duplicate entry '1616-de' for key 'wp_icl_translations.trid_lang' for query UPDATE `wp_icl_translations`
January 26, 2023 at 12:53 pm
January 27, 2023 at 10:05 am #12902959

Laura
Supporter

Languages: English (English ) Italian (Italiano )

Timezone: Europe/Rome (GMT+01:00)

Hi,

please do a database backup and run this query, it should fix the issue

DELETE FROM `wp_postmeta`
WHERE `meta_key` = '_icl_lang_duplicate_of';
DELETE FROM `wp_icl_translations`
WHERE `language_code` = '';
January 29, 2023 at 1:01 pm #12912275

frankM-36

Hi Laura,

I've just executed the query and it deleted 2 rows. But no changes occurred issue wise. The site still times out, when WPML is activated.

Kind regards.
F.

Deleted Table entries.png
January 30, 2023 at 10:18 am #12920159

Laura
Supporter

Languages: English (English ) Italian (Italiano )

Timezone: Europe/Rome (GMT+01:00)

Do you still have the same error in the logs?
January 30, 2023 at 12:59 pm #12921979

frankM-36

Hi Laura,

I couldn't detect that error again in the logs since the 25.01., but except for testing purposes yesterday the plugin was deactivated (as otherwise the site is not loading). Is it necessary to enable the plugin for a longer amount of time in order to debug the issue further? Independently, I attached the whole log in order to get you an overview.

debug.log:
(Activating the Plugin and logging into debug.log -> warning array to string conversion in wp-includes formatting.php on line 1098)

error.log.dms:
hidden link

Kind regards
Felix
January 30, 2023 at 2:50 pm #12922683

Laura
Supporter

Languages: English (English ) Italian (Italiano )

Timezone: Europe/Rome (GMT+01:00)

I've seen several errors like this "WordPress database error Lost connection to MySQL server during query for query SELECT id" but most of them are not related to WPML.

You can check if the tables are missing autoincrement (specifically, wp_posts, wp_postmeta and wp_options) as it might cause something like that.
Otherwise, it might be related to the database size, especially if you're on a shared hosting but it's not related to WPML.