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.

This topic contains 2 replies, has 2 voices.

Last updated by ronaldB-12 3 weeks, 1 day ago.

Assigned support staff: Bigul.

Author Posts
September 18, 2019 at 5:36 pm #4599351

ronaldB-12

I use Duplicator Pro to backup my sites regularly. It runs some generic tests before each backup and for some time has been reporting the database has some issues. This is related to size and the use of uppercase letters in tables. Please see below. What can be done to rectify this? I cannot see why the data in mcfsurg_icl_string_pages should be 128mb.

mcfsurg_icl_string_pages
Uppercase: 0 Rows: 1,458,045 Size: 127.75MB

mcfsurg_posts
Uppercase: 0 Rows: 2,019 Size: 26.8MB

mcfsurg_wfBlockedIPLog
Uppercase: 1 Rows: 426 Size: 48KB
mcfsurg_wfBlocks7
Uppercase: 1 Rows: 6 Size: 64KB
mcfsurg_wfConfig
Uppercase: 1 Rows: 293 Size: 1.3MB
mcfsurg_wfCrawlers
Uppercase: 1 Rows: 17 Size: 16KB
mcfsurg_wfFileChanges
Uppercase: 1 Rows: 0 Size: 16KB
mcfsurg_wfFileMods
Uppercase: 1 Rows: 20,887 Size: 7.52MB
mcfsurg_wfHits
Uppercase: 1 Rows: 1,094 Size: 2.19MB
mcfsurg_wfHoover
Uppercase: 1 Rows: 0 Size: 32KB
mcfsurg_wfIssues
Uppercase: 1 Rows: 2 Size: 80KB
mcfsurg_wfKnownFileList
Uppercase: 1 Rows: 22,672 Size: 2.52MB
mcfsurg_wfLiveTrafficHuman
Uppercase: 1 Rows: 0 Size: 32KB
mcfsurg_wfLocs
Uppercase: 1 Rows: 2 Size: 16KB
mcfsurg_wfLogins
Uppercase: 1 Rows: 637 Size: 224KB
mcfsurg_wfNotifications
Uppercase: 1 Rows: 299 Size: 128KB
mcfsurg_wfPendingIssues
Uppercase: 1 Rows: 0 Size: 80KB
mcfsurg_wfReverseCache
Uppercase: 1 Rows: 5 Size: 16KB
mcfsurg_wfSNIPCache
Uppercase: 1 Rows: 0 Size: 64KB
mcfsurg_wfStatus
Uppercase: 1 Rows: 896 Size: 224KB
mcfsurg_wfTrafficRates
Uppercase: 1 Rows: 3 Size: 16KB

September 20, 2019 at 6:15 am #4609945

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.

*_icl_string_pages* table mainly contains the caches related to WPML String Translation. We can clear the caches by doing WPML Troubleshooting steps.

Please try the following troubleshooting steps after a site backup and make sure the table is cleared or not.

1) Go to WPML>>Support page

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

3) 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

To help you faster, I've enabled debug information for this support ticket. Please see this link for how to get this information from your site and give it to us: http://wpml.org/faq/provide-debug-information-faster-support/

--
Thanks!

Bigul

September 23, 2019 at 3:02 pm #4625297

ronaldB-12

My issue is resolved now. Thank you!

What would have caused this in the first place?