Programming.dev Meta

2507 readers

1 users here now

Welcome to the Programming.Dev meta community!

This is a community for discussing things about programming.dev itself. Things like announcements, site help posts, site questions, etc. are all welcome here.

Credits

Icon base by Lorc under CC BY 3.0 with modifications to add a gradient

founded 2 years ago

MODERATORS

snowe

Ategon

The site may be down within the period of 1-3am ET for maintenance (self.meta)

submitted 2 weeks ago by Ategon to c/meta

4 comments fedilink hide all child comments

Doing another round of maintenance to fix some issues related to posts

It might only be down for a bit within that window but im giving myself two hours in case some things take longer than I expect

you are viewing a single comment's thread
view the rest of the comments

[–] Nothing4You 1 points 1 week ago (1 children)

Then I generated sql statements to remove duplicate posts that had higher ids than the other posts theyre a duplicate of

i assume this was done after updating the other tables referencing this table, such as comments, votes, saved posts, as previously discussed on matrix?

while it may be omitted here for simplicity, it can be dangerous to not mention that for others that might find this in the future if they experience index corruptions on their own if they don't fix all references, as that would result in data loss.

[–] Ategon 1 points 1 week ago* (last edited 1 week ago)

No votes or comments were connected to the duplicates but yeah if there was some you would move it over to the other one

The posts that had comments were the posts that were uniquely on the other community and those moved over with the post when I updated the community of the post

Programming.dev Meta

Links

Credits