# Ghost update failed - portal\_title not in the offers table

**URL:** <https://forum.ghost.org/t/ghost-update-failed-portal-title-not-in-the-offers-table/26525>\
**Category:** Installation\
**Created:** [October 27, 2021, 7:40pm UTC](https://forum.ghost.org/t/ghost-update-failed-portal-title-not-in-the-offers-table/26525 "2021-10-27T19:40:27Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![stewartnoyce](https://avatars.discourse-cdn.com/v4/letter/s/5daacb/32.png) [@stewartnoyce](https://forum.ghost.org/u/stewartnoyce)\
**Post date:** [October 27, 2021, 7:40pm UTC](https://forum.ghost.org/t/ghost-update-failed-portal-title-not-in-the-offers-table/26525/1 "2021-10-27T19:40:27Z")

</div>

While attempting a major update from 2.38 to v4 I am blocked by the following error - “The column portal\_title is not in the offers table”.

Any thoughts on how to resolve? I would like to move to v4.

* * *

Message: Ghost was able to start, but errored during boot with: The column portal\_title is not in the offers table

Debug Information:  
OS: Ubuntu, v16.04.2 LTS  
Node Version: v14.18.1  
Ghost Version: 4.20.4  
Ghost-CLI Version: 1.17.4  
Environment: production  
Command: ‘ghost start’

— additional detail from journalctl —  
InternalServerError: The column portal\_title is not in the offers table  
at DatabaseStateManager.makeReady (/ghost/versions/4.20.4/core/server/data/db  
at async initDatabase (/ghost/versions/4.20.4/core/boot.js:62:5)  
at async bootGhost (/ghost/versions/4.20.4/core/boot.js:344:9)  
RollbackError: …  
Error: The column portal\_title is not in the offers table  
at SQLite3\_DDL.getColumn (/ghost/versions/4.20.4/node\_modules/knex-migrator/node\_modules/knex/lib/dialects/sqlite3/schema/ddl.js:48:13)  
at /ghost/versions/4.20.4/node\_modules/knex-migrator/node\_modules/knex/lib/dialects/sqlite3/schema/ddl.js:287:57  
at Array.map ()  
at client.transaction.connection (/ghost/versions/4.20.4/node\_modules/knex-migrator/node\_modules/knex/lib/dialects/sqlite3/schema/ddl.js:287:36)  
at /ghost/versions/4.20.4/node\_modules/knex-migrator/node\_modules/knex/lib/transaction.js:183:22

---

<div class="post-metadata">

**Author:** ![stewartnoyce](https://avatars.discourse-cdn.com/v4/letter/s/5daacb/32.png) [@stewartnoyce](https://forum.ghost.org/u/stewartnoyce)\
**Post date:** [October 27, 2021, 10:14pm UTC](https://forum.ghost.org/t/ghost-update-failed-portal-title-not-in-the-offers-table/26525/2 "2021-10-27T22:14:03Z")

</div>

More information - I am using sqlite3 as the database. Here are the tables. No offers in the list.

sqlite\> .open ghost.db  
sqlite\> .tables  
actions permissions\_apps  
api\_keys permissions\_roles  
app\_fields permissions\_users  
app\_settings posts  
apps posts\_authors  
brute posts\_meta  
integrations posts\_tags  
invites roles  
members roles\_users  
members\_stripe\_customers sessions  
members\_stripe\_customers\_subscriptions settings  
migrations subscribers  
migrations\_lock tags  
mobiledoc\_revisions users  
permissions  
webhooks