Looks like you haven't created any sites yet

Hi,

I rebooted my Windows 8.1 laptop and now starting up Local my sites are not recognised, I get the following message displayed:
looks like you haven’t created any sites yet

I upgraded to the latest version of local but get the same message.

I’ve included the log file below.

Can anyone please advise what to do?

Steve

{"thread":"main","reason":{"code":"ETIMEDOUT","connect":true},"p":{},"level":"warn","message":"Unhandled Rejection.","timestamp":"2021-08-21T16:33:59.608Z"}
{"thread":"main","name":"DeprecationWarning","code":"DEP0066","level":"info","message":"Warning:OutgoingMessage.prototype._headers is deprecated","stack":"DeprecationWarning: OutgoingMessage.prototype._headers is deprecated\n    at reset (%%appPath%%\\node_modules\\superagent-retry\\lib\\index.js:60:29)\n    at %%appPath%%\\node_modules\\superagent-retry\\lib\\index.js:41:9\n    at Request.callback (%%appPath%%\\node_modules\\superagent\\lib\\node\\index.js:728:3)\n    at ClientRequest.<anonymous> (%%appPath%%\\node_modules\\superagent\\lib\\node\\index.js:647:10)\n    at Object.onceWrapper (events.js:422:26)\n    at ClientRequest.emit (events.js:315:20)\n    at TLSSocket.socketErrorListener (_http_client.js:469:9)\n    at TLSSocket.emit (events.js:315:20)\n    at emitErrorNT (internal/streams/destroy.js:106:8)\n    at emitErrorCloseNT (internal/streams/destroy.js:74:3)","timestamp":"2021-08-21T16:39:12.527Z"}
{"thread":"main","level":"error","stack":"TypeError: Cannot read property 'webContents' of null\n    at Updater.onDownloadProgress (%%appPath%%\\main\\updater\\Updater.js:1:7972)\n    at Request.<anonymous> (%%appPath%%\\main\\updater\\Updater.js:1:2877)\n    at Request.emit (events.js:315:20)\n    at reportState (%%appPath%%\\node_modules\\request-progress\\index.js:83:21)\n    at Timeout.call [as _onTimeout] (%%appPath%%\\node_modules\\throttleit\\index.js:28:16)\n    at listOnTimeout (internal/timers.js:554:17)\n    at processTimers (internal/timers.js:497:7)","message":"Cannot read property 'webContents' of null","timestamp":"2021-08-21T16:50:04.247Z"}
{"thread":"main","level":"error","stack":"TypeError: Cannot read property 'webContents' of null\n    at Updater.onDownloadProgress (%%appPath%%\\main\\updater\\Updater.js:1:7972)\n    at Request.<anonymous> (%%appPath%%\\main\\updater\\Updater.js:1:2877)\n    at Request.emit (events.js:315:20)\n    at reportState (%%appPath%%\\node_modules\\request-progress\\index.js:83:21)\n    at call (%%appPath%%\\node_modules\\throttleit\\index.js:28:16)\n    at Object.throttled [as reportState] (%%appPath%%\\node_modules\\throttleit\\index.js:20:26)\n    at onData (%%appPath%%\\node_modules\\request-progress\\index.js:44:36)\n    at IncomingMessage.emit (events.js:327:22)\n    at addChunk (internal/streams/readable.js:309:12)\n    at readableAddChunk (internal/streams/readable.js:284:9)","message":"Cannot read property 'webContents' of null","timestamp":"2021-08-21T16:50:04.248Z"}
{"thread":"main","class":"Updater","bytesParsed":-32792,"code":"HPE_JS_EXCEPTION","reason":"JS Exception","rawPacket":},"level":"error","stack":"Error: Parse Error: JS Exception\n    at HTTPParser.execute (<anonymous>)\n    at TLSSocket.socketOnData (_http_client.js:509:22)\n    at TLSSocket.emit (events.js:315:20)\n    at addChunk (internal/streams/readable.js:309:12)\n    at readableAddChunk (internal/streams/readable.js:284:9)\n    at TLSSocket.Readable.push (internal/streams/readable.js:223:10)\n    at TLSWrap.onStreamRead (internal/stream_base_commons.js:188:23)","message":"Parse Error: JS Exception","timestamp":"2021-08-21T16:50:06.628Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%resourcesPath%%\\lightning-services\\mailhog-1.0.0+3\\lib\\main.js","timestamp":"2021-08-21T16:50:28.681Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%resourcesPath%%\\lightning-services\\mailhog-1.0.0+3\\lib\\main.js","timestamp":"2021-08-21T16:50:28.684Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%resourcesPath%%\\lightning-services\\mariadb-10.4.10+4\\lib\\main.js","timestamp":"2021-08-21T16:50:28.685Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%resourcesPath%%\\lightning-services\\mariadb-10.4.10+4\\lib\\main.js","timestamp":"2021-08-21T16:50:28.719Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%resourcesPath%%\\lightning-services\\mysql-8.0.16+6\\lib\\main.js","timestamp":"2021-08-21T16:50:28.720Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%resourcesPath%%\\lightning-services\\mysql-8.0.16+6\\lib\\main.js","timestamp":"2021-08-21T16:50:28.755Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%resourcesPath%%\\lightning-services\\nginx-1.16.0+5\\lib\\main.js","timestamp":"2021-08-21T16:50:28.756Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%resourcesPath%%\\lightning-services\\nginx-1.16.0+5\\lib\\main.js","timestamp":"2021-08-21T16:50:28.788Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%resourcesPath%%\\lightning-services\\php-7.3.5+10\\lib\\main.js","timestamp":"2021-08-21T16:50:28.789Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%resourcesPath%%\\lightning-services\\php-7.3.5+10\\lib\\main.js","timestamp":"2021-08-21T16:50:28.822Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%appPath%%\\node_modules\\@getflywheel\\local-addon-broken-link-checker\\lib\\main.js","timestamp":"2021-08-21T16:50:28.824Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%appPath%%\\node_modules\\@getflywheel\\local-addon-broken-link-checker\\lib\\main.js","timestamp":"2021-08-21T16:50:28.825Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"productName\" specified in package.json: %%appPath%%\\node_modules\\@getflywheel\\local-browsersync\\package.json","level":"info","timestamp":"2021-08-21T16:50:28.826Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"productName\" specified in package.json: %%appPath%%\\node_modules\\@getflywheel\\local-browsersync-client\\package.json","level":"info","timestamp":"2021-08-21T16:50:28.827Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"productName\" specified in package.json: %%appPath%%\\node_modules\\@getflywheel\\local-components\\package.json","level":"info","timestamp":"2021-08-21T16:50:28.827Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"productName\" specified in package.json: %%appPath%%\\node_modules\\@getflywheel\\localcert\\package.json","level":"info","timestamp":"2021-08-21T16:50:28.830Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"productName\" specified in package.json: %%appPath%%\\node_modules\\@getflywheel\\localtunnel\\package.json","level":"info","timestamp":"2021-08-21T16:50:28.830Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"productName\" specified in package.json: %%appPath%%\\node_modules\\@getflywheel\\memoize-one-ts\\package.json","level":"info","timestamp":"2021-08-21T16:50:28.831Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"main\" or \"renderer\" specified in package.json: %%appPath%%\\node_modules\\@getflywheel\\replacestream\\package.json","level":"info","timestamp":"2021-08-21T16:50:28.832Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%resourcesPath%%\\lightning-services\\mailhog-1.0.0+3\\lib\\main.js","timestamp":"2021-08-21T20:17:18.627Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%resourcesPath%%\\lightning-services\\mailhog-1.0.0+3\\lib\\main.js","timestamp":"2021-08-21T20:17:18.630Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%resourcesPath%%\\lightning-services\\mariadb-10.4.10+4\\lib\\main.js","timestamp":"2021-08-21T20:17:18.631Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%resourcesPath%%\\lightning-services\\mariadb-10.4.10+4\\lib\\main.js","timestamp":"2021-08-21T20:17:18.663Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%resourcesPath%%\\lightning-services\\mysql-8.0.16+6\\lib\\main.js","timestamp":"2021-08-21T20:17:18.664Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%resourcesPath%%\\lightning-services\\mysql-8.0.16+6\\lib\\main.js","timestamp":"2021-08-21T20:17:18.703Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%resourcesPath%%\\lightning-services\\nginx-1.16.0+5\\lib\\main.js","timestamp":"2021-08-21T20:17:18.703Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%resourcesPath%%\\lightning-services\\nginx-1.16.0+5\\lib\\main.js","timestamp":"2021-08-21T20:17:18.735Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%resourcesPath%%\\lightning-services\\php-7.3.5+10\\lib\\main.js","timestamp":"2021-08-21T20:17:18.736Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%resourcesPath%%\\lightning-services\\php-7.3.5+10\\lib\\main.js","timestamp":"2021-08-21T20:17:18.768Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%appPath%%\\node_modules\\@getflywheel\\local-addon-broken-link-checker\\lib\\main.js","timestamp":"2021-08-21T20:17:18.769Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%appPath%%\\node_modules\\@getflywheel\\local-addon-broken-link-checker\\lib\\main.js","timestamp":"2021-08-21T20:17:18.773Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"productName\" specified in package.json: %%appPath%%\\node_modules\\@getflywheel\\local-browsersync\\package.json","level":"info","timestamp":"2021-08-21T20:17:18.774Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"productName\" specified in package.json: %%appPath%%\\node_modules\\@getflywheel\\local-browsersync-client\\package.json","level":"info","timestamp":"2021-08-21T20:17:18.775Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"productName\" specified in package.json: %%appPath%%\\node_modules\\@getflywheel\\local-components\\package.json","level":"info","timestamp":"2021-08-21T20:17:18.775Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"productName\" specified in package.json: %%appPath%%\\node_modules\\@getflywheel\\localcert\\package.json","level":"info","timestamp":"2021-08-21T20:17:18.776Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"productName\" specified in package.json: %%appPath%%\\node_modules\\@getflywheel\\localtunnel\\package.json","level":"info","timestamp":"2021-08-21T20:17:18.777Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"productName\" specified in package.json: %%appPath%%\\node_modules\\@getflywheel\\memoize-one-ts\\package.json","level":"info","timestamp":"2021-08-21T20:17:18.777Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"main\" or \"renderer\" specified in package.json: %%appPath%%\\node_modules\\@getflywheel\\replacestream\\package.json","level":"info","timestamp":"2021-08-21T20:17:18.778Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%resourcesPath%%\\lightning-services\\mailhog-1.0.0+3\\lib\\main.js","timestamp":"2021-08-21T20:28:14.086Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%resourcesPath%%\\lightning-services\\mailhog-1.0.0+3\\lib\\main.js","timestamp":"2021-08-21T20:28:14.089Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%resourcesPath%%\\lightning-services\\mariadb-10.4.10+4\\lib\\main.js","timestamp":"2021-08-21T20:28:14.090Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%resourcesPath%%\\lightning-services\\mariadb-10.4.10+4\\lib\\main.js","timestamp":"2021-08-21T20:28:14.193Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%resourcesPath%%\\lightning-services\\mysql-8.0.16+6\\lib\\main.js","timestamp":"2021-08-21T20:28:14.194Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%resourcesPath%%\\lightning-services\\mysql-8.0.16+6\\lib\\main.js","timestamp":"2021-08-21T20:28:14.228Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%resourcesPath%%\\lightning-services\\nginx-1.16.0+5\\lib\\main.js","timestamp":"2021-08-21T20:28:14.229Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%resourcesPath%%\\lightning-services\\nginx-1.16.0+5\\lib\\main.js","timestamp":"2021-08-21T20:28:14.260Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%resourcesPath%%\\lightning-services\\php-7.3.5+10\\lib\\main.js","timestamp":"2021-08-21T20:28:14.261Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%resourcesPath%%\\lightning-services\\php-7.3.5+10\\lib\\main.js","timestamp":"2021-08-21T20:28:14.293Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%appPath%%\\node_modules\\@getflywheel\\local-addon-broken-link-checker\\lib\\main.js","timestamp":"2021-08-21T20:28:14.294Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%appPath%%\\node_modules\\@getflywheel\\local-addon-broken-link-checker\\lib\\main.js","timestamp":"2021-08-21T20:28:14.295Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"productName\" specified in package.json: %%appPath%%\\node_modules\\@getflywheel\\local-browsersync\\package.json","level":"info","timestamp":"2021-08-21T20:28:14.298Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"productName\" specified in package.json: %%appPath%%\\node_modules\\@getflywheel\\local-browsersync-client\\package.json","level":"info","timestamp":"2021-08-21T20:28:14.298Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"productName\" specified in package.json: %%appPath%%\\node_modules\\@getflywheel\\local-components\\package.json","level":"info","timestamp":"2021-08-21T20:28:14.299Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"productName\" specified in package.json: %%appPath%%\\node_modules\\@getflywheel\\localcert\\package.json","level":"info","timestamp":"2021-08-21T20:28:14.300Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"productName\" specified in package.json: %%appPath%%\\node_modules\\@getflywheel\\localtunnel\\package.json","level":"info","timestamp":"2021-08-21T20:28:14.301Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"productName\" specified in package.json: %%appPath%%\\node_modules\\@getflywheel\\memoize-one-ts\\package.json","level":"info","timestamp":"2021-08-21T20:28:14.301Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"main\" or \"renderer\" specified in package.json: %%appPath%%\\node_modules\\@getflywheel\\replacestream\\package.json","level":"info","timestamp":"2021-08-21T20:28:14.302Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on:

