AbleCommerce Shopping Cart Software

Problem solved! Thanks Judy!

truncate table ac_PageViews worked, while DELETE FROM ac_PageViews did not. I was getting some errors while trying to run the 'delete' query, while 'truncate' cleared the table with no problems.

This makes my day!

Thanks!

I know this is very simple, but I can't remember where to edit the email address which is used when a customer adds a note to an order. Thank you.

Thanks Judy! That is some very helpful information.

Thanks Judy! What is the exact SQL statement to truncate the table? Like I said, this is pretty foreign to me.

Thanks for your input. Unfortunately, my website is still down, and nothing seems to work! Is there any way just to delete all rows from the PageViews table? I can't get into the AbleComm admin, so it would have to be a command entered directly from the database manager. I don't have much experience...

Thanks Judy, before I couldn't even Login into the admin. Now I'm not getting any errors for some reason. But, when I try to clear the Page Tracking log, I get an error which basically says that the transaction log for the database is full.

It looks like the PageViews table in the database has almost 500,000 entries. Can someone tell me how to remove some or all of the rows in that specific table?

Our website is displaying this message: Could not allocate space for object 'dbo.ac_PageViews'.'ac_PageViews_PK' in database 'AbleComm2' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup,...

So we have one AbleComm site on GoDaddy which works fine. We have another one which is down more than it is up. I need to transfer that installation to another host. Two Questions - 1) Is there any windows hosting solution that has a control panel similar to cPanel, which is what I'm used to? 2) I a...

Hello. I need to add this Shopzilla ROI script to our website. Can some help me determine a) where to put the code (what page) and b) how to get the appropriate variables into the script. Thanks! <!-- Shopzilla --> <script language="javascript"> <!-- /* Performance Tracking Data */ var mid = '******...

Thanks for the reply, Dustin.

Do you mean that you installed AbleComm onto a different server and copied and pasted that license onto the original server? I have about 400 products in the database right now and don't want to lose anything by doing a clean install.

-Greg

My 30 day trial expired yesterday, I received a license key for the installation today, but the page "Install/UpdateKey.aspx" gives me an error. I deleted the commercebuilder.lic file. The weird thing is that I accessed the updatekey.aspx page on our two other installs, and they both showed up fine....

Yesterday, the site was working fine and today I'm getting this error: Server Application Unavailable The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request. Administrator Note: An error ...

Thanks for the heads up regarding having multiple sites with identical content... that hadn't crossed my mind! It might not be a bad thing with different product ids, since your bookkeeping probably runs by SKU or manufacturer number? But DataPort uses the ProductId to determine whether a row within...

We have plans to create multiple AC stores and we may have certain products on more than one site. To make things easier to manage, I want to use one version of AC as a master database which will hold ALL of our products, and from there I can download site specific products in csv format and upload ...

Thanks for all the great info! This has really helped clear things up for me. I was able to accomplish my goal. Basically, I wanted to pull in products as variants instead of actually using product variants. For example, I created a product "Relief Valve" and in the "More Details" field (which I don...

Thanks for those examples! Hypothetically, if I wanted to select all the products with a particular Sku, what would that code look like? I tried adding this code to one of my custom ConLibs, but it doesn't work (This code may or may not make any sense, but like I said this is all very new to me!): p...

Thanks for the info!

Although I still feel a little lost and overwhelmed looking through those posts, I think I just have to work my way through it. Hopefully I'll "get it" eventually... I'm a designer, not a programmer, so this stuff doesn't come easy for me!

As I've browsed through various posts on this forum I've noticed a lot of people talking about creating custom database queries. This is something I would like to do, but am not sure where to start. I've looked through the AC code, and do not see any example queries. I'm guessing this is because the...

Sorry, It's a bit convoluted... I did get a license key for the new domain. I don't want to get into all the little details, but basically it all worked fine until I purchased an SSL certificate. I have a feeling it has something to do with the fact that when I bought the SSL, our host switched us f...

Thanks Joe, but the domain name for my site has not changed, only the IP Address of the hosting account. I can't even access the admin for my site because I'm getting the same error. Any other ideas?

It's a long story but here's the gist of it: I purchased an SSL certificate and then revoked it because we decided to use a different domain name for our site. Because of this, our hosting account is now under a different IP address than it was two days ago. Monday our AbleComm site worked fine, but...

That's very cool!

As for centering the product name, let me know if this works:

.pageHeader h1 {
text-align:center;
}

I too encountered this problem. I had to add some custom code to make it work: App_Code/ProductHelper.cs -> BuildProductOptions function: // Notice the extra variable "PlaceHolder phProductImage" public static Dictionary<int> BuildProductOptions(Product product, PlaceHolder phOptions, PlaceHolder ph...