Cannot start a new install of Ghost

Developer help
1

Hello, I’m running a brand new local test version of ghost ona fedora linux VM following the official instructions. I added a few posts, changed a couple design options in the settings and messed a bit with payments, connecting a Stripe account. Then I shut down ghost, restarted, and now cannot start ghost again.

error i’m getting when running “ghost start” : Cannot read properties of undefined (reading ‘members’)
when running “ghost run”: ERROR connect ECONNREFUSED 127.0.0.1:3306

Any help appreciated :) Don’t want to lose my work so far. more details below:

Ghost-CLI version: 1.24.0
Ghost version: 5.49.3 (at ~/Documents/GhostCMS)
node v18.16.0

when I start ghost via “ghost start” I get this output:


Running in development mode

✔ Checking system Node.js version - found v18.16.0
ℹ Ensuring user is not logged in as ghost user [skipped]
ℹ Checking if logged in user is directory owner [skipped]
✔ Checking current folder permissions
✔ Validating config
✔ Checking memory availability
✔ Checking binary dependencies
✖ Starting Ghost: ghost-local
A GhostError occurred.

Message: Ghost was able to start, but errored during boot with: Cannot read properties of undefined (reading 'members')

Debug Information:
    OS: Fedora Linux, v38
    Node Version: v18.16.0
    Ghost Version: 5.49.3
    Ghost-CLI Version: 1.24.0
    Environment: development
    Command: 'ghost start'

Additional log info available in: /home/vblanton/.ghost/logs/ghost-cli-debug-2023-06-04T21_24_40_994Z.log

Try running ghost doctor to check your system for known issues.

You can always refer to https://ghost.org/docs/ghost-cli/ for troubleshooting.

the additional log info:

Debug Information:
    OS: Fedora Linux, v38
    Node Version: v18.16.0
    Ghost Version: 5.49.3
    Ghost-CLI Version: 1.24.0
    Environment: development
    Command: 'ghost start'
Message: Ghost was able to start, but errored during boot with: Cannot read properties of undefined (reading 'members')
Stack: Error: Ghost was able to start, but errored during boot with: Cannot read properties of undefined (reading 'members')
    at ChildProcess.<anonymous> (/usr/local/lib/node_modules/ghost-cli/lib/utils/local-process.js:75:35)
    at ChildProcess.emit (node:events:513:28)
    at emit (node:internal/child_process:937:14)
    at process.processTicksAndRejections (node:internal/process/task_queues:83:21)

ghost run:

ERROR connect ECONNREFUSED 127.0.0.1:3306

connect ECONNREFUSED 127.0.0.1:3306

"Unknown database error"

Error ID:
    500

Error Code: 
    ECONNREFUSED

----------------------------------------

Error: connect ECONNREFUSED 127.0.0.1:3306
    at /home/vblanton/Documents/GhostCMS/versions/5.49.3/node_modules/knex-migrator/lib/database.js:57:19
    at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1494:16)
  • What steps could someone else take to reproduce the issue you’re having?
    npm, “ghost install local”, add a few articles and connect a stripe account. disable free memberships.

Thanks again :pray:

2

Is MySQL running? That’s an error connecting to MySQL of some sort.

3

I think I may have figure it out. It’s just a guess, but i’m thinking that I wasn’t supposed to mess with Stripe integration in a local install ( “ghost install local” ).

the local install uses sqlite.

That’s my only guess. If that was the case it would’ve been nice to be informed or locked out of that :slight_smile:

4

Ghost local did not support members data when you integrate Stripe. You need to empty table members on sqlite to avoid error, then start ghost again.

5

I’m going to assume this is the solution. I accidentally deleted my database and had to start from scratch regardless. I’ll avoid using ghost local for anything other than theme development now.

6

How do I empty table members on sqlite?

7

Try use this: https://sqlitebrowser.org/

8

I got the same error in MySQL after running ghost install and not ghost install local.