There are a couple of errors at the beginning of the log that seem to indicate that a secure connection couldn’t be made.

Since the Local UI isn’t showing your sites, Can you try restoring the site to a new one in Local? You can use a backup of the site, or try using the files for the site by following the steps outlined in the “Restoring From Only Local Site files” section of this help doc:

If restoring the sites doesn’t work, can you give us an updated version of the Local log so we can see what’s going on?

Hi Ben,

Thank you for your reply.

I’ve successfully restored one site by creating a zip file as suggested in the link.

Can I please ask if there’s any reason this might have happened?
I did reboot my PC to apply windows updates, the only thing I can think of.
Whilst I’m relieved that the site restored, I have another 21 to do on my machine so I hope it won’t happen too often.

Thank you so much for your help once again.

Steve

Hi Ben,

Restored a 2nd site and it has the pages that it originally had when I cloned it.

All the changes I made have gone, it’s as if I just made the clone.

I wonder how that is even possible. One thing I did notice is that it was accessing a database with the original site’s name included in the name.

Weeks of effort down the drain if I can’t get it back to how it was.

Steve

Hi Ben,

Please see the log file attached.

Steve

local-lightning.log (961.8 KB)

I’ve been unable to import several of my websites. The error message I get is as follows:
"Uh-oh! Unable to import site

