Theres been issues with the communities table since the update and it hasnt been fixed yet since there hasnt been time to do so. Same issue that hit the person table but that one was fixed after the db maintenance we had
I havent been the one looking at the database but im assuming itll be a similar way to how the person table was fixed. Theres essentially duplicate entries for certain communities atm
are there no references to the duplicates from posts? if there are and the duplicate rows are just deleted it’ll cascade deletion and purge all those posts from the db as well
Theres been issues with the communities table since the update and it hasnt been fixed yet since there hasnt been time to do so. Same issue that hit the person table but that one was fixed after the db maintenance we had
how are you planning to fix this?
I havent been the one looking at the database but im assuming itll be a similar way to how the person table was fixed. Theres essentially duplicate entries for certain communities atm
so just dropping duplicates then?
are there no references to the duplicates from posts? if there are and the duplicate rows are just deleted it’ll cascade deletion and purge all those posts from the db as well
there are references which is why its a pain to fix and isnt just dropping duplicates
Ah ok. I saw there was issues with federation and communities getting blocked, didn’t think either of those would be it. Thanks for letting me know!