HomeHome Product Discus... Product Discus...SmithCartSmithCartParameter Count ErrorParameter Count Error
Previous
 
Next
New Post
4/13/2010 3:15 PM
 
Dawn Hopkins Hopkins
No Ranking

Joined: 4/13/2010
Posts: 3

Just trying to get the cart setup now on a new install of DNN CE 5.3.1. When trying to add a product I get this error:

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.AddProducts(Int32 categoryID, String manufacturer, String modelNumber, String modelName, String productImage, String thumbnailImage, Decimal unitCost, Decimal memberPrice, Int32 quantityOnHand, String summary, String description, String downloadUrl, Boolean featured, Boolean archived, Decimal weight, Int32 sortOrder, Boolean excludeCoupon, Int32 items, Boolean share, Int32 tabModuleId, String createdByUser, DateTime createdDate, Boolean logicallyDeleted, Boolean recurring, String recurringInterval, Int32 recurringOccurances, String urlGUID, Boolean encryptUrl, String addDnnRole, Boolean requireLogin, Boolean usePriPriceWght, Int32 bundleID, String roleExpireDays, Int32 subCategoryID, Boolean taxExempt, Int32 PortalID, String affiliateUrl, Boolean requireCoupon, Boolean showPDUDF) at Smith.DNN.Modules.BuyNow.ProductsController.AddProducts(ProductsInfo objProducts) at Smith.DNN.Modules.BuyNow.AddProducts.AddProduct() at Smith.DNN.Modules.BuyNow.AddProducts.btnSubmit_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.Button.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 ---

Using cart version 2.74.0, which was upgraded from whatever version was on snowcovered.
 
New Post
4/13/2010 4:30 PM
 
Scott Kelly
1st Level Poster


Joined: 3/11/2010
Posts: 1979

Did you upgrade from a previous version of the cart or is this a brand new install?

Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
4/14/2010 6:14 AM
 
Dawn Hopkins Hopkins
No Ranking

Joined: 4/13/2010
Posts: 3

I installed the one one snowcovered, then got a notice after the purchase to download and install the latest version from Smith Cart.

Do I need to unistall. And reinstall.
 
New Post
4/14/2010 10:10 AM
 
Scott Kelly
1st Level Poster


Joined: 3/11/2010
Posts: 1979

yes can you try the unistall and reinstall

Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
4/14/2010 12:22 PM
 
Dawn Hopkins Hopkins
No Ranking

Joined: 4/13/2010
Posts: 3

That seemed to correct the issue. You should update the download on Snowcovered so others don't waste their afternoons.

Thanks
 
New Post
4/16/2010 10:08 AM
 
Scott Kelly
1st Level Poster


Joined: 3/11/2010
Posts: 1979

Already done!

-Scott

Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
5/1/2010 9:44 AM
 
No Ranking

Joined: 1/1/0001
Posts: 0

I'm having this problem going from the trial to the snowcovered version. If I uninstall will I loose all my products?
 
New Post
5/1/2010 12:22 PM
 
Dave Smith
1st Level Poster

Joined: 7/28/2009
Posts: 1452

What version of the cart are you trying to upgrade from? To answer your question yes when you delete the module thru the dnn - host - module definitions menu the tables are deleted.

There are a couple options for you to upgrade and save your data if installing the new module over the old one isnt working. For both of these options you should backup your database first:

1. This is probably the easiest option. Copy the tables to a test/backup database in sql server. See these 2 forum posts for more info.

http://www.smith-consulting.com/forums/forumid/1/threadid/357/scope/posts.aspx
http://www.smith-consulting.com/forums/forumid/1/threadid/300/scope/posts.aspx

Instructions to install a clean cart build
---------------------------------------------

1. From the dnn->host menu uninstall all 6 modules; Smith.BuyNow, Smith.AffliateTracking, Smit.CategoryMenu, Smith.MiniCart, Smith.MyAccount and smith.featuredproducts. Make sure you check the delete files box when you uninstall
2. Confirm that all stored procs and tables with a prefix of smith in your database are deleted
3. Confirm that all files in /desktopmodules/smith.buynow are deleted and the folder is removed
4. Install the latest cart module
5. Configure the cart settings
6. Add one category, manufacturer and product and test



2. Apply the stored procedures and dlls manually. Copy all the dlls from the zip file to your \bin folder. Run the stored procs from the sqlprovider files in the zip in a query window in sql server. Before you run the stored procs you will have to to a search and replace the {databaseOwner}[{objectQualifier} with your object qualifier you entered when you installed dnn

At your service,
Dave Smith
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
5/1/2010 1:16 PM
 
No Ranking

Joined: 1/1/0001
Posts: 0

The trial was 2.64 and the version I bought was 2.76.
 
New Post
5/1/2010 2:18 PM
 
Dave Smith
1st Level Poster

Joined: 7/28/2009
Posts: 1452

There was an issue in the install script that prevented some of the new stored procs from being run during an upgrade. This was fixed in v2.76 so if you are running 2.6 you will have to follow the instructions outlined above to upgrade and save your store data.

At your service,
Dave Smith
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
 Page 1 of 1
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartParameter Count ErrorParameter Count Error




Questions? Contact us for answers!

Contact Us!