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

  • Rimu@piefed.socialM
    link
    fedilink
    English
    arrow-up
    4
    ·
    10 hours 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