Error when installing 5.0

Sep 17, 2012 at 2:04 PM

Running DNN 6.2.3 and AF4.3.8.
This came up when I tried to install 5.0 today. 

Start Sql exekvering: 04.03.09.SqlDataProvider fil
Fel Exekvering av SQL resulterade i följande undantagsfel: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'URL'. Invalid column name 'URL'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.[activeforums_TP_GetPosts] @PortalId int, @Forums nvarchar(1000), @TopicsOnly bit, @RandomOrder bit, @Rows int, @IgnoreSecurity bit = 0, @Tags nvarchar(400), @FilterByUserId int = -1 AS --SET ROWCOUNT @Rows IF @RandomOrder = 1 AND @TopicsOnly = 1 BEGIN SELECT * FROM ( SELECT g.GroupName, g.ForumGroupId, M.TabId, M.ModuleId, T.ForumName, T.ForumId, T.[Subject], T.AuthorId, T.AuthorUserName, T.AuthorFirstName, T.AuthorLastName, T.AuthorDisplayName, T.DateCreated, T.Body, T.ReplyCount, T.TopicId, "ReplyId" = 0,ROW_NUMBER() OVER (ORDER BY NewID()) as RowRank, ISNULL(URL,'') as TopicURL, ISNULL(af.PrefixURL,'') as PrefixURL, ISNULL(g.PrefixURL,'') as GroupPrefixURL FROM dbo.vw_activeforums_TopicsView as T INNER JOIN dbo.activeforums_Functions_Split(@Forums,':') as F on t.ForumId = F.ID INNER JOIN dbo.TabModules as M ON T.ModuleId = M.ModuleId INNER JOIN dbo.activeforums_Forums as af ON T.ForumId = af.ForumId INNER JOIN dbo.activeforums_Groups as g on af.ForumGroupId = g.ForumGroupId WHERE @Tags = '' OR (@Tags <> '' AND T.TopicId IN ( SELECT tt.TopicId FROM dbo.activeforums_Tags as tag INNER JOIN dbo.activeforums_Topics_Tags as TT ON tag.TagId = tt.TagId WHERE tag.TagName = @Tags AND tag.Moduleid = t.ModuleId)) ) as posts WHERE RowRank <=@Rows END IF @RandomOrder = 0 AND @TopicsOnly = 1 BEGIN SELECT * FROM ( SELECT g.GroupName, g.ForumGroupId, M.TabId, M.ModuleId, T.ForumName, T.ForumId, T.[Subject], T.AuthorId, T.AuthorUserName, T.AuthorFirstName, T.AuthorLastName, T.AuthorDisplayName, T.DateCreated, T.Body, T.ReplyCount, T.TopicId, "ReplyId" = 0,ROW_NUMBER() OVER (ORDER BY T.DateCreated DESC) as RowRank, ISNULL(URL,'') as TopicURL, ISNULL(af.PrefixURL,'') as PrefixURL, ISNULL(g.PrefixURL,'') as GroupPrefixURL FROM dbo.vw_activeforums_TopicsView as T INNER JOIN dbo.activeforums_Functions_Split(@Forums,':') as F on t.ForumId = F.ID INNER JOIN dbo.TabModules as M ON T.ModuleId = M.ModuleId INNER JOIN dbo.activeforums_Forums as af ON f.ID = af.ForumId INNER JOIN dbo.activeforums_Groups as g on af.ForumGroupId = g.ForumGroupId WHERE (@FilterByUserId = -1 OR T.AuthorId = @FilterByUserId) AND (@Tags = '' OR (@Tags <> '' AND T.TopicId IN ( SELECT tt.TopicId FROM dbo.activeforums_Tags as tag INNER JOIN dbo.activeforums_Topics_Tags as TT ON tag.TagId = tt.TagId WHERE tag.TagName = @Tags AND tag.Moduleid = t.ModuleId)) ) ) as posts WHERE RowRank <=@Rows END IF @RandomOrder = 0 AND @TopicsOnly = 0 BEGIN SELECT * FROM ( SELECT g.GroupName, g.ForumGroupId, M.TabId, M.ModuleId, AF.ForumName, T.ForumId, T.Subject as [Subject], T.AuthorId as AuthorId, T.Username AS AuthorUserName, T.FirstName as AuthorFirstName, T.LastName AS AuthorLastName, T.DisplayName AS AuthorDisplayName, T.DateUpdated AS DateCreated, "ReplyCount" = 0, T.TopicId, T.ReplyId, c.Body,ROW_NUMBER() OVER (ORDER BY T.DateUpdated DESC) as RowRank, ISNULL(URL,'') as TopicURL, ISNULL(af.PrefixURL,'') as PrefixURL, ISNULL(g.PrefixURL,'') as GroupPrefixURL FROM dbo.vw_activeforums_TopicView as T INNER JOIN dbo.activeforums_Functions_Split(@Forums,':') as F on t.ForumId = F.ID INNER JOIN dbo.TabModules as M ON T.ModuleId = M.ModuleId INNER JOIN dbo.activeforums_Forums as af ON T.ForumId = af.ForumId INNER JOIN dbo.activeforums_Groups as g on af.ForumGroupId = g.ForumGroupId INNER JOIN dbo.activeforums_Content as c on c.ContentId = T.ContentId WHERE (@Tags = '' OR (@Tags <> '' AND T.TopicId IN ( SELECT tt.TopicId FROM dbo.activeforums_Tags as tag INNER JOIN dbo.activeforums_Topics_Tags as TT ON tag.TagId = tt.TagId WHERE tag.TagName = @Tags AND tag.Moduleid = AF.ModuleId)) ) ) as Posts WHERE RowRank <= @Rows END IF @RandomOrder = 1 AND @TopicsOnly = 0 BEGIN SELECT * FROM ( SELECT g.GroupName, g.ForumGroupId, M.TabId, M.ModuleId, AF.ForumName, T.ForumId, T.Subject as [Subject], T.AuthorId as AuthorId, T.Username AS AuthorUserName, T.FirstName as AuthorFirstName, T.LastName AS AuthorLastName, T.DisplayName AS AuthorDisplayName, T.DateUpdated AS DateCreated, "ReplyCount" = 0, T.TopicId, T.ReplyId, c.Body,ROW_NUMBER() OVER (ORDER BY NEWID() DESC) as RowRank, ISNULL(URL,'') as TopicURL, ISNULL(af.PrefixURL,'') as PrefixURL, ISNULL(g.PrefixURL,'') as GroupPrefixURL FROM dbo.vw_activeforums_TopicView as T INNER JOIN dbo.activeforums_Functions_Split(@Forums,':') as F on t.ForumId = F.ID INNER JOIN dbo.TabModules as M ON T.ModuleId = M.ModuleId INNER JOIN dbo.activeforums_Forums as af ON T.ForumId = af.ForumId INNER JOIN dbo.activeforums_Groups as g on af.ForumGroupId = g.ForumGroupId INNER JOIN dbo.activeforums_Content as c on c.ContentId = T.ContentId WHERE (@Tags = '' OR (@Tags <> '' AND T.TopicId IN ( SELECT tt.TopicId FROM dbo.activeforums_Tags as tag INNER JOIN dbo.activeforums_Topics_Tags as TT ON tag.TagId = tt.TagId WHERE tag.TagName = @Tags AND tag.Moduleid = AF.ModuleId)) ) ) as Posts WHERE RowRank <=@Rows END
Sep 17, 2012 at 2:05 PM

Just figured that this should probably be on the issue tracker, sorry about that.