« first day (320 days earlier)      last day (314 days later) » 

Downgoat
Downgoat
12:50 AM
@Mego uhh for some reason the /challenges page isn't updating despite new posts being posted
zero idea why
actually quite a few challenges are missing
I don't know which ones show and dont O_o
might have something to do with wilson score?
they are 22 undeleted posts yet only 5 show
 
 
1 hour later…
Anonymous
2:07 AM
If it was Wilson score, we'd be getting exceptions
 
Anonymous
I think hotness is messing with it - there's something funky. All questions apparently have 64 vies
 
Downgoat
Downgoat
2:29 AM
@Mego oh that's issue with old Google Analytics formats messing with new ones
 
Downgoat
Downgoat
2:42 AM
oh maybe something with my outerjoin: github.com/Axtell/Axtell/blob/master/app/controllers/…
would this exclude posts that don't have answers/
aha yup that's it
 
Anonymous
@Downgoat No, because it's a left outer join
 
Downgoat
Downgoat
that's what I would think yet as soon as I answer a question only then it suddenly shows up
 
Anonymous
That would translate into SELECT posts.*, COUNT(answers.id) FROM posts LEFT JOIN answers ON answers.post_id = posts.id WHERE posts.deleted = 0 GROUP BY posts.id ORDER BY posts.date_created DESC
 
Downgoat
Downgoat
wtf
 
Anonymous
And you can clearly see, by running that query, all 22 rows get returned
 
Anonymous
2:49 AM
I think I see the issue
 
Anonymous
 
Anonymous
If you do WHERE answers.deleted = 0, it returned only posts with answers
 
Anonymous
We weren't being specific enough
 
Downgoat
Downgoat
@Mego wouldn't we have to do .filter(Post.deleted == False) for that
 
Anonymous
@Downgoat Err yeah
 
Anonymous
2:55 AM
Seems I can't remember the diff between filter and filter_by too :P
 
Anonymous
Challenges are fixed
 
Downgoat
Downgoat
Awesome
 

« first day (320 days earlier)      last day (314 days later) »