Looking for the old forum?

For topics posted before June 2015, please click here to visit the old support forum. Post your questions in this forum if you have any questions.

Support Forums
PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 12 Aug 2015 02:41 PM by  DavidWSNow
 1 Replies
You are not authorized to post a reply.
Author Messages

New Member

New Member

12 Aug 2015 02:41 PM
    I am in the process of upgrading my site (www.AgingSafely.com) from DNN6.1.5 to DNN7.3.4. I have staged the upgrade 6.2.9 => 7.1.2 => 7.3.4 on my localhost.
    I have enabled "advanced" in the friendlyURL bits.

    I decided that I should upgrade UltraMediaGallery from 8.6 to 9.8.9 (just purchased).

    When I go to install it I get a failure:

    Start Sql execution: datatables.SqlDataProvider file
    Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_UMG_Album_Portals". The conflict occurred in database "ASI3", table "dbo.Portals", column 'PortalID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:471a3c01-e703-49bb-b94a-7ebd32ecdf2c Error Number:547,State:0,Class:16 if not exists(select * from dbo.sysobjects where id = object_id('FK_UMG_Album_Portals') and type = 'F') ALTER TABLE dbo.UMG_Album WITH CHECK ADD CONSTRAINT FK_UMG_Album_Portals FOREIGN KEY(PortalID) REFERENCES dbo.Portals (PortalID) ON DELETE CASCADE
    Info End Sql execution: datatables.SqlDataProvider file
    Info Finished Sql execution
    Failure Installation Failed - Script

    Does this work with DNN7.3.4? I am sure glad that I tried this on my localhost first!

    Basic Member

    Basic Member

    14 Aug 2015 01:34 PM
    It might be caused by corrupted data, you can email me an admin account so I can fix it for you.
    You are not authorized to post a reply.

    Copyright © 2005-2013 BizModules Contact us