SmilingLez
Word Arranger
- Joined
- Jul 8, 2025
- Posts
- 3,297
@Manu @Laurel
I’m posting this publicly for transparency. Too many authors are being told the problem is on their end, and it isn’t. This is a reproducible Level 1 bug in the story submission pipeline (aka Pending Purgatory), and I want it documented in the open so authors stop blaming themselves.
The reproduction path is consistent. A story is submitted and rejected. The author edits and resubmits, and the resubmission may become permanently stuck in pending. If the story is rejected again and resubmitted again, it may become stuck again.
I currently have six stories in this state. Poetry and non‑story submissions behave normally, so the issue is specific to the story submission logic.
The likely cause is a database flag that isn’t resetting on rejection. A field such as resubmit_count or status_id is retaining the wrong value, causing the resubmit action to write to a row that never triggers moderation. This explains why some first‑time submissions move through the queue while some first-time submissions and resubmissions do not.
The possible fix is straightforward from a database perspective. Query the submissions table for rows where last_action is ‘resubmit’, status is ‘pending’, and days_pending is greater than two. This isolates only the stuck resubmissions without touching anything legitimately awaiting review. Each of these entries can then be checked for content validity and manually moved into the moderation queue or reset to a clean ‘submitted’ state. After that, the resubmit handler needs to be patched so the internal moderation flag resets properly on every resubmission.
If you want, I can text you my 6 stuck stories IDs.
Thanks.
I’m posting this publicly for transparency. Too many authors are being told the problem is on their end, and it isn’t. This is a reproducible Level 1 bug in the story submission pipeline (aka Pending Purgatory), and I want it documented in the open so authors stop blaming themselves.
The reproduction path is consistent. A story is submitted and rejected. The author edits and resubmits, and the resubmission may become permanently stuck in pending. If the story is rejected again and resubmitted again, it may become stuck again.
I currently have six stories in this state. Poetry and non‑story submissions behave normally, so the issue is specific to the story submission logic.
The likely cause is a database flag that isn’t resetting on rejection. A field such as resubmit_count or status_id is retaining the wrong value, causing the resubmit action to write to a row that never triggers moderation. This explains why some first‑time submissions move through the queue while some first-time submissions and resubmissions do not.
The possible fix is straightforward from a database perspective. Query the submissions table for rows where last_action is ‘resubmit’, status is ‘pending’, and days_pending is greater than two. This isolates only the stuck resubmissions without touching anything legitimately awaiting review. Each of these entries can then be checked for content validity and manually moved into the moderation queue or reset to a clean ‘submitted’ state. After that, the resubmit handler needs to be patched so the internal moderation flag resets properly on every resubmission.
If you want, I can text you my 6 stuck stories IDs.
Thanks.
Last edited: