# בעיות בעדכון מ-3.0.0 ל-3.0.1

**URL:** <https://meta.discourse.org/t/problems-while-updating-from-3-0-0-to-3-0-1/253066>\
**Category:** Self-hosting\
**Created:** [27 בינואר,‏ 2023,‏ 6:25am UTC](https://meta.discourse.org/t/problems-while-updating-from-3-0-0-to-3-0-1/253066 "2023-01-27T06:25:07Z")\
**Posts on this page:** 1\
**Showing post:** 15

<div class="post-metadata">

**Author:** ![n1bff](https://avatars.discourse-cdn.com/v4/letter/n/e95f7d/32.png) [@n1bff](https://meta.discourse.org/u/n1bff)\
**Post date:** [1 בפברואר,‏ 2023,‏ 6:57pm UTC](https://meta.discourse.org/t/problems-while-updating-from-3-0-0-to-3-0-1/253066/15 "2023-02-01T18:57:53Z")

</div>

I too am bitten by this. Thanks for sharing your manual fixes, I just used that to fix ~20 of those in mind.

My forum was using lots of tags in any kind of MixEdCasE and this never was an issue until the upgrade. Seems like there is/was a bug that made duplicate entries, regardless of case.

```plaintext
  id | name | created_at         
-------+------------------------+----------------------------
   707 | ParkRide | 2019-05-21 21:36:53.213993
 18982 | ParkRide | 2020-06-05 18:43:09.409895

```

(Yes, there is difference in whitespace around those)

I am now stuck with one last duplicate and it cannot be fixed:

```plaintext
discourse=> select name from tags group by name having count(*) > 1; 
    name    
------------
 Bike--Ride
(1 row)

discourse=> UPDATE tags SET name = 'Bike--Ride_2' WHERE name = 'Bike--Ride';
ERROR: duplicate key value violates unique constraint "index_tags_on_name"
DETAIL: Key (name)=(Bike--Ride_2) already exists.
discourse=> UPDATE tags SET name = 'Bike--Ride_3' WHERE name = 'Bike--Ride';
ERROR: duplicate key value violates unique constraint "index_tags_on_name"
DETAIL: Key (name)=(Bike--Ride_3) already exists.
discourse=> UPDATE tags SET name = 'something is broken here' WHERE name = 'Bike--Ride';
ERROR: duplicate key value violates unique constraint "index_tags_on_name"
DETAIL: Key (name)=(something is broken here) already exists.

```

while upgrading fails on

```plaintext
2023-02-01 18:56:58.610 UTC [475] discourse@discourse ERROR: duplicate key value violates unique constraint "index_tags_on_name"
2023-02-01 18:56:58.610 UTC [475] discourse@discourse DETAIL: Key (name)=(Bike--Ride) already exists.

```

Any idea how to work around this?

---

_[View the full topic](https://meta.discourse.org/t/problems-while-updating-from-3-0-0-to-3-0-1/253066)._
