1
Vote

SHIPPING CRASHING & INSTALL PROBLEMS

description

i LOVED THIS STORE until I upgraded to dnn 7. perhaps it was user error but whenever you were checking out after you select shipping the cart would crash.
I tried a bunch of stuff like going back thru the entire set up then I exported the csv or products and uninstalled the entire store and now apparently I can't reinstall because when I try I get this error.


SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DNNspot_Store_PaymentStatus' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action1 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) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 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:19fbdce3-6319-47c7-91a1-5e857b79ea46 CREATE TABLE dbo.[DNNspot_Store_PaymentStatus]( [Id] [smallint] NOT NULL, [Name] [nvarchar](150) NOT NULL, CONSTRAINT [PK_DNNspot_Store_PaymentStatus] PRIMARY KEY CLUSTERED ( [Id] ASC ) ) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DNNspot_Store_PaymentProvider' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action1 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) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 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:f50b1a1d-3f10-44a2-9879-0016019d47b4 CREATE TABLE dbo.[DNNspot_Store_PaymentProvider]( [Id] [smallint] NOT NULL, [Name] nvarchar NOT NULL, CONSTRAINT [PK_DNNspot_Store_PaymentProcessor] PRIMARY KEY CLUSTERED ( [Id] ASC ) ) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DNNspot_Store_OrderStatus' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action1 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) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 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:dcc43f1b-383f-4e96-891d-21460686d022 CREATE TABLE dbo.[DNNspot_Store_OrderStatus]( [Id] [smallint] NOT NULL, [Name] [nvarchar](100) NOT NULL, CONSTRAINT [PK_DNNspot_Store_OrderStatus] PRIMARY KEY CLUSTERED ( [Id] ASC ) ) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DNNspot_Store_EmailTemplate' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action1 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) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 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:95ae8672-aa28-497b-8561-b60816003005 CREATE TABLE dbo.[DNNspot_Store_EmailTemplate]( [Id] [smallint] NOT NULL, [NameKey] varchar NOT NULL, [Description] nvarchar NOT NULL, [DefaultSubject] nvarchar NOT NULL, [DefaultBody] nvarchar NOT NULL, CONSTRAINT [PK_DNNspot_Store_EmailTemplate] PRIMARY KEY CLUSTERED ( [Id] ASC ) ) System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'IX_DNNspot_Store_EmailTemplate' already exists on table 'dbo.DNNspot_Store_EmailTemplate'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action1 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) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 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:dcc43f1b-383f-4e96-891d-21460686d022 CREATE UNIQUE NONCLUSTERED INDEX [IX_DNNspot_Store_EmailTemplate] ON dbo.[DNNspot_Store_EmailTemplate] ( [NameKey] ASC ) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DNNspot_Store_DeliveryMethod' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action1 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) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 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:19fbdce3-6319-47c7-91a1-5e857b79ea46 CREATE TABLE dbo.[DNNspot_Store_DeliveryMethod]( [Id] [smallint] NOT NULL, [Name] varchar NOT NULL, CONSTRAINT [PK_DNNspot_Store_DeliveryMethod] PRIMARY KEY CLUSTERED ( [Id] ASC ) ) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DNNspot_Store_Store' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action1 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.RunExecuteNonQueryTd

comments

southwo8 wrote Aug 21, 2013 at 3:18 PM

Unfortunately, support for DNN 7 is still in progress, it's unstable on DNN 7 at the moment. Some people are having good success, while others are having problems.

I realize you have already upgraded your DNN, but if you haven't I'd recommend sticking to DNN 6 for the time being.