Pulling newly migrated site from Flywheel generates errors (POINT column in MySQL)

Support
1

I am trying to copy a site down from Flywheel using the Pull feature in Local.

The site is copied, but for some reason the database isn’t coming in the pull (as far as I can tell) and I am getting an error message from Local.

“Uh-oh! We ran into an issue when pulling form Flywheel.”

I have access the log and copied the parts related to starting the site and doing the pull. Here is that log after I removed the username and sitename details.
local-lightning-error.log (3.9 KB)

Any help would be greatly appreciated. Flywheel support basically said reach out here.

Thank you,

2

Hi @Archatlanta,

I apologize for the trouble with Pulling from Flywheel!

It looks like the issues are related to the Toolset Maps plugin which has a cache table that utilizes point columns. These are notorious for causing issues during exporting and importing of MySQL databases.

@ben.turner has a great technical writeup here on the bug if you’re curious: Error importing SQL from Local Lightning

As a workaround, you could look into deleting the toolset_cache table prior to pushing/pulling but I know that’s not ideal. A more ergonomic solution may be to exclude the database when pushing/pulling and then use https://wordpress.org/plugins/wp-migrate-db/ to handle pushing/pulling the database.

This is a problem we’re keeping a close eye on since the frequency seems to be increasing.

3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.