# 2.7.0.beta2 upgrade failed with ERROR: duplicate key **URL:** \ **Category:** Self-hosting\ **Created:** [January 22, 2021, 8:25pm UTC](https://meta.discourse.org/t/2-7-0-beta2-upgrade-failed-with-error-duplicate-key/176980 "2021-01-22T20:25:45Z")\ **Posts on this page:** 1\ **Showing post:** 10
**Author:** ![Gunnar](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/gunnar/32/119647_2.png) [@Gunnar](https://meta.discourse.org/u/Gunnar)\ **Post date:** [January 23, 2021, 12:09am UTC](https://meta.discourse.org/t/2-7-0-beta2-upgrade-failed-with-error-duplicate-key/176980/10 "2021-01-23T00:09:00Z")
> [@omarfilip](#): > > You do have two Did you visit my site? 😉 I see what you mean, when I search the in the GUI, I do see two. However, when I click on both as an admin and bring up the details page, they appear to be the same user. I can’t find a single detail that’s different between the two. Basically, no matter which one of those I click, I get the data for the second one, the one with the full name entered. Since that user had never posted, and not visited in a while, I deleted the account from the GUI. Interestingly, I still have the other one, the first one on your list, without a full name. But now, if I click on that user, nothing happens. I can see a dialog trying to open, then immediately closing. Searching the database directly for username = DaveW now returns zero rows. However, if I search for `select * from users WHERE name = 'DaveW';` (name, not username,) I get 1 row returned: ``` 19732 | DaveW | 2016-11-15 12:43:02.708166 | 2016-11-15 12:43:02.708166 | DaveW | 0 | | | | t | davew | 2016-11-15 12:43:02.708166 | f | 2017-06-01 18:09:45.018058 | 1 | f | | | | | | | 0 | 0 | | f | | | | | | f | | | | | (1 row) ``` Notice how it has DaveW (same spelling) in the username field! This account is also three years older than the other one. Can I get rid of it with: `DELETE from users WHERE id = 19732;` without any ill effects? Thanks for all your help! Gunnar --- _[View the full topic](https://meta.discourse.org/t/2-7-0-beta2-upgrade-failed-with-error-duplicate-key/176980)._