Register   Login
     
  Latest Posts  
RE: Comments not posting
by smcculloch on 1/08/2009 2:55 AM
Does anyone have XHTML Compliant PA Template
by tmahmud on 1/08/2009 1:04 AM
RE: Comments not posting
by WillJean on 1/08/2009 12:53 AM
RE: Comments not posting
by smcculloch on 1/08/2009 12:24 AM
RE: 4.9.0 and 5.0.0 with Simple gallery
by smcculloch on 1/08/2009 12:23 AM
Enable to comment in Simple Gallery
by nmduc073 on 1/07/2009 11:33 PM
Comments not posting
by WillJean on 1/07/2009 11:32 PM
4.9.0 and 5.0.0 with Simple gallery
by insomnia on 1/07/2009 11:31 PM
RE: Unable install News Articles in DNN 5
by nmduc073 on 1/07/2009 11:27 PM
Layout Settings: Listing View
by shawno on 1/07/2009 10:58 PM
  Forums  
Subject: upgrade exception
Prev Next
You are not authorized to post a reply.

Author Messages
Eric SwanzeyUser is Offline
Gold Membership
Nuke Super Newbie
Nuke Super Newbie
Posts:19

12/28/2006 8:44 PM  

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

Scott McCullochUser is Offline
Administrators
Nuke Master
Nuke Master
Posts:12797


12/28/2006 9:02 PM  
Hmm, was this the only exception? Did you move databases or something? It's like it didn't delete the stored proc before updating, is it still working?

Scott McCulloch
Site Administrator
Eric SwanzeyUser is Offline
Gold Membership
Nuke Super Newbie
Nuke Super Newbie
Posts:19

12/28/2006 10:03 PM  
This was the only exception. DB didn't move - it was a .net upgrade to v2, then a DNN upgrade to v4.3.7, then a Simple Gallery upgrade. Seems to be still working OK.
You are not authorized to post a reply.
Forums > Modules > Simple Gallery > upgrade exception



ActiveForums 3.7