What issue or error are you experiencing?
I’m using WP Migrate Pro - to extract a single subsite from a multisite install. no matter what combination of files I choose to export as a zip, I get an error in Local that says I need a compatible zip file.
I have also attempted to just take database.sql and the wp-content folders and created a new zip of those only - and got the same result.
Can you help me by explaining just what I need to export to get this to work?
What steps can be taken to replicate the issue? Feel free to include screenshots, videos, etc
System Details
-
Local Version:
7.1.2+6410 -
Operating System (OS) and OS version:
MacOS ventura v 13.2
Local Logs
Attach your Local Logs here (Help Doc - Retrieving Local’s Log)
{"localVersion":"7.1.2+6410","osPlatform":"darwin","osRelease":"22.3.0","osArch":"arm64","windowsEdition":null,"linuxEdition":null,"level":"warn","message":"Electron Event ready","timestamp":"2023-09-06T16:04:34.554Z"}
{"localVersion":"7.1.2+6410","osPlatform":"darwin","osRelease":"22.3.0","osArch":"arm64","windowsEdition":null,"linuxEdition":null,"level":"warn","message":"Electron Event ready","timestamp":"2023-09-06T16:06:39.063Z"}
{"localVersion":"7.1.2+6410","osPlatform":"darwin","osRelease":"22.3.0","osArch":"arm64","windowsEdition":null,"linuxEdition":null,"level":"warn","message":"Electron Event ready","timestamp":"2023-09-06T16:06:50.397Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T17:25:38.601563Z 0 [System] [MY-010116] [Server] %%resourcesPath%%/lightning-services/mysql-8.0.16+6/bin/darwin/bin/mysqld (mysqld 8.0.16) starting as process 34743","timestamp":"2023-09-06T17:25:38.811Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T17:25:38.602585Z 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.","timestamp":"2023-09-06T17:25:38.811Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T17:25:38.603143Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for %%site.runData%%/mysql/data/ is case insensitive","timestamp":"2023-09-06T17:25:38.811Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T17:25:38.800070Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","timestamp":"2023-09-06T17:25:38.811Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T17:25:38.810665Z 0 [System] [MY-010931] [Server] %%resourcesPath%%/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: 10004 MySQL Community Server - GPL.","timestamp":"2023-09-06T17:25:38.811Z"}
{"thread":"main","class":"ImporterGeneric","code":1,"killed":false,"signal":null,"cmd":"%%resourcesPath%%/lightning-services/mysql-8.0.16+6/bin/darwin/bin/mysql local -B --disable-column-names -e SELECT option_value FROM options WHERE option_name = 'siteurl';","level":"error","stack":"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 options WHERE option_name = 'siteurl';\nERROR 1146 (42S02) at line 1: Table 'local.options' doesn't exist\n\n at ChildProcess.exithandler (node:child_process:407:12)\n at ChildProcess.emit (node:events:527:28)\n at ChildProcess.emit (node:domain:475:12)\n at maybeClose (node:internal/child_process:1092:16)\n at ChildProcess._handle.onexit (node:internal/child_process:302:5)","message":"Command failed: %%resourcesPath%%/lightning-services/mysql-8.0.16+6/bin/darwin/bin/mysql local -B --disable-column-names -e SELECT option_value FROM options WHERE option_name = 'siteurl';\nERROR 1146 (42S02) at line 1: Table 'local.options' doesn't exist\n","timestamp":"2023-09-06T17:27:30.419Z"}
{"stack":"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 options WHERE option_name = 'siteurl';\nERROR 1146 (42S02) at line 1: Table 'local.options' doesn't exist\n\n at ChildProcess.exithandler (node:child_process:407:12)\n at ChildProcess.emit (node:events:527:28)\n at ChildProcess.emit (node:domain:475:12)\n at maybeClose (node:internal/child_process:1092:16)\n at ChildProcess._handle.onexit (node:internal/child_process:302:5)","level":"warn","message":"Unable to import site.","timestamp":"2023-09-06T17:27:30.426Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T17:33:03.231305Z 0 [System] [MY-010116] [Server] %%resourcesPath%%/lightning-services/mysql-8.0.16+6/bin/darwin/bin/mysqld (mysqld 8.0.16) starting as process 35705","timestamp":"2023-09-06T17:33:03.430Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T17:33:03.232305Z 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.","timestamp":"2023-09-06T17:33:03.430Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T17:33:03.232883Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for %%site.runData%%/mysql/data/ is case insensitive","timestamp":"2023-09-06T17:33:03.430Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T17:33:03.418220Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","timestamp":"2023-09-06T17:33:03.430Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T17:33:03.430136Z 0 [System] [MY-010931] [Server] %%resourcesPath%%/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: 10004 MySQL Community Server - GPL.","timestamp":"2023-09-06T17:33:03.431Z"}
{"thread":"main","class":"ImporterGeneric","code":1,"killed":false,"signal":null,"cmd":"%%resourcesPath%%/lightning-services/mysql-8.0.16+6/bin/darwin/bin/mysql local -B --disable-column-names -e SELECT option_value FROM options WHERE option_name = 'siteurl';","level":"error","stack":"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 options WHERE option_name = 'siteurl';\nERROR 1146 (42S02) at line 1: Table 'local.options' doesn't exist\n\n at ChildProcess.exithandler (node:child_process:407:12)\n at ChildProcess.emit (node:events:527:28)\n at ChildProcess.emit (node:domain:475:12)\n at maybeClose (node:internal/child_process:1092:16)\n at Socket.<anonymous> (node:internal/child_process:451:11)\n at Socket.emit (node:events:527:28)\n at Socket.emit (node:domain:475:12)\n at Pipe.<anonymous> (node:net:709:12)","message":"Command failed: %%resourcesPath%%/lightning-services/mysql-8.0.16+6/bin/darwin/bin/mysql local -B --disable-column-names -e SELECT option_value FROM options WHERE option_name = 'siteurl';\nERROR 1146 (42S02) at line 1: Table 'local.options' doesn't exist\n","timestamp":"2023-09-06T17:33:42.910Z"}
{"stack":"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 options WHERE option_name = 'siteurl';\nERROR 1146 (42S02) at line 1: Table 'local.options' doesn't exist\n\n at ChildProcess.exithandler (node:child_process:407:12)\n at ChildProcess.emit (node:events:527:28)\n at ChildProcess.emit (node:domain:475:12)\n at maybeClose (node:internal/child_process:1092:16)\n at Socket.<anonymous> (node:internal/child_process:451:11)\n at Socket.emit (node:events:527:28)\n at Socket.emit (node:domain:475:12)\n at Pipe.<anonymous> (node:net:709:12)","level":"warn","message":"Unable to import site.","timestamp":"2023-09-06T17:33:42.915Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T18:00:44.111497Z 0 [System] [MY-010116] [Server] %%resourcesPath%%/lightning-services/mysql-8.0.16+6/bin/darwin/bin/mysqld (mysqld 8.0.16) starting as process 37700","timestamp":"2023-09-06T18:00:44.310Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T18:00:44.112476Z 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.","timestamp":"2023-09-06T18:00:44.310Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T18:00:44.113048Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for %%site.runData%%/mysql/data/ is case insensitive","timestamp":"2023-09-06T18:00:44.310Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T18:00:44.298397Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","timestamp":"2023-09-06T18:00:44.310Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T18:00:44.310004Z 0 [System] [MY-010931] [Server] %%resourcesPath%%/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: 10004 MySQL Community Server - GPL.","timestamp":"2023-09-06T18:00:44.310Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T18:05:42.251426Z 0 [System] [MY-010116] [Server] %%resourcesPath%%/lightning-services/mysql-8.0.16+6/bin/darwin/bin/mysqld (mysqld 8.0.16) starting as process 38285","timestamp":"2023-09-06T18:05:42.444Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T18:05:42.252415Z 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.","timestamp":"2023-09-06T18:05:42.445Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T18:05:42.252990Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for %%site.runData%%/mysql/data/ is case insensitive","timestamp":"2023-09-06T18:05:42.445Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T18:05:42.434666Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","timestamp":"2023-09-06T18:05:42.445Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T18:05:42.444856Z 0 [System] [MY-010931] [Server] %%resourcesPath%%/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.","timestamp":"2023-09-06T18:05:42.445Z"}
{"thread":"main","class":"ImporterGeneric","code":1,"killed":false,"signal":null,"cmd":"%%resourcesPath%%/lightning-services/mysql-8.0.16+6/bin/darwin/bin/mysql local -B --disable-column-names -e SELECT option_value FROM options WHERE option_name = 'siteurl';","level":"error","stack":"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 options WHERE option_name = 'siteurl';\nERROR 1146 (42S02) at line 1: Table 'local.options' doesn't exist\n\n at ChildProcess.exithandler (node:child_process:407:12)\n at ChildProcess.emit (node:events:527:28)\n at ChildProcess.emit (node:domain:475:12)\n at maybeClose (node:internal/child_process:1092:16)\n at Socket.<anonymous> (node:internal/child_process:451:11)\n at Socket.emit (node:events:527:28)\n at Socket.emit (node:domain:475:12)\n at Pipe.<anonymous> (node:net:709:12)","message":"Command failed: %%resourcesPath%%/lightning-services/mysql-8.0.16+6/bin/darwin/bin/mysql local -B --disable-column-names -e SELECT option_value FROM options WHERE option_name = 'siteurl';\nERROR 1146 (42S02) at line 1: Table 'local.options' doesn't exist\n","timestamp":"2023-09-06T18:06:02.713Z"}
{"stack":"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 options WHERE option_name = 'siteurl';\nERROR 1146 (42S02) at line 1: Table 'local.options' doesn't exist\n\n at ChildProcess.exithandler (node:child_process:407:12)\n at ChildProcess.emit (node:events:527:28)\n at ChildProcess.emit (node:domain:475:12)\n at maybeClose (node:internal/child_process:1092:16)\n at Socket.<anonymous> (node:internal/child_process:451:11)\n at Socket.emit (node:events:527:28)\n at Socket.emit (node:domain:475:12)\n at Pipe.<anonymous> (node:net:709:12)","level":"warn","message":"Unable to import site.","timestamp":"2023-09-06T18:06:02.718Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T18:26:12.651338Z 0 [System] [MY-010116] [Server] %%resourcesPath%%/lightning-services/mysql-8.0.16+6/bin/darwin/bin/mysqld (mysqld 8.0.16) starting as process 44120","timestamp":"2023-09-06T18:26:12.897Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T18:26:12.654067Z 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.","timestamp":"2023-09-06T18:26:12.898Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T18:26:12.654737Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for %%site.runData%%/mysql/data/ is case insensitive","timestamp":"2023-09-06T18:26:12.898Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T18:26:12.883989Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","timestamp":"2023-09-06T18:26:12.898Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T18:26:12.897711Z 0 [System] [MY-010931] [Server] %%resourcesPath%%/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: 10004 MySQL Community Server - GPL.","timestamp":"2023-09-06T18:26:12.898Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T18:27:04.751529Z 0 [System] [MY-010116] [Server] %%resourcesPath%%/lightning-services/mysql-8.0.16+6/bin/darwin/bin/mysqld (mysqld 8.0.16) starting as process 44233","timestamp":"2023-09-06T18:27:04.996Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T18:27:04.755550Z 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.","timestamp":"2023-09-06T18:27:04.996Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T18:27:04.756173Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for %%site.runData%%/mysql/data/ is case insensitive","timestamp":"2023-09-06T18:27:04.996Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T18:27:04.980698Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","timestamp":"2023-09-06T18:27:04.996Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T18:27:04.995924Z 0 [System] [MY-010931] [Server] %%resourcesPath%%/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: 10004 MySQL Community Server - GPL.","timestamp":"2023-09-06T18:27:04.996Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T19:59:40.261349Z 0 [System] [MY-010116] [Server] %%resourcesPath%%/lightning-services/mysql-8.0.16+6/bin/darwin/bin/mysqld (mysqld 8.0.16) starting as process 50100","timestamp":"2023-09-06T19:59:40.460Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T19:59:40.262386Z 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.","timestamp":"2023-09-06T19:59:40.461Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T19:59:40.262946Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for %%site.runData%%/mysql/data/ is case insensitive","timestamp":"2023-09-06T19:59:40.461Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T19:59:40.448708Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","timestamp":"2023-09-06T19:59:40.461Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T19:59:40.460438Z 0 [System] [MY-010931] [Server] %%resourcesPath%%/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: 10003 MySQL Community Server - GPL.","timestamp":"2023-09-06T19:59:40.461Z"}
{"thread":"main","class":"ImporterGeneric","stack":"Error: ERROR 1146 (42S02) at line 1: Table 'local.wp_60_users' doesn't exist\n at %%appPath%%/main/_helpers/importSQLFile.js:1:2560\n at Generator.next (<anonymous>)\n at a (%%appPath%%/main/_helpers/importSQLFile.js:1:742)","level":"error","message":"Unable to import /Users/michaelboldin/Local Sites/shop-tenth-amendment-center/app/sql/database.sql","timestamp":"2023-09-06T20:00:00.817Z"}
{"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:9812)\n at Generator.throw (<anonymous>)\n at o (%%appPath%%/main/importer/Importer.js:1:793)","level":"warn","message":"Unable to import site.","timestamp":"2023-09-06T20:00:00.825Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:01:50.011458Z 0 [System] [MY-010116] [Server] %%resourcesPath%%/lightning-services/mysql-8.0.16+6/bin/darwin/bin/mysqld (mysqld 8.0.16) starting as process 51121","timestamp":"2023-09-06T20:01:50.205Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:01:50.012446Z 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.","timestamp":"2023-09-06T20:01:50.206Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:01:50.012997Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for %%site.runData%%/mysql/data/ is case insensitive","timestamp":"2023-09-06T20:01:50.206Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:01:50.194914Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","timestamp":"2023-09-06T20:01:50.206Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:01:50.205763Z 0 [System] [MY-010931] [Server] %%resourcesPath%%/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: 10003 MySQL Community Server - GPL.","timestamp":"2023-09-06T20:01:50.206Z"}
{"thread":"main","class":"ImporterGeneric","stack":"Error: ERROR 1146 (42S02) at line 1: Table 'local.wp_60_users' doesn't exist\n at %%appPath%%/main/_helpers/importSQLFile.js:1:2560\n at Generator.next (<anonymous>)\n at a (%%appPath%%/main/_helpers/importSQLFile.js:1:742)","level":"error","message":"Unable to import /Users/michaelboldin/Local Sites/tenth-amendment-center/app/sql/database.sql","timestamp":"2023-09-06T20:01:59.383Z"}
{"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:9812)\n at Generator.throw (<anonymous>)\n at o (%%appPath%%/main/importer/Importer.js:1:793)","level":"warn","message":"Unable to import site.","timestamp":"2023-09-06T20:01:59.388Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:14:30.041799Z 0 [System] [MY-010116] [Server] %%resourcesPath%%/lightning-services/mysql-8.0.16+6/bin/darwin/bin/mysqld (mysqld 8.0.16) starting as process 52311","timestamp":"2023-09-06T20:14:30.272Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:14:30.042907Z 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.","timestamp":"2023-09-06T20:14:30.273Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:14:30.043537Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for %%site.runData%%/mysql/data/ is case insensitive","timestamp":"2023-09-06T20:14:30.273Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:14:30.261121Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","timestamp":"2023-09-06T20:14:30.273Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:14:30.272588Z 0 [System] [MY-010931] [Server] %%resourcesPath%%/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: 10003 MySQL Community Server - GPL.","timestamp":"2023-09-06T20:14:30.273Z"}
{"thread":"main","class":"ImporterGeneric","stack":"Error: ERROR 1146 (42S02) at line 1: Table 'local.wp_52_users' doesn't exist\n at %%appPath%%/main/_helpers/importSQLFile.js:1:2560\n at Generator.next (<anonymous>)\n at a (%%appPath%%/main/_helpers/importSQLFile.js:1:742)","level":"error","message":"Unable to import /Users/michaelboldin/Local Sites/tenth-amendment-center/app/sql/database.sql","timestamp":"2023-09-06T20:14:37.693Z"}
{"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:9812)\n at Generator.throw (<anonymous>)\n at o (%%appPath%%/main/importer/Importer.js:1:793)","level":"warn","message":"Unable to import site.","timestamp":"2023-09-06T20:14:37.699Z"}
{"thread":"main","class":"HostsFileService","error":{},"stdout":{},"stderr":{},"exitCode":{},"level":"error","message":"Could not update hosts.","timestamp":"2023-09-06T20:14:47.894Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:18:34.491389Z 0 [System] [MY-010116] [Server] %%resourcesPath%%/lightning-services/mysql-8.0.16+6/bin/darwin/bin/mysqld (mysqld 8.0.16) starting as process 53210","timestamp":"2023-09-06T20:18:34.690Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:18:34.492368Z 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.","timestamp":"2023-09-06T20:18:34.690Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:18:34.493071Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for %%site.runData%%/mysql/data/ is case insensitive","timestamp":"2023-09-06T20:18:34.690Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:18:34.678128Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","timestamp":"2023-09-06T20:18:34.690Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:18:34.689989Z 0 [System] [MY-010931] [Server] %%resourcesPath%%/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: 10004 MySQL Community Server - GPL.","timestamp":"2023-09-06T20:18:34.690Z"}
{"localVersion":"7.1.2+6410","osPlatform":"darwin","osRelease":"22.3.0","osArch":"arm64","windowsEdition":null,"linuxEdition":null,"level":"warn","message":"Electron Event ready","timestamp":"2023-09-06T20:23:11.969Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:23:19.631595Z 0 [System] [MY-010116] [Server] %%resourcesPath%%/lightning-services/mysql-8.0.16+6/bin/darwin/bin/mysqld (mysqld 8.0.16) starting as process 54715","timestamp":"2023-09-06T20:23:19.878Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:23:19.633807Z 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.","timestamp":"2023-09-06T20:23:19.878Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:23:19.634545Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for %%site.runData%%/mysql/data/ is case insensitive","timestamp":"2023-09-06T20:23:19.878Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:23:19.867020Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","timestamp":"2023-09-06T20:23:19.879Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:23:19.878443Z 0 [System] [MY-010931] [Server] %%resourcesPath%%/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: 10004 MySQL Community Server - GPL.","timestamp":"2023-09-06T20:23:19.879Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:24:43.361531Z 0 [System] [MY-010116] [Server] %%resourcesPath%%/lightning-services/mysql-8.0.16+6/bin/darwin/bin/mysqld (mysqld 8.0.16) starting as process 55083","timestamp":"2023-09-06T20:24:43.562Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:24:43.362535Z 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.","timestamp":"2023-09-06T20:24:43.562Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:24:43.363140Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for %%site.runData%%/mysql/data/ is case insensitive","timestamp":"2023-09-06T20:24:43.562Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:24:43.551637Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","timestamp":"2023-09-06T20:24:43.562Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:24:43.562056Z 0 [System] [MY-010931] [Server] %%resourcesPath%%/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: 10004 MySQL Community Server - GPL.","timestamp":"2023-09-06T20:24:43.563Z"}
{"thread":"main","class":"ImporterGeneric","stack":"Error: ERROR 1146 (42S02) at line 1: Table 'local.wp_52_users' doesn't exist\n at %%appPath%%/main/_helpers/importSQLFile.js:1:2560\n at Generator.next (<anonymous>)\n at a (%%appPath%%/main/_helpers/importSQLFile.js:1:742)","level":"error","message":"Unable to import /Users/michaelboldin/Local Sites/traccking-tenth-amendment-center/app/sql/database.sql","timestamp":"2023-09-06T20:24:52.943Z"}
{"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:9812)\n at Generator.throw (<anonymous>)\n at o (%%appPath%%/main/importer/Importer.js:1:793)","level":"warn","message":"Unable to import site.","timestamp":"2023-09-06T20:24:52.947Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:25:38.311723Z 0 [System] [MY-010116] [Server] %%resourcesPath%%/lightning-services/mysql-8.0.16+6/bin/darwin/bin/mysqld (mysqld 8.0.16) starting as process 55281","timestamp":"2023-09-06T20:25:38.533Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:25:38.312805Z 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.","timestamp":"2023-09-06T20:25:38.534Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:25:38.313371Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for %%site.runData%%/mysql/data/ is case insensitive","timestamp":"2023-09-06T20:25:38.534Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:25:38.522476Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","timestamp":"2023-09-06T20:25:38.534Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:25:38.533502Z 0 [System] [MY-010931] [Server] %%resourcesPath%%/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: 10003 MySQL Community Server - GPL.","timestamp":"2023-09-06T20:25:38.534Z"}
{"thread":"main","class":"ImporterGeneric","stack":"Error: ERROR 1146 (42S02) at line 1: Table 'local.wp_52_users' doesn't exist\n at %%appPath%%/main/_helpers/importSQLFile.js:1:2560\n at Generator.next (<anonymous>)\n at a (%%appPath%%/main/_helpers/importSQLFile.js:1:742)","level":"error","message":"Unable to import /Users/michaelboldin/Local Sites/tenth-amendment-center/app/sql/database.sql","timestamp":"2023-09-06T20:25:46.142Z"}
{"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:9812)\n at Generator.throw (<anonymous>)\n at o (%%appPath%%/main/importer/Importer.js:1:793)","level":"warn","message":"Unable to import site.","timestamp":"2023-09-06T20:25:46.147Z"}
{"thread":"main","class":"HostsFileService","error":{},"stdout":{},"stderr":{},"exitCode":{},"level":"error","message":"Could not update hosts.","timestamp":"2023-09-06T20:27:30.391Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:29:49.191753Z 0 [System] [MY-010116] [Server] %%resourcesPath%%/lightning-services/mysql-8.0.16+6/bin/darwin/bin/mysqld (mysqld 8.0.16) starting as process 55751","timestamp":"2023-09-06T20:29:49.406Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:29:49.192793Z 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.","timestamp":"2023-09-06T20:29:49.406Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:29:49.193410Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for %%site.runData%%/mysql/data/ is case insensitive","timestamp":"2023-09-06T20:29:49.406Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:29:49.394407Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","timestamp":"2023-09-06T20:29:49.406Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:29:49.406012Z 0 [System] [MY-010931] [Server] %%resourcesPath%%/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: 10004 MySQL Community Server - GPL.","timestamp":"2023-09-06T20:29:49.407Z"}
{"thread":"main","class":"ImporterGeneric","stack":"Error: ERROR 1146 (42S02) at line 1: Table 'local.wp_52_users' doesn't exist\n at %%appPath%%/main/_helpers/importSQLFile.js:1:2560\n at Generator.next (<anonymous>)\n at a (%%appPath%%/main/_helpers/importSQLFile.js:1:742)","level":"error","message":"Unable to import /Users/michaelboldin/Local Sites/tracking/app/sql/database.sql","timestamp":"2023-09-06T20:29:58.141Z"}
{"thread":"main","class":"ImporterGeneric","code":1,"killed":false,"signal":null,"cmd":"%%resourcesPath%%/lightning-services/mysql-8.0.16+6/bin/darwin/bin/mysql local -B --disable-column-names -e SELECT option_value FROM options WHERE option_name = 'siteurl';","level":"error","stack":"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 options WHERE option_name = 'siteurl';\nERROR 1146 (42S02) at line 1: Table 'local.options' doesn't exist\n\n at ChildProcess.exithandler (node:child_process:407:12)\n at ChildProcess.emit (node:events:527:28)\n at ChildProcess.emit (node:domain:475:12)\n at maybeClose (node:internal/child_process:1092:16)\n at Socket.<anonymous> (node:internal/child_process:451:11)\n at Socket.emit (node:events:527:28)\n at Socket.emit (node:domain:475:12)\n at Pipe.<anonymous> (node:net:709:12)","message":"Command failed: %%resourcesPath%%/lightning-services/mysql-8.0.16+6/bin/darwin/bin/mysql local -B --disable-column-names -e SELECT option_value FROM options WHERE option_name = 'siteurl';\nERROR 1146 (42S02) at line 1: Table 'local.options' doesn't exist\n","timestamp":"2023-09-06T20:29:58.894Z"}
{"stack":"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 options WHERE option_name = 'siteurl';\nERROR 1146 (42S02) at line 1: Table 'local.options' doesn't exist\n\n at ChildProcess.exithandler (node:child_process:407:12)\n at ChildProcess.emit (node:events:527:28)\n at ChildProcess.emit (node:domain:475:12)\n at maybeClose (node:internal/child_process:1092:16)\n at Socket.<anonymous> (node:internal/child_process:451:11)\n at Socket.emit (node:events:527:28)\n at Socket.emit (node:domain:475:12)\n at Pipe.<anonymous> (node:net:709:12)","level":"warn","message":"Unable to import site.","timestamp":"2023-09-06T20:29:58.898Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:30:57.741099Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).","timestamp":"2023-09-06T20:30:57.742Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:30:57.741385Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled","timestamp":"2023-09-06T20:30:57.742Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:30:57.741416Z 0 [Note] %%userDataPath%%/lightning-services/mysql-5.7.28+4/bin/darwin/bin/mysqld (mysqld 5.7.28) starting as process 56027 ...","timestamp":"2023-09-06T20:30:57.742Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:30:57.741440Z 0 [ERROR] Can't find error-message file '/usr/local/mysql/share/errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.","timestamp":"2023-09-06T20:30:57.743Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:30:57.742015Z 0 [Warning] Setting lower_case_table_names=2 because file system for %%site.runData%%/mysql/data/ is case insensitive","timestamp":"2023-09-06T20:30:57.743Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:30:57.742890Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins","timestamp":"2023-09-06T20:30:57.743Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:30:57.742900Z 0 [Note] InnoDB: Uses event mutexes","timestamp":"2023-09-06T20:30:57.743Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:30:57.742903Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier","timestamp":"2023-09-06T20:30:57.743Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:30:57.742906Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11","timestamp":"2023-09-06T20:30:57.743Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:30:57.744236Z 0 [Note] InnoDB: Number of pools: 1","timestamp":"2023-09-06T20:30:57.744Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:30:57.744320Z 0 [Note] InnoDB: Using CPU crc32 instructions","timestamp":"2023-09-06T20:30:57.744Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:30:57.745270Z 0 [Note] InnoDB: Initializing buffer pool, total size = 32M, instances = 1, chunk size = 32M","timestamp":"2023-09-06T20:30:57.745Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:30:57.747432Z 0 [Note] InnoDB: Completed initialization of buffer pool","timestamp":"2023-09-06T20:30:57.747Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:30:57.762002Z 0 [Note] InnoDB: Highest supported file format is Barracuda.","timestamp":"2023-09-06T20:30:57.762Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:30:57.775794Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables","timestamp":"2023-09-06T20:30:57.776Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:30:57.775892Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...","timestamp":"2023-09-06T20:30:57.776Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:30:57.778802Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.","timestamp":"2023-09-06T20:30:57.779Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:30:57.779255Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.","timestamp":"2023-09-06T20:30:57.779Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:30:57.779261Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.","timestamp":"2023-09-06T20:30:57.779Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:30:57.779543Z 0 [Note] InnoDB: Waiting for purge to start","timestamp":"2023-09-06T20:30:57.779Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:30:57.834640Z 0 [Note] InnoDB: 5.7.28 started; log sequence number 2628227","timestamp":"2023-09-06T20:30:57.834Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:30:57.834825Z 0 [Note] InnoDB: Loading buffer pool(s) from %%site.runData%%/mysql/data/ib_buffer_pool","timestamp":"2023-09-06T20:30:57.835Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:30:57.834943Z 0 [Note] Plugin 'FEDERATED' is disabled.","timestamp":"2023-09-06T20:30:57.835Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:30:57.836295Z 0 [Note] InnoDB: Buffer pool(s) load completed at 230906 13:30:57","timestamp":"2023-09-06T20:30:57.836Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:30:57.839779Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.","timestamp":"2023-09-06T20:30:57.840Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:30:57.839795Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.","timestamp":"2023-09-06T20:30:57.840Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:30:57.840752Z 0 [Warning] CA certificate ca.pem is self signed.","timestamp":"2023-09-06T20:30:57.840Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:30:57.840813Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.","timestamp":"2023-09-06T20:30:57.841Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:30:57.840894Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 10003","timestamp":"2023-09-06T20:30:57.841Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:30:57.841810Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1';","timestamp":"2023-09-06T20:30:57.841Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:30:57.841864Z 0 [Note] Server socket created on IP: '127.0.0.1'.","timestamp":"2023-09-06T20:30:57.842Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:30:57.851176Z 0 [Note] Event Scheduler: Loaded 0 events","timestamp":"2023-09-06T20:30:57.851Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:30:57.851394Z 0 [Note] ","timestamp":"2023-09-06T20:30:57.851Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:30:57.874913Z 2 [Note] ","timestamp":"2023-09-06T20:30:57.875Z"}
{"thread":"main","class":"ImporterGeneric","stack":"Error: ERROR 1146 (42S02) at line 1: Unknown error 1146\n at %%appPath%%/main/_helpers/importSQLFile.js:1:2560\n at Generator.next (<anonymous>)\n at a (%%appPath%%/main/_helpers/importSQLFile.js:1:742)","level":"error","message":"Unable to import /Users/michaelboldin/Local Sites/archive/app/sql/database.sql","timestamp":"2023-09-06T20:31:05.497Z"}
{"thread":"main","class":"ImporterGeneric","code":1,"killed":false,"signal":null,"cmd":"%%userDataPath%%/lightning-services/mysql-5.7.28+4/bin/darwin/bin/mysql local -B --disable-column-names -e SELECT option_value FROM options WHERE option_name = 'siteurl';","level":"error","stack":"Error: Command failed: %%userDataPath%%/lightning-services/mysql-5.7.28+4/bin/darwin/bin/mysql local -B --disable-column-names -e SELECT option_value FROM options WHERE option_name = 'siteurl';\nERROR 1146 (42S02) at line 1: Unknown error 1146\n\n at ChildProcess.exithandler (node:child_process:407:12)\n at ChildProcess.emit (node:events:527:28)\n at ChildProcess.emit (node:domain:475:12)\n at maybeClose (node:internal/child_process:1092:16)\n at ChildProcess._handle.onexit (node:internal/child_process:302:5)","message":"Command failed: %%userDataPath%%/lightning-services/mysql-5.7.28+4/bin/darwin/bin/mysql local -B --disable-column-names -e SELECT option_value FROM options WHERE option_name = 'siteurl';\nERROR 1146 (42S02) at line 1: Unknown error 1146\n","timestamp":"2023-09-06T20:31:06.235Z"}
{"stack":"Error: Command failed: %%userDataPath%%/lightning-services/mysql-5.7.28+4/bin/darwin/bin/mysql local -B --disable-column-names -e SELECT option_value FROM options WHERE option_name = 'siteurl';\nERROR 1146 (42S02) at line 1: Unknown error 1146\n\n at ChildProcess.exithandler (node:child_process:407:12)\n at ChildProcess.emit (node:events:527:28)\n at ChildProcess.emit (node:domain:475:12)\n at maybeClose (node:internal/child_process:1092:16)\n at ChildProcess._handle.onexit (node:internal/child_process:302:5)","level":"warn","message":"Unable to import site.","timestamp":"2023-09-06T20:31:06.240Z"}
{"thread":"main","class":"HostsFileService","error":{},"stdout":{},"stderr":{},"exitCode":{},"level":"error","message":"Could not update hosts.","timestamp":"2023-09-06T20:31:14.020Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:37:40.051484Z 0 [System] [MY-010116] [Server] %%resourcesPath%%/lightning-services/mysql-8.0.16+6/bin/darwin/bin/mysqld (mysqld 8.0.16) starting as process 57751","timestamp":"2023-09-06T20:37:40.255Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:37:40.052490Z 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.","timestamp":"2023-09-06T20:37:40.256Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:37:40.053105Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for %%site.runData%%/mysql/data/ is case insensitive","timestamp":"2023-09-06T20:37:40.256Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:37:40.242965Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","timestamp":"2023-09-06T20:37:40.256Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:37:40.255748Z 0 [System] [MY-010931] [Server] %%resourcesPath%%/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: 10004 MySQL Community Server - GPL.","timestamp":"2023-09-06T20:37:40.256Z"}
{"thread":"main","class":"ImporterGeneric","stack":"Error: ERROR 1146 (42S02) at line 1: Table 'local.wp_52_users' doesn't exist\n at %%appPath%%/main/_helpers/importSQLFile.js:1:2560\n at Generator.next (<anonymous>)\n at a (%%appPath%%/main/_helpers/importSQLFile.js:1:742)","level":"error","message":"Unable to import /Users/michaelboldin/Local Sites/tenth-amendment-center/app/sql/database.sql","timestamp":"2023-09-06T20:37:41.600Z"}
{"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:9812)\n at Generator.throw (<anonymous>)\n at o (%%appPath%%/main/importer/Importer.js:1:793)","level":"warn","message":"Unable to import site.","timestamp":"2023-09-06T20:37:41.610Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:38:43.641295Z 0 [System] [MY-010116] [Server] %%resourcesPath%%/lightning-services/mysql-8.0.16+6/bin/darwin/bin/mysqld (mysqld 8.0.16) starting as process 57902","timestamp":"2023-09-06T20:38:43.841Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:38:43.642237Z 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.","timestamp":"2023-09-06T20:38:43.842Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:38:43.642798Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for %%site.runData%%/mysql/data/ is case insensitive","timestamp":"2023-09-06T20:38:43.842Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:38:43.827285Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","timestamp":"2023-09-06T20:38:43.842Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-09-06T20:38:43.841555Z 0 [System] [MY-010931] [Server] %%resourcesPath%%/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: 10004 MySQL Community Server - GPL.","timestamp":"2023-09-06T20:38:43.842Z"}
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.
