WP could not create a database table for address cache

This thread is resolved. Here is a description of the problem and solution.

Problem:

Convert Maps address cache to new format, but get this error:

WP could not create a database table for address cache.

Is there a Way to crate the table manually ?

Solution:

If you are familiar with mysql tools, you can try these manually:

1) Backup your website database first

2) Run the SQL query, like this:

https://toolset.com/forums/topic/wp-could-not-create-a-database-table-for-address-cache/#post-1281629

Relevant Documentation:

This support ticket is created 5 years, 5 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 – 13:00	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	-
-	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	-

Supporter timezone: Asia/Hong_Kong (GMT+08:00)

Tagged: Toolset Maps, Views plugin

This topic contains 2 replies, has 2 voices.

Last updated by miguelG-5 5 years, 5 months ago.

Assisted by: Luo Yang.

Author

Posts

July 2, 2019 at 7:23 am #1281533

miguelG-5

I got this message : 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!

I am trying to: Convert Maps address cache to new format.

Instead, I got:

Created table sz22cetot9_toolset_maps_address_cache
WP could not create a database table for address cache. Old cache system will be used.

Is there a Way to crate the table manually ?

Thanks in advance

July 2, 2019 at 8:53 am #1281629

Luo Yang

Hello,

Yes, in the latest version of Toolset Maps plugin, we have add some new features:
https://toolset.com/2019/06/toolset-forms-2-4-and-maps-1-8-release/
section "Toolset Maps 1.8 Provides Big Performance Improvements"

If you are familiar with mysql tools, you can try these manually:
1) Backup your website database first
2) Run the SQL query, like this:

CREATE TABLE IF NOT EXISTS 'sz22cetot9_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;

Please replace "sz22cetot9_" with your wordpress database table prefix.

July 2, 2019 at 9:41 am #1281697

miguelG-5

My issue is resolved now. Thank you!