Search found 117 matches

by euroluxantiques
Tue Jan 14, 2014 9:14 pm
Forum: AbleCommerce GOLD
Topic: Errors in Anonymous User Maintenance
Replies: 24
Views: 32921

Re: Errors in Anonymous User Maintenance

I ran the code from Mazhar's post December 5, 2013, and got:

ac_Users_ac_Orders_FK1 0 SET_NULL NO_ACTION
ac_Users_ac_PageViews_FK1 0 NO_ACTION NO_ACTION

Running AbleCommerce for ASP.NET
VERSION: 7.0.86.6169
Running on SQL Server 2008 R2
by euroluxantiques
Tue Jan 14, 2014 9:06 pm
Forum: AbleCommerce GOLD
Topic: Errors in Anonymous User Maintenance
Replies: 24
Views: 32921

Re: Errors in Anonymous User Maintenance

I just saw the latest posts in this topic, so I ran the SQL code posted by Mazhar. I returned 0 records, so it seems the code didn't do anything for me. I'm still generating tons of errors every day. I'm around 26,000 today, and I clear this out daily to keep the error log from getting into the mill...
by euroluxantiques
Fri Nov 22, 2013 1:35 pm
Forum: AbleCommerce GOLD
Topic: Temporary/Cached Product Images Problem
Replies: 1
Views: 2061

Temporary/Cached Product Images Problem

We have our product images on a separate image server. In the original version of Gold, you could not use a web link as a product image. So, I set up sym links and that worked somewhat. In R6, you can supposedly use web links as the product images, like you used to be able to do in the older version...
by euroluxantiques
Tue Oct 15, 2013 8:59 pm
Forum: AbleCommerce GOLD
Topic: Errors in Anonymous User Maintenance
Replies: 24
Views: 32921

Re: Errors in Anonymous User Maintenance

Still generating these types of errors very frequently and having to clear them manually. Can someone please suggest a solution? Thanks!
by euroluxantiques
Thu Oct 10, 2013 8:51 am
Forum: AbleCommerce GOLD
Topic: Checkout by Amazon
Replies: 33
Views: 52079

Re: Checkout by Amazon

You've got that right. Amazon support is horrible. I know more about their system than most of the folks I've spoken with over there, and that's not saying much. Katie, is that patch you listed above the one you mentioned for a few posts previous? I am running build VERSION: 7.0.86.6169. Thanks.
by euroluxantiques
Tue Oct 08, 2013 5:51 am
Forum: AbleCommerce GOLD
Topic: Moving Hosting & Database
Replies: 5
Views: 3835

Re: Moving Hosting & Database

I've got it working now. It just suddenly stopped doing that loop. Thanks!
by euroluxantiques
Mon Oct 07, 2013 10:11 am
Forum: AbleCommerce GOLD
Topic: Moving Hosting & Database
Replies: 5
Views: 3835

Re: Moving Hosting & Database

Thanks, but still getting the same agreement loop. I copied all files over to the new server, passed the permissions check, and am now at the screen where I have to agree to the T&C. I check the box, click Continue and it goes right back to the agreement page. This is where I was having the problem ...
by euroluxantiques
Sun Oct 06, 2013 10:36 am
Forum: AbleCommerce GOLD
Topic: Moving Hosting & Database
Replies: 5
Views: 3835

Moving Hosting & Database

I've decided to move my hosting and have transferred all my website files to the new host and installed SQL Server 2008 r2. I unchecked the SSL box in my current website and backed up the database and transferred to the new host. Now when I try to finish the setup process, I go to the install direct...
by euroluxantiques
Mon Sep 30, 2013 2:26 pm
Forum: AbleCommerce GOLD
Topic: Checkout by Amazon
Replies: 33
Views: 52079

Re: Checkout by Amazon

Thanks, Katie. With you finding one that works, I think I identified the problem. I found a bunch of products in ac_Products with ShippableId=0, which is the default value assigned in the table. We were not passing the value "1" when we were loading products via our product loader. I updated the def...
by euroluxantiques
Mon Sep 30, 2013 2:07 pm
Forum: AbleCommerce GOLD
Topic: Errors in Anonymous User Maintenance
Replies: 24
Views: 32921

Re: Errors in Anonymous User Maintenance

I checked the update/delete for ac_Users_ac_PageViews_FK1 and they are both set to No Action. Meanwhile, I have over 1 million error messages in the website that have to be cleared manually ever few days.
by euroluxantiques
Tue Sep 24, 2013 2:15 pm
Forum: AbleCommerce GOLD
Topic: Errors in Anonymous User Maintenance
Replies: 24
Views: 32921

Re: Errors in Anonymous User Maintenance

name delete_referential_action_desc update_referential_action_desc
ac_Users_ac_PageViews_FK1 NO_ACTION NO_ACTION
by euroluxantiques
Sat Sep 21, 2013 9:16 am
Forum: AbleCommerce GOLD
Topic: Errors in Anonymous User Maintenance
Replies: 24
Views: 32921

Errors in Anonymous User Maintenance

