Who has installed 7.0.7?

[compunerdy]

All I have seen so far is posts from people with issues after installing this upgrade. If you installed it and it works fine for you please speak up so we can see if we want to risk the upgrade or wait for it to be fixed.

[batmike]

I have installed 7.0.7 and after the last day having very slow performance I rechecked all the changes made between 7.0.6 and 7.0.7 - both the normal files and source code - and the thing that solved it for my install was removing the changed code that checks all associated categories in the /App_Code/PageHelper.cs file. The 7.0.6 code just pulled the first associated category while 7.0.7 loops through all categories and checks pageviews to pull the most used category ... at least that's what I read out of it.

Anyway, I went back to the 7.0.6 code block there and now my site is working as it did before.

[jmestep]

batmike - Thanks for figuring that out for me!
We have a couple of sites in development in Able 7.0.7 and I'm not working on either of them, but I was concerned after reading about your performance problems and knew that sooner or later I should try to find out what was going on so we wouldn't get hit with a problem when a site went live.
I can think of a reason that Able changed the code. For example, we have a merchant with products in a couple of categories and one of them is a new arrivals category. But if someone clicks on the other category and it is using the Category.aspx page, when they click on the product on that category page, the breadcrumbs point to the new arrivals category and they don't want that. But since the Category.aspx pulls products from subcategories, Able has to decide somehow what category id to pass. So it looks like the 7.0.7 code is looking for the most popular one, but that adds processing time.
In Able 5, you could select which category you wanted to be the more important one.

[AbleMods]

Anyway, I went back to the 7.0.6 code block there and now my site is working as it did before.

Awesome detective work !!

[propeerspk]

I am trying to upgrade my able commerce 7.0.6 to 7.0.7 version. But when I browse the install/upgrade.aspx it asks for license key and after entering license key it shows a button for "Continue" and when I hit this button site stops working and shows "internet explorer cannot display the page".

I followed the same instructions as given in able site help to upgrade but not able to upgrade.

Thanks
Pankaj Kaushik

[Logan Rhodehamel]

Thanks for the notes about this code change. This was the result of a fix for a bug report. We are reopening that bug report and will attend to the performance issue.

[jasonhendee]

We have our AC707 launch scheduled for the end of this week. Keep in mind this will be our first live experience with AbleCommerce as we are coming over from another shopping cart. We currently only have each product mapped to only one category - will this performance issue affect us? I haven't noticed any major performance issues in development, but we're also using a virtual dev server so any lags have been chalked up to that moreso than anything.

[Logan Rhodehamel]

I am attaching a modified file App_Data/PageHelper.cs. This is the 7.0.7 version of the file, but with the offending code removed. The change is around line 307 if you want to do a file comparison.

For anyone who has the performance issue, you can use this file until the official patch is released. We were able to solve the performance issue but it will need to be part of an official service release since it contains a new assembly and index for the database.

[jasonhendee]

Just installed the modded file - can't say that I'm aware of any difference in performance, but as I mentioned above, all of my products are currently only mapped to one category. That will change, however, as soon as we launch, the dust settles and we have time to go back in and map prods to multiple cats.

On a side note, you guys can stop trying to impress me now with your timely forum responses and fixes from very qualified developers. I've already bought the software

Seriously though, the support available and the professionalism exhibited here continues to impress me.

[batmike]

I as well have benefitted very much from having a great user community available here and a great amount of posts to search through ... which is where I often find most of my information.

Additionally, I'm glad this particular issue was able to be fixed up and look forward to the patch to see how that works out too.

@jasonhendee - I would think that you probably wouldn't notice much different partially because you don't have multi-linked categories but also because there's probably not too many pageviews in the database of a development site to filter through to determine the proper categories either. That's where my issue was along with the multi-linked categories. Anyway, good luck with your launch!

[Logan Rhodehamel]

This is correct... it has to do with the size of the pageview database so it's not likely to be noticeable on newer installations. The official patch resolves the issue by creating a scalar query specifically targeted at the information we need and also adding a database index to ac_PageViews to make that query as fast as possible.

@batmike how many records are in your ac_PageViews table? I'd like to make sure the performance of the patch is good in your scenario.

[scooter85]

We upgraded March 20th but have had nothing but problems. Our site was very slow after upgrading and received 1,000 errors in the error log a day. I reported the bug in our Support Case but got no response. After 10 days I called and Able said they were having problems with their Support Cases not working correctly. After that I got responses from a tech to help and it was figured out there were two issues. Below is information from our host tech does our upgrades.

1. Page Views was not configured to ever purge any records. In other words, every time a user viewed any page of the website, this was logged. I cleared out about a million records.

2. Anonymous users were not configured to purge either meaning any user/browser/internet bot that hit your website became a user. I cleared out about 700,000 records there.

