Upgrade failed .offers missing

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

I changed all row types to dynamic and that seemed to resolve things.