HomeHome Product Discus... Product Discus...SmithCartSmithCartError working with categories (v2.5)Error working with categories (v2.5)
Previous
 
Next
New Post
1/30/2010 2:15 PM
 
David Amm
No Ranking

Joined: 11/19/2009
Posts: 30

I have run into a problem with editing categories (see error details below). The steps I carried out were as follows:
1. Add 2 categories
2. Add 2 products to category 1
3. Delete category 2
4. Attempt to rename category 1
5. Attempt to add new category 3
How do I fix this?
David
InnerException: Parameter count does not match Parameter Value count.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: Microsoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValues
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: Parameter count does not match Parameter Value count. ---> System.ArgumentException: Parameter count does not match Parameter Value count. at Microsoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValues(SqlParameter[] commandParameters, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at Smith.DNN.Modules.BuyNow.SqlDataProvider.UpdateCategory(Int32 categoryID, String categoryName, Int32 sortOrder, Boolean share, Int32 tabModuleId, Int32 parentID, Int32 portalID) at Smith.DNN.Modules.BuyNow.ProductsController.UpdateCategory(CategoryInfo objCategory) at Smith.DNN.Modules.BuyNow.ManageCategories.grdCategories_RowUpdating(Object sender, GridViewUpdateEventArgs e) at System.Web.UI.WebControls.GridView.OnRowUpdating(GridViewUpdateEventArgs e) at System.Web.UI.WebControls.GridView.HandleUpdate(GridViewRow row, Int32 rowIndex, Boolean causesValidation) at System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) at System.Web.UI.WebControls.GridView.OnBubbleEvent(Object source, EventArgs e) at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) at System.Web.UI.WebControls.GridViewRow.OnBubbleEvent(Object source, EventArgs e) at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) at System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---
 
New Post
1/31/2010 4:24 PM
 
Dave Smith
1st Level Poster

Joined: 7/28/2009
Posts: 1452

Did you get this after upgrading the cart from a previous version or is this on a brand new install?

At your service,
Dave Smith
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
1/31/2010 11:29 PM
 
Dave Smith
1st Level Poster

Joined: 7/28/2009
Posts: 1452

Can you confirm that your Smith_UpdateCategory stored procedure looks like this, if not run this substituting your objectqualifier in front of the table name.

ALTER PROCEDURE [dbo].[dnn_Smith_UpdateCategory]
@CategoryID int,
@CategoryName varchar(50),
@SortOrder INT ,
@Share BIT,
@TabModuleId INT,
@ParentID INT
AS

UPDATE dnn_Smith_Category SET
[CategoryName] = @CategoryName ,
[SortOrder] = @SortOrder ,
[Share] = @Share ,
[TabModuleId] = @TabModuleId,
[ParentID] = @ParentID
WHERE
[CategoryID] = @CategoryID

At your service,
Dave Smith
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
2/1/2010 10:09 AM
 
David Amm
No Ranking

Joined: 11/19/2009
Posts: 30

This site was previously running Alicommerce, which was full uninstalled prior to installation of Smith Cart 2.5.

I checked the UpdateCategory stored procedure and it was correct.
 
New Post
2/1/2010 1:23 PM
 
SuperUser Account
No Ranking

Joined: 6/2/2009
Posts: 36

It looks like you might have a dll out of sync. I just emailed you a patch.
 
New Post
2/2/2010 1:03 PM
 
David Amm
No Ranking

Joined: 11/19/2009
Posts: 30

In the end I had to uninstall and reinstall v2.51. Fortunately I was able to copy all th eprduct, category and manufacturer data into an excel sheet which I then imported using the import function.

NB. v2.51 gives an error message on installation: Stored Procedure Smith_UpdateProducts already exists. However, the install was successful.
 
New Post
2/2/2010 2:11 PM
 
Dave Smith
1st Level Poster

Joined: 7/28/2009
Posts: 1452

I just uploaded a new build to snowcovered that fixes this. The issue was in the install script for the new feature we just added that allows you to entered fixed shipping costs by product. Please download the new build from snowcovered and install.

At your service,
Dave Smith
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
 Page 1 of 1
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartError working with categories (v2.5)Error working with categories (v2.5)




Questions? Contact us for answers!

Contact Us!