Useless registers on table 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.

Sun	Mon	Tue	Wed	Thu	Fri	Sat
-	9:00 – 14:00	9:00 – 14:00	9:00 – 14:00	9:00 – 14:00	9:00 – 14:00	-
-	19:00 – 22:00	19:00 – 22:00	19:00 – 22:00	19:00 – 22:00	19:00 – 22:00	-

Supporter timezone: Europe/Paris (GMT+02:00)

This topic contains 3 replies, has 2 voices.

Last updated by Yvette 1 year, 9 months ago.

Assisted by: Yvette.

Author	Posts
July 22, 2022 at 12:17 pm #11718993
edT-2	I used to have a custom post type set as "translatable". This post type has 70,000 rows I decided NOT to translate this content anymore, and set up as "don't translate" As you can see in the image attached, all 70,000 rows are still on icl_translations. I tried to follow these instructions: https://wpml.org/it/forums/topic/optimize-database-tables/ but the registers were not deleted. Can I delete directly from the database?
July 22, 2022 at 2:20 pm #11720011
Yvette Supporter Languages: English (English ) Spanish (Español ) Timezone: Europe/Paris (GMT+02:00)	Hello The icl_translations table is our directory of posts that are associated as translations of each other and assigns the post type language for each post-id. However, you still need to have an entry for each post id in this table if you want to SEE these post types when WPML is activated. The action of setting this post type as "not translatable" simply means that there are no translations to be made but the post type will still be assigned a language info equivalent to the site default language.
July 22, 2022 at 6:03 pm #11721807
edT-2	Hey Yvette, You mean that, regardless the post_type (or taxonomy) is translatable or not, THERE WILL BE a register in the icl_translations table, correct?
July 24, 2022 at 12:20 pm #11726625
Yvette Supporter Languages: English (English ) Spanish (Español ) Timezone: Europe/Paris (GMT+02:00)	Correct. It will be stored with language information so that you can actually see it in the backend dashboard(s)

The topic ‘[Closed] Useless registers on table icl_translations.’ is closed to new replies.