PieFed help

2134 readers

2 users here now

It's seems right that we should have a local community to help us all with PieFed

Rules

Be kind! We're all learning

founded 2 years ago

MODERATORS

007@piefed.social

Unable to purge deleted posts (thebluehydrangea.org)

submitted 2 months ago* (last edited 2 months ago) by thebluehydrangea@thebluehydrangea.org to c/piefed_meta@piefed.social

9 comments fedilink hide all child comments

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.

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

[–] thebluehydrangea@thebluehydrangea.org 2 points 2 months ago (1 children)

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!

[–] rimu@piefed.social 2 points 2 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