I’m getting a similar error when I tried updating a couple different installs up to the latest. I’m on a D.O. 1-click install. I actually two separate droplets with different ghost installs and they both are throwing the same error which seemed odd to me.
I’ll just focus on the one here, since it seems like a similar problem. If anyone has any thoughts on this?
URL: btkofilms.com
OS: Ubuntu, v20.04.3 LTS
Node Version: v12.22.6
Ghost Version: 4.20.1
Ghost-CLI Version: 1.17.3
Environment: production
The update to 4.20.1 seemed to go just find. And then I ran Ghost Start to get it up and running and everything was good up until the final:
Starting Ghost: btkofilms-com
A GhostError occurred.
Message: Ghost was able to start, but errored during boot with: alter table offers add constraint offers_product_id_foreign foreign key (product_id) references products (id) - UNKNOWN_CODE_PLEASE_REPORT: Referencing column ‘product_id’ and referenced column ‘id’ in foreign key constraint ‘offers_product_id_foreign’ are incompatible.
-- Logs begin at Thu 2021-04-01 18:12:59 UTC, end at Fri 2021-10-22 20:58:42 UTC. --
Oct 22 20:58:15 ghost-btko-films node[1796]: Error: UNKNOWN_CODE_PLEASE_REPORT: Referencing column 'product_id' >
Oct 22 20:58:15 ghost-btko-films node[1796]: at Query.Sequence._packetToError (/var/www/ghost/versions/4.20.>
Oct 22 20:58:15 ghost-btko-films node[1796]: at Query.ErrorPacket (/var/www/ghost/versions/4.20.1/node_modul>
Oct 22 20:58:15 ghost-btko-films node[1796]: at Protocol._parsePacket (/var/www/ghost/versions/4.20.1/node_m>
Oct 22 20:58:15 ghost-btko-films node[1796]: at Parser._parsePacket (/var/www/ghost/versions/4.20.1/node_mod>
Oct 22 20:58:15 ghost-btko-films node[1796]: at Parser.write (/var/www/ghost/versions/4.20.1/node_modules/my>
Oct 22 20:58:15 ghost-btko-films node[1796]: at Protocol.write (/var/www/ghost/versions/4.20.1/node_modules/>
Oct 22 20:58:15 ghost-btko-films node[1796]: at Socket.<anonymous> (/var/www/ghost/versions/4.20.1/node_modu>
Oct 22 20:58:15 ghost-btko-films node[1796]: at Socket.<anonymous> (/var/www/ghost/versions/4.20.1/node_modu>
Oct 22 20:58:15 ghost-btko-films node[1796]: at Socket.emit (events.js:314:20)
Oct 22 20:58:15 ghost-btko-films node[1796]: at addChunk (_stream_readable.js:297:12)
Oct 22 20:58:15 ghost-btko-films node[1796]: at readableAddChunk (_stream_readable.js:272:9)
Oct 22 20:58:15 ghost-btko-films node[1796]: at Socket.Readable.push (_stream_readable.js:213:10)
Oct 22 20:58:15 ghost-btko-films node[1796]: at TCP.onStreamRead (internal/stream_base_commons.js:188:23)
Oct 22 20:58:15 ghost-btko-films node[1796]: --------------------
Oct 22 20:58:15 ghost-btko-films node[1796]: at Protocol._enqueue (/var/www/ghost/versions/4.20.1/node_modul>
Oct 22 20:58:15 ghost-btko-films node[1796]: at Connection.query (/var/www/ghost/versions/4.20.1/node_module>
Oct 22 20:58:15 ghost-btko-films node[1796]: at /var/www/ghost/versions/4.20.1/node_modules/knex-migrator/no>
Oct 22 20:58:15 ghost-btko-films node[1796]: at new Promise (<anonymous>)
Oct 22 20:58:15 ghost-btko-films node[1796]: at Client_MySQL._query (/var/www/ghost/versions/4.20.1/node_mod>
Oct 22 20:58:15 ghost-btko-films node[1796]: at Client_MySQL.query (/var/www/ghost/versions/4.20.1/node_modu>
Oct 22 20:58:15 ghost-btko-films node[1796]: at Runner.query (/var/www/ghost/versions/4.20.1/node_modules/kn>
Oct 22 20:58:15 ghost-btko-films node[1796]: at Runner.queryArray (/var/www/ghost/versions/4.20.1/node_modul>
Oct 22 20:58:15 ghost-btko-films node[1796]: at processTicksAndRejections (internal/process/task_queues.js:9>
Oct 22 20:58:15 ghost-btko-films node[1796]: at async /var/www/ghost/versions/4.20.1/node_modules/knex-migra>
Oct 22 20:58:15 ghost-btko-films node[1796]: at async Object.up [as down] (/var/www/ghost/versions/4.20.1/co>
Oct 22 20:58:15 ghost-btko-films node[1796]:
Oct 22 20:58:15 ghost-btko-films node[1796]: [2021-10-22 20:58:15] WARN Ghost is shutting down
Oct 22 20:58:15 ghost-btko-films node[1796]: [2021-10-22 20:58:15] WARN Ghost has shut down
Oct 22 20:58:15 ghost-btko-films node[1796]: [2021-10-22 20:58:15] WARN Your site is now offline
Oct 22 20:58:15 ghost-btko-films node[1796]: [2021-10-22 20:58:15] WARN Ghost was running for a few seconds
Oct 22 20:58:15 ghost-btko-films node[1796]: [2021-10-22 20:58:15] INFO Bootstrap client was closed.
Oct 22 20:58:15 ghost-btko-films node[1796]: [2021-10-22 20:58:15] WARN Ghost is shutting down
Oct 22 20:58:15 ghost-btko-films node[1796]: [2021-10-22 20:58:15] WARN Ghost has shut down
Oct 22 20:58:15 ghost-btko-films systemd[1]: Stopping Ghost systemd service for blog: btkofilms-com...
Oct 22 20:58:15 ghost-btko-films node[1796]: [2021-10-22 20:58:15] WARN Your site is now offline
Oct 22 20:58:15 ghost-btko-films node[1796]: [2021-10-22 20:58:15] WARN Ghost was running for a few seconds
Oct 22 20:58:15 ghost-btko-films node[1796]: [2021-10-22 20:58:15] WARN Ghost is shutting down
Oct 22 20:58:15 ghost-btko-films node[1796]: [2021-10-22 20:58:15] WARN Ghost has shut down
Oct 22 20:58:15 ghost-btko-films node[1796]: [2021-10-22 20:58:15] WARN Your site is now offline
Oct 22 20:58:15 ghost-btko-films node[1796]: [2021-10-22 20:58:15] WARN Ghost was running for a few seconds
Oct 22 20:58:16 ghost-btko-films node[1758]: /usr/lib/node_modules/ghost-cli/lib/process-manager.js:46
Oct 22 20:58:16 ghost-btko-films node[1758]: throw error;