an ASP.NET Open Source CMS & eCommerce platform
Search:
Last Post 1/13/2011 10:12:52 AM By lukezy. 1 replies.
1/12/2011 3:43:17 PM
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Attributes Bug
 What attributes supposed to do? I vreated a global Attribute. then added that attribute to a product. Now 10 rows of attributes is created and listed. When I delete them all and then press update
in Admin/product then everything is refreshed. the attribute rows are not deleteable. 
 
 
 
1/13/2011 10:12:52 AM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Attributes Bug
Looks like you encoutered the old bug that was fixed in the latest version. You can manually remove these attributes by using the following sql.
 
 
            DELETE FROM dbo.DSC_Product_Attribute_Value
            FROM dbo.DSC_Product_Attribute_Value pav
            JOIN dbo.DSC_Product_Attribute_Map pam
                        ON pam.productAttributeId = pav.productAttributeId
            WHERE pam.productId = @productId
 
            DELETE FROM dbo.DSC_Product_Attribute_Map
            WHERE productId = @productId
DotShoppingCart Staff