Tag: SET

Installation Wizard Error

Comersus Version: 7097Database type: AccessFrequency: Permanent issue Upon completing the installation Wizard I get the following error: Error Details: Update Error in comersus_backoffice_install10.asp, error: 006~ASP 0177~Server.CreateObject Failed~Invalid class string – Err.Number:-2147221005 – SQL:UPDATE settings SET settingValue='Msxml2.ServerXMLHTTP.5.0' WHERE settingKey='pXmlHTTPComponent'

Error in backoffice – email component

Comersus Version: 709Database type: AccessFrequency: Permanent issue Hi there, I have recently moved my shopping cart to a different server (hosting company). The cart use to run with cdonts without errors, but the hosting company told me that it does not support cdonts but cdo. The problem is that although the front end is working

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

Mark as Paid

Comersus Version: 709Database type: SQL ServerFrequency: Permanent issue I get the follwoing when I try to chnage the status of my orders to "Mark as Paid: There are errors in your BackOffice+: Update Error in comersus_backoffice_updateTransactionResults.asp, error: At least one of the From or Sender fields is required, and neither was found. – Err.Number:-2147220979 –

paypal wizard – error

Comersus Version: 708Database type: SQL ServerFrequency: Permanent issue Temporary errors There are errors in your BackOffice+: Update Error in PaypalWizardExec.asp, error: [Microsoft][ODBC SQL Server Driver][SQL Server]INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_payments_customerTypes'. The conflict occurred in database 'artelat_comersusdb', table 'customerTypes', column 'idCustomerType'. – Err.Number:-2147217900 – SQL:UPDATE settings SET settingValue='amelia.holt_api1.artelatinoh.com' WHERE settingKey='pPayPalApiUser'

Error al Marcar como pagado

Comersus Version: 700Database type: AccessFrequency: Random issue Al marcar La Orden como Pagada me da el siguiente error: There are errors in your BackOffice+: Update Error in comersus_backoffice_updateTransactionResults.asp, error: Type mismatch – Err.Number:13 – SQL:UPDATE orders SET transactionResults='6E475499HL8597732', orderStatus=4 WHERE idOrder=15 Me pide un codigo que no se exactamente lo que tengo que introducir, agradezco

Float can't update

Comersus Version: 603Database type: OtherFrequency: Permanent issue I want to update my prices, and there are thousands! So I tried:- UPDATE products SET price=17.99 WHERE price=17.9 But it didn't work. I found online that float numbers are not stored exactly as they seem. Would it affect anything if the price was changed from float to

error converting order to paid

Comersus Version: 705Database type: AccessFrequency: Permanent issue i get the following error when i try to convert a pending order to paid: There are errors in your BackOffice+: Update Error in comersus_backoffice_updateTransactionResults.asp, error: The server rejected one or more recipient addresses. The server response was: 550 5.7.1 Unable to relay for psamra@rocketproducts.co.uk – Err.Number:-2147220977 –

Transaction Updates

Comersus Version: 707Database type: SQL ServerFrequency: Permanent issue Getting the following error updating off-line credit cards. When I enter the authorization code (currently just testing) I get the following error for every order: ********************************************* Temporary errors There are errors in your BackOffice+: Update Error in comersus_backoffice_updateTransactionResults.asp, error: Type mismatch – Err.Number:13 – SQL:UPDATE orders SET

Unclosed connections

Comersus Version: 705Database type: OtherFrequency: Permanent issue Let me first say I not an expert. But, the way I read the code for closeDB() is that it closes rsTemp and sets it to nothing. But what about all the other connections, especially the heavily used ones like those in the itemsFunctions.asp, such as rstempSPrice that's

Uploading Images

Comersus Version: 707Database type: SQL ServerFrequency: Permanent issue Hi, When I try to upload an Image to a product using BackOfficePlus It gives the following error. What could be the wrong there? Temporary errors There are errors in your BackOffice+: Update Error in comersus_backoffice_uploadImagesForProductExec.asp, error: Permission denied – Err.Number:70 – SQL:UPDATE products SET imageUrl='Access 2000

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

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.

uploading images

Comersus Version: 705Database type: AccessFrequency: Permanent issue Hello, I am getting this error when uploading images: There are errors in your BackOffice+: Update Error in comersus_backoffice_uploadImagesForProductExec.asp, error: Permission denied – Err.Number:70 – SQL:UPDATE products SET imageUrl='JE301am.jpg' WHERE idProduct=42 I have the correct permissions set on the /store/catalog/ folder but error persists. If I apply write

SQL update with 2 categories

Comersus Version: 705Database type: AccessFrequency: Random issue hi, i'm trying to do an update through the genericSQL script, but i'm a bit confused, i need to update the category that some products are in depending on the name. this is waht i've got so far: UPDATE categories_products, products SET categories_products.idCategory = 196 WHERE products.description LIKE

Settings Update Error

Comersus Version: 705Database type: AccessFrequency: Permanent issue I was trying to update the store configuration settings (specifically our 'company slogan') and I received this message: Details: 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 idSetting=201

Error 450

Comersus Version: 509Database type: AccessFrequency: Permanent issue Greetings : I am receiving the following error after an Authorization Code is entered and the update arrow to the right of the text box is clicked to change the status of a purchase from Pending to Paid in the View Order screen. There are errors in your

SQL update is lowercase

Comersus Version: 0Database type: AccessFrequency: Permanent issue I used the SQL Tool to update message # 173 to say 'First Name' instead of simply 'Name'… but it results in "first name" being entered into the DB. Without downloading the db and putting it back up there, how can I update it to be capitalized? here's

Offline credit card processing

Comersus Version: 607Database type: AccessFrequency: Permanent issue I am still setting up my store. When I try to change the status of an offline credit card order, I get the following error: There are errors in your BackOffice+: Update Error in BackOffice Authorize Silent Response, error: The "SendUsing" configuration value is invalid. – Err.Number:-2147220960 –

digital goods

Comersus Version: 607Database type: SQL ServerFrequency: Permanent issue Hi I am setting up my shopping cart to sell digital goods direct and although I believe I have set up the sql server side correctly and email I am receiveing a number of errors. The manual seems to be short on explanation and after looking up