Hi Scott,
I tried to upgrade the News Article module from 00.07.19 to 00.07.88 but got errors. I restored site from backup and had the folks at PowerDNN (hosting provider) try the upgrade and they got errors as well.
I'm running DNN 5.6.2
After the attempted upgrade, instead of the module content I get the following error:
Error: Articles and White Papers is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Object reference not set to an instance of an object. ---> System.NullReferenceException: Object reference not set to an instance of an object. at Ventrian.NewsArticles.Controls.Listing.BindListing() at Ventrian.NewsArticles.ViewCurrent.Page_Init(Object sender, EventArgs e) --- End of inner exception stack trace ---
In addition, in the Module Definition list I can see both instances of the NA module 7.19 and 7.88.
These were the errors at the time of install/upgrade:
------------------------------------------------------------------------------------------------------
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: There is already an object named 'DnnForge_NewsArticles_GetArticleListByAuthorByStatus' in the database. 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(TdsParserStateObject stateObj) 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.DnnForge_NewsArticles_GetArticleListByAuthorByStatus @ModuleID int, @AuthorID int, @IsApproved bit, @IsDraft bit AS
Info End Sql execution: 00.00.02.SqlDataProvider file
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: There is already an object named 'DnnForge_NewsArticles_GetCategoryListAll' in the database. 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(TdsParserStateObject stateObj) 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.DnnForge_NewsArticles_GetCategoryListAll @ModuleID int, @Current int, @CategoryID varchar(255) AS SET NOCOUNT ON DECLARE @level int, @line int CREATE TABLE #hierarchy(HierarchyID int IDENTITY (1,1), CategoryID int, level int) CREATE TABLE #stack (item int, level int) INSERT INTO #stack VALUES (@current, 1) SELECT @level = 1 WHILE @level > 0 BEGIN IF EXISTS (SELECT * FROM #stack WHERE level = @level) BEGIN SELECT @current = item FROM #stack WHERE level = @level insert into #hierarchy(CategoryID, level) values(@current, @level) DELETE FROM #stack WHERE level = @level AND item = @current INSERT #stack SELECT CategoryID, @level + 1 FROM dbo.DnnForge_NewsArticles_Category WHERE ParentID = @current and ModuleID = @ModuleID ORDER BY [Name] DESC IF @@ROWCOUNT > 0 SELECT @level = @level + 1 END ELSE SELECT @level = @level - 1 END -- WHILE DECLARE @strModuleID nvarchar(50) SELECT @strModuleID = convert(varchar, @ModuleID) DECLARE @strCategoryId nvarchar(255) IF (@CategoryId is not null) SELECT @strCategoryId = ' AND c.CategoryID in (' + @CategoryID + ')' EXEC(' SELECT c.[CategoryID], c.[ParentID], c.[ModuleID], c.[Name], REPLICATE(''.'',(level-2)*2) + c.[Name] as ''NameIndented'', c.[Image], (SELECT COUNT(*) FROM dbo.DnnForge_NewsArticles_ArticleCategories ac WHERE ac.CategoryID = c.CategoryID) as ''NumberofArticles'', (SELECT SUM(a.NumberOfViews) FROM dbo.DnnForge_NewsArticles_Article a INNER JOIN dbo.DnnForge_NewsArticles_ArticleCategories ac ON a.ArticleID = ac.ArticleID WHERE ac.CategoryID = c.CategoryID) as ''NumberofViews'' FROM #hierarchy h INNER JOIN dbo.DnnForge_NewsArticles_Category c ON h.CategoryID = c.CategoryID WHERE c.[ModuleID] = ' + @strModuleID + @strCategoryId + ' ORDER BY h.HierarchyID ASC') drop table #hierarchy drop table #stack
------------------------------------------------------------------------------------------------------
Any thoughts as to what the problem might be?
Thank you very much,
Adrian |