# \[Site Down :(\] Upgrade\\Rebuild Failure - DB Migration Issue?

**URL:** <https://meta.discourse.org/t/site-down-upgrade-rebuild-failure-db-migration-issue/268359>\
**Category:** Self-hosting\
**Created:** [June 14, 2023, 8:49pm UTC](https://meta.discourse.org/t/site-down-upgrade-rebuild-failure-db-migration-issue/268359 "2023-06-14T20:49:04Z")\
**Posts on this page:** 1\
**Showing post:** 9

<div class="post-metadata">

**Author:** ![SouperC](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/souperc/32/62875_2.png) [@SouperC](https://meta.discourse.org/u/SouperC)\
**Post date:** [June 19, 2023, 12:57pm UTC](https://meta.discourse.org/t/site-down-upgrade-rebuild-failure-db-migration-issue/268359/9 "2023-06-19T12:57:51Z")

</div>

Update (Was in drafts for a few days, sorry) Looks like I got it figured out. Not sure if it what I did was the right approach, but it rebuilt successfully.

Found it hard to modify\append the racerx value in the username\_lower column using the syntax so I went about it another way. by looking up the IDs for the rows and modifiying the username\_lower value in a specific row.

First I tried to get a report of any rows in the users table that had “racerx” in the username\_lower column.

`select all from users where username_lower ='racerx';`

From this I decided I’d modify racerx to racerx2, I can’t remember exactly what I typed to make that happen. I _think_ it was UPDATE SET from users username\_lower racerx to racerx2

---

_[View the full topic](https://meta.discourse.org/t/site-down-upgrade-rebuild-failure-db-migration-issue/268359)._