[Resolved] WP could not create a database table for address cache – phpmyadmin

[Author]

Posts

[shawnW-3]

Tell us what you are trying to do?
We're trying to run this SQL Query from phpmyadmin, but we're not having any luck...
We're hoping it's just a syntax error. Please advise.

https://toolset.com/forums/topic/wp-could-not-create-a-database-table-for-address-cache/
ourdbtableprefix isn't the actual name, but for the purpose of this it should suffice.

CREATE TABLE IF NOT EXISTS 'ourdbtableprefix_toolset_maps_address_cache' (
'address_passed' varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
'address' varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
'point' point NOT NULL,
PRIMARY KEY ('address_passed')
) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

Is there any documentation that you are following?
https://toolset.com/forums/topic/wp-could-not-create-a-database-table-for-address-cache/

Is there a similar example that we can see?
Attached is the image of the errors we encountered.

[Nigel]

Hi Shawn

I just tried the same and saw the same formatting errors.

Within the SQL editor I replaced all of the single quotes with backticks, and that worked, e.g.

CREATE TABLE IF NOT EXISTS `wp_toolset_maps_address_cache` (
  `address_passed` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `point` point NOT NULL,
  PRIMARY KEY (`address_passed`)
) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

Do you want to try the same?

[shawnW-3]

This worked, thank you, but I notice the initial error persists on the backend of the website. Is there something more I need to do or is it going to work?

Toolset Maps: You've got some address data cached. Convert it to a new, more efficient format to gain significant performance benefits on Troubleshooting Page!

[Nigel]

Is this an older site with existing addresses?

They'll want migrating to the newer format which should bring significant performance improvements.

I don't have such a test site available where I see that message, is there not a link and an action for you to take to perform the migration?

If you go to Toolset > Settings and at the bottom of the page click the link for the debugging page.

If it's not clear what action to take I'll have to set up a test site with an old version of maps so that I can see for myself what the UI looks like in this scenario.