# Ghost migration error from 3.x to 5.x **URL:** \ **Category:** Bugs\ **Created:** [November 22, 2022, 4:44am UTC](https://forum.ghost.org/t/ghost-migration-error-from-3-x-to-5-x/34326 "2022-11-22T04:44:40Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![aaronhe](https://avatars.discourse-cdn.com/v4/letter/a/7993a0/32.png) [@aaronhe](https://forum.ghost.org/u/aaronhe)\ **Post date:** [November 22, 2022, 4:44am UTC](https://forum.ghost.org/t/ghost-migration-error-from-3-x-to-5-x/34326/1 "2022-11-22T04:44:40Z")
**Issue Summary** - I’m upgrading a ghost instance from 3.x to the latest. From the guide, it looks like the best way is to backup the content and reinstall ghost, but then ran into this during the last step of the installation. And now I can consistently reproduce this by running `ghost start` **Steps to Reproduce** `ghost start` * * * ## Setup information **Ghost Version** 5.22.4 **Node.js Version** 16.18.0 **How did you install Ghost?** Had a version of Ghost 3.x, and did the reinstallation of Ghost 5.x. **Provide details of your host & operating system** Ubuntu v18.04.6 LTS on DigitalOcean **Database type** \*MySQL 5.7 **Browser & OS version** N/A **Relevant log / error output** ```auto Debug Information: OS: Ubuntu, v18.04.6 LTS Node Version: v16.18.0 Ghost Version: 5.22.4 Ghost-CLI Version: 1.23.1 Environment: production Command: 'ghost start' Message: Ghost was able to start, but errored during boot with: Unable to run migrations Help: Run 'ghost update v3' to get the latest v3.x version, then run 'ghost update' to get to the latest. Suggestion: journalctl -u ghost_aaronhe-org -n 50 Stack: Error: Ghost was able to start, but errored during boot with: Unable to run migrations at Server. (/usr/lib/node_modules/ghost-cli/lib/utils/port-polling.js:73:28) at Object.onceWrapper (node:events:627:28) at Server.emit (node:events:513:28) at emitCloseNT (node:net:1857:8) at processTicksAndRejections (node:internal/process/task_queues:82:21) ``` ---
**Author:** ![aaronhe](https://avatars.discourse-cdn.com/v4/letter/a/7993a0/32.png) [@aaronhe](https://forum.ghost.org/u/aaronhe)\ **Post date:** [November 22, 2022, 4:45am UTC](https://forum.ghost.org/t/ghost-migration-error-from-3-x-to-5-x/34326/2 "2022-11-22T04:45:11Z")
reinstalled ghost again with a different mysql db name `ghost_prod2` and restored a backup and the site is running okay. but when I try to click on Posts/Drafts/Scheduled or Published, it always give me 404. And when I try to write a new post, there’s an internal server error: `Internal server error, cannot save post. select `posts`.*, (with `k` as (select `member_id` from `members_subscription_created_events` where posts.id = members_subscription_created_events.attribution_id union select `member_id` from `members_created_events` where posts.id = members_created_events.attribution_id) select count(*) from `k`) as `count__conversions`, `posts`.*, (select count(distinct `members_click_events`.`member_id`) from `members_click_events` inner join `redirects` on `members_click_events`.`redirect_id` = `redirects`.`id` where posts.id = redirects.post_id) as `count__clicks`, `posts`.*, (select COALESCE(ROUND(AVG(score) * 100), 0) from `members_feedback` where posts.id = members_feedback.post_id) as `count__sentiment`, `posts`.*, (select count(*) from `members_feedback` where posts.id = members_feedback.post_id AND members_feedback.score = 0) as `count__negative_feedback`, `posts`.*, (select sum(`score`) from `members_feedback` where posts.id = members_feedback.post_id) as `count__positive_feedback` from `posts` where `posts`.`id` = '6362078cfc88c120b3e8dba7' limit 1 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`k` as (select `member_id` from `members_subscription_created_events` where post' at line 1` ---
**Author:** ![aaronhe](https://avatars.discourse-cdn.com/v4/letter/a/7993a0/32.png) [@aaronhe](https://forum.ghost.org/u/aaronhe)\ **Post date:** [November 22, 2022, 4:46am UTC](https://forum.ghost.org/t/ghost-migration-error-from-3-x-to-5-x/34326/3 "2022-11-22T04:46:34Z")
I also tried `ghost update --rollback` but it tells me `Message: 'No previous version found'` ---
**Author:** ![mjw](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/mjw/32/30781_2.png) [@mjw](https://forum.ghost.org/u/mjw)\ **Post date:** [November 22, 2022, 10:05am UTC](https://forum.ghost.org/t/ghost-migration-error-from-3-x-to-5-x/34326/4 "2022-11-22T10:05:39Z")
> [@aaronhe](#): > > **Database type** > \*MySQL 5.7 You need to be running MySQL version 8 with Ghost V5. The steps to follow are: 1. Backup the original database, or export your content, and copy the contents folder, theme, routes, and redirects. 2. Install the latest versions of Ghost, MySQL, Node etc. 3. Create a new Ghost site, and import the data. Before doing this it’s a good idea to take a snapshot of the Droplet. Alternatively, create a new Droplet, setup Ghost, and migrate your data. ---
**Author:** ![aaronhe](https://avatars.discourse-cdn.com/v4/letter/a/7993a0/32.png) [@aaronhe](https://forum.ghost.org/u/aaronhe)\ **Post date:** [November 22, 2022, 11:01am UTC](https://forum.ghost.org/t/ghost-migration-error-from-3-x-to-5-x/34326/5 "2022-11-22T11:01:14Z")
Thanks! Upgraded to MySQL 8 solved this. ---
**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/ghost2/original/2X/b/ba9ce5100b8bb264586f4f572545596b2ce3f081.png) [@system](https://forum.ghost.org/u/system)\ **Post date:** [February 20, 2023, 11:02am UTC](https://forum.ghost.org/t/ghost-migration-error-from-3-x-to-5-x/34326/6 "2023-02-20T11:02:00Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.