Tag Archives: SQL

Getting Started – http 500 error

Comersus Version: 7097Database type: AccessFrequency: Permanent issue Hi, I have unzipped the files and uploaded them to the root of my website. The host is running asp.net 1.1 and 2.0 and I can use SQL db's if i need to. When I go to /comersus7f/quickstart.html, I can view it fine. The problem is when I […]

Posted in Uncategorized | Tagged | 1 Comment

Reviews/ratings error

Comersus Version: 7097Database type: OtherFrequency: Permanent issue getting this error when trying to "save a review" Sorry for the inconvenience. Error in getSettingKey error MySQLODBC 351 Drivermysqld-5022-community-max-ntYou have an error in your SQL syntax check the manual that corresponds to your MySQL server version for the right syntax to use near 2008-06-12 41809 testbrbrhttptwofishguyzcomcomersusstorecomersu at […]

Posted in Uncategorized | Tagged | 1 Comment

Multiple Store Management

Comersus Version: 7097Database type: SQL ServerFrequency: Permanent issue Hi I am in the process of setting up multiple stores (we have run a single store for a while). However I have run into some problem with the backend category management. Can I check the following peice of code with you: "includes/rootverify.asp" Line 17 & 18: […]

Posted in Uncategorized | Tagged | 5 Comments

Password Recovery SQL only?

Comersus Version: 7097Database type: AccessFrequency: Permanent issue I am configuring the Password Recovery option for the Comersus shopping cart and keep getting a SQL error, for the obvious reason of the fact that we are keeping it all access based. Is this feature only available when using a SQL database, or is there a different […]

Posted in Uncategorized | Tagged , | 4 Comments

Error Type: Active Server Pages, ASP 0126

Comersus Version: 7095Database type: SQL ServerFrequency: Permanent issue Hi, I'm trying this on my local computer and I'm receiving this error. Error Type: Active Server Pages, ASP 0126 (0x80004005) The include file '/comersus7F/includes/settings.asp' was not found. /COMERSUS/store/default.asp, line 9 the path is correct but keeps displaying this message. As of now I'm using the ACCESS […]

Posted in Uncategorized | Tagged , , , | 7 Comments

SQL error ?

Comersus Version: 7097Database type: AccessFrequency: Permanent issue I get following messages first time launching the store: Temporary error Sorry for the inconvenience. Error in getSettingKey error Invalid procedure call or argument – ErrNumber5 – SQLSELECT settingValue FROM settings WHERE settingKeypShowCategories AND idStore1 You can request free technical assistance at Comersus Forum

Posted in Uncategorized | Tagged | 1 Comment

Error5

Comersus Version: 7097Database type: AccessFrequency: Permanent issue My first effort at using I am trying to set up comersus free version * I have set up IIS on WinXp and it appears to be OK * I logged into localhost (via Firefox2)and the Comersus setup wizard ran. I entered some company details, and also some […]

Posted in Uncategorized | Tagged , , | 1 Comment

incorrect date format in backoffice

Comersus Version: 709Database type: SQL ServerFrequency: Permanent issue Hello. Just a note… I've been getting bad date formatting whenever placing an order through the backoffice component of our site… while we had MM/DD/YYYY selected in settings, and had checked to swap the format to get proper results from our SQL sever, all orders from backoffice […]

Posted in Uncategorized | Tagged | 1 Comment

SQL error

Comersus Version: 7097Database type: SQL ServerFrequency: Permanent issue Viewing products in categories is ok the problem I am experiencing arises when I go to view; Top sellers and top deals I get this error "Sorry for the inconvenience. Error in getStock error MicrosoftODBC SQL Server DriverSQL ServerIncorrect syntax near – ErrNumber-2147217900 – SQLSELECT stockstock FROM […]

Posted in Uncategorized | Tagged | 1 Comment

Unable to add categories

Comersus Version: 7097Database type: SQL ServerFrequency: Permanent issue Hi all, I've just installed the cart and power pack and am familiarizing myself with the system. When I try to add a new product category, I get the message "Cannot add category, there is already a category with that name in that level."… except that there […]

Posted in Uncategorized | Tagged | 3 Comments

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 […]

Posted in Uncategorized | Tagged , | 3 Comments

Distinct Visits

Comersus Version: 707Database type: AccessFrequency: Permanent issue can you let me know why this SQL will not execute in the Generic SQL script: Select Count(Distinct userIP) From Visits

Posted in Uncategorized | Tagged , | 3 Comments

slq issues and docuemtnation

Comersus Version: 7097Database type: SQL ServerFrequency: Permanent issue hi there In the documentation for with the free site it has the SQL table properties for the database, is their a similar list for the tables added by the power pack as I have been making some changes ready for going live and I am now […]

Posted in Uncategorized | Tagged | 7 Comments

Search results not showing all products

Comersus Version: 708Database type: AccessFrequency: Permanent issue I need to edit a group of products. When I do a search and I put in a search key that I know should be found, it only returns the first 10 products. But if I do an SQL query of the products table I find that I […]

Posted in Uncategorized | Tagged | 1 Comment

Local Installation – Wizard does not start

Comersus Version: 7095Database type: AccessFrequency: Random issue … instead I receive the following page: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] Disk or network error. /cart/includes/databaseFunctions.asp, line 17 I re-copied the comersus.mdb and ensured the permissions are still OK. I am running a fairly new installation of Windows Vista […]

Posted in Uncategorized | Tagged , | 1 Comment

Trouble with advanced search

Comersus Version: 7095Database type: SQL ServerFrequency: Permanent issue When I use the advanced search anonymously (not as a logged in user), it works fine. When I log in and use the search, I get the following error – Temporary error Sorry for the inconvenience. Error in advancedSearchExec error MicrosoftODBC SQL Server DriverSQL ServerString or binary […]

Posted in Uncategorized | Tagged | 6 Comments

how to list Inactive items with quantity > 0

Comersus Version: 707Database type: OtherFrequency: Permanent issue As topic How to do it by SQL query? Thanks!!

Posted in Uncategorized | Tagged | 1 Comment

Update Price via SQL -20%

Comersus Version: 702Database type: SQL ServerFrequency: Permanent issue Hello I need to change the entire catalog pricing by -20%. When i use the backofficeplus to do this it says it completed successfully but SQL manager shows no change in price. It seems to only work for price increase. i am using the syntax -20. What […]

Posted in Uncategorized | Tagged | 7 Comments

Modificar fecha

Comersus Version: 603Database type: AccessFrequency: Random issue Con que sentencia SQL puedo modificar la fecha de una orden de compra ? Gracias

Posted in Uncategorized | Tagged | 2 Comments

discount's problem

Comersus Version: 705Database type: OtherFrequency: Permanent issue after setting discount percentage in the backoffice, in frontoffice show this error: Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [MySQL][ODBC 3.51 Driver][mysqld-4.1.22-community-nt]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 […]

Posted in Uncategorized | Tagged | 1 Comment
© 2017 Comersus Forum. All Rights Reserved.
Powered by WordPress. Download Free Shopping Cart Now
porno porno izle porno izle