We're using RankID to display album user stats among other places, I suspect. There's some sort of rankID assignment bug with multiple boards that I haven't tracked down but which affects certain processes like displaying a user's profile. The album_getstats() method is returning nulls for usrAlbums and usrAlbumImages causing a runtime.

Attached yaf0601a.jpg is the runtime.

Attached yaf0601b.jpg is what's being returned from yaf_user_getalbumsdata.

Attached yaf0601c.jpg is the yaf_rank table showing the issue. The user's assigned rank in yaf_user is "10", the current boardID is "1." So no records are returned so the isnull(c.UsrAlbums,0) isnull(c.UsrAlbumImages,0) has no effect as @RankData table has no records.

The point is that using a single RankID value and support multiple boards seems a bit off. What I'll do is update the RankIDs to support BoardID =1 (the main forum) and monitor when changes occur.

Thanks,

Dave

Lo mate.

Bet you a beer that its when a user posts and upgrades to the next rank. The upgrade routine doesn't pass the boardID or take it into account to get the next rank; they then have a rank thats not linked to that board.

Let me know as this is gonna cause me a migraine when I finally get my multiboard installation running.

"It's a case of RTFM.. the only problem being we don't have a manual!"

When I post FP:Mek in a topic, I'm leaving my footprint there so I can track it once I get into coding/supporting. (Yes I stole this off Ederon 🙂 )

LOL! I'll start looking into this today yet. I may not have the exact sequence of events for you, but we should know when the rank change occurs. You're right, considering requiring rank-based functionality in additional boards and basing logic on boardID=1 ranks, we could be popping a lot of Excedrins.

I'll post back with anything pertinent to the cause.

Thanks for your comments,

Dave

You da man, so what you say I do. I'll add something to the tracker in the next 24 hrs. Want to look at it some more.

Thanks,

Dave

SO FORGET THE BAD RANKID ISSUE, in other words. How certain of my key user RankIDs got screwed up, I don't know, but I'm not worrying about it. Mek, we don't have to budget for Excedrins anymore.

My apologies for the noise. I do have some thoughts on the yaf_user_getalbumsdata logic which I'll post on a separate thread.

Thanks,

Dave