Go to previous topic
Go to next topic
Last Post 12 Dec 2017 09:11 AM by  Pengtsen R
Error Uninstalling FlexEvents 1.8.4
 1 Replies
Author Messages


New Member


Posts:7
New Member


--
07 Dec 2017 06:48 PM
    Hello,

    We tried to uninstall FlexEvents 1.8.4 from a DNN 8.0.4 site and we received the following error at the end of the summary page.

    SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Could not drop object 'dbo.FlexEvent' because it is referenced by a FOREIGN KEY constraint. 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& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:10ff6ac0-71c3-4aa6-8406-2a3d5a4f0ab4 Error Number:3726,State:1,Class:16 IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.FlexEvent') AND type in (N'U')) DROP TABLE dbo.FlexEvent

    After receiving the uninstall summary page with the error above we were not able to load the site. We had to restore from a backup. =-)

    Any ideas why this is occurring?

    Thanks


    Basic Member


    Posts:189
    Basic Member


    --
    12 Dec 2017 09:11 AM
    The database errors can be handled by manually deleting all database objects starting with FlexEvent_.

    If you cannot load the website, maybe it is caused by some missing dlls. I recommend you to do this:

    1, backup the bin folder
    2, uninstall flxevents
    3, if the website doesn't load, restore the /bin folder
    4, from the installation package, you can find which dll's are used by flexevents in its own /bin folder
    5, delete these dll's one by one, ensure the website loads after deleting each file.
    6, go to your database, delete data objects starting with FlexEvents.


    ---