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.
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!
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_containerto 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