WordPress database error: [Duplicate entry 'Bogota, Bogotá, Colombie' for key 'P

This support ticket is created 4 years, 7 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.

Sun	Mon	Tue	Wed	Thu	Fri	Sat
-	9:00 – 12:00	9:00 – 12:00	9:00 – 12:00	9:00 – 12:00	9:00 – 12:00	-
-	13:00 – 18:00	13:00 – 18:00	13:00 – 18:00	14:00 – 18:00	13:00 – 18:00	-

Supporter timezone: America/Jamaica (GMT-05:00)

Tagged: Toolset Maps, Views plugin

This topic contains 5 replies, has 3 voices.

Last updated by Shane 4 years, 6 months ago.

Assisted by: Shane.

Author

Posts

April 22, 2020 at 10:48 am #1595483

fredericP

I am trying to:
make my project works...

Link to a page where the issue can be seen:
home page. hidden link

I expected to see:
a nice website

Instead, I got:
a database error
WordPress database error: [Duplicate entry 'Bogota, Bogotá, Colombie' for key 'PRIMARY']
INSERT INTO wp_toolset_maps_address_cache ( `address_passed`, `address`, `point` ) VALUES ( 'Bogota, Bogotá, Colombie', 'Bogota, Colombia', ST_PointFromText('POINT(-74.072092 4.710989)') )

It seems the database uses as PRIMARY key some string ? Then if the location is already set, it crashes ?

April 22, 2020 at 5:12 pm #1596127

Christian Cox

Hi, may I make a clone of your site using the Duplicator plugin so I can pass this information to our developers for investigation? Please provide login credentials in the private reply fields here.

April 23, 2020 at 2:54 pm #1597715

Christian Cox

Hello, I am unable to log in using these credentials. Can you check and provide an update if needed? Is there an IP-based restriction or other security measures in place that could be causing a problem?

April 27, 2020 at 12:36 pm #1602675

fredericP

I've cleaned by hand the database. It seems that some posts that were deleted were still there and made some mess.
I remove by hand all post (and meta) that were linked to Bogota and all were ok after that. Then I could re inject the posts.

So it is solved but I wish I could explain what happened.

April 28, 2020 at 8:57 pm #1604791

Shane

Supporter

Languages: English (English )

Timezone: America/Jamaica (GMT-05:00)

Hi Frederic,

Christian is currently unavailable today but he will be back tomorrow to continue assisting with this.

Thanks,
Shane

May 6, 2020 at 2:30 pm #1613925

Shane

Supporter

Languages: English (English )

Timezone: America/Jamaica (GMT-05:00)

Hi Frederic,

Given that the issue has been resolved there isn't much else that we can do here.

What could've happen was that you had some corrupt information in the database as you explained here "It seems that some posts that were deleted were still there and made some mess."

What you can do is to continue to monitor the site and if the issue re-occurs you are more than welcomed to get in touch with us again and we will take it from there.

Thanks,
Shane