# Can't Upgrade from v2.27 to v3.8 ER\_NO\_SUCH\_TABLE error **URL:** \ **Category:** Installation\ **Created:** [February 25, 2020, 1:39pm UTC](https://forum.ghost.org/t/cant-upgrade-from-v2-27-to-v3-8-er-no-such-table-error/12271 "2020-02-25T13:39:13Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![nspeaks](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/nspeaks/32/3014_2.png) [@nspeaks](https://forum.ghost.org/u/nspeaks)\ **Post date:** [February 25, 2020, 1:39pm UTC](https://forum.ghost.org/t/cant-upgrade-from-v2-27-to-v3-8-er-no-such-table-error/12271/1 "2020-02-25T13:39:13Z")
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//.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](http://bit.ly/2vZxJ6p) OS: Ubuntu 18.04.4 npm v6.13.4 nodejs v10.19.0 ---
**Author:** ![DavidDarnes](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/daviddarnes/32/3533_2.png) [@DavidDarnes](https://forum.ghost.org/u/DavidDarnes)\ **Post date:** [February 25, 2020, 2:05pm UTC](https://forum.ghost.org/t/cant-upgrade-from-v2-27-to-v3-8-er-no-such-table-error/12271/2 "2020-02-25T14:05:43Z")
Hey there, did you follow the upgrading steps shown here? > **[Ghost Docs](https://ghost.org/docs/update/?v=2.0)** > > Everything you need to know about working with the Ghost professional publishing platform. ---
**Author:** ![nspeaks](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/nspeaks/32/3014_2.png) [@nspeaks](https://forum.ghost.org/u/nspeaks)\ **Post date:** [February 25, 2020, 2:55pm UTC](https://forum.ghost.org/t/cant-upgrade-from-v2-27-to-v3-8-er-no-such-table-error/12271/3 "2020-02-25T14:55:42Z")
Yes. I did. I tried using the --force parameter but met with the same result. ---
**Author:** ![nspeaks](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/nspeaks/32/3014_2.png) [@nspeaks](https://forum.ghost.org/u/nspeaks)\ **Post date:** [February 27, 2020, 1:32am UTC](https://forum.ghost.org/t/cant-upgrade-from-v2-27-to-v3-8-er-no-such-table-error/12271/4 "2020-02-27T01:32:25Z")
Bumping up. What to do? ---
**Author:** ![nspeaks](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/nspeaks/32/3014_2.png) [@nspeaks](https://forum.ghost.org/u/nspeaks)\ **Post date:** [March 1, 2020, 1:18pm UTC](https://forum.ghost.org/t/cant-upgrade-from-v2-27-to-v3-8-er-no-such-table-error/12271/5 "2020-03-01T13:18:41Z")
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 ``` ---
**Author:** ![DavidDarnes](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/daviddarnes/32/3533_2.png) [@DavidDarnes](https://forum.ghost.org/u/DavidDarnes)\ **Post date:** [March 3, 2020, 9:09am UTC](https://forum.ghost.org/t/cant-upgrade-from-v2-27-to-v3-8-er-no-such-table-error/12271/6 "2020-03-03T09:09:38Z")
There appears to be a similar thread here, however it looks like we weren’t able to reproduce the bug: > > > I have a problem upgrading my blog from v2.37.0 to the new v3.0.2. I am using SQ…Lite as database backend. > > Here is the message I got: > > \`\`\` > \[2019-11-07 06:55:15\] ERROR Cannot read property '1' of null > Cannot read property '1' of null > {"config":{"transaction":true},"name":"01-remove-user-ghost-auth-columns.js"} > "Error occurred while executing the following migration: 01-remove-user-ghost-auth-columns.js" > Error ID: > 300 > \---------------------------------------- > MigrationScriptError: Cannot read property '1' of null > at MigrationScriptError.KnexMigrateError (/var/lib/ghost/versions/3.0.2/node\_modules/knex-migrator/lib/errors.js:7:26) > at new MigrationScriptError (/var/lib/ghost/versions/3.0.2/node\_modules/knex-migrator/lib/errors.js:25:26) > at /var/lib/ghost/versions/3.0.2/node\_modules/knex-migrator/lib/index.js:1053:19 > at tryCatcher (/var/lib/ghost/versions/3.0.2/node\_modules/knex-migrator/node\_modules/bluebird/js/release/util.js:16:23) > at Promise.\_settlePromiseFromHandler (/var/lib/ghost/versions/3.0.2/node\_modules/knex-migrator/node\_modules/bluebird/js/release/promise.js:547:31) > at Promise.\_settlePromise (/var/lib/ghost/versions/3.0.2/node\_modules/knex-migrator/node\_modules/bluebird/js/release/promise.js:604:18) > at Promise.\_settlePromise0 (/var/lib/ghost/versions/3.0.2/node\_modules/knex-migrator/node\_modules/bluebird/js/release/promise.js:649:10) > at Promise.\_settlePromises (/var/lib/ghost/versions/3.0.2/node\_modules/knex-migrator/node\_modules/bluebird/js/release/promise.js:725:18) > at \_drainQueueStep (/var/lib/ghost/versions/3.0.2/node\_modules/knex-migrator/node\_modules/bluebird/js/release/async.js:93:12) > at \_drainQueue (/var/lib/ghost/versions/3.0.2/node\_modules/knex-migrator/node\_modules/bluebird/js/release/async.js:86:9) > at Async.\_drainQueues (/var/lib/ghost/versions/3.0.2/node\_modules/knex-migrator/node\_modules/bluebird/js/release/async.js:102:5) > at Immediate.Async.drainQueues \[as \_onImmediate\] (/var/lib/ghost/versions/3.0.2/node\_modules/knex-migrator/node\_modules/bluebird/js/release/async.js:15:14) > at runCallback (timers.js:705:18) > at tryOnImmediate (timers.js:676:5) > at processImmediate (timers.js:658:5) > at process.topLevelDomainCallback (domain.js:126:23) > TypeError: Cannot read property '1' of null > at SQLite3\_DDL.\_doReplace (/var/lib/ghost/versions/3.0.2/node\_modules/knex-migrator/node\_modules/knex/lib/dialects/sqlite3/schema/ddl.js:103:30) > at columns.forEach.column (/var/lib/ghost/versions/3.0.2/node\_modules/knex-migrator/node\_modules/knex/lib/dialects/sqlite3/schema/ddl.js:243:25) > at Array.forEach (\) > \[2019-11-07 06:54:50\] ERROR Cannot read property '1' of null > at SQLite3\_DDL.\ (/var/lib/ghost/versions/3.0.2/node\_modules/knex-migrator/node\_modules/knex/lib/dialects/sqlite3/schema/ddl.js:241:17) > at SQLite3\_DDL.tryCatcher (/var/lib/ghost/versions/3.0.2/node\_modules/knex-migrator/node\_modules/bluebird/js/release/util.js:16:23) > Cannot read property '1' of null > at Promise.\_settlePromiseFromHandler (/var/lib/ghost/versions/3.0.2/node\_modules/knex-migrator/node\_modules/bluebird/js/release/promise.js:547:31) > at Promise.\_settlePromise (/var/lib/ghost/versions/3.0.2/node\_modules/knex-migrator/node\_modules/bluebird/js/release/promise.js:604:18) > > \`\`\` > > Can I help out with any additional information? Thanks for your support! Have a read through the comments and see if any of those point apply to your setup ---
**Author:** ![nspeaks](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/nspeaks/32/3014_2.png) [@nspeaks](https://forum.ghost.org/u/nspeaks)\ **Post date:** [March 3, 2020, 9:41am UTC](https://forum.ghost.org/t/cant-upgrade-from-v2-27-to-v3-8-er-no-such-table-error/12271/7 "2020-03-03T09:41:11Z")
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.