I’ve set both of these to store info for 15 days only. You can adjust this in your cart settings.
After these 2 actions were taken, I purged the sites entire database taking it from 20GB->200Mb, which should be a huge performance boost.

Everything seemed to be running fine after the above changes but after about a week the site will shut down and display a "Service Unavailable" message when you try to go to the site. Our tech said something is shutting the system down and he can't seem to find out why it's shutting down. It just happened again last night at 10:00pm and it was off till about 10:00am. Very Frustrating! I'll let him know about the new page helper fix to see if that helps in anyway.

Thanks, Scott
www.DccCrafts.com

[Logan Rhodehamel]

2. Anonymous users were not configured to purge either meaning any user/browser/internet bot that hit your website became a user. I cleared out about 700,000 records there.

This is another problem we decided to address based on your support case. Coming soon will be an update for the Configure > Maintenance page that will allow you to see the size of the anonymous user database and also to trigger a manual cleanup based on the age of the records. We're also going to add a dashboard alert to warn you if you haven't specified a time to purge these records. We no longer will accept a blank value in that field and new installations will have the value set to 30 days by default.

[scooter85]

Our host tech emailed me that he had to reset the website to get it running again. He has no idea why it shuts down. This has happened two or three times since Mike Ward looked at our site and got with our host and fixed the other problems. Seems like it is getting to a certain point and then shutting down after so many days. I opened app.log and it is running maintenance exactly every minute deleting users and payments expired. There was no error listed before it shuts down. So it has been difficult to figure out this problem.
Thanks, Scott

[batmike]

Logan,

In response to your question, I currently have a little over 160,000 records in the ac_PageViews table and I have the history set to maintain for 5 days and delete ... which isn't really that long but in any case, that should help you decide what to do with the patch optimization.

Thanks!

[SteelArt]

Have these been fixed or are they still an issue ?

[jmestep]

Able is fixing the issues, but it doesn't look like they have come out with patches yet at help.ablecommerce.com.

[napacabs]

Has anyone installed 7.0.7 with all patches up to the last one "Performance issue were introduced in the \App_code\PageHelper.cs file.", any other issues that would keep one from upgrading?

[jmestep]

I have done it on a test site and the problems are fixed by the patches.

[batmike]

We've been using it successfully on our live site for about a month now. The PageHelper.cs issue was the big one and with that fixed, everything else works well on our site.

[Logan Rhodehamel]

The latest official patches for 7.0.7, including the correction for this page view problem are listed here:
http://help.ablecommerce.com/upgrades/a ... atches.htm

[franksaraceno]

I've been using 7.0.7 for couple of weeks now with not really any problems. I started with a fresh install.
Able has been a breath of fresh after air 2 years of the horror show called aspdotnetstorefront,
but I won't get into that right now.

I've had problems with IE8 and IE9. Problem is when you select a new category, content page loads in new products
the whole page or content area resizes. The page rezies while trying to render the product images.
The product images start out to right side of page and then IE resizes them
back into the content area. So the whole page goes from wider to where is should be seemingly defeating the whole
ajax thing. I don't know if this is an AJAX or css issue. (Firefox displays everything fine.)

Has anyone seen this kind of odd resizing issues with with IE? I've tried 8 and 9 and see the same thing.

If you look at the site in IE, http://greenhomediscounts.com and move through the categories you'll see
what I'm talking about.

I looked on stack overflow and post suggest to change W3C to W34 in the master pages.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"

Just wanted to check in forum before changing anything in a master page.
Any help greatly appreciated.


Thanks.

[jasonhendee]

Able has been a breath of fresh after air 2 years of the horror show called aspdotnetstorefront,
but I won't get into that right now.

That made me chuckle this morning... we, too switched from ADNSF to Able about a month and a half ago, and it's crazy how things "just work" with this package, isn't it?

Anyhow, we are on 7.0.7 & I do see what you're talking about in IE; other browsers load new content much more smoothly, whereas IE appears to do a much more sluggish "full" reload of the content section.

[franksaraceno]

Using Able and Dataport I imported 11k products in about 2 minutes. It took days to do this kind of thing with ASPDNSF and third party addons.
I'd like to see "Delete' feature in the dataport tool.

This content rendering issue in IE drives me nuts and I've seen it in different carts.
My content section is at about 810 pixels wide. Using IE, whenever I click on a new category and the images reload to the content page, the
whole page stretches from full screen back to the 810 pixel wide. Is anyone else seeing this kind of behavior with IE?

[jmestep]

SR1 for 7.0.7 is out and it may or may not fix the IE problem - it does fix one of them.
http://help.ablecommerce.com/upgrades/a ... ease_1.htm