error: Local was unable to import the following SQL files:"

None are listed though.

Is there any way to over come this. I’ve got 22 sites installed locally and I’d like to be able to restore them.

The main question I have though, is how to prevent this happening again and how can I recover from it?

I’m looking at the Local log now and the main thing that I’m seeing is that Local looks like it was interrupted. So numerous lines that look something like:

{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2021-08-21T13:13:24.060538Z 0 [System] [MY-010229] [Server] Starting crash recovery...","timestamp":"2021-08-21T13:13:26.762Z"}

From that timestamp of August 21, I think that’s around when you wrote in.

If I were to guess as to what happened, Local and the various pieces of software were running when the system went to upgrade. Having the system restart and make changes to how it works appears to have crashed and broken those services, in particular MySQL.

To your question of how to prevent this sort of thing in the future, I think the best thing is to always stop a Local site when you’re not actively working on it. This will export the DB to a .sql file and cleanly stop the various processes. Additionally, before having the computer restart to perform upgrades, make sure to quit Local and allow it to cleanly shut down the various services.

If there are sites that especially important, you might consider exporting them so that you have a complete zip with all the data needed for the site, or create regular backups using the Cloud backups add-on

That seems to indicate that Local thinks there’s a sql file present, but when it goes to actually import the file, it is having issues doing so. If that’s the case, you might need to more closely examine the site folder and see if there are any sql files in there.

In particular, if you do find some, you can try zipping up only the sql dump and the wp-content folder.

Hi Ben,

Thank you for your reply and looking into this.

I will be much more careful in future, shutting down local sites and quitting Local as you suggest.

I assume there’s really no chance of recovering my site? There is one in particular which will take me a couple of weeks to redo.

In particular, if you do find some, you can try zipping up only the sql dump and the wp-content folder.
Not sure what you mean here exactly. Do you mean that after I get the above message that I create zip file which only contains the ‘wp-content’ directory and the .sql file. Where exactly would I find the .sql file, I don’t want to add the wrong one. Should the .sql file be at the top level or in it’s original directory. Then I would import this zip file over the top of the existing installation, is that correct? Just guessing and really not sure to be honest.

Best Regards,

Steve

I tried adding the local.sql file at the top level of a directory then adding the wp-content directory, then zipped the two up. Tried importing and entered the name of the site, got a message:
"Invalid Domain

[my site name].local is already taken by another site. Please choose a different domain."

So you must mean something else.

That’s the right idea! Basically the error you are seeing is because those files already exist in the place that Local is trying to put it.

You’ll need to either:

  • Choose a different domain so that you can work with both the old (broken) site along side the new site
  • Or delete the original, broken site from within Local and import the new site with the original domain

Hi Ben,

Thank you for your suggestions.

None of my original sites were showing up in Local.

Just to be clear I’ve tried the following:
o Renamed the site directory
o Created a zip for that directory containing the app, conf and logs directories.
o Imported the zip using the sites original name.
o Created a further zip with the wp-content directory and the local.sql file and imported that to the same name.

I’ve also tried importing files to a different name but that hasn’t worked either.

Assuming the above is correct and it correctly covers your suggestion, is there anything else I can do?

Best Regards,

Steve

Of the 22 sites I have under Local, I recovered just a few. A couple of them have the original pages. Several don’t, the pages have gone, even for sites that weren’t started when I rebooted my laptop. Checked the database (from Local) and the pages don’t exist there either. So is it possible my original databases have been overwritten when I imported to the same name?

That checklist looks right and what I would be trying on my own machine. The challenge is that if the original database wasn’t exported to a sql file, then there isn’t really a way to recover the content for the site because it existed within that database.

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