Push to Flywheel Staging - critical error

Support
1

Bug Summary

I get an error when trying to Push from Local to a Flywheel staging site.
The error says, “Uh-oh! We ran into an issue pushing this site to Flywheel.”
It happened fairly quickly in the Push process.

Steps to reproduce

I talked to Flywheel support, who referenced an issue in the Local Community.

I followed the instructions, found my [SITE ID] in Local, and saw a lock file in ~/Library/Application Support/Local/run/[SITE ID]/mysql/ named mysqld.lock. I deleted the lock file, restarted Local, and tried to Push to Flywheel Staging. Same error, lock file returned. No joy.

Environment Info

Describe your environment.
• MacBook Pro with M1 Max Apple Silicone, 32 GB Memory.
• macOS Ventura 13.3.1
• Local Version 6.7.0+6347
• Local webserver: nginx
• PHP version: 8.1.9
• Database: MySQL 8.0.16
• WordPress version: 6.2
• Xdebug: OFF

Supporting info

local-logs.zip (51.3 KB)

Include any screenshots or video recordings of the issue to help others reproduce.

2

Hey @swest I sent you a DM to gather some additional details here. Thanks!

3

Hey @swest!

Sorry for the delay. I know we have been messaging 1 on 1 but I thought I’d come back to the public thread in case any users are searching and want to know where things might have gotten resolved.

I tried direct importing the site as you sent it to me yesterday but couldn’t get it to go through. This morning I tried importing it manually but got the below error:

ERROR 1062 (23000) at line 45054 in file: 'database.sql': Duplicate entry '????????????' for key 'token'

I took a look at that line in the DB along with everything around it and it looked very odd and out of place. That led me to here: “Duplicate Entry for Unique Key” Error when Migrating/Restoring Site - SearchWP

I think the issue lies with SearchWP and the tables it’s creating that will need to be dropped before any migration can happen.

Let me know if that helps, if you hit any other snags, or have other questions that come up!

4

Great find!
Ok, I’ll drop those tables and will let you know what happens.

Thanks so much for your help on this.

1 Like
5

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