| Posted by: balbes - Saturday, 24 October 2009 08:57:28 |
|---|
| 1. Column [b]DownloadAccess[/b] in view [b]vaccess[/b] missing fix [code] SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER VIEW [dbo].[yaf_vaccess] AS SELECT UserID = a.UserID, ForumID = x.ForumID, IsAdmin = max(convert(int,b.Flags & 1)), IsForumModerator = max(convert(int,b.Flags & 8)), IsModerator = (select count(1) from [dbo].[yaf_UserGroup] v,[dbo].[yaf_Group] w,[dbo].[yaf_ForumAccess] x,[dbo].[yaf_AccessMask] y where v.UserID=a.UserID and w.GroupID=v.GroupID and x.GroupID=w.GroupID and y.AccessMaskID=x.AccessMaskID and (y.Flags & 64)<>0), ReadAccess = max(x.ReadAccess), PostAccess = max(x.PostAccess), ReplyAccess = max(x.ReplyAccess), PriorityAccess = max(x.PriorityAccess), PollAccess = max(x.PollAccess), VoteAccess = max(x.VoteAccess), ModeratorAccess = max(x.ModeratorAccess), EditAccess = max(x.EditAccess), DeleteAccess = max(x.DeleteAccess), UploadAccess = max(x.UploadAccess), DownloadAccess = max(x.DownloadAccess) FROM [dbo].[yaf_vaccessfull] as x WITH(NOLOCK) INNER JOIN [dbo].[yaf_UserGroup] a WITH(NOLOCK) on a.UserID=x.UserID INNER JOIN [dbo].[yaf_Group] b WITH(NOLOCK) on b.GroupID=a.GroupID GROUP BY a.UserID,x.ForumID GO [/code] 2. Method [b]GetStringSafely[/b] (~/pages/members.ascx.cs line 71) throws exception if parameter [b]svalue[/b] == null fix [code] return svalue == null ? string.Empty : HtmlEncode(svalue.ToString()); [/code] |
| Posted by: Jaben - Saturday, 24 October 2009 14:52:34 |
|---|
| First issue: Can't seem to find this as an error in the code. The SQL I see has the DownloadAccess column. Second thing: thanks. Committed to SVN. |
| Posted by: balbes - Saturday, 24 October 2009 17:12:07 |
|---|
| View [b]vaccess[/b] already exists in YAF 1.9.1.8 I don't see [b]upgrade[/b] procedure for it in views.sql ([b]drop[/b] or anything else). |
| Posted by: balbes - Wednesday, 28 October 2009 11:15:48 |
|---|
| Issue with view [b]vaccess[/b] fixed in rev.2836 Many thanks! |