Tag: Access

Database maintenance

Comersus Version: 4295Database type: AccessFrequency: Permanent issue I'm a happy user of Comersus shop from 3/4 years; now I have the problem that in the Access database the dbSession, the dbSessionCart, the CartRows are full of records (obout 50.000 each label) and the file heavy is increasing (now about 20 Mb) every day; is there

Discount Code

Comersus Version: 708Database type: AccessFrequency: Permanent issue Hi, If I open the database in Access, How do I put in a general discount code in the free version. I have tried, but when I enter the code in the store, it says invalid code. What must be filled in in the fields? eg: storeID etc.

Missing Orders

Comersus Version: 600Database type: AccessFrequency: Random issue I am having problems with Missing Orders. I was attempting to customize the check-out process so that customers were not required to create an account. However after doing this, there were two order emails that came through, but nothing in the database. I restored the original files I

importing a product's information

Comersus Version: 708Database type: OtherFrequency: Permanent issue Hi, i'm importing a product's information from Access' s database to Mysql's database. In Access' s database "price", "listPrice", "freeShipping" are numerical (double precision) flieds, in mysql' s database "price", "listPrice", "freeShipping" are float field What suggested to make?

Access to SQL

Comersus Version: 708Database type: AccessFrequency: Permanent issue Does anyone have any best practices for moving the data from MS Access to MS SQL Server. Cheers, Steve

Access db categories image field

Comersus Version: 708Database type: AccessFrequency: Permanent issue Is it possible within the framework to increase the size of the Access for table element categories.imageCategory from 50 to 250? I would like the field to have URLs to other sites which host the images rather than mantain them locally. Does the application work with URLs? I

CVV2

Comersus Version: 708Database type: AccessFrequency: Permanent issue The CC companies don't want the CVV stored in any database more than, I think, 48 hours. Is it automatically deleted from your database (Access, MS SQL and MySQL) ? If so, when? Thanks,

Installation

Comersus Version: 708Database type: AccessFrequency: Permanent issue Installed to wwwroot/comersus running IIS6 on XP Pro. when loading http://3moons.selfip.com/comersus or http://3moons.selfip.com/comersus/backofficelite i get SERVICE UNAVAILABLE message in IE. Friendly error messages turned off. Also sometimes get directory listing and directory browsing is turned off. All permissions set properly on all folders. Have SQL Server, MySQL, and

Access to MySQL

Comersus Version: 707Database type: AccessFrequency: Permanent issue Comersus Version : 7.07 Current Database: Microsoft Access I am using comersus power pack 7.07 and i have all data in my Access Database. Recently, i plan to convert all my data in Access DB to mySQL, can you please guide me how can i migrate to mySQL

change an oder

Comersus Version: 600Database type: AccessFrequency: Permanent issue By mistake, pBonusPointsPerPrice was not zero. I received an order and it was priced at less than the correct price. I would like to submit SQL to change the bonus points to zero and the price to the correct price just for this order. (I have already reset

Problems updating and displaying products

Comersus Version: 707Database type: AccessFrequency: Permanent issue I have manually added some products to my database. An example of the products can be downloaded from: http://watermark-moon/exampleProducts.csv In the database I have defined showInHome as -1 and Active as -1. When I enter backOfficeLite and search for the products I get a listing of the products

Items not appearing in web

Comersus Version: 707Database type: AccessFrequency: Permanent issue I have uploaded the products, caterories, categories.products directly to Access. However I cannot see the products. The categories are there but no items display. I know the products are in the database.

Use MySQL with Free Distribution

Comersus Version: 707Database type: AccessFrequency: Permanent issue Hello, I downloaded the free version of Comersus Cart to evaluate for a client. If the client wants to use the free version of Comersus Cart only, will recreating the Access tables in MySQL and updating the connection string work? Thanks in advance, Rad

Access error

Comersus Version: 707Database type: AccessFrequency: Permanent issue I keep receiving the same error (below) when I try to connect to the comersus shop. Active Server Pages error 'ASP 0131' Disallowed Parent Path /comersus/store/Default.asp, line 9 The Include file '../includes/settings.asp' cannot contain '..' to indicate the parent directory. It checked this online where I found info

From Lite to a Power Pack

Comersus Version: 601Database type: AccessFrequency: Random issue With the help of a developer we have upgraded the site, but the BackOffice Control Panel is version 7, not 6. This initially gave us an incompatibility problem which has been solved by sticking to BackOffice Lite. The error is Microsoft VBScript runtime error '800a000d' Type mismatch: 'getCategoryStart'

Site slows or gets stuck

Comersus Version: 707Database type: AccessFrequency: Permanent issue Hello. We bought the 7.07 with premium pack and installed it on the IIS 6 with Access. Very often site gets very slow or even stuck/ Some minutes pass and it comes back to normal state. Could you suggest?

Access db connection properties

Comersus Version: 707Database type: AccessFrequency: Permanent issue Using a hosting service and to create the dsn I need the username and password for the db. I have looked through the settings code and do not see these for creating an mdb dsn. thanks in advance

Access problem

Comersus Version: 707Database type: AccessFrequency: Random issue When I login to the backoffice I get a page crash intermittently. It's "unspecified error" on line 17 of databasefunctions.asp which is the statement connTemp.Open pDatabaseConnectionString I think it occurs after I have manually opened the database and updated and then closed. If I reboot it goes away.

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