With the help of other users here I have finally been able to get a PieFed instance up and running! I am running 1.5.3 (Docker install) and I've run into one small problem...trying to manually purge deleted posts always redirects to a page indicating that an error has occurred, the post is not purged. I am not sure how I would go about debugging this, but I will certainly provide any additional information that one might need. I appreciate all the help, the best part about the fediverse for me has to be the community! ๐Ÿ‘

Edit: included screenshot of error page.

gKXfv9JHhaN7H1Y.jpg

you are viewing a single comment's thread
view the rest of the comments
[โ€“] [S] 2 points 9 months ago (1 child)

Goodness, well that's certainly easy enough to handle, I'm glad that I did the Docker install after all ๐Ÿ˜ Very impressive that a fix is on the way already as well, I will look forward to it as I've made a bunch of test posts that I've deleted on my instance and they are currently cluttering things up ๐Ÿ‘

I will keep an eye on the thread for further developments, much appreciated once again!

  • source
  • parent
  • hideshow 1 child comment
  • [โ€“] 4 points 9 months ago

    Sorry, looks like the fix will have to come out in v1.6, available in a week or so.

    In the meantime you can fix it manually by running this: (change postgres_container to your DB container)

    docker exec -i postgres_container psql -U piefed piefed <<'SQL'
    ALTER TABLE post_vote
        DROP CONSTRAINT IF EXISTS post_vote_post_id_fkey,
        ADD CONSTRAINT post_vote_post_id_fkey
            FOREIGN KEY (post_id)
            REFERENCES post(id)
            ON DELETE CASCADE;
    
    ALTER TABLE post_reply_vote
        DROP CONSTRAINT IF EXISTS post_reply_vote_post_reply_id_fkey,
        ADD CONSTRAINT post_reply_vote_post_reply_id_fkey
            FOREIGN KEY (post_reply_id)
            REFERENCES post_reply(id)
            ON DELETE CASCADE;
    SQL
    
    
  • source
  • parent