Buggy FuseTalk API...

[halik]

Hey guys,
your webapp just hit a deadlock on FuseTalk.API.GetOnlineUsers(Int32 ForumID, DateTime PassDate) +271. I'm guessing you aquire db locks on ftdb_forumusers and ftdb_users in the opposite order someone else in the api and it just bombs out.

Full Stack Trace:
[QueryErrorException: Transaction (Process ID 97) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
select u.vchnickname,u.btombstoneavailable,u.iuserid,u.dtbirthdate,u.vchfirstname,u.vchlastname from ftdb_users u,ftdb_forumusers fu where fu.iforumid = 1 and u.iuserid = fu.iuserid and dtlastvisiteddate between '2007-06-13T12:38:52' and '2007-06-13T12:54:52']
FuseTalk.Tools.Data.Query.RunQuery() +457
FuseTalk.Tools.Data.Query.RunQuery(String Name) +15
FuseTalk.API.GetOnlineUsers(Int32 ForumID, DateTime PassDate) +271
ASP.include_common_statistics_ascx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) +734
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +2068251
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +24
System.Web.UI.Control.Render(HtmlTextWriter writer) +7
System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22
ASP.lib_default_ascx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) +1967
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +2068251
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +24
System.Web.UI.Control.Render(HtmlTextWriter writer) +7
System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +130
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +24
System.Web.UI.Page.Render(HtmlTextWriter writer) +26
System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1896