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, 4 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.

Our next available supporter will start replying to tickets in about 1.95 hours from now. Thank you for your understanding.

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, 4 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!