dashCommerce

Those of you who are following the dashCommerce svn will notice since 3.01 there has be a couple of notable bug fixes and features here's a list of some of them. I will try to keep this list updated untill the next release so we know what has changed.

BUGS

• Issue with the PayPal Service where an OR should have been an AND for credit card processing.  Patch thanks Corey10e!
• Typo in Order Received - Merchant notification email
• Various Licensing updates and bug fixes.
• Sku may be the same, but attributes are not. This should result in 2 different items in basket.
• Infinite redirect bug cause by website URL having special characters.
• Cannot select an uploaded image with an apostrophe in the file name.
• Coalation conflict errors reported by some SQL databases when running scripts.
• Memory leak on admin imageselector and product image edit when scaling images.
• btnProcessOrder_Click sometimes being called twice while using Firefox 3.0 in .NET 3.5.
• Infinite redirect bug if using a Apache SSL cluster based hosting (eg. Mosso) and have Require SSL enabled in site settings.
• Fixed bug where if you selected express checkout on cart.aspx and then went back and decided to checkout with a card it would throw and error until you clear your cart.
• Fixed bug where it didn't allow you to upload an image if the extension wasn't all lower case e.g. .Jpg or .GIF
• Analytics tag was only displaying on the homepage moved it to master page so it should now track all pages.
• Various bug fixes and tweaks to Install pages.
• Various performance tweaks OrderController was loading new Product but not doing anything with it and re-arranged attribute selector logic so it doesn't need to load new SKU() if AllowNegativeInventories == true;
• Was hitting the DB 2 to 3 times to load a products SkuCollection on Page_Load should do it in 1 hit now improving product page load speed.
• Exception page wasn't using selected site theme.
• Dollar Sign ($) or other special charectors in Attribute Names breaks the product page on client side.
• Collection was modified; enumeration operation may not execute bug when trying to load descriptors on product page.
• Chrome and Safari App_Browser files. Thanks to Dic k
• On Checkout after selecting a shipping method if you change your shipping address it fails to re-get shipping options throwing an exception.
• Some workaround on Uploading images in medium trust hosting.
• Wasn't aligning right content with main content blocks on some Content Managed pages updated .css
  
• ViewState was hitting 12kb on certain pages especially on the Product and Catalog pages. This has been tweaked and should now be under 1kb and improve page download and upload (post) speeds throught the site.
• Removed overlib reference from masterpage we are not actually using it on the main site anywhere apart only in the admin side so we should save a HTTP Request on every page bieng hit.
• Removed submodel script and css from masterpage in favour of thickbox which we use for the lightbox style images on the product page, this should save us a further 3 HTTP Requests on every page load throughout the site.
• Theme CSS's were being referenced twice on all pages throught the site causing at least 3 extra unnecessary HTTP Requests on every page load.

FEATURES

• NullPaymentProvider for testing and transaction recording.
• Validation Groups to the Payment Accordion so that you can continue with the Coupon Accordion. Patch thanks Corey10e!
• Filtering to the dashCommerceTaxProvider as some clients wish to only charge for certain states / provinces.
• Shipping Method to order.ToHtml so it will display in receipts.
• Edit link on product details to allow admin to jump straight into product edit.
  
• Site Setting to specify default sorting on Catalog List, Order by Date, Title, Cost etc
  
• Ability to Delete images from server.
• Sorting on image picker to display most recently uploaded ones first. (Might not work with some Medium Trust Hosting)
  
• Site Setting ability to enable or disable ratings for products.
• Contact Us content provider allows you to create a content page with a contact email form. Example, To Install to existing dC setup run following SQL: INSERT [dbo].[dashCommerce_Content_Provider] ([Name], [ViewControl], [EditControl], [StyleSheet], [CreatedBy], [ModifiedBy]) VALUES (N'Contact Us', N'~/controls/content/ContactUs.ascx', '~/admin/controls/content/EditContactUs.ascx', NULL, N'SYSTEM', N'SYSTEM')
  
• Added support for Maestro, Switch and Solo debit cards and updated Paypal Pro.
• Added breadcrumbs on product page, if product has more than one categories it displays the first crumb.
• Adding a try match for state when the country is selected.
• Added Permission step in Install with tests to determine permissions are correctly set up.
• Attribute selector only display SKU's in stock in DropDownList if AllowNegativeInventories == false;
• Re-write of the error logging system to allow us to find those bugs that are not reported with more info for debugging. More Info
• dC will now pass the IPN notify_url to PayPal for standard transactions allowing you to have multiple dC installs with one PayPal account. Thanks to  gnomee2 for the info. More Info
• Adding ability to edit addresses in My Account --> My Addresses. Thank you to crholliday for this patch!
• Polish translations for Navigation. Thank you Midgar!
• Adding customerinformation.aspx page that lets you perform the MyAccount functions for the client. Thanks again to crholliday.
• Added support windows authentication for connecting to trusted databases.
• Added a Test Connection button on database setup page.
• Copy product into a new listing allowing you to quickly add similar products.
• Show shipping costs on cart if enabled so customers can see how much it will cost to ship before checkout.
• Added a new narrow by Sub-Category Widget to Catalog Page.
• Added Debug and Release configuration files with post-build event for easier deployment.
• MailSettings, SKU's and Catalog Breadcrumbs will be cached if enabled.
• Updated jQuery library to 1.3.2 and switched from lightbox to Thickbox plugin for the lightbox model images.

