Hello,
I was running DNN 5 and the events module was working great. After I upgraded to DNN 6.0.0 the events module was not working and I tried to reinstall the module. I get the following error when I try to install Events 5.2. I only pasted the beginning of the error as it was really long. I copied the content of the Uninstall.SqlDataProvider file from the events module 5.2 install file and ran it under host, SQL, but it still does not install right. Any advice?
Error loading files from temporary folder - see below
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Cannot find the object "dbo.Events" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (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) /************************************************************/ /***** *****/ /***** SqlDataProvider *****/ /***** Install/Upgrade for Events module 05.00.03 *****/ /***** *****/ /***** Note: To manually execute this script you must *****/ /***** perform a search AND replace operation *****/ /***** for dbo. AND *****/ /***** or use 'SQL' FROM Host Menu AND run this. *****/ /***** *****/ /************************************************************/ /************************************************************/ /************************************************************/ /***** *****/ /***** Tidy Up Tables *****/ /***** *****/ /************************************************************/ /************************************************************/ /**** Change EnrollRoleID to Int ****/ ALTER TABLE dbo.[Events] ALTER COLUMN [EnrollRoleID] Int System.Data.SqlClient.SqlException: Invalid object name 'dbo.Events'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (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,