----------------------------------------------------------------------------
>> OrdersBLL.Add
-----------------------------------------------------------------------------
>> System.Data.SqlClient.SqlException
>> 24/11/201318:28:14
>> Version:2.5005
>> URL:http://www.hotel-buyer-store.co.uk/Checkout.aspx
>> 109.204.115.163
>> CUSTOMMESSAGE:
Database Error: duplicate-key violation.
>> NUMBER:2627
>> MESSAGE:
Violation of PRIMARY KEY constraint'PK_tblKartrisOrdersPromotions'. Cannot insert duplicate key in object'dbo.tblKartrisOrdersPromotions'.
The statement has been terminated.
>> STACK:
atSystem.Data.SqlClient.SqlConnection.OnError(SqlException exception, BooleanbreakConnection)
atSystem.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception,Boolean breakConnection)
atSystem.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
atSystem.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler,SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler,TdsParserStateObject stateObj)
atSystem.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehaviorcmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
atSystem.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior,RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResultresult)
atSystem.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result,String methodName, Boolean sendToPipe)
atSystem.Data.SqlClient.SqlCommand.ExecuteNonQuery()
atOrdersBLL.Add(Int32 C_ID, String strUserEmailAddress, String strUserPassword,Address BillingAddress, Address ShippingAddress, BooleanblnSameShippingAsBilling, BasketBLL BasketObject, ArrayList BasketArray, StringstrOrderDetails, String strGatewayName, Int32 intLanguageID, Int32intCurrencyID, Int32 intGatewayCurrencyID, Boolean blnOrderEmails, StringstrShippingMethod, Double numGatewayTotalPrice, String strEUVATNumber, StringstrPromotionDescription, String strPurchaseOrderNo, String strComments)
==================================================
[/code]
Having looked at tblKartrisOrdersPromotions I can see that there is no data so I do not understand how it can be erroring on a duplicate key.