Tag: SET

Error when marking as paid

Comersus Version: 603Database type: AccessFrequency: Permanent issue When I want to manually update an order and mark it as paid, (I have no gateway installed my customers pays via their bankaccount), I go trough Store, List all. I select the order that I want to mark as paid. As far as I understand, I must

Refund Problem

Comersus Version: 603Database type: AccessFrequency: Permanent issue we are using authorize.net and when I go to refund partially order I'm getting the following error: Temporary errors There are errors in your BackOffice+: Update Error in refundOrderExec.asp, error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. – Err.Number:-2147217904 – SQL:UPDATE products SET sales=sales-1 WHERE idProduct=24

visits not working please help

Comersus Version: 603Database type: AccessFrequency: Permanent issue (code from view item page)' increase visits to the product mySQL="UPDATE products SET visits=visits+1 WHERE idProduct="& pIdProduct my store opens with a modified list categories and products page and navigates from that page. My site receives about 10000 visits a day, my stats show me that cetain products

BackOffice+: Update Error in BackOffice Authorize

Comersus Version: 603Database type: SQL ServerFrequency: Permanent issue [There are errors in your BackOffice+: Update Error in BackOffice Authorize Silent Response, error: Object required – Err.Number:424 – SQL:UPDATE products SET sales=sales+2 WHERE idProduct=1] i am getting this error while marking status as paid i am not using any payment gateway what Authorization code i give

Error in Backoffice+

Comersus Version: 603Database type: AccessFrequency: Permanent issue When trying to view pending orders I receive the following error: There are errors in your BackOffice+: Update Error in comersus_backoffice_showOrder.asp, error: Type mismatch – Err.Number:13 – SQL:UPDATE orders SET viewed=-1 WHERE idOrder=247

Error entering Authorization Code

Comersus Version: 602Database type: AccessFrequency: Permanent issue The following error occurs when entering an Authorization Code in BackOfficePlus – View Order. Temporary errors 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 SET transactionResults='', orderStatus=4 WHERE idOrder=1 Despite the error,

Update statement error Err.Number:-2147217900

Comersus Version: 603Database type: AccessFrequency: Permanent issue Hi, I am getting the following error while modifying the Personal information(customer). " Sorry for the inconvenience. Error in screenMessages, error: Syntax error in UPDATE statement. – Err.Number:-2147217900 – SQL:SELECT screenMessage FROM screenMessages WHERE idScreenMessage=190 AND idStore=1" I can do all other things but modifying part is not

error: Syntax error in UPDATE statement. – Err.Num

Comersus Version: 603Database type: AccessFrequency: Permanent issue Hi, I am getting the following error while modifying the Personal information(customer). " Sorry for the inconvenience. Error in screenMessages, error: Syntax error in UPDATE statement. – Err.Number:-2147217900 – SQL:SELECT screenMessage FROM screenMessages WHERE idScreenMessage=190 AND idStore=1" I can do all other things but modifying part is not

error 450 in manual status update in orders

Comersus Version: 5099Database type: AccessFrequency: Permanent issue Hi, On clicking the orange button ( authorisation code)in manually changing the order status, i get: 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=12344, orderStatus=4 WHERE idOrder=57 same result when blank

Missing idCustomer

Comersus Version: 500Database type: AccessFrequency: Permanent issue I am getting the following SQL on the checkOutCustomerExec page. I'm missing the idCustomer. UPDATE customers SET shippingName='Tom', shippingAddress='123 Main', shippingZip='54323', shippingStateCode='LA', shippingState='', shippingCity='Anytown', shippingCountryCode='US' WHERE idCustomer=

backofficeplus: Refund order will get error messag

Comersus Version: 602Database type: AccessFrequency: Permanent issue There are errors in your BackOffice+: Update Error in refundOrderExec.asp, error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. – Err.Number:-2147217904 – SQL:UPDATE products SET sales=sales-1 WHERE idProduct=431

Err.Number:450

Comersus Version: 5099Database type: SQL ServerFrequency: Random issue Hi. I experience also Err.Number:450 errors and have gone through the forum but found no solution. Temporary errors There are errors in your BackOffice+: Error in updateTransactionResults.asp, error: Wrong number of arguments or invalid property assignment – Err.Number:450 – SQL:UPDATE products SET sales=sales+4 WHERE idProduct=114 Thx

Error when posting authorization code

Comersus Version: 601Database type: AccessFrequency: Permanent issue I am getting the following error when trying to update the authorization code to mark a product and paid in backoffice premium 6.00. Oddly enough the update works and the order does get marked as being paid, however the error still displays which I know will confuse the

Auth_Only Code

Comersus Version: 5099Database type: SQL ServerFrequency: Permanent issue I am using Authorize.net SIM for my payment gateway. Everything is configured correctly(I think). I am able to place orders in "live" mode. I am receiving a valid auth code from the gateway and my order confirmation page. Example: (Your payment for the order #52 was approved.

error processing pending orders

Comersus Version: 507Database type: AccessFrequency: Permanent issue I get the following error when I "Mark All Pending Orders As Paid" There are errors in your BackOffice+: Error in updateTransactionResults.asp, error: Wrong number of arguments or invalid property assignment – Err.Number:450 – SQL:UPDATE products SET sales=sales+1 WHERE idProduct=3084

Error entering Authorization Code.

Comersus Version: 5099Database type: AccessFrequency: Permanent issue I noted the thread "Odd backoffice+ error by Clark Rumsey on 7/8/2004" It seems I am experiencing the exact same issue. I am accepting Offline payments and PayPal. Whenever I enter an authorization code, I get the following error: "Temporary errors There are errors in your BackOffice+: Error

Error 70

Comersus Version: 508Database type: AccessFrequency: Permanent issue Hi There, I've been trying to upload a new product. However, although it tells me that it adds the `copy' and then offers to get me to upload pics. The site doesn't change. The pics aren't uploaded and I get this message: Error in comersus_backoffice_uploadImagesForProductExec.asp, error: Permission denied

Odd backoffice+ error

Comersus Version: 5095Database type: SQL ServerFrequency: Permanent issue Hi, Whenever I try to update an order by clicking the little "Mark as Paid" button next to authorization code, I get the following error: 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

Error when updating order status to paid

Comersus Version: 5095Database type: AccessFrequency: Permanent issue Error in comersus_backoffice_updateOrderStatus.asp, error: Wrong number of arguments or invalid property assignment – Err.Number:450 – SQL:UPDATE orders SET orderStatus=4 WHERE idOrder=53 Please advise.

automatic inventory update at checkout

Comersus Version: 503Database type: AccessFrequency: Permanent issue Hi, I am trying to update my product stock and sales at the time of checkout versus at time of payment. I am not using real-time payment and most of my items are single unique items and therefore I do not want more than one person to order