Hi, I am experiencing an issue when trying to import one of our sites from WP Engine, using the ‘Pull from WP Engine’ functionality of local.
Error message: “Error: Command failed: /resourcesPath/lightning-services/mysql-8.0.16+6/bin/darwin/bin/mysql local -B --disable-column-names -e SELECT option_value FROM wp_options WHERE option_name = ‘siteurl’;ERROR 1146 (42S02) at line 1: Table ‘local.wp_options’ doesn’t exist”
I have had a look at the forums and I did find a similar-ish issue here: SQL missing table error prevent importing site. However, in this instance the user was importing a site using the zip method, and in either case the links to the screenshots no longer work. So, I am unable to see how to resolve it.
- Does this happen for all sites in Local, or just one in particular?
No, this is only happening for one particular site. In this instance, the Prod version of the site imports correctly, however the staging version of the site results in the issue.
Replication is as simple as pulling the site from the WPE server.
Which version of Local is being used? 5.10.5+5403
What Operating System (OS) and OS version is being used? MacOS 11.4
Attach the Local Log. See this Community Forum post for instructions on how to do so:
Log attached.local-lightning.log (794.9 KB)