HomeHome Product Discus... Product Discus...SmithCartSmithCartParameter count does not match Parameter Value count.Parameter count does not match Parameter Value count.
Previous
 
Next
New Post
11/27/2011 7:03 PM
 

I purased and installed smith cart without any errors. When I try to add buy now module, I get an error "Parameter count does not match Parameter Value count.". I am using the latest version of smith cart

From event viewer...

 

AssemblyVersion: 6.1.1

PortalID: 0

PortalName: RelayBuilder

UserID: 1

UserName: host

ActiveTabID: 181

ActiveTabName: store

RawURL: /store/tabid/181/Default.aspx

AbsoluteURL: /Default.aspx

AbsoluteURLReferrer: http://relaybuilder.com.dnnmax.com/store/tabid/181/Default.aspx

UserAgent: Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)

DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider

ExceptionGUID: 52d47e68-b81c-4de7-bf4e-bb18aea59c65

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.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at Smith.DNN.Modules.BuyNow.SqlDataProvider.ListProductByFilter(Int32 PageNum, Int32 Records, String catergoryName, String Filter, Int32 tabModuleId, Int32 PortalId, String MySort, String VendorID, String PIDList) at Smith.DNN.Modules.BuyNow.ProductsList.bindDtProductList() at Smith.DNN.Modules.BuyNow.ProductsList.Page_Load(Object sender, EventArgs e) at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---

Source:

Server Name: Generic118

 
New Post
11/28/2011 8:18 AM
 

After searching around for the afternoon, I figured out that the trial version I uninstalled left behind several files, tables, and stored procedures. Once I removed them, and installed again, it seems to be working.

 
New Post
11/28/2011 3:55 PM
 
Hi Marc,

Which version of the Trial did you uninstall?

Was there a specific reason for uninstalling the Trial version before installing the full version?

When uninstalling the SmithCart module I would recommend doing a clean install of the cart as follows:

1. From the dnn->host menu uninstall all Smith modules; Smith.BuyNow, Smith.AffliateTracking, Smith.Category, etc. 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 Smith files in /desktopmodules are deleted and the folders are removed

4. Install the latest cart module

5. Configure the cart settings and test

Thanks,
 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartParameter count does not match Parameter Value count.Parameter count does not match Parameter Value count.