Skip Navigation

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 1 reply, has 2 voices.

Last updated by Yvette 4 years, 11 months ago.

Assisted by: Yvette.

Author Posts
October 30, 2019 at 11:19 am #4854897

Waldemar Kawulski

Tell us what you are trying to do?
I try repeair to big DB table wp_icl_string_pages
But i don't see button *Recreate ST DB cache tables*

Is there any documentation that you are following?
https://wpml.org/forums/topic/table-wp_icl_string_pages-is-too-big/

Is there a similar example that we can see?

What is the link to your site?
hidden link
WPML Version 4.3.1 | (today upgreaded)

ph-error-wpml.png
October 30, 2019 at 2:43 pm #4856505

Yvette
Supporter

Languages: English (English ) Spanish (Español )

Timezone: Europe/Paris (GMT+02:00)

Hello

The current version of WPML is not using these caching tables. This is why you no longer see the option to create them.

If you need, you can drop the table manually and then recreate it,.

You can use the following SQL command in myphpadmin - please make sure you make a backup of your database before doing this and also that you replace the "wp" in the code with the correct prefix for your database instance.

DROP TABLE IF EXISTS `wp_icl_string_pages`;
CREATE TABLE `wp_icl_string_pages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `string_id` bigint(20) unsigned NOT NULL,
  `url_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `string_to_url_id` (`url_id`),
  KEY `string_id` (`string_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

Please let me know if this addresses your problem.

This ticket is now closed. If you're a WPML client and need related help, please open a new support ticket.