Can't delete portal
Last Post 07-29-2011 10:35 AM by Kellyo. 3 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
KellyoUser is Offline
river guide
river guide
Posts:113
Avatar

--
05-31-2011 08:58 AM
    When I try to delete a portal, that never used Dynamic Views I get the following error.

    Error: Portals is currently unavailable.
    DotNetNuke.Services.Exceptions.ModuleLoadException: The DELETE statement conflicted with the REFERENCE constraint "FK_DataSprings_DynamicViews_Modules". The conflict occurred in database "webmontonmediagroup", table "dbo.DataSprings_DynamicViews", column 'ModuleID'. The DELETE statement conflicted with the REFERENCE constraint "FK_Modules_Portals". The conflict occurred in database "webmontonmediagroup", table "dbo.Modules", column 'PortalID'. The statement has been terminated. The statement has been terminated. ---> System.Data.SqlClient.SqlException: The DELETE statement conflicted with the REFERENCE constraint "FK_DataSprings_DynamicViews_Modules". The conflict occurred in database "webmontonmediagroup", table "dbo.DataSprings_DynamicViews", column 'ModuleID'. The DELETE statement conflicted with the REFERENCE constraint "FK_Modules_Portals". The conflict occurred in database "webmontonmediagroup", table "dbo.Modules", column 'PortalID'. The statement has been terminated. The statement has been terminated. 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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.DeletePortalInfo(Int32 PortalId) at DotNetNuke.Entities.Portals.PortalController.DeletePortalInfo(Int32 PortalId) at DotNetNuke.Entities.Portals.PortalController.DeletePortal(PortalInfo portal, String serverPath) at DotNetNuke.Modules.Admin.Portals.Portals.grdPortals_DeleteCommand(Object source, DataGridCommandEventArgs e) --- End of inner exception stack trace ---
    KellyoUser is Offline
    river guide
    river guide
    Posts:113
    Avatar

    --
    06-01-2011 05:08 PM
    Added info .. this is on a DNN 5.6.2 installation with extensions Dynamic Forms 3.4.3, Dynamic Views 2.1.1, Dynamic Registration 3.2.7, and Opt-In Email 4.0.1
    Don GeeUser is Offline
    river guide
    river guide
    Posts:273
    Avatar

    --
    06-02-2011 11:45 AM
    Hi Kellyo,
    This is a tough problem to figure out based on the information at hand. We will probablyl need to have you delete any forum key constraints for that. Our lead developer here at DataSprings says that you may need to open up a help desk case for this one. Let us know if you can do that. Sorry
    KellyoUser is Offline
    river guide
    river guide
    Posts:113
    Avatar

    --
    07-29-2011 10:35 AM

    Sorry for the delayed response, I was able to correct the situation. Once I deleted the Dynamic views module, the portals deleted fine. I will let you know if I run into any similar issues.

    Thanks Again!



    ---
  • film izle
  • 720 izle
  • film
  • sinema izle
  • film makinesi
  • T�rk�e dublaj film
  • film izle
  • film izle
  • baglan film izle
  • sinema izle
  • 1080 film izle
  • film mercegi