Issue importing site exported with WP Migrate Lite

What issue or error are you experiencing?

Hola amigos. I cannot import this site. Used WP Migrate Lite plugin to export site and when importing it says incompatible .zip file. I did follow the instructions found in another thread to totally delete localwp and reinstalled, but am still not able to import this site. I am able to import a new, blank site. Logs say something about a table not existing, but it should have created it, yeah?


What steps can be taken to replicate the issue? Feel free to include screenshots, videos, etc

Export with recommended plugin. Import by dragging zip file. Error.


System Details

  • Local Version:
    Version 8.2.0+6554
  • Operating System (OS) and OS version:
    macOS Ventura

Local Logs

Attach your Local Logs here (Help Doc - Retrieving Local’s Log)

{"class":"LiveLinksService","extraInfo":{},"graphQLErrors":[{"extensions":{"category":"internal"},"locations":[{"column":3,"line":2}],"message":"Internal server error","path":["availableSubdomain"]}],"level":"error","message":"GraphQL error: Internal server error","networkError":null,"stack":"Error: GraphQL error: Internal server error\n    at new ApolloError (%%appPath%%/node_modules/apollo-client/bundle.umd.js:92:26)\n    at %%appPath%%/node_modules/apollo-client/bundle.umd.js:1588:34\n    at %%appPath%%/node_modules/apollo-client/bundle.umd.js:2008:15\n    at Set.forEach (<anonymous>)\n    at %%appPath%%/node_modules/apollo-client/bundle.umd.js:2006:26\n    at Map.forEach (<anonymous>)\n    at QueryManager.broadcastQueries (%%appPath%%/node_modules/apollo-client/bundle.umd.js:2004:20)\n    at %%appPath%%/node_modules/apollo-client/bundle.umd.js:2131:19\n    at Object.next (%%appPath%%/node_modules/zen-observable/lib/Observable.js:322:23)\n    at notifySubscription (%%appPath%%/node_modules/zen-observable/lib/Observable.js:135:18)","thread":"main","timestamp":"2024-01-18T17:25:18.550Z"}
{"class":"LiveLinksService","extraInfo":{},"graphQLErrors":[{"extensions":{"category":"internal"},"locations":[{"column":3,"line":2}],"message":"Internal server error","path":["availableSubdomain"]}],"level":"error","message":"GraphQL error: Internal server error","networkError":null,"stack":"Error: GraphQL error: Internal server error\n    at new ApolloError (%%appPath%%/node_modules/apollo-client/bundle.umd.js:92:26)\n    at %%appPath%%/node_modules/apollo-client/bundle.umd.js:1588:34\n    at %%appPath%%/node_modules/apollo-client/bundle.umd.js:2008:15\n    at Set.forEach (<anonymous>)\n    at %%appPath%%/node_modules/apollo-client/bundle.umd.js:2006:26\n    at Map.forEach (<anonymous>)\n    at QueryManager.broadcastQueries (%%appPath%%/node_modules/apollo-client/bundle.umd.js:2004:20)\n    at %%appPath%%/node_modules/apollo-client/bundle.umd.js:2131:19\n    at Object.next (%%appPath%%/node_modules/zen-observable/lib/Observable.js:322:23)\n    at notifySubscription (%%appPath%%/node_modules/zen-observable/lib/Observable.js:135:18)","thread":"main","timestamp":"2024-01-18T17:25:18.551Z"}
{"class":"LiveLinksService","extraInfo":{},"graphQLErrors":[{"extensions":{"category":"internal"},"locations":[{"column":3,"line":2}],"message":"Internal server error","path":["availableSubdomain"]}],"level":"error","message":"GraphQL error: Internal server error","networkError":null,"stack":"Error: GraphQL error: Internal server error\n    at new ApolloError (%%appPath%%/node_modules/apollo-client/bundle.umd.js:92:26)\n    at %%appPath%%/node_modules/apollo-client/bundle.umd.js:1588:34\n    at %%appPath%%/node_modules/apollo-client/bundle.umd.js:2008:15\n    at Set.forEach (<anonymous>)\n    at %%appPath%%/node_modules/apollo-client/bundle.umd.js:2006:26\n    at Map.forEach (<anonymous>)\n    at QueryManager.broadcastQueries (%%appPath%%/node_modules/apollo-client/bundle.umd.js:2004:20)\n    at %%appPath%%/node_modules/apollo-client/bundle.umd.js:2131:19\n    at Object.next (%%appPath%%/node_modules/zen-observable/lib/Observable.js:322:23)\n    at notifySubscription (%%appPath%%/node_modules/zen-observable/lib/Observable.js:135:18)","thread":"main","timestamp":"2024-01-18T17:25:29.241Z"}
{"class":"LiveLinksService","extraInfo":{},"graphQLErrors":[{"extensions":{"category":"internal"},"locations":[{"column":3,"line":2}],"message":"Internal server error","path":["availableSubdomain"]}],"level":"error","message":"GraphQL error: Internal server error","networkError":null,"stack":"Error: GraphQL error: Internal server error\n    at new ApolloError (%%appPath%%/node_modules/apollo-client/bundle.umd.js:92:26)\n    at %%appPath%%/node_modules/apollo-client/bundle.umd.js:1588:34\n    at %%appPath%%/node_modules/apollo-client/bundle.umd.js:2008:15\n    at Set.forEach (<anonymous>)\n    at %%appPath%%/node_modules/apollo-client/bundle.umd.js:2006:26\n    at Map.forEach (<anonymous>)\n    at QueryManager.broadcastQueries (%%appPath%%/node_modules/apollo-client/bundle.umd.js:2004:20)\n    at %%appPath%%/node_modules/apollo-client/bundle.umd.js:2131:19\n    at Object.next (%%appPath%%/node_modules/zen-observable/lib/Observable.js:322:23)\n    at notifySubscription (%%appPath%%/node_modules/zen-observable/lib/Observable.js:135:18)","thread":"main","timestamp":"2024-01-18T17:25:31.967Z"}
{"class":"Process","level":"warn","message":"2024-01-18T17:25:31.781378Z 0 [System] [MY-010116] [Server] %%userDataPath%%/lightning-services/mysql-8.0.16+6/bin/darwin/bin/mysqld (mysqld 8.0.16) starting as process 6393","process":"mysql","thread":"main","timestamp":"2024-01-18T17:25:32.004Z"}
{"class":"Process","level":"warn","message":"2024-01-18T17:25:31.783137Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.","process":"mysql","thread":"main","timestamp":"2024-01-18T17:25:32.004Z"}
{"class":"Process","level":"warn","message":"2024-01-18T17:25:31.783648Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for %%site.runData%%/mysql/data/ is case insensitive","process":"mysql","thread":"main","timestamp":"2024-01-18T17:25:32.004Z"}
{"class":"Process","level":"warn","message":"2024-01-18T17:25:31.994830Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","process":"mysql","thread":"main","timestamp":"2024-01-18T17:25:32.004Z"}
{"class":"Process","level":"warn","message":"2024-01-18T17:25:32.004121Z 0 [System] [MY-010931] [Server] %%userDataPath%%/lightning-services/mysql-8.0.16+6/bin/darwin/bin/mysqld: ready for connections. Version: '8.0.16'  socket: '%%site.runData%%/mysql/mysqld.sock'  port: 10009  MySQL Community Server - GPL.","process":"mysql","thread":"main","timestamp":"2024-01-18T17:25:32.004Z"}
{"class":"ImporterGeneric","level":"error","message":"Unable to import /Users/mediaworks12/Local Sites/colorado-wildlife-federation/app/sql/database.sql","stack":"Error: ERROR 1146 (42S02) at line 1: Table 'local.wp_wsal_occurrences' doesn't exist\n    at %%appPath%%/main/_helpers/importSQLFile.js:1:2667\n    at Generator.next (<anonymous>)\n    at a (%%appPath%%/main/_helpers/importSQLFile.js:1:849)","thread":"main","timestamp":"2024-01-18T17:25:37.569Z"}
{"level":"warn","message":"Unable to import site.","stack":"Error: Local was unable to import the following SQL files: \n\n• /app/sql/database.sql\n    at ImporterGeneric.<anonymous> (%%appPath%%/main/importer/Importer.js:1:9910)\n    at Generator.throw (<anonymous>)\n    at o (%%appPath%%/main/importer/Importer.js:1:900)","timestamp":"2024-01-18T17:25:37.572Z"}

