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: [imagem] '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 you…

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

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.

[imagem] 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 duplicate…

Existem algumas tags duplicadas devido a corrupção no banco de dados e não consigo mesclar

Suporte

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

Tive um problema semelhante causado por um índice corrompido.

Não sei se isso vai ajudar Can't restore due to corrupt indexes (with some clues on how to deal with corrupt indexes)

Tópico		Respostas	Visualizações
Tags are Duplicated while editing Bug	6	955	5 de Agosto de 2020
Internal Server Error on using some tags (ERROR: duplicate key value violates unique constraint "index_tags_on_name") Bug	20	3305	12 de Novembro de 2019
Can't restore due to corrupt indexes (with some clues on how to deal with corrupt indexes) Self-hosting	13	4751	5 de Fevereiro de 2020
Lost tags from old topic Support	2	467	23 de Junho de 2020
Corrupt indexes in PG12, how do I fix? Self-hosting	44	11727	26 de Janeiro de 2023

Existem algumas tags duplicadas devido a corrupção no banco de dados e não consigo mesclar

Tópicos relacionados