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

Last updated by Bigul 3 weeks ago.

Assigned support staff: Bigul.

Author Posts
September 25, 2019 at 11:50 am #4638397

peterC-27

During backup with UPdraft I received the following warning message, which seems to be related to WPML: "0036.152 (0) Table KezTbBAQpostmeta: Total expected rows (approximate): 1900899
0036.154 (0) [Warning] The table KezTbBAQpostmeta has many rows (1900899) - we hope that your webhoster provides you with enough resources to dump this table. If not, you must either delete data from this table, or ask your hosting provider to provide you with more resources."

September 25, 2019 at 6:47 pm #4641779

Bigul
Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

Hello,

Welcome to the WPML support forum. I will do my best to help you to resolve the issue.

Please try the following troubleshooting steps after a full site backup and make sure the issue is existing or not.

1) Upgrade to the latest version of WPML(4.2.9). We have released a new version day before yesterday.

2) Go to WPML>>Support page

3) Click on Troubleshooting link (blue link in the middle of the page)

4) In Troubleshooting page, please click on the following options of the *Clean up* section. Wait for confirmation of processing after each one.

- Clear the cache in WPML
- Remove ghost entries from the translation tables
- Fix element_type collation
- Set language information
- Fix WPML tables collation
- Assign translation status to duplicated content
- Fix terms count
- Fix post type assignment
- Recreate ST DB cache tables

--
Thanks!

Bigul

September 28, 2019 at 1:09 pm #4658369

peterC-27

Hi, we tried that but it did not solve the issue. Can you help us cleaning this table or to uninstall/delete all WPML entries/tables/rows to get a clean wordpress again? We could give u access to our system.

September 29, 2019 at 7:42 am #4660191

Bigul
Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

Hello,

Thank you for the feedback. WPML has a reset option. But it will delete all the translation records and settings of WPML. You can find the Reset option at the bottom of the WPML>>Support>>Troubleshooting page. Please check the attached images for more details.

It is only recommed when you want to delete all the WPML settings from a site. Once we reset it will not possible to revert back. Therefore please try it after a full site backup.

--
Thanks!

Bigul

The topic ‘[Closed] KezTbBAQpostmeta has 1.9 Mio rows’ is closed to new replies.