Hi, I upgraded DNN fro v3.2.2 to v4.3.7.
After that, I upgraded Simple Gallery from v2.1.1 to v2.1.3, but got the following exception on the upgrade. I would appreciate knowing if there's anything I should force with some tsql. The upgrade finished successfully except for the following.
StartJob Start Sql execution: 02.01.02.SqlDataProvider file Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: There is already an object named 'DnnForge_SimpleGallery_AlbumGetByPath' 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_SimpleGallery_AlbumGetByPath @ModuleID int, @HomeDirectory nvarchar(255) AS SELECT TOP 1 [AlbumID], [ModuleID], [ParentAlbumID], [Caption], [Description], [IsPublic], [HomeDirectory], [Password], [AlbumOrder] FROM dbo.DnnForge_SimpleGallery_Album WHERE [ModuleID] = @ModuleID and [HomeDirectory] = @HomeDirectory EndJob End Sql execution: 02.01.02.SqlDataProvider file |