Can't Upgrade from v2.27 to v3.8 ER_NO_SUCH_TABLE error

I am trying to upgrade my Ghost v2.27 install to v3.8 and I am getting the following error

You can also check theme compatibility at https://gscan.ghost.org

? Are you sure you want to proceed with migrating to Ghost 3.8.0? Yes
✔ Updating to a major version
+ sudo systemctl stop ghost_chrometips-nspeaks-com
✔ Stopping Ghost
✔ Linking latest Ghost and recording versions
+ sudo systemctl start ghost_chrometips-nspeaks-com
+ sudo systemctl stop ghost_chrometips-nspeaks-com
✖ Restarting Ghost
A GhostError occurred.

Message: show columns from `emails` - ER_NO_SUCH_TABLE: Table 'chrometips.emails' doesn't exist
Suggestion: journalctl -u ghost_chrometips-nspeaks-com -n 50

Debug Information:
    OS: Ubuntu, v18.04.4 LTS
    Node Version: v10.19.0
    Ghost Version: 3.8.0
    Ghost-CLI Version: 1.13.1
    Environment: production
    Command: 'ghost upgrade'

Additional log info available in: /home/<user>/.ghost/logs/ghost-cli-debug-2020-02-25T13_30_27_168Z.log

Contents of the Log file

Debug Information:
    OS: Ubuntu, v18.04.4 LTS
    Node Version: v10.19.0
    Ghost Version: 3.8.0
    Ghost-CLI Version: 1.13.1
    Environment: production
    Command: 'ghost upgrade'
Message: show columns from `emails` - ER_NO_SUCH_TABLE: Table 'chrometips.emails' doesn't exist
Suggestion: journalctl -u ghost_chrometips-nspeaks-com -n 50
Stack: Error: show columns from `emails` - ER_NO_SUCH_TABLE: Table 'chrometips.emails' doesn't exist
    at Server.server.close (/usr/lib/node_modules/ghost-cli/lib/utils/port-polling.js:38:28)
    at Object.onceWrapper (events.js:286:20)
    at Server.emit (events.js:198:13)
    at emitCloseNT (net.js:1619:8)
    at process._tickCallback (internal/process/next_tick.js:63:19)

Result of the journalctl command - http://bit.ly/2vZxJ6p

OS: Ubuntu 18.04.4
npm v6.13.4
nodejs v10.19.0

Hey there, did you follow the upgrading steps shown here?

Yes. I did. I tried using the --force parameter but met with the same result.

Bumping up. What to do?

Upgraded to 2.38. But upgrade to 3.0.0 is failing. Got a new error.

Message: alter table `users` drop `ghost_auth_access_token` - ER_TOO_BIG_ROWSIZE: Row size too large. The maximum row si
ze for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to c
hange some columns to TEXT or BLOBs
Help: Error occurred while executing the following migration: 01-remove-user-ghost-auth-columns.js

There appears to be a similar thread here, however it looks like we weren’t able to reproduce the bug:

Have a read through the comments and see if any of those point apply to your setup

That post is about using SQLite. I am using MariaDB. Anyway, since I had a backup of both the content directory and json file, I just uninstalled Ghost and did a fresh installation. Worked.

2 Likes