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: [immagine] '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 many tags as y…

[immagine] codinghorror: bad third party plugins this is the list of plugins we have, I guess none of them may be related to tags: [image] [immagine] 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 …

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)

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?

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) . 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 familiar with both might…

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.

[immagine] RGJ: I don’t think the index corruption is caused by a plugin. I also think this is a 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 new duplica…

Ci sono alcuni tag duplicati a causa di corruzione del database e non riesco a unirli

Supporto

pfaffman (Jay Pfaffman) 23 Gennaio 2020, 2:59pm 2

Ho avuto un problema simile causato da un indice corrotto.

Non so se questo possa aiutare Can't restore due to corrupt indexes (with some clues on how to deal with corrupt indexes)

Argomento		Risposte	Visualizzazioni
Tags are Duplicated while editing Bug	6	955	Agosto 5, 2020
Internal Server Error on using some tags (ERROR: duplicate key value violates unique constraint "index_tags_on_name") Bug	20	3305	Novembre 12, 2019
Can't restore due to corrupt indexes (with some clues on how to deal with corrupt indexes) Self-hosting	13	4751	Febbraio 5, 2020
Lost tags from old topic Support	2	467	Giugno 23, 2020
Corrupt indexes in PG12, how do I fix? Self-hosting	44	11727	Gennaio 26, 2023

Ci sono alcuni tag duplicati a causa di corruzione del database e non riesco a unirli

Argomenti correlati