Buggy thing. May 15, 2007 10:09 PM   Subscribe

Bug: "Favorited by others" pages may have an issue sometimes when you try to go to the next page of favorited comments. I'm not sure what causes it, but for example: mine no worky, but mathowie's does.
posted by twiggy to Bugs at 10:09 PM (14 comments total)

Matt is counting pages as (total number of favorites/comments he shows per page). Comments per page is as constant, 30, so number of pages is calculated as (total number of favorites/30).

But a comment can be favorited by more than one user; when that happend the comemnt is still shown only once.

Here's an example. say only onew comment you made was favorited, but it was favorited by 300 people.

Then Matt would calculate total pages as (300/30) = 10, but there's only be one comment (and thus one page) to show. So pages 2 through 10 would show up blank, just like your page 2.

Matt can fix this easily, by adding count distinct (and, depending on his DDL, a join) to his SQL.
posted by orthogonality at 10:25 PM on May 15, 2007


I'm about to replace that savedfavorites page with a new one tomorrow.
posted by mathowie (staff) at 10:34 PM on May 15, 2007


Now that's solved, can anyone explain to me why naturesgreatestmiracle doesn't have a 'What's the deal with your nickname?' bit showing?
posted by tellurian at 11:17 PM on May 15, 2007


Oh! forget that. I realise now that it's dropped if they don't fill out the field. I had to ask to realise though.
posted by tellurian at 11:19 PM on May 15, 2007


I just want to point out how disappointed I was with Spider-Man 3. garbage. not quite, but almost total garbage.
posted by shmegegge at 12:28 AM on May 16, 2007


On this topic, both of the "favourited by your contacts" pages (usercontacts and friendsfavorites) seem to only include a tiny fraction of what they should, at least for me.
posted by cillit bang at 1:08 AM on May 16, 2007


And I'm not getting favorited nearly as often as I think I ought.
posted by yeti at 5:28 AM on May 16, 2007


please stop derailing the thread. we're talking about how terrible spider-man 3 was.
posted by shmegegge at 9:39 AM on May 16, 2007


Sorry smegegge, I already covered that next-door.
posted by Partial Law at 10:34 AM on May 16, 2007


Also, my 'h' key doesn't work, let's say.
posted by Partial Law at 10:34 AM on May 16, 2007


Surely you mean your " key.
posted by cortex (staff) at 2:44 PM on May 16, 2007


Crap, you saw through my ruse. Well, I guess that's why you get the big bucks gift cards.
posted by Partial Law at 4:47 PM on May 16, 2007


Man, I need to photoshop myself with a giant novelty Best Buy card or something.
posted by cortex (staff) at 5:05 PM on May 16, 2007


you guys are cute, but I think you're forgetting something. we're talking about how bad Spider-Man 3 was. stop derailing the thread.
posted by shmegegge at 9:59 PM on May 16, 2007


« Older Unban ParisParamus   |   Because some people won't put [more inside] Newer »

You are not logged in, either login or create an account to post comments