Our site is generating 1000s of errors in our Error Log daily for anonymous user maintenance. The types of errors we keep getting are: Error in user maintenance; could not delete user id 2711244 Exception: could not execute native bulk manipulation query:DELETE FROM ac_Users WHERE UserId = :userId[S...
by euroluxantiques
Sat Sep 21, 2013 8:38 am
Forum: AbleCommerce GOLD
Topic: Checkout by Amazon
Replies: 33
Views: 52079

Re: Checkout by Amazon

The problem is that we do "free shipping" on everything in the store. Of course, the amount of shipping is buried in the price, so we do not need to calculate shipping, unless the customer wants faster domestic shipping or it is an international order. I do have UPS and USPS set up as integrated car...
by euroluxantiques
Thu Sep 19, 2013 2:20 pm
Forum: AbleCommerce GOLD
Topic: Checkout by Amazon
Replies: 33
Views: 52079

Re: Checkout by Amazon

I'm not sure if this helps, but this is the error message that shows in the dashboard: An error has occured at https://www.euroluxantiques.com/Checkout/Amazon.aspx?purchaseContractId=xxxxxxxxxx Exception: Exception of type 'System.Web.HttpUnhandledException' was thrown. Stack Trace: at System.Web.UI...
by euroluxantiques
Thu Sep 19, 2013 2:14 pm
Forum: AbleCommerce GOLD
Topic: Checkout by Amazon
Replies: 33
Views: 52079

Re: Checkout by Amazon

I did add http://www. your domain .com/AmazonIPN.ashx to our merchant url in Checkout Pipeline in Amazon, BTW.
by euroluxantiques
Thu Sep 19, 2013 2:13 pm
Forum: AbleCommerce GOLD
Topic: Checkout by Amazon
Replies: 33
Views: 52079

Re: Checkout by Amazon

Nope. Still not working. I have been on the phone with Amazon for HOURS, and they are totally no help at all. I have followed the instructions step-by-step here: http://help.ablecommerce.com/mergedProjects/ablecommerceGold/configure/payments/gateways/amazon_checkout.htm I feel like this is actually ...
by euroluxantiques
Mon Sep 16, 2013 4:11 pm
Forum: AbleCommerce GOLD
Topic: Checkout by Amazon
Replies: 33
Views: 52079

Re: Checkout by Amazon

It seems we can't see the shipping method dialog box. The Recalculate and Place Order buttons seem to be set to Hidden via in-line styles. I assume once a shipping method is selected, the buttons would then be displayed. However, we can't see the shipping methods, almost like Amazon isn't returning ...
by euroluxantiques
Mon Sep 16, 2013 3:32 pm
Forum: AbleCommerce GOLD
Topic: Checkout by Amazon
Replies: 33
Views: 52079

Re: Checkout by Amazon

We've tried again to set this up. Amazon is no help at all. We have followed the setup, gotten the Merchant ID, Secret and Access keys, and filled them in properly. When you choose Amazon Checkout on the website, it actually does talk to Amazon enough to get a list of shipping addresses from Amazon....
by euroluxantiques
Sat Sep 07, 2013 12:41 pm
Forum: AbleCommerce GOLD
Topic: Checkout Custom Header Problem
Replies: 13
Views: 8362

Re: Checkout Custom Header Problem

It's R5, and it doesn't show up with Firebug. Works perfectly on all other pages and the custom footer shows up fine on the checkout pages. I was looking through the code in Checkout to see if they had the store header hard-coded to default or something, but I don't see the problem. You should be ab...
by euroluxantiques
Fri Sep 06, 2013 2:47 pm
Forum: AbleCommerce GOLD
Topic: Checkout Custom Header Problem
Replies: 13
Views: 8362

Checkout Custom Header Problem

We have a custom header that I want to use on my checkout pages. I have gone into Layouts/Fixed/Base.Master (because you can't modify the layout directly in admin) and changed the Header and Footer references to: <%@ Register src="~/ConLib/Custom/StoreHeader.ascx" tagname="StoreHeader" tagprefix="uc...
by euroluxantiques
Sun Apr 14, 2013 5:25 pm
Forum: AbleCommerce GOLD
Topic: Offsite Image Hosting and Symlinks
Replies: 5
Views: 5000

Re: Offsite Image Hosting and Symlinks

Physically copying all the product images from our offsite image server to the Assets folder seems to do the trick, but of course, it takes time and storage, and you have to keep it in sync. Not ideal, but it is what it is at this point. Please implement product image URL capability in the very near...
by euroluxantiques
Sun Apr 14, 2013 12:48 pm
Forum: AbleCommerce GOLD
Topic: Offsite Image Hosting and Symlinks
Replies: 5
Views: 5000

Re: Offsite Image Hosting and Symlinks

Thanks. This is VERY important as my product image popups and featured products are not rendering at the moment, and all I can come up with is the symlink problems.
by euroluxantiques
Sun Apr 14, 2013 12:47 pm
Forum: AbleCommerce GOLD
Topic: Treeview for gold?
Replies: 24
Views: 21382

Re: Treeview for gold?

Can you post a link to the example you're working on? I want to have a drop-down nested category using CSS and SimpleCategory conlib, but I haven't been able to figure out how to do this since the code in Gold changed. I want to see if what you've got going on could help me out if I change it a litt...
by euroluxantiques
Tue Apr 09, 2013 8:05 am
Forum: AbleCommerce GOLD
Topic: Offsite Image Hosting and Symlinks
Replies: 5
Views: 5000

Offsite Image Hosting and Symlinks

Because Gold can't handle offsite image URL for products, I have had to create symlinks from the Assets\ProductImages folder to the url where the product images are located. The images seem to load inconsistently at best. In prior versions of AbleCommerce this same image server did absolutely fine w...
by euroluxantiques
Mon Mar 25, 2013 3:01 pm
Forum: AbleCommerce GOLD
Topic: Email Button in BuyProduct.aspx
Replies: 3
Views: 3481

Re: Email Button in BuyProduct.aspx

Thanks for this. I modified it and have it working. I had to add a using AbleCommerce.code statement to get the PageHelper to work.