# Upgrade failed .offers missing

**URL:** <https://forum.ghost.org/t/upgrade-failed-offers-missing/26312>\
**Category:** Self-hosting\
**Created:** [October 16, 2021, 2:47pm UTC](https://forum.ghost.org/t/upgrade-failed-offers-missing/26312 "2021-10-16T14:47:43Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![lrossouw](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/lrossouw/32/15454_2.png) [@lrossouw](https://forum.ghost.org/u/lrossouw)\
**Post date:** [October 16, 2021, 2:47pm UTC](https://forum.ghost.org/t/upgrade-failed-offers-missing/26312/1 "2021-10-16T14:47:43Z")

</div>

My upgrade failed I think.

When I start ghost it says:

```auto
✖ 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.

```auto
✔ 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

```

---

<div class="post-metadata">

**Author:** ![lrossouw](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/lrossouw/32/15454_2.png) [@lrossouw](https://forum.ghost.org/u/lrossouw)\
**Post date:** [October 16, 2021, 3:09pm UTC](https://forum.ghost.org/t/upgrade-failed-offers-missing/26312/2 "2021-10-16T15:09:15Z")

</div>

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