Huge database translation table even all the translation are deleted

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
-	8:00 – 12:00	8:00 – 12:00	8:00 – 12:00	8:00 – 12:00	8:00 – 12:00	-
-	13:00 – 17:00	13:00 – 17:00	13:00 – 17:00	13:00 – 17:00	13:00 – 17:00	-

Supporter timezone: Asia/Ho_Chi_Minh (GMT+07:00)

Tagged: Known issue

This topic contains 3 replies, has 2 voices.

Last updated by Long Nguyen 1 year, 5 months ago.

Assisted by: Long Nguyen.

Author	Posts
July 13, 2023 at 3:51 pm #14034805
federicoB-41	Hello! I just copied a site with translations to a new server, deleted all the translated pages and posts etc. manually, but the translations table in the database is still looking large. Any idea why is that and how can I clean it? Thanks in advance!
July 14, 2023 at 3:40 am #14037067
Long Nguyen Supporter Languages: English (English ) Timezone: Asia/Ho_Chi_Minh (GMT+07:00)	Hi Federico, Thank you for contacting WPML support, I'd be happy to help you with this issue. Please follow steps in the documentation below to reduce the size of the table icl_translate on your site. https://wpml.org/errata/reducing-size-of-icl_translate_job-icl_translate-and-other-wpml-tables/ And you can find the plugin to do this here hidden link ❌ IMPORTANT: Please backup your database and website before proceeding ❌ Look forward to your reply. Thanks
July 14, 2023 at 10:10 am #14039105
federicoB-41	Thanks, I did as you suggested and I was able to reduce the size a bit, but not significantly. Please see the screenshot attached. It's still huge considering there are no translations. What to do?
July 17, 2023 at 2:16 am #14045559
Long Nguyen Supporter Languages: English (English ) Timezone: Asia/Ho_Chi_Minh (GMT+07:00)	Hi, May I ask you a question, how do you delete the translated posts/pages? If you delete all translation content of a/all languages, please follow this documentation https://wpml.org/documentation/getting-started-guide/language-setup/deleting-languages-and-plugin-data-by-doing-a-wpml-reset-on-your-site/ Note: you will need to delete taxonomies like menus, categories, tags ... manually by switching to a second language and deleting the translation. Then check this issue again. Look forward to your reply. Thanks

The topic ‘[Closed] Huge database translation table even all the translation are deleted’ is closed to new replies.