Database causes a duplication error

This support ticket is created 2 years, 11 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

This topic contains 2 replies, has 2 voices.

Last updated by juttaB 2 years, 11 months ago.

Author

Posts

February 14, 2022 at 4:19 pm #2292031

juttaB

I am trying to:

Duplicate a page on a Multisite

Link to a page where the issue can be seen:

hidden link

I expected to see:
Hi there, I try to duplicate a site within a multisite, I tried 3 different tools, but I always get this error:

Duplication failed :

ERROR SQL ON : SELECT `point` FROM `1k7yN_14_toolset_maps_address_cache` WHERE `point` LIKE '{3ef18fd4152850cd7158f5e429bb0f48d69dc8e82c0b920002589e6e80ae231b}hidden link{3ef18fd4152850cd7158f5e429bb0f48d69dc8e82c0b920002589e6e80ae231b}'

WPDB ERROR : Incorrect arguments to like

What can I do?
Please find login cress in the other tickets.

February 14, 2022 at 4:58 pm #2292091

Nigel

Supporter

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

Timezone: Europe/London (GMT+00:00)

I took a quick look at your site, and although you only have a few sites in your multisite installation, there appear to be database tables for very many sites (around 20?) in the same table, e.g. there are around 20 toolset_maps_address_cache tables.

I suggest you drop the toolset_maps_address_cache table for the particular site. Toolset will then recreate the table, and rebuild the cache.

If that doesn't help, let us know and we can take another look.

February 14, 2022 at 7:02 pm #2292185

juttaB

Hi Nigel, thank for your advice. All these table where created by canceled duplication processes. I will try to delete them as you have suggested.