Oops on Checkout


https://forum.kartris.com/Topic7084.aspx
Print Topic | Close Window

By shulemj - Tue 30 Oct 2018
I have a Kartris cart running for a while on v2.9014, and now randomly throws a Oops error. See log below:


>> Version:2.9005>> URL:http://www.mysite.com/Checkout.aspx>> Page:----------------------------------------------------------------------------->> 10/29/2018 5:17:18 PM>> 67.86.248.119>> DESCRIPTION:System.Data.SqlClient.SqlException (0x80131904): Cannot insert explicit value for identity column in table 'tblKartrisBasketValues' when IDENTITY_INSERT is set to OFF.The INSERT statement conflicted with the FOREIGN KEY constraint "FK_tblKartrisBasketOptionValues_tblKartrisBasketValues". The conflict occurred in database "MyDatabase", table "dbo.tblKartrisBasketValues", column 'BV_ID'.Cursorfetch: The number of variables declared in the INTO list must match that of selected columns.The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 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 kartrisBasketDataTableAdapters.CustomersTblAdptr.SaveBasket(Nullable`1 CustomerID, String BasketName, Nullable`1 BasketID, Nullable`1 NowOffset) at BasketBLL.SaveBasket(Int64 numCustomerID, String strBasketName, Int64 numBasketID) at _Checkout.btnProceed_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)ClientConnectionId:a4b8e83d-144a-409e-966d-edbb8cc9d05bError Number:544,State:1,Class:16


By shulemj - Tue 7 May 2019
Anyone?
By Jarmando - Fri 8 Nov 2019
I know it's a bit late for you, but for the record. It is a language string problem, for sure.Try to use english language and see if the oops page still appears.