Security Reminder
Local does a pretty good job of scrubbing private info from the logs and the errors it produces, however there’s always the possibility that something private can come through. Because these are public forums, always review the screenshots you are sharing to make sure there isn’t private info like passwords being displayed.

Hi @edigermatthew

Are you able to manually import the site using the steps here?

1 Like

I am not. Hitting basically the same error:

% wp db import database.sql 
ERROR 1146 (42S02) at line 1 in file: 'database.sql': Table 'local.wp_wsal_occurrences' doesn't exist

Hi there,

I looked up that table mentioned in the error wp_wsal_occurrences and it appears that it might be connected to this plugin:

Do you have that plugin installed?

Sam

I do have that installed. I will try to remove it and take another export.

That plugin, WP Activity Log, was actually messing up the export from WP Migrate Lite. I checked out the database.sql I had gotten and that table’s insert values sql query’s were the only parts exported. The table creations, as well as the rest of the database tables were not exported. I deleted that plugin, as well as the corresponding table from phpmyadmin. Had to reinstall WP Migrate Lite to get it to run a new check of the database? Maybe this is a cron job? I couldn’t get it to refresh. Finally got it to export fully and imported fine into LocalWP. Thanks for the help! Will have to find a new wp monitoring plugin for zealous clients…

2 Likes

Hi @edigermatthew -

Wonderful - I’m glad that helped solve the problem!

Happy building :green_heart:

Sam

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