HomeHome Product Discus... Product Discus...Payment Registr...Payment Registr...Parameter count does not match Parameter Value count. Parameter count does not match Parameter Value count.
Previous
 
Next
New Post
12/9/2011 12:49 AM
 

I'm having an error that I have seen on numerous posts, but have been unable to resolve so here it is.

Have Smith Payment Pro, using Auth.net (AIM), SSL installed, dnn 5.6.1

I tried the following steps, any other ideas?

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

Here's my error:

AssemblyVersion: 5.6.1
PortalID: 0
PortalName: The HNBA Legal Education Fund
UserID: -1
UserName
ActiveTabID: 74
ActiveTabName: Donate
RawURL: /Donate.aspx?ctlname=Confirm
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: https://www.hnbafund.org/Donate.aspx?ctlname=Confirm
UserAgent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.2 (KHTML, like Gecko) Chrome/15.0.874.121 Safari/535.2
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 4e445ca2-ca23-4408-aaaf-1bbfd2d941be
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.Registration.SqlDataProvider.UpdateCustomer(Int32 customerID, String firstName, String lastName, String address1, String address2, String city, String state, String country, String zip, String homePhone, String cellPhone, String workPhone, String email, String password, Boolean contact, String dNNLogin, Boolean subscriptionCancelled, String comments, String udf, String udtb, String udtb2, String udtb3, String fileUpload, String companyName) at Smith.DNN.Modules.Registration.RegistrationController.UpdateCustomer(CustomerInfo objCustomer) at Smith.DNN.Modules.Registration.Confirm.btnSubmit_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) at System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.ImageButton.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 ---
Source
Server Name: CLE02WEB06

 
New Post
12/9/2011 1:02 AM
 

New update - upgraded to 5.6.5 and it worked.

Case closed.

 
New Post
12/9/2011 2:29 AM
 
I'm still at it. It was working great processing transactions with Auth.net in test mode (on their end), then I switch that to live and Bam. Same error. This is not fixed yet. Here's the full error. Any assistance will be appreciated.

AssemblyVersion: 5.6.5
PortalID: 0
PortalName: The HNBA Legal Education Fund
UserID: -1
UserName:
ActiveTabID: 74
ActiveTabName: Donate
RawURL: /Donate.aspx?ctlname=Confirm
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: https://www.hnbafund.org/Donate.aspx?ctlname=Confirm
UserAgent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.2 (KHTML, like Gecko) Chrome/15.0.874.121 Safari/535.2
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: a0ab6644-6087-4511-8d46-c39c0a6da05e
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.Registration.SqlDataProvider.UpdateCustomer(Int32 customerID, String firstName, String lastName, String address1, String address2, String city, String state, String country, String zip, String homePhone, String cellPhone, String workPhone, String email, String password, Boolean contact, String dNNLogin, Boolean subscriptionCancelled, String comments, String udf, String udtb, String udtb2, String udtb3, String fileUpload, String companyName) at Smith.DNN.Modules.Registration.RegistrationController.UpdateCustomer(CustomerInfo objCustomer) at Smith.DNN.Modules.Registration.Confirm.btnSubmit_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) at System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.ImageButton.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 ---
Source:
Server Name: CLE02WEB06
 
New Post
12/9/2011 2:40 AM
 
Going back to test the theory that the Auth.net switch from test mode caused a problem, I put it back in test mode and then ran the transaction again. Again it brought up the error above. But I noticed while I was in Auth.net, the transaction went through. (I have since voided it.)
 
New Post
12/9/2011 2:46 AM
 
It's amazing. I try a different browser. With auth.net still in test mode. It succeeds. I turn test mode off. It fails again. (I have noticed I am talking to myself here.)
 
New Post
12/12/2011 12:53 PM
 
Hello,

Which version of Smith Registration Pro are you currently running?

Thanks,
 
New Post
12/12/2011 1:50 PM
 
Smith Registration Pro 4.10.0
 
New Post
12/14/2011 2:30 PM
 
Hello,

We have not been able to replicate this issue on our test portal however we are unable to test on the same version of the module you are running. The current version of Smith RegPro is v.4.25. I recommend upgrading to the latest version of the module which has many new feature enhancements which are listed at the following link: http://www.smith-consulting.com/Products/DotnetnukeModules/RegistrationModules/RegProChangeLog.aspx

Thanks,
 
New Post
12/15/2011 1:48 AM
 
That's a great change log. Where is the download? Snowcovered does not have it. It has 4.18 with a link to a trial download on your site and that looks like version 4.22. I'll give that a try.
 
New Post
12/15/2011 2:12 AM
 
Hello,

Please email your purchase receipt to me at kevin@smith-consulting and I will check to see if you have access to the latest version.

Thanks,
 
New Post
12/15/2011 5:06 PM
 

I emailed my receipt earlier today and have not heard back. Purchase date was 10/2/2011. I'm running out of time and need this fixed tonight. After I upgraded to 4.22, I now get a different error and it does not go as far as it had gone before. Please get me fixed. I am at risk of losing my client.

 
New Post
12/20/2011 9:33 PM
 

I have called and emailed. If you cannot do so, please let me know and I will move onto another vendor. If you are doing something, please communicate with me.

 
New Post
12/21/2011 5:23 PM
 

Hi LD,

We have completed the uninstall, clean install, upgrade to v.4.27, and configuration of the Smith Registration module on your site.

When testing the a transaction using our Auth.net test credentials we received the following error:

We couldn't complete your payment.

Status : false
Message : The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.

I believe this issue as well as the initial issue you reported are related and indicate an issue with your SSL setup and configuration.

Thanks,

 
Previous
 
Next
HomeHome Product Discus... Product Discus...Payment Registr...Payment Registr...Parameter count does not match Parameter Value count. Parameter count does not match Parameter Value count.