Push to WP Engine Fails

Issue Summary

When attempting to push from local to WP Engine I am getting the following error message: "Uh-oh! We ran into an issue when updating the table prefix from WP Engine. You might need to set the $table_prefix variable in the wp-config.php on WP Engine to “wp_”. I checked this and the $table_prefix variable in the wp-config.php is set to “wp_”. I spent an hour with WP Engine support and they are stumped

Troubleshooting Questions

ALL of my Local sites are doing this

System Details

I am using Local version 5.10.4+5377

macOS Big Sur 11.4

local-lightning.log (308.7 KB)

Sad to see this hasn’t gone anywhere as I’m running into the same issue

Sorry that I missed this one, but if you two are still around, I’d love to work through this with you!

When I take a look at the @tkapner 's Local log, I’m seeing a number of entries that look like this:

{"thread":"main","class":"CAPIService","message":"Creating backup for install 2cb6cfc5-0c1b-4c51-ba28-6536fb82b98a","level":"info","timestamp":"2021-05-28T16:22:46.370Z"}
{"thread":"main","class":"DevKitService","message":"Failed to create shell\r\n","level":"warn","timestamp":"2021-05-28T16:23:00.840Z"}
{"thread":"main","class":"DevKitService","message":"rsync: connection unexpectedly closed (0 bytes received so far) [sender]\nrsync error: error in rsync protocol data stream (code 12) at io.c(226) [sender=3.1.3]\n","level":"warn","timestamp":"2021-05-28T16:23:00.841Z"}
{"thread":"main","class":"DevKitService","message":"Failed to create shell\r\nConnection to pnmshop21.ssh.wpengine.net closed by remote host.\r\n","level":"warn","timestamp":"2021-05-28T16:23:02.014Z"}
{"thread":"main","class":"DevKitService","level":"info","message":"Pushing database to the remote server\n","timestamp":"2021-05-28T16:23:02.019Z"}
{"thread":"main","class":"DevKitService","message":"Failed to create shell\r\n","level":"warn","timestamp":"2021-05-28T16:23:03.166Z"}
{"thread":"main","class":"DevKitService","level":"info","message":"\u001b[1;31m\rError: \u001b[0mIt appears you're trying to push your Database to a production environment. This functionality is not yet supported in this beta product. Please push to a dev or staging environment instead.\n","timestamp":"2021-05-28T16:23:03.174Z"}

Note these parts:

Failed to create shell

and

rsync: connection unexpectedly closed (0 bytes received so far) [sender]\nrsync error: error in rsync protocol data stream (code 12) at io.c(226) [sender=3.1.3]\

It almost seems like the Connect push was interrupted due to network issues since you were able to pull the site down a couple of days before these events.

Do you ever log into your site through the terminal, using SSH? If you do, are you still able to?

It might be good idea to try and disconnect Local from WPE and then reconnect by generating a new key using this help doc: