Tag: Update Error

add item to cart

Comersus Version: 607Database type: OtherFrequency: Permanent issue I can add items to my cart fine in firefox, but when I do the same in IE7 I get this error – Temporary error Sorry for the inconvenience. Update Error in addItem, error: [MySQL][ODBC 3.51 Driver][mysqld-4.1.21-community-nt]You have an error in your SQL syntax check the manual that

Problem with e-mail Client

Comersus Version: 7097Database type: AccessFrequency: Permanent issue Hi, I have been having a problem with my e-mail client. I recently had to migrate to a new server as my old one went into liquidation. Since the migration I have been unable to get the store to work properly. The problem is that neither customers nor

OrderVerify error

Comersus Version: 7097Database type: AccessFrequency: Permanent issue any one have a fix for this? Temporary error Sorry for the inconvenience. Update Error in orderVerify error Object required – ErrNumber424 – SQLUPDATE dbSession set sessionDataStandard 995VisaDebitCredit Cards00109952 WHERE idDbSession1

Err.Number:-2147352567 – SQL

Comersus Version: 707Database type: SQL ServerFrequency: Permanent issue I am getting this message when a customer tries to register: Sorry for the inconvenience. Update Error in customerRegistrationExec, error: Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. – Err.Number:-2147352567 – SQL:INSERT INTO customers (name, lastName,

Checlout Error

Comersus Version: 707Database type: SQL ServerFrequency: Permanent issue I am configuring a new store and at checkout I am getting the below error message: Sorry for the inconvenience. Update Error in saveorder 12 error MicrosoftODBC SQL Server DriverSQL ServerThe record cant be added or changed Referential integrity rules require a related record in table dbSession

i got this by checkout

Comersus Version: 707Database type: OtherFrequency: Permanent issue Temporary error Sorry for the inconvenience. Update Error in saveorder 9, error: Subscript out of range – Err.Number:9 –

Error in Checkout

Comersus Version: 707Database type: AccessFrequency: Permanent issue Sorry for the inconvenience. Update Error in saveorder 9, error: Subscript out of range – Err.Number:9 – SQL:INSERT INTO orders (orderDate, idCustomer, details, total, taxAmount, obs, address, zip, state, stateCode, city, countryCode, shippingName, shippingLastName, shippingAddress, shippingZip, shippingState, shippingStateCode, shippingCity, shippingCountryCode, shipmentDetails, paymentDetails, discountDetails, nroRan, orderStatus, idAffiliate, viewed, idCustomerType,

Error When Processing Cart

Comersus Version: 708Database type: OtherFrequency: Permanent issue I get the following error when clicking continue from comersus_showcart.asp to comersus_checkOut2.asp Update Error in orderVerify, error: Type mismatch – Err.Number:13 – SQLUPDATE dbSession set sessionData='Pickup $0.00||||||0||||||||||||0||1.44||15.84||' WHERE idDbSession=59 ANd I can't work out why.

error on checkout3.asp

Comersus Version: 708Database type: AccessFrequency: Permanent issue I am getting the following error on checkout3.asp that I just can't figure out. I have modified the cutomers table only, which has caused me to fix some errors. Such as, for checkout2.asp I needed to change the shippingmethodFunctions include file since it was looking for a customer

trying to install the cart

Comersus Version: 708Database type: AccessFrequency: Random issue I have assigned the permissions to the directories: comersus -execute comersusstore -execute comersusdatabase -execute The db file itself I don't have the ability to change its permissions. I get this error. Update Error in comersus_backoffice_install.asp, error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. – Err.Number:-2147467259

Checkout – Intershipper Error

Comersus Version: 607Database type: AccessFrequency: Permanent issue I'm using InterShipper and this error comes up during checkout. Temporary error Sorry for the inconvenience. Update Error in shipment, error: Subscript out of range – Err.Number:9 – SQL:UPDATE dbSession set sessionData='FDX FDX 2nd Day%%11.77%%0||FDX FDX First Overnight%%51.62%%0||FDX FDX Priority Overnight%%20.43%%0||FDX FDX Standard Overnight%%18.32%%0||FDX FDX Ground%%4.86%%0||UPS UPS 2nd

Can't get this cart installed. Temporary error

Comersus Version: 707Database type: AccessFrequency: Permanent issue Now I am getting the following Temporary error Sorry for the inconvenience. Update Error in sessionFunctions, checkSessionData, error: Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. – Err.Number:3001 – SQL:INSERT INTO dbSession (randomKey, sessionType, dbSessionDate) VALUES (53507632,'web','3/25/2007')

Erro message

Comersus Version: 707Database type: OtherFrequency: Permanent issue I get the follwoing message whenever a user does not finish checking out but goes back to viewing products Temporary error Sorry for the inconvenience. Update Error in ViewItem, error: [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]Data too long for column 'misc' at row 1 – Err.Number:-2147217871 – SQL:UPDATE products SET visits=visits+1

error at checkout

Comersus Version: 0Database type: AccessFrequency: Random issue Temporary error Sorry for the inconvenience. Update Error in default, error: Type mismatch – Err.Number:13 – SQL:INSERT INTO visits (userIp, referrer, keywords, visitDate, visitTime, idStore) VALUES ('','','','12/14/2006','10:36:21 AM',1)

Type Mismatch Error – On Update

Comersus Version: 705Database type: AccessFrequency: Permanent issue I have created a new table and I am updating values in that table using the updateDatabase function. When I capture the sql statement and execute it in SQL Query panel in Backoffice it works. But executing the statement via the site generates a Sorry for the inconvenience.

Update Error in comersus_backoffice_install6.asp

Comersus Version: 705Database type: AccessFrequency: Random issue Error Details: Update Error in comersus_backoffice_install6.asp, error: Ikke samsvar mellom typer – Err.Number:13 – SQL:DELETE FROM taxPerPlace WHERE idStore=1 I have Windows XP sp2 pro Please help

error upon checkout

Comersus Version: 607Database type: AccessFrequency: Permanent issue Sorry for the inconvenience. Update Error in shipment, error: Subscript out of range – Err.Number:9 – SQL:UPDATE dbSession set sessionData='FDX FDX 2nd Day%%10.92%%0||FDX FDX First Overnight%%64.41%%0||FDX FDX Priority Overnight%%36.29%%0||FDX FDX Standard Overnight%%32.18%%0||FDX FDX Ground%%4.91%%0||UPS UPS 2nd Day Air%%12.04%%0||UPS UPS 2nd Day Air AM%%14.97%%0||UPS UPS Next Day Air Saver%%31.95%%0||UPS

temperory error

Comersus Version: 700Database type: AccessFrequency: Permanent issue hai when i completed the adding items to the cart by giving discount code,while checkout, when i gave click the confirm button the following error is occuring Temporary error Sorry for the inconvenience. Update Error in saveorder 9, error: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria

Error with UPS real time shipping

Comersus Version: 700Database type: SQL ServerFrequency: Permanent issue I have been trying to incorporate real time shipping with UPS into Comersus. I was previously not using real time shipping so pRealTimeShipping was set to "NONE". I obtained my UPS account information and set pRealTimeShipping to "UPS" and set pUpsLicense, pUpsUser, pUpsPassword accordingly. After making the

discount per quantity

Comersus Version: 607Database type: OtherFrequency: Permanent issue hi, I have discount per quantity on some products, for example when ordering more than 10 units and when a customer adds first 10 or more and then later adds more like 1 or 2 units there's an error like this one; Sorry for the inconvenience. Update Error