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)
This topic contains 3 replies, has 2 voices.
Last updated by Luo Yang 1 year, 11 months ago.
Assisted by: Luo Yang.
I had a strange problem trying to migrate the wordpress MySQL database from our live site to our staging server. When I tried to import the database via the command line, I got the following unusual error which caused the mysql import to fail:
ERROR 1416 (22003) at line 2673: Cannot get geometry object from data you send to the GEOMETRY field
The culprit appears to be that our 'wp_toolset_maps_address_cache table' contained a number of rows with a NULL (or blank) value for the 'point' column, which uses the special POINT MySQL type.
When I manually deleted those rows and re-exported the database, I was then able to successfully import our database.
I'm sending this as a bug report, because I can't think of any good reason for toolset to be inserting invalid (blank) POINT records in this table -- especially since at least some versions of MySQL have a hard failure trying to import a database containing such rows.
Please provide detail steps to reproduce the same problem, I have tried it in my localhost with a fresh WP installation + the latest version of Toolset plugins, use the same address value as your screenshot: Tucson, AZ, USA
It works fine, I can see the cached value in Maps setting page, see my screenshot
The topic ‘[Closed] wp_toolset_maps_address_cache is corrupted and prevents database import’ is closed to new replies.
