AbleCommerce Shopping Cart Software

Do my eyes deceive me or do I *still* have to manually put the store in/out of daylight savings time? I'm running GOLD build 7345.

Yes, the upgrade scripts were definitely run. I'll see about dropping and recreating the constraint, but I'm mighty curious why that constraint wasn't updated. There were no errors reported during the DB upgrade part of the process.

HaggisMan

Query results are:

Hi Mazhar, Here are the query results: ORDINAL_POSITION COLUMN_NAME DATA_TYPE CHARACTER_MAXIMUM_LENGTH IS_NULLABLE COLUMN_DEFAULT 1 OrderId int NULL NO NULL 2 OrderNumber int NULL NO NULL 3 OrderDate datetime NULL NO NULL 4 StoreId int NULL NO NULL 5 UserId int NULL YES NULL 6 AffiliateId int NULL Y...

Recently upgraded from 7.0.4 to 7.0.7, then to 7.0.8 (Gold). Have started seeing the following in the Ablecommerce Error log regarding one specific user: Severity: Error Message: Error in user maintenance; could not delete user id 118030 Exception: could not execute native bulk manipulation query:DE...

What is the best way to create a Gold DEV site from a Gold LIVE site? I have LIVE and DEV licenses. Both sites/stores have to live on the same physical server - the LIVE site is publicly accessible but the DEV site will only be accessible on the internal network by IP:port (http://10.11.12.13:85). I...

True, .Net 4 wasn't the problem, but uninstall/reinstall ruled that out completely. The problem was two-fold: I had created a new website for the Gold installation/Upgrade. The new site was missing two important Authentication elements: In IIS Manager under IIS/Authentication, only Anonymous authent...

I tried the simple html file route; it generates the same error. I may just uninstall and reinstall .NET4 and see what happens.

Yes, the server was rebooted after .Net4 was installed. The website is in a folder at the drive's root and answers to abc.xyz.com. The site isn't defined as an application, should it be? I haven't tried destroying the website and app pool yet, but that may be the next step. As I mentioned in the ori...

The connection string isn't set up yet. The error occurs when I try running the /install/default.aspx script to actually do the install. The script doesn't run - instead of asking me for the Gold license key and then gathering the information to set up the connection string, it throws the error desc...

I'm bringing a 7.0.4 site up to Gold ( 7.0.8 ). The upgrade to 7.0.7 went fine. I then installed a new site for Gold, following the Gold Upgrade instructions with the intent of upgrading the DB and migrating custom stuff into the Gold site: *stopped the 7.0.7 site after verifying the database was up...

This fails in the same manner with 7.0.4 Build 13424. Copying the files from the ClientAPI\v7.0.4 folder to the appropriate places on the 7.0.4 site yields a version mismatch. If this is a known bug since back in 2011, that doesn't sound like good support to me. The "connect to a 7.0.6/7 site workar...

Mazhar, In my case the port was blocked at the firewall by mistake. All I received was: "Internet Explorer Cannot Display the Webpage". It appears that Ablecommerce isn't rendering anything until the database can be queried for the store settings. Where does Ablecommerce make the intial db connection?

I have my Ablecommerce website on one server and the database on a different server. If the webserver is unable to establish a connection to database server, I'd like to trap that and redirect the user to an informative page. I am thinking that I could trap at the point where the initial db connecti...

Thanks Mazhar. What I meant to ask was:

Has anyone successfully built a list of the full and partial zipcodes that comprise the RTD tax district in Colorado? I'm uncertain how to define a zone that has parts more granular than a zipcode, as well as full zipcodes.

Haggisman

Has anyone configured a Zone for the Denver, Colorado RTD tax district?

True, but it is also not uncommon for websites that serve Intranets, Extranets, or development sites to run on ports other than 80. It is also not uncommon for associated applications to handle different ports. Apparently DataPort operates in the "common" camp only.

There are several reasons (one being that the customer requests it). I'm guessing that the ultimate answer is, "Sorry, DataPort only works if the site is bound to port 80."

Does DataPort connect to http on other than port 80? I have two sites on one server: a live site running on port 80 and a development site running on port 85. DataPort connects just fine to the site on port 80 but fails with an "Authentication Failed. Invalid or Empty Request" error when the service...