Error Installing WordPress Local 7.1.0

wpfangirl · July 24, 2023, 9:00pm

What issue or error are you experiencing?

When I try to create a new site in Local 7.1.0 on Windows 10 Professional 22H2, I get the same error I got with the previous version:

The error doesn’t say precisely what’s wrong, though I suspect it’s either not finding the files it’s looking for or not able to run the commands.

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

It seems to happen whenever I try to create a website (has for the last couple of versions).

System Details

Local Version:
7.1.0
Operating System (OS) and OS version:
Windows 10 Professional 22H2

Local Logs

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

I believe this is the relevant part of the log file, which goes back a looooooong way.

{"localVersion":"7.0.2+6395","osPlatform":"win32","osRelease":"10.0.19045","osArch":"ia32","windowsEdition":"Microsoft Windows 10 Pro","linuxEdition":null,"level":"warn","message":"Electron Event ready","timestamp":"2023-07-10T23:20:57.066Z"}
{"localVersion":"7.0.2+6395","osPlatform":"win32","osRelease":"10.0.19045","osArch":"ia32","windowsEdition":"Microsoft Windows 10 Pro","linuxEdition":null,"level":"warn","message":"Electron Event ready","timestamp":"2023-07-24T20:17:15.714Z"}
{"localVersion":"7.1.0+6396","osPlatform":"win32","osRelease":"10.0.19045","osArch":"ia32","windowsEdition":"Microsoft Windows 10 Pro","linuxEdition":null,"level":"warn","message":"Electron Event ready","timestamp":"2023-07-24T20:19:58.777Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-07-24 13:32:30 0 [Note] %%resourcesPath%%\\lightning-services\\mariadb-10.4.10+4\\bin\\win32\\bin\\mysqld.exe (mysqld 10.4.10-MariaDB) starting as process 28372 ...","timestamp":"2023-07-24T20:32:30.338Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"InnoDB: using atomic writes.","timestamp":"2023-07-24T20:32:30.338Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-07-24 13:32:30 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions","timestamp":"2023-07-24T20:32:30.338Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-07-24 13:32:30 0 [Note] InnoDB: Uses event mutexes","timestamp":"2023-07-24T20:32:30.339Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-07-24 13:32:30 0 [Note] InnoDB: Compressed tables use zlib 1.2.11","timestamp":"2023-07-24T20:32:30.339Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-07-24 13:32:30 0 [Note] InnoDB: Number of pools: 1","timestamp":"2023-07-24T20:32:30.339Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-07-24 13:32:30 0 [Note] InnoDB: Using SSE2 crc32 instructions","timestamp":"2023-07-24T20:32:30.339Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-07-24 13:32:30 0 [Note] InnoDB: Initializing buffer pool, total size = 32M, instances = 1, chunk size = 32M","timestamp":"2023-07-24T20:32:30.340Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-07-24 13:32:30 0 [Note] InnoDB: Completed initialization of buffer pool","timestamp":"2023-07-24T20:32:30.340Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-07-24 13:32:30 0 [Note] InnoDB: Resizing redo log from 2*50331648 to 2*100663296 bytes; LSN=139836","timestamp":"2023-07-24T20:32:30.340Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-07-24 13:32:30 0 [Note] InnoDB: Starting to delete and rewrite log files.","timestamp":"2023-07-24T20:32:30.446Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-07-24 13:32:30 0 [Note] InnoDB: Setting log file .\\ib_logfile101 size to 100663296 bytes","timestamp":"2023-07-24T20:32:30.470Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-07-24 13:32:30 0 [Note] InnoDB: Setting log file .\\ib_logfile1 size to 100663296 bytes","timestamp":"2023-07-24T20:32:30.471Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-07-24 13:32:30 0 [Note] InnoDB: Renaming log file .\\ib_logfile101 to .\\ib_logfile0","timestamp":"2023-07-24T20:32:30.478Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-07-24 13:32:30 0 [Note] InnoDB: New log files created, LSN=139836","timestamp":"2023-07-24T20:32:30.485Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-07-24 13:32:30 0 [Note] InnoDB: 128 out of 128 rollback segments are active.","timestamp":"2023-07-24T20:32:30.488Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-07-24 13:32:30 0 [Note] InnoDB: Creating shared tablespace for temporary tables","timestamp":"2023-07-24T20:32:30.489Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-07-24 13:32:30 0 [Note] InnoDB: Setting file '.\\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...","timestamp":"2023-07-24T20:32:30.490Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-07-24 13:32:30 0 [Note] InnoDB: File '.\\ibtmp1' size is now 12 MB.","timestamp":"2023-07-24T20:32:30.490Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-07-24 13:32:30 0 [Note] InnoDB: Waiting for purge to start","timestamp":"2023-07-24T20:32:30.492Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-07-24 13:32:30 0 [Note] InnoDB: 10.4.10 started; log sequence number 139836; transaction id 21","timestamp":"2023-07-24T20:32:30.556Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-07-24 13:32:30 0 [Note] InnoDB: Loading buffer pool(s) from %%userDataPath%%\\run\\Nwe06eKRB\\mariadb\\data\\ib_buffer_pool","timestamp":"2023-07-24T20:32:30.557Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-07-24 13:32:30 0 [Note] Plugin 'FEEDBACK' is disabled.","timestamp":"2023-07-24T20:32:30.557Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-07-24 13:32:30 0 [Note] Server socket created on IP: '127.0.0.1'.","timestamp":"2023-07-24T20:32:30.562Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-07-24 13:32:30 0 [Note] InnoDB: Buffer pool(s) load completed at 230724 13:32:30","timestamp":"2023-07-24T20:32:30.565Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-07-24 13:32:30 0 [Note] Reading of all Master_info entries succeeded","timestamp":"2023-07-24T20:32:30.594Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-07-24 13:32:30 0 [Note] Added new Master_info '' to hash table","timestamp":"2023-07-24T20:32:30.594Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-07-24 13:32:30 0 [Note] %%resourcesPath%%\\lightning-services\\mariadb-10.4.10+4\\bin\\win32\\bin\\mysqld.exe: ready for connections.","timestamp":"2023-07-24T20:32:30.595Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"Version: '10.4.10-MariaDB'  socket: ''  port: 10028  mariadb.org binary distribution","timestamp":"2023-07-24T20:32:30.595Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-07-24 13:32:31 9 [Warning] Access denied for user 'root'@'localhost' (using password: NO)","timestamp":"2023-07-24T20:32:31.346Z"}
{"thread":"main","class":"Process","process":"mariadb","level":"warn","message":"2023-07-24 13:32:31 10 [Warning] Access denied for user 'root'@'localhost' (using password: NO)","timestamp":"2023-07-24T20:32:31.466Z"}
{"thread":"main","service":{},"serviceBinVersion":{},"stack":"Error: Command failed: %%resourcesPath%%\\lightning-services\\mariadb-10.4.10+4\\bin\\win32\\bin\\mysql.exe --password= -e ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';\nERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)\r\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":"error","message":"Error setting up MySQL user","timestamp":"2023-07-24T20:32:31.471Z"}
{"thread":"main","class":"WordPressInstaller","stack":"Error: Error: Command failed: \"%%resourcesPath%%\\lightning-services\\php-8.1.9+8\\bin\\win64\\php.exe\" \"%%resourcesPath%%\\bin\\wp-cli\\wp-cli.phar\" --path=\"C:\\Users\\salli\\Local Sites\\hurqalya\\app\\public\" --require=\"%%resourcesPath%%\\bin\\wp-cli\\local-wpcli-error-reporting.php\" --skip-plugins --skip-themes \"core\" \"config\" --skip-check --dbname=local --dbuser=root --dbpass=root --skip-salts\n\n    at WordPressInstaller.<anonymous> (%%appPath%%\\main\\sites\\wp\\WordPressInstaller.js:1:9735)\n    at Generator.throw (<anonymous>)\n    at o (%%appPath%%\\main\\sites\\wp\\WordPressInstaller.js:1:793)\n    at process.processTicksAndRejections (node:internal/process/task_queues:96:5)","level":"error","message":"Error installing WordPress","timestamp":"2023-07-24T20:32:50.242Z"}
{"thread":"main","reason":{},"p":{},"eventId":"87a35533f0674ae0ae80b4fc39efde3f","level":"warn","message":"Unhandled Rejection.","timestamp":"2023-07-24T20:34:22.287Z"}

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.

Nick-B · July 25, 2023, 2:25pm

Hi @wpfangirl!

Do you have any antivirus, security, or firewall applications that could be blocking Local?

More details about troubleshooting this here: Router Mode

You could also check this:

wpfangirl · July 25, 2023, 4:47pm

Hi, Nick.

First, to answer your earlier question, I was previously able to set up sites on Local. I can’t quite pinpoint when the trouble began…possibly sometime in May. I’m having a slightly different problem with my other local dev environment, Laragon, and don’t know whether it’s for the same reason.

I’m not running any AV except Windows Defender, but it’s possible that updates to that or to other aspect of Windows have changed some security settings. Local appears to be able to access the hosts file (I checked it and the new site name was there), but not to install WP and the database, particularly the database. I will look at the routing post and also check the Laragon forum. If I find the answer, I’ll post it here.

Nick-B · July 25, 2023, 4:59pm

Sounds great! Thank you for the update. Keep us posted and we’d be happy to help further!

burt · July 25, 2023, 5:30pm

@wpfangirl Have you tried creating a site using mysql instead of mariadb? I’m curious whether that might make a difference.

wpfangirl · July 25, 2023, 8:51pm

While I hadn’t tried it for this site (since the live site uses MariaDB), I had tried it for a different site and got the same error.

wpfangirl · July 26, 2023, 1:28am

I’m checking my Windows Firewall settings.

Apache HTTP is allowed for TCP and UDP
httpd.exe is allowed for TCP and UDP
Local is allowed for TCP and UDP
mysqld is allowed for TCP and UDP
nginx is allowed for TCP and UDP

Those are all inbound permissions.

I looked at the routing error doc and discovered that nothing is listening on Port 80. So far I’m totally baffled.

wpfangirl · July 26, 2023, 1:44am

After coming up dry on other things, I took a closer look at the error message. Am I right in understanding that it wasn’t able to call (or to run) the file local-error-reporting.php? I looked in the file and there’s a function there to suppress warnings because they cause failed imports. The file is definitely there.

Nick-B · July 28, 2023, 4:20pm

If you downgrade your Local version are you able to get things working again? Here are some instructions to help out:

wpfangirl · October 12, 2023, 7:50pm

Finally solved! I wanted to post the answer here for anyone it might help. It turns out to be in the Security settings for the Local install folder. You need to give full permissions to users of your computer.

Go to C:\Program Files (x86)\Local
Right click and choose “Properties”
Click the “Security” tab
Under “Group or user names,” click “Edit”
Scroll down to “Users ([computer name]\Users)”
Check “Full Control”
Click “Apply”
Click “OK”
Launch Local and create a new site.

Nick-B · October 12, 2023, 8:55pm

Thank you for coming back and sharing your fix! Happy developing

Topic		Replies	Views
Error installing WordPress on local site Support windows-10	2	508	June 30, 2023
Error Installing Wordpress. Just started happening Support	8	1324	July 29, 2021
Error install wordpress Support hosts-file , installation , lightning , windows-10	1	555	March 27, 2021
Error when trying to add a new site Support	8	1156	March 16, 2022
Error Installing Wordpress - The System cannot find the file specified Support windows-11	14	335	February 11, 2024