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

  • Nothing4You
    link
    fedilink
    English
    arrow-up
    1
    ·
    12 days ago

    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.

    • AtegonOPMA
      link
      fedilink
      arrow-up
      1
      ·
      edit-2
      12 days 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