# Error upgrading from 3.0.1 to 3.1.0

**URL:** <https://meta.discourse.org/t/error-upgrading-from-3-0-1-to-3-1-0/259712>\
**Category:** Self-hosting\
**Created:** [March 28, 2023, 3:32pm UTC](https://meta.discourse.org/t/error-upgrading-from-3-0-1-to-3-1-0/259712 "2023-03-28T15:32:48Z")\
**Posts on this page:** 1\
**Showing post:** 14

<div class="post-metadata">

**Author:** ![Olivier\_Lambert](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/olivier_lambert/32/74807_2.png) [@Olivier\_Lambert](https://meta.discourse.org/u/Olivier_Lambert)\
**Post date:** [March 28, 2023, 4:38pm UTC](https://meta.discourse.org/t/error-upgrading-from-3-0-1-to-3-1-0/259712/14 "2023-03-28T16:38:24Z")

</div>

Alright, for anyone else reading this in the future, here’s how you do it:

```plaintext
// Enter the container
./launcher enter app

// Use the postgres user
su postgres

// Access the Database
psql discourse

// Needs to have a semi-column at the end
select * from tags where name like '%e-commerce%';

// Tip: press the Q key after a query to go back.

```

Here’s what I’m getting:

 ![image](https://global.discourse-cdn.com/meta/original/4X/3/4/4/34433427c633988547ed74b6994e9a85237b774d.png)

Looks like there are two tags with the same slug.

I’ve also checked my table for duplicates using this:

```plaintext
SELECT name, COUNT(*) 
FROM tags
GROUP BY name
HAVING COUNT(*) > 1;

```

Which returned this:

 ![image](https://global.discourse-cdn.com/meta/original/4X/a/c/2/ac2e748604e4220512dc71ce1c223d4c4697442a.png)

I’ve deleted all the duplicates and will try to rebuild.

## Update

The rebuild process worked! God damned, these udpates scare the shit out of me.

A big thank you to @pfaffman and @RGJ, your pointers were very helpful!

---

_[View the full topic](https://meta.discourse.org/t/error-upgrading-from-3-0-1-to-3-1-0/259712)._
