Local Community

Switching to PHP v8.0.0 from v7.4.1 breaks Local, WP-CLI db commands

Issue Summary

I spun up a brand new site with PHP 8.0.0. The site appears to be operational and the admin behaves properly but the Local UI does not: the Admin and Open Site buttons in the top right do nothing and neither does the Adminer link in the Database tab. Also, all wp db commands fail with a message similar to (below is the result of wp db check):

‘“mysqlcheck “local” --check --default-character-set=“utf8” --user=“root” --host=“localhost””’ is not recognized as an internal or external command,
operable program or batch file.

Troubleshooting Questions

  • Does this happen for all sites in Local, or just one in particular?
    This happens to any site that I switch over to PHP 8.0.0. If i switch it back to 7 everything returns to normal.

  • Are you able to create a new, plain WordPress site in Local and access it in a Browser?
    Yes, the site appears just fine.

Replication

Describe the steps that others can take to replicate this issue. If you have screenshots that can help clarify what is happening, please include them!

Install Local, create a new site with PHP8.0.0/Apache/MySQL8. Observe the issues described above.

System Details

  • Which version of Local is being used?
    6.3.1+5826

  • What Operating System (OS) and OS version is being used?
    Windows 10

  • Attach the Local Log. See this Help Doc for instructions on how to do so:

    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T19:31:44.256905Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).”,“timestamp”:“2022-03-15T19:31:44.404Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T19:31:44.257034Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled”,“timestamp”:“2022-03-15T19:31:44.404Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T19:31:44.258603Z 0 [Note] %%userDataPath%%\lightning-services\mysql-5.7.28+4\bin\win64\bin\mysqld.exe (mysqld 5.7.28) starting as process 15844 …”,“timestamp”:“2022-03-15T19:31:44.405Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T19:31:44.268998Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions”,“timestamp”:“2022-03-15T19:31:44.405Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T19:31:44.269212Z 0 [Note] InnoDB: Uses event mutexes”,“timestamp”:“2022-03-15T19:31:44.405Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T19:31:44.269366Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier”,“timestamp”:“2022-03-15T19:31:44.406Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T19:31:44.269502Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11”,“timestamp”:“2022-03-15T19:31:44.406Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T19:31:44.270172Z 0 [Note] InnoDB: Number of pools: 1”,“timestamp”:“2022-03-15T19:31:44.407Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T19:31:44.270534Z 0 [Note] InnoDB: Not using CPU crc32 instructions”,“timestamp”:“2022-03-15T19:31:44.407Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T19:31:44.273295Z 0 [Note] InnoDB: Initializing buffer pool, total size = 32M, instances = 1, chunk size = 32M”,“timestamp”:“2022-03-15T19:31:44.408Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T19:31:44.276486Z 0 [Note] InnoDB: Completed initialization of buffer pool”,“timestamp”:“2022-03-15T19:31:44.409Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T19:31:44.337407Z 0 [Note] InnoDB: Highest supported file format is Barracuda.”,“timestamp”:“2022-03-15T19:31:44.409Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T19:31:44.338832Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 13426475”,“timestamp”:“2022-03-15T19:31:44.410Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T19:31:44.339029Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 13426484”,“timestamp”:“2022-03-15T19:31:44.411Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T19:31:44.339192Z 0 [Note] InnoDB: Database was not shutdown normally!”,“timestamp”:“2022-03-15T19:31:44.411Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T19:31:44.339316Z 0 [Note] InnoDB: Starting crash recovery.”,“timestamp”:“2022-03-15T19:31:44.412Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T19:31:44.697392Z 0 [Note] InnoDB: Removed temporary tablespace data file: “ibtmp1"”,“timestamp”:“2022-03-15T19:31:44.698Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T19:31:44.697604Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables”,“timestamp”:“2022-03-15T19:31:44.699Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T19:31:44.698094Z 0 [Note] InnoDB: Setting file ‘.\ibtmp1’ size to 12 MB. Physically writing the file full; Please wait …”,“timestamp”:“2022-03-15T19:31:44.700Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T19:31:44.726292Z 0 [Note] InnoDB: File ‘.\ibtmp1’ size is now 12 MB.”,“timestamp”:“2022-03-15T19:31:44.727Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T19:31:44.732089Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.”,“timestamp”:“2022-03-15T19:31:44.733Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T19:31:44.732364Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.”,“timestamp”:“2022-03-15T19:31:44.734Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T19:31:44.732968Z 0 [Note] InnoDB: Waiting for purge to start”,“timestamp”:“2022-03-15T19:31:44.734Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T19:31:44.788084Z 0 [Note] InnoDB: 5.7.28 started; log sequence number 13426484”,“timestamp”:“2022-03-15T19:31:44.789Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T19:31:44.788992Z 0 [Note] Plugin ‘FEDERATED’ is disabled.”,“timestamp”:“2022-03-15T19:31:44.790Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T19:31:44.789459Z 0 [Note] InnoDB: Loading buffer pool(s) from %%userDataPath%%\run\yySO2aqE8\mysql\data\ib_buffer_pool”,“timestamp”:“2022-03-15T19:31:44.791Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T19:31:44.804966Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220315 15:31:44”,“timestamp”:“2022-03-15T19:31:44.806Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T19:31:44.806536Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.”,“timestamp”:“2022-03-15T19:31:44.808Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T19:31:44.806846Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.”,“timestamp”:“2022-03-15T19:31:44.809Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T19:31:44.809739Z 0 [Warning] CA certificate ca.pem is self signed.”,“timestamp”:“2022-03-15T19:31:44.811Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T19:31:44.810288Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.”,“timestamp”:“2022-03-15T19:31:44.812Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T19:31:44.811312Z 0 [Note] Server hostname (bind-address): ‘127.0.0.1’; port: 10082”,“timestamp”:“2022-03-15T19:31:44.813Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T19:31:44.811677Z 0 [Note] - ‘127.0.0.1’ resolves to ‘127.0.0.1’;”,“timestamp”:“2022-03-15T19:31:44.813Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T19:31:44.811855Z 0 [Note] Server socket created on IP: ‘127.0.0.1’.”,“timestamp”:“2022-03-15T19:31:44.814Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T19:31:44.921752Z 0 [Note] Event Scheduler: Loaded 0 events”,“timestamp”:“2022-03-15T19:31:44.923Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T19:31:44.922225Z 0 [Note] %%userDataPath%%\lightning-services\mysql-5.7.28+4\bin\win64\bin\mysqld.exe: ready for connections.”,“timestamp”:“2022-03-15T19:31:44.924Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“Version: ‘5.7.28’ socket: ‘’ port: 10082 MySQL Community Server (GPL)”,“timestamp”:“2022-03-15T19:31:44.924Z”}
    {“thread”:“main”,“reason”:{“code”:“SELF_SIGNED_CERT_IN_CHAIN”},“p”:{},“eventId”:“1c24da47628a4ce39a36524eff6e56c5”,“level”:“warn”,“message”:“Unhandled Rejection.”,“timestamp”:“2022-03-15T19:36:01.389Z”}
    {“thread”:“main”,“reason”:{“code”:“SELF_SIGNED_CERT_IN_CHAIN”},“p”:{},“eventId”:“b3fa7b518c514bb1bef3f24fc31277a5”,“level”:“warn”,“message”:“Unhandled Rejection.”,“timestamp”:“2022-03-15T19:36:21.402Z”}
    {“localVersion”:“6.3.1+5826”,“osPlatform”:“win32”,“osRelease”:“10.0.19044”,“windowsEdition”:“Microsoft Windows 10 Pro”,“linuxEdition”:null,“level”:“warn”,“message”:“Electron Event ready”,“timestamp”:“2022-03-15T19:44:59.419Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T20:04:24.887293Z 0 [System] [MY-010116] [Server] %%resourcesPath%%\lightning-services\mysql-8.0.16+6\bin\win64\bin\mysqld.exe (mysqld 8.0.16) starting as process 13600”,“timestamp”:“2022-03-15T20:04:27.079Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T20:04:24.888506Z 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”:“2022-03-15T20:04:27.080Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T20:04:27.039807Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.”,“timestamp”:“2022-03-15T20:04:27.080Z”}
    {“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2022-03-15T20:04:27.076755Z 0 [System] [MY-010931] [Server] %%resourcesPath%%\lightning-services\mysql-8.0.16+6\bin\win64\bin\mysqld.exe: ready for connections. Version: ‘8.0.16’ socket: ‘’ port: 10004 MySQL Community Server - GPL.”,“timestamp”:“2022-03-15T20:04:27.081Z”}
    {“thread”:“main”,“class”:“WordPressInstaller”,“stack”:“Error: Command failed: “%%userDataPath%%\lightning-services\php-8.0.0+2\bin\win64\php.exe” “%%resourcesPath%%\bin\wp-cli\wp-cli.phar” --path=“C:\Users\jsmith\localwp\phpeight\app\public” --require=”%%resourcesPath%%\bin\wp-cli\local-wpcli-error-reporting.php” --skip-plugins --skip-themes “plugin” “delete” “akismet” “hello”\n\n at ChildProcess.exithandler (child_process.js:317:12)\n at ChildProcess.emit (events.js:315:20)\n at ChildProcess.EventEmitter.emit (domain.js:467:12)\n at maybeClose (internal/child_process.js:1048:16)\n at Process.ChildProcess._handle.onexit (internal/child_process.js:288:5)",“level”:“error”,“message”:“Error deleting Akismet and Hello Dolly”,“timestamp”:“2022-03-15T20:05:26.849Z”}

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