KNOWN ISSUES

• If you change the Base SKU of a product which already has SKU's saved then you canot add it to cart.
• You cannot change attributes for a product where the SKU's have already been saved.
• UK Debit card are only supported in by Paypal Pro UK see post bellow.
• Random "An entry with the same key already exists." errors logged, it's a known Subsonic 2.0.3 bug and aparently fixed in Subsonic 2.1
• Subsonic 2.0.3 has a bug with some laguages (Turkish) and aprently fixed in Subsonic 2.1

dashCommerce repository: http://mettlesystems.svnrepository.com/svn/dashCommerce/trunk/dashCommerce/

Hi Naz,

 It's good to see you always put comments on check-ins. I noticed a bug concerning the caching, the cache for the product breadcrumbs is never removed when the categories for a product are changed.

Dic k:

Hi Naz,

 It's good to see you always put comments on check-ins. I noticed a bug concerning the caching, the cache for the product breadcrumbs is never removed when the categories for a product are changed.

Done.... :) Revision 242

Thanks for reporting the issue...

You know PayPal will only process Maestro, Switch and Solo card for people with the PayPal UK Pro product correct. A US PayPal Pro account will not work.

Stupid question, but where do we download these fixes?

grupe:

You know PayPal will only process Maestro, Switch and Solo card for people with the PayPal UK Pro product correct. A US PayPal Pro account will not work.

Yes one of the things we should maybe do is allow some way for the site admin to specify the different card types supported in General Payment Settings. That way for example if your site uses a payment provider that doesnt accept AMEX or UK Debit cards you can specify the ones you actually support. Currently the only way is to remove card types from the hard coded dropdownlist on checkout.aspx.

I could add some validation and rely on the SiteSettings.Currency field to determine wether to display those card types eg if Currency = "GBP" but thats just an assumption as you could still have a US paypal pro account even though your site is in GBP or your site can be in USD but you have a Pro UK account.

These changes and fixes are not schedule for a release yet but if you want to access the current SVN repository for testing it's available at

http://mettlesystems.svnrepository.com/svn/dashCommerce/trunk/dashCommerce/

Revision 261 includes.

Complete re-write of the error logging system to allow us to find those bugs that are not reported by dashCommerce with more information for helping us debug them.

1. All thrown exceptions now logged automatically no need for try, catch blocks unless you want to handle the exception, this even includes providers!

- Currently it's set to log all errors including 404's this many be usefull for some or just annoying for others anyways we store them as different types.

- The current codebase has a lot of methods with Try, Catch with throw; in the catch those code can be cleaned up and removed.

2. Much more useful information is stored on each exception for debugging including Authenticated User Name, User Agent (Browser, Goglebot etc), Remote Host, Referrer, Cookie/Form/QueryString Data, Script Name, Machine Name.

- This required a scheme change on the dashCommerce_Core_Log table I felt the extra information was very usefull and since the table is only for logging without any sensitive data it was safe to add those fields.

3. Removed Dependencies/log4net.dll

- Not needed anymore all logging is now handled by Core.Logger itself.

4. Removed Insert and FetchAll Logs stored procedures.

- We can just use Subsonic to write the logs and fetch them.

All new installs would have to do anything but to upgrade an existing site run the following SQL

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dashCommerce_Core_Log]') AND type in (N'U'))
DROP TABLE [dbo].[dashCommerce_Core_Log]
GO
CREATE TABLE [dbo].[dashCommerce_Core_Log](
    [LogID] [int] IDENTITY(1,1) NOT NULL,
    [LogDate] [datetime] NOT NULL CONSTRAINT [DF_Script_Message_Log_Log_Date]  DEFAULT (getdate()),
    [Message] [text] NULL,
    [MessageType] [tinyint] NOT NULL,
    [UserAgent] [varchar](256) NULL,
    [RemoteHost] [varchar](256) NULL,
    [AuthUser] [varchar](64) NULL,
    [Referer] [varchar](512) NULL,
    [MachineName] [varchar](32) NULL,
    [FormData] [text] NULL,
    [QueryStringData] [varchar](512) NULL,
    [CookiesData] [varchar](2048) NULL,
    [ExceptionType] [varchar](256) NULL,
    [ScriptName] [varchar](256) NULL,
    [ExceptionMessage] [varchar](512) NULL,
    [ExceptionSource] [varchar](256) NULL,
    [ExceptionStackTrace] [varchar](2048) NULL,
 CONSTRAINT [PK__dashCommerce_Cor__457F2FDE] PRIMARY KEY CLUSTERED
(
    [LogID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

Sorry had to be done

The logging changes are a significant improvement. Thanks!

omg!

I made full translation to polish but I never got the last reply with compiled source to check all the spelling and staff :/ after that the contact just died on me. please contact me at adam.grodzki@midgar.pl

and I will finish the full translation?

This list is the final list for 3.2 RC version? because it posted half year ago. is it updated?

Thank you.