as can be seen in the image, in our forums there are some tags that are exactly the same! [image] when creating a topic, you will see different number of topics in these tags: [image] but if you choose one, both will be chosen. but then as you click on the tags, both direct you to the same pag…

I had a similar problem that was due to an index being corrupt. I don’t know if this will help Can't restore due to corrupt indexes (with some clues on how to deal with corrupt indexes)

@neil any ideas here, is this a side effect of synonyms?

Unlikely, we’ve seen a lot of corrupt indexes and bad third party plugins cause this.

Sounds the same as this topic: [image] 'Tag is Invalid' - likely due to an unspecified plugin Support It works fine with one tag, but with more sometimes it won’t allow users to post and gives that error message. You can edit the post afterwards with as …

[image] codinghorror: bad third party plugins this is the list of plugins we have, I guess none of them may be related to tags: [image] [image] neil: what you’ll need to do to remove the duplicate tags and fix the indexes. I already removed them by hand! or let’s say, I could remove…

It sounds like you did it from the UI, but it can’t be done that way. As Jay did, you need to update all topics that use one of the tags to use the other, like in his example: TopicTag.where(tag_id: 717).update_all(tag_id: 611)

I describe how I did it (or something similar) over at Can't restore due to corrupt indexes (with some clues on how to deal with corrupt indexes) - #14 by pfaffman . It’s far from a howto, but might help. You have to switch back and forth between the rails console and psql, which if you’re not famili…

I don’t think the index corruption is caused by a plugin. I’ve seen this kind of PSQL index corruption five times in the past few months and four of them were using Farsi language settings.

[image] RGJ: I don’t think the index corruption is caused by a plugin. I also think this is a Contribute > Bug , and the bad part is that it’s ongoing! no matter I have deleted previous duplicates, I get new ones again. if it helps I can remove the non-official plugins and check the birth of n…

There are some duplicated tags due to database corruption and I can't merge

Product Support

Pad_Pors (Pad Pors) February 1, 2020, 7:00am 8

thanks, are there any command to find the corrupted tags (those I have already changed from UI) as well as the duplicated tags? if so, may you guide me?

Topic		Replies	Views
Tags are Duplicated while editing Bug	5	1104	August 5, 2020
Internal Server Error on using some tags (ERROR: duplicate key value violates unique constraint "index_tags_on_name") Bug	19	3612	November 8, 2019
Can't restore due to corrupt indexes (with some clues on how to deal with corrupt indexes) Self-hosting	12	4998	January 6, 2020
Lost tags from old topic Product Support	2	500	June 23, 2020
Corrupt indexes in PG12, how do I fix? Self-hosting	43	12929	January 26, 2023

There are some duplicated tags due to database corruption and I can't merge

Related topics