My upgrade failed I think.
When I start ghost it says:
✖ Starting Ghost: unsupervised-online
A GhostError occurred.
Message: Ghost was able to start, but errored during boot with: show columns from `offers` - ER_NO_SUCH_TABLE: Table 'unsupervised.offers' doesn't exist
Suggestion: journalctl -u ghost_unsupervised-online -n 50
Debug Information:
OS: Ubuntu, v18.04.6 LTS
Node Version: v14.17.1
Ghost Version: 4.19.0
Ghost-CLI Version: 1.17.3
Environment: production
Command: 'ghost start'
Additional log info available in: /home/louis/.ghost/logs/ghost-cli-debug-2021-10-16T14_45_15_515Z.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.
It also doesn’t want to rollback.
How can I create the relevant table? I can’t find it’s schema.
When I run ghost doctor I get this. It seems to not pickup MariaDB correctly.
✔ Checking system Node.js version - found v14.17.1
✔ Checking logged in user
✔ Ensuring user is not logged in as ghost user
✔ Checking if logged in user is directory owner
✔ Checking current folder permissions
✔ Checking system compatibility
Local MySQL install was not found or is stopped. You can ignore this if you are using a remote MySQL host.
Alternatively you could:
a) install/start MySQL locally
b) run `ghost install --db=sqlite3` to use sqlite
c) run `ghost install local` to get a development install using sqlite3.
? Continue anyway? Yes
MySQL check skipped
ℹ Checking for a MySQL installation [skipped]
+ sudo systemctl is-active ghost_unsupervised-online
+ sudo systemctl reset-failed ghost_unsupervised-online
✔ Validating config
✔ Checking folder permissions
✔ Checking file permissions
✔ Checking content folder ownership
✔ Checking memory availability
✔ Checking binary dependencies
✔ Checking free space
✔ Checking systemd unit file
✔ Checking systemd node version - found v14.17.1