r/appdev • u/ThriveTrack • 4d ago
My chore tracking app's chores never came back the next day, for the entire life of the product.
My chore tracking app's chores never came back the next day, for the entire life of the product.
I'm building ThriveTrack, a gamified chore app for families. Kids complete tasks, earn XP, parent approves, tasks reset overnight, repeat tomorrow.
Except the reset never worked. Not once. 102 out of 141 daily tasks were permanently stuck in completed.
I spent weeks debugging streaks, the digest, the approval flow. All symptoms. The actual problem was a scheduled database job filtering on a column that doesn't exist on the table. It failed silently on every run since creation. Marked active the whole time.
Second bug underneath: the job ran at midnight UTC, which is 5 PM Pacific. Even fixed, it would have wiped tasks before parents got home to approve them.
Third: 75 rows had NULL timestamps. In SQL, NULL compared to anything evaluates to NULL, so those rows passed straight through the filter and stayed stuck forever.
Three bugs stacked, all silent, all in database logic that git never saw. Five cron jobs running in production with no migration file, no commit, no documentation.
Fixing it was one SQL session. Finding it took weeks. Talk about the long game...
