Uninstalled all modules of 3.92, being careful to delete all files for each module. However, upon re-install I get the following error:
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: There is already an object named 'EVC_Smith_AddVMatrixDetail' 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.EVC_Smith_AddVMatrixDetail @ProductID int, @YAxisTitle varchar(50), @MatrixItemID1 int, @MatrixItemID2 int, @MatrixItemID3 int, @MatrixItemID4 int, @MatrixItemID5 int, @MatrixItemID6 int, @MatrixItemID7 int, @MatrixItemID8 int, @MatrixItemID9 int, @MatrixItemID10 int AS INSERT INTO EVC_Smith_VariantMatrixDetail (ProductID, YAxisTitle, MatrixItemID1,MatrixItemID2,MatrixItemID3,MatrixItemID4,MatrixItemID5,MatrixItemID6,MatrixItemID7, MatrixItemID8,MatrixItemID9, MatrixItemID10) VALUES (@ProductID,@YAxisTitle, @MatrixItemID1,@MatrixItemID2,@MatrixItemID3,@MatrixItemID4,@MatrixItemID5,@MatrixItemID6,@MatrixItemID7, @MatrixItemID8,@MatrixItemID9,@MatrixItemID10) SELECT SCOPE_IDENTITY()
I'm not sure where to go now. Any suggestions are greatly appreciated.
Dana Richard
|