Tag: SET

SQL help

Comersus Version: 607Database type: AccessFrequency: Random issue Hi, I changed and added a link to a terms and conditions page in the footer page so It could be seen when someone be in Home. Because I'm using comersus lite I couldn't change that just using back office so I used the next SQL sentence: UPDATE

Authorization code and moving to paid

Comersus Version: 605Database type: OtherFrequency: Random issue Hello, this is the message when i try to add an authorization code or just trying to move the customer from pending to paid. There are errors in your BackOffice+: Update Error in BackOffice Authorize Silent Response, error: 550 Requested action not taken: mailbox unavailable or not local

Maintaining case

Comersus Version: 607Database type: AccessFrequency: Permanent issue when I run the following sql statement : UPDATE shipments SET shipmentDesc = 'Postal Service International' WHERE idShipment=1; the table now shows: postal service international Where did my capitals go?

Update transaction results not working

Comersus Version: 607Database type: AccessFrequency: Permanent issue I use the offline payment form to collect CC information. When I log into the backoffice and try to enter an authorization code, I get the following error: are errors in your BackOffice+: Update Error in cart_backoffice_updateTransactionResults.asp, error: [Microsoft][ODBC Microsoft Access Driver] Not a valid bookmark. – Err.Number:-2147467259

Error 450

Comersus Version: 603Database type: OtherFrequency: Permanent issue Hello , When we mark a pending order as paid the following error occured : There are errors in your BackOffice+: Error in comersus_backoffice_updateTransactionResults.asp, error: Wrong number of arguments or invalid property assignment – Err.Number:450 = SQL:UPDATE orders SET transactionResults= . orderSatus=4 This is happen after a Plesk

Error Dialogue since I upgraded

Comersus Version: 606Database type: AccessFrequency: Permanent issue The following is an exact print of the first error I came across"There are errors in your BackOffice+: Update Error in comersus_backoffice_updateTransactionResults.asp, error: Object required – Err.Number:424 – SQL:UPDATE orders SET transactionResults='', orderStatus=4 WHERE idOrder=9 This is in response to Credit card Transactions via 2Co. Can you Help?

Database problems

Comersus Version: 606Database type: AccessFrequency: Permanent issue The following represents an error I am receiving: There are errors in your BackOffice+: Update Error in comersus_backoffice_resetCustomerPasswords.asp, error: Object required – Err.Number:424 – SQL:UPDATE customers SET password='|9|27|68|180|205' WHERE idCustomer=2 This started appearing once I upgraded to Premium I'm still using Access. Got any ideas? Rich

error with PayPal – make paid

Comersus Version: 605Database type: OtherFrequency: Permanent issue I'm receiving the following error when processing an order. Please advise BackOffice+: Update Error in BackOffice Authorize Silent Response, error: 550 Requested action not taken: mailbox unavailable or not local – Err.Number:6 – SQL:UPDATE products SET sales=sales+2 WHERE idProduct=12

can't update customer

Comersus Version: 6045Database type: OtherFrequency: Permanent issue From Backoffice Plus cannot modify customer data. I get error message: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Field 'customers.email' cannot be a zero-length string. /practice/includes/databaseFunctions.asp, line 84 Then inserted: response.write mysql response.end after update string: UPDATE customers SET name='rrrgf', lastName='ggggff', customerCompany='', email='',

Mystery Product

Comersus Version: 5095Database type: SQL ServerFrequency: Random issue Hi, I am receiving this error every few days: Error: Error in ViewItem, error: Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. – Err.Number:3021 – SQL:UPDATE products SET visits=visits+1 WHERE idProduct=508 I do not have any

Attempting Authorization Code Fails

Comersus Version: 605Database type: SQL ServerFrequency: Permanent issue I am running on a local machine, and I am testing, using off-line credit card. After the order is placed, I assume that I need to enter the Authorization code in order to proceed to complete the order. Whenever I enter an Autorization code (fictitious)and press the

BackOffice+ credit Card

Comersus Version: 605Database type: OtherFrequency: Permanent issue When i update payment Authorization code i get this error There are errors in your BackOffice+: Update Error in updateTransactionResults.asp, error: – Err.Number:-2147352567 – SQL:UPDATE orders SET transactionResults='Credit Card Payment', orderStatus=4 WHERE idOrder=66

Error confirmar pago

Comersus Version: 605Database type: OtherFrequency: Permanent issue Cuando confirmo pago, me sale el siguiente error: There are errors in your BackOffice+: Update Error in comersus_backoffice_updateTransactionResults.asp, error: [TCX][MyODBC]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '34) WHERE idCustomer=7' at

Updating settings

Comersus Version: 6045Database type: AccessFrequency: Permanent issue I get error There are errors in your BackOffice+: Update Error in comersus_backoffice_settingsModifyExec.asp, error: [Microsoft][ODBC Microsoft Access Driver] Field 'settings.settingValue' cannot be a zero-length string. – Err.Number:-2147467259 – SQL:UPDATE settings SET settingValue='-1' WHERE idSetting=45 When updating settings .. pls advise urgently

Assign product to bundle

Comersus Version: 604Database type: SQL ServerFrequency: Permanent issue I have been trying to modify some of the products to make a bundle. This is the error message recieved: There are errors in your BackOffice+: Update Error in comersus_backoffice_addBundleProductExec.asp, error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'idBundle', table 'comersus.dbo.bundles'; column does

Error in Backoffice configuration

Comersus Version: 6045Database type: AccessFrequency: Permanent issue In backofice I make changes to the settings configuration but when i save I get the following error There are errors in your BackOffice+: Update Error in comersus_backoffice_settingsModifyExec.asp, error: [Microsoft][ODBC Microsoft Access Driver] Field 'settings.settingValue' cannot be a zero-length string. – Err.Number:-2147467259 – SQL:UPDATE settings SET settingValue='0' WHERE

Update Error in comersus_backoffice_updateTransact

Comersus Version: 601Database type: OtherFrequency: Permanent issue When I click on pending orders, I enter in the Authorization code and click on "mark as paid" button. I get the folloing error: There are errors in your BackOffice+: Update Error in comersus_backoffice_updateTransactionResults.asp, error: Wrong number of arguments or invalid property assignment – Err.Number:450 – SQL:UPDATE orders

Update Error in comersus_backoffice_updateTransact

Comersus Version: 601Database type: OtherFrequency: Permanent issue I get the following error when I try to mark paid an sales order: There are errors in your BackOffice+: Update Error in comersus_backoffice_updateTransactionResults.asp, error: Object required – Err.Number:424 – SQL:UPDATE orders SET transactionResults='', orderStatus=4 WHERE idOrder=8

Error on SQL update transaction page

Comersus Version: 507Database type: OtherFrequency: Permanent issue we are getting an error when the customer trys to mark a pending order as paid. There are errors in your BackOffice+: Error in updateTransactionResults.asp, error: Object variable not set – Err.Number:91 – SQL:UPDATE products SET sales=sales+2 WHERE idProduct=6391 We cannot update a pending order to paid and

Manual Payment Authorization Entry Error

Comersus Version: 507Database type: OtherFrequency: Permanent issue Hello, It seems that when I go into backoffice and select a pending order from the list orders page and I try to manually enter the auth code and submit it to change the order to paid I get the following error: Temporary errors There are errors in