|
Here is what I did in my SQL ... if you page down you will find "Description" ...
it originally was originally b.[Description], I changed it to b.Description .... I did a Drop and Create in SQL, but the error is still present.
and once again this is only happening in Sitecore, not Stand alone.
Thank you for all of your assistance.
Regards,
Paul T. Rykiel, PMP, CSM
USE [YAF_DB]
GO
/****** Object: StoredProcedure [dbo].[yaf_forum_listread] Script Date: 05/28/2013 11:53:33 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[yaf_forum_listread]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[yaf_forum_listread]
GO
USE [YAF_DB]
GO
/****** Object: StoredProcedure [dbo].[yaf_forum_listread] Script Date: 05/28/2013 11:53:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create procedure [dbo].[yaf_forum_listread](@BoardID int,@UserID int,@CategoryID int=null,@ParentID int=null, @StyledNicks bit=null, @FindLastRead bit = 0) as
begin
declare @tbl1 table
( ForumID int, ParentID int)
declare @tbl table
( ForumID int, ParentID int)
-- get parent forums list first
insert into @tbl1(ForumID,ParentID)
select
b.ForumID,
b.ParentID
from
[dbo].[yaf_Category] a with(nolock)
join [dbo].[yaf_Forum] b with(nolock) on b.CategoryID=a.CategoryID
join [dbo].[yaf_ActiveAccess] x with(nolock) on x.ForumID=b.ForumID
where
a.BoardID = @BoardID and
((b.Flags & 2)=0 or x.ReadAccess<>0) and
(@CategoryID is null or a.CategoryID=@CategoryID) and
((@ParentID is null and b.ParentID is null) or b.ParentID=@ParentID) and
x.UserID = @UserID
order by
a.SortOrder,
b.SortOrder
-- child forums
insert into @tbl(ForumID,ParentID)
select
b.ForumID,
b.ParentID
from
[dbo].[yaf_Category] a with(nolock)
join [dbo].[yaf_Forum] b with(nolock) on b.CategoryID=a.CategoryID
join [dbo].[yaf_ActiveAccess] x with(nolock) on x.ForumID=b.ForumID
where
a.BoardID = @BoardID and
((b.Flags & 2)=0 or x.ReadAccess<>0) and
(@CategoryID is null or a.CategoryID=@CategoryID) and
(b.ParentID IN (SELECT ForumID FROM @tbl1)) and
x.UserID = @UserID
order by
a.SortOrder,
b.SortOrder
insert into @tbl(ForumID,ParentID)
select * FROM @tbl1
-- more childrens can be added to display as a tree
select
a.CategoryID,
Category = a.Name,
ForumID = b.ForumID,
Forum = b.Name,
b.Description,
b.ImageUrl,
b.Styles,
b.ParentID,
b.PollGroupID,
Topics = [dbo].[yaf_forum_topics](b.ForumID),
Posts = [dbo].[yaf_forum_posts](b.ForumID),
LastPosted = t.LastPosted,
LastMessageID = t.LastMessageID,
LastMessageFlags = t.LastMessageFlags,
LastUserID = t.LastUserID,
LastUser = IsNull(t.LastUserName,(select [Name] from [dbo].[yaf_User] x with(nolock) where x.UserID=t.LastUserID)),
LastTopicID = t.TopicID,
TopicMovedID = t.TopicMovedID,
LastTopicName = t.Topic,
LastTopicStatus = t.Status,
LastTopicStyles = t.Styles,
b.Flags,
Viewing = (select count(1) from [dbo].[yaf_Active] x with(nolock) JOIN [dbo].[yaf_User] usr with(nolock) ON x.UserID = usr.UserID where x.ForumID=b.ForumID AND usr.IsActiveExcluded = 0),
b.RemoteURL,
ReadAccess = CONVERT(int,x.ReadAccess),
Style = case(@StyledNicks)
when 1 then (select top 1 usr.[UserStyle] from [dbo].[yaf_User] usr with(nolock) where usr.UserID = t.LastUserID)
else '' end,
LastForumAccess = case(@FindLastRead)
when 1 then
(SELECT top 1 LastAccessDate FROM [dbo].[yaf_ForumReadTracking] x with(nolock) WHERE x.ForumID=b.ForumID AND x.UserID = @UserID)
else '' end,
LastTopicAccess = case(@FindLastRead)
when 1 then
(SELECT top 1 LastAccessDate FROM [dbo].[yaf_TopicReadTracking] y with(nolock) WHERE y.TopicID=t.TopicID AND y.UserID = @UserID)
else '' end
from
[dbo].[yaf_Category] a with(nolock)
join [dbo].[yaf_Forum] b with(nolock) on b.CategoryID=a.CategoryID
join [dbo].[yaf_ActiveAccess] x with(nolock) on x.ForumID=b.ForumID
left outer join [dbo].[yaf_Topic] t with(nolock) ON t.TopicID = [dbo].[yaf_forum_lasttopic](b.ForumID,@UserID,b.LastTopicID,b.LastPosted)
where
(@CategoryID is null or a.CategoryID=@CategoryID) and
x.UserID = @UserID and
(b.ForumID IN (SELECT ForumID FROM @tbl) )
order by
a.SortOrder,
b.SortOrder
end
GO
|