Error During Final Step of Checkout - Payment Registration Pro

Item		Qty	Total
	{{cartItem.ProductName}} SKU: {{cartItem.ProductSku}}	{{cartItem.Quantity \| number : 2}} x {{cartItem.UnitCost \| currency : '$' : 2}}	{{cartItem.UnitCost * cartItem.Quantity \| currency : '$' : 2}}
{{itemVariant.VariantHasText ? (itemVariant.VariantName + ': ' + itemVariant.VariantText) : (itemVariant.VariantGroup + ': ' + itemVariant.VariantName)}}
You have no items in your shopping cart.
Subtotal	{{minicart.cartTotals.SubTotal \| currency : '$' : 2}}

Image	Item	Qty	Total
	{{cartItem.ProductName}} SKU: {{cartItem.ProductSku}}	{{cartItem.Quantity \| number : 2}} x {{cartItem.UnitCost \| currency : '$' : 2}}	{{cartItem.UnitCost * cartItem.Quantity \| currency : '$' : 2}}
{{itemVariant.VariantHasText ? (itemVariant.VariantName + ': ' + itemVariant.VariantText) : (itemVariant.VariantGroup + ': ' + itemVariant.VariantName)}}
You have no items in your shopping cart.

Status	Order No.	Order Date	Ship To	Order Total	Pay Total	Balance
Bill Me Later Open Ready To Ship Shipped Picked Up Cancelled Incomplete On Hold Back Ordered Returned {{order.Status}}	{{order.OrderID}}	{{order.OrderDate \| date : 'M/d/yyyy'}}	{{order.ShipFirstName}} {{order.ShipLastName}}, {{order.ShipAddress1}} {{order.ShipAddress2}}, {{order.ShipCity}}, {{order.ShipState}} {{order.ShipZipcode}}	{{order.GrandTotal \| currency : '$' : 2}}	{{order.PayTotal \| currency : '$' : 2}}	{{order.GrandTotal - order.PayTotal \| currency : '$' : 2}}

Home

Product Discus...

Payment Registr...

Error During Final Step of Checkout

3/16/2012 1:45 PM

Patrick Ryan

Joined: 8/29/2010

Posts: 73

Error During Final Step of Checkout

Hello:

I uninstalled the trial version of Registration Pro, manually dropped all tables and procedures. I then performed a clean install of Registration Pro 4.36

I created my products, inserted my authorize.net developers key.

DNN 5.6.5 Enterprise

ASP 3.5

I really need this fixed ASAP. Please advise. I'm noticing similar errors across the forums.

I get the following error upon the final step of submitting payment:

AssemblyVersion: 5.6.5

PortalID: 0

PortalName: Local Livin' Ads - Local Classifieds, Local Prizes, Local Chatrooms, Local Events, and more!

UserID: 549

UserName: sryan86

ActiveTabID: 406

ActiveTabName: Signup

RawURL: /Marketplace/LocalBusinesses/Directory/Signup.aspx?ctlname=Confirm

AbsoluteURL: /Default.aspx

AbsoluteURLReferrer: https://locallivinads.com/Marketplace/LocalBusinesses/Directory/Signup.aspx?ctlname=Confirm

UserAgent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7; rv:6.0) Gecko/20100101 Firefox/6.0

DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider

ExceptionGUID: 7b7e8f41-f80b-4b6a-a47f-36d78fb35725

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.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at Smith.DNN.Modules.Registration.SqlDataProvider.AddSubscription(Int32 customerID, Int32 payHistID, String productName, DateTime createDate, DateTime cancelDate, DateTime subStartDate, DateTime subEndDate, Int32 PortalId) at Smith.DNN.Modules.Registration.RegistrationController.AddSubscription(SubscriptionInfo objSubscription) at Smith.DNN.Modules.Registration.Confirm.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 ---

Source:

Server Name: D132

3/16/2012 6:27 PM

Joined: 1/1/0001

Posts: 0

Re: Error During Final Step of Checkout

H Patrick,

Which Auth.net gateway do you have configured in the Registration Settings?

Is the product you are running a transaction with setup for recurring billing? If so, how do you have the Recurring Billing Options configured?

Thanks,

3/16/2012 6:35 PM

Patrick Ryan

Joined: 8/29/2010

Posts: 73

Re: Error During Final Step of Checkout

Hi Kevin,

I'm using my developer's test account API and KEY, and have "test mode" checked.

In the products, I have the price.

The "Enable Recurring Billing" is checked

Interval is "Monthly"

Occurences: 9999

Start recurring billing is "Checked"

That's it for the recurring settings..

Thanks!!!

- Patrick

3/19/2012 2:07 PM

Joined: 1/1/0001

Posts: 0

Re: Error During Final Step of Checkout

Hi Patrick,

Which Auth.net gateway do you have configured for your Payment Gateway in the Registration Settings?

The following 2 Auth.net Gateways are available:

Authorize.net (AIM)
Authorize.net Hosted Payment Page (SIM)

Thanks,

3/19/2012 2:36 PM

Patrick Ryan

Joined: 8/29/2010

Posts: 73

Re: Error During Final Step of Checkout

AIM

Is that correct?

3/19/2012 3:56 PM

Joined: 1/1/0001

Posts: 0

Re: Error During Final Step of Checkout Modified By on 3/19/2012 3:57:30 PM

Hi Patrick,

I have not been able to replicate this issue, please see the following screenshots to verify any differences between your product setup and ours:

3/19/2012 10:45 PM

Patrick Ryan

Joined: 8/29/2010

Posts: 73

Re: Error During Final Step of Checkout Modified By on 3/20/2012 12:09:56 AM

I have verified that all settings are properly configured. Here is my complete history:

I downloaded and installed the RegProTrial which was version 4.38 (newer than the regular version)
I purchased and attempted to install the full version (4.36) and it told me a newer version was installed.
I uninstalled the trial, and I got several errors in the uninstallation log.
I manually deleted all files, tables, stored procedures, etc.
I performed a clean install of 4.36 witihout error.
I have verified that all settings are as you dictated, still with the error.
I uninstalled all the reg pro modules, and got an error during uninstall which I will post at the end of this forum post.
I manually deleted all files, tables, stored procedures etc.
I performed a clean install of 4.36 without error.
I have verified that all settings are as you dictated, still with the error.

I have no idea what is wrong. I have a standard DNN installation, and have done nothing out of the ordinary. I really need you guys to fix this please. I understand you can't replicate it on your end, but I literally have a standard installation and have followed the instructions explicitly. The uninstall problems concern me, and I feel it may be related to the problems with the module.

Here is the part of the uninstall script that shows errors. It's referencing procedures that do not exist.

Thank you for your prompt attention

SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Cannot find the object "dbo.YourCompany_Registration" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /************************************************************/ /***** SqlDataProvider *****/ /***** *****/ /***** *****/ /***** Note: To manually execute this script you must *****/ /***** perform a search and replace operation *****/ /***** for dbo. and *****/ /***** *****/ /************************************************************/ /** Drop FAQs Table **/ ALTER TABLE dbo.[YourCompany_Registration] DROP CONSTRAINT [FK_Registration_Modules] System.Data.SqlClient.SqlException: Cannot find the object "dbo.YourCompany_Registration" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE dbo.[YourCompany_Registration] DROP CONSTRAINT [PK_YourCompany_Registration] System.Data.SqlClient.SqlException: Cannot drop the index 'dbo.YourCompany_Registration.IX_YourCompany_Registration', because it does not exist or you do not have permission. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) DROP INDEX dbo.[YourCompany_Registration].[IX_YourCompany_Registration] System.Data.SqlClient.SqlException: Cannot drop the table 'dbo.YourCompany_Registration', because it does not exist or you do not have permission. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) DROP TABLE dbo.[YourCompany_Registration] System.Data.SqlClient.SqlException: Cannot drop the procedure 'dbo.YourCompany_GetRegistrations', because it does not exist or you do not have permission. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /** Drop Stored Procedures **/ DROP PROCEDURE dbo.[YourCompany_GetRegistrations] System.Data.SqlClient.SqlException: Cannot drop the procedure 'dbo.YourCompany_GetRegistration', because it does not exist or you do not have permission. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) DROP PROCEDURE dbo.[YourCompany_GetRegistration] System.Data.SqlClient.SqlException: Cannot drop the procedure 'dbo.YourCompany_AddRegistration', because it does not exist or you do not have permission. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) DROP PROCEDURE dbo.[YourCompany_AddRegistration] System.Data.SqlClient.SqlException: Cannot drop the procedure 'dbo.YourCompany_UpdateRegistration', because it does not exist or you do not have permission. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) DROP PROCEDURE dbo.[YourCompany_UpdateRegistration] System.Data.SqlClient.SqlException: Cannot drop the procedure 'dbo.YourCompany_DeleteRegistration', because it does not exist or you do not have permission. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) DROP PROCEDURE dbo.[YourCompany_DeleteRegistration]

3/20/2012 1:47 PM

Joined: 1/1/0001

Posts: 0

Re: Error During Final Step of Checkout

Hi Patrick,

Please do the following to perform a clean installation of the RegPro module:

1. From the dnn->host menu uninstall all Smith modules. Make sure you check the delete files box when you uninstall.

2. Confirm the following tables and stored procs with a prefix of Smith in your database are deleted:
• Smith_AuthorizeNetLog
• Smith_Country
• Smith_EmailTemplate
• Smith_PageTemplate
• Smith_RegCoupons
• Smith_RegCustomer
• Smith_RegPayHist
• Smith_RegProducts
• etc.

3. Confirm that all Smith folders in /desktopmodules are deleted and the folder is removed

4. Install the latest module

5. Configure the settings and test

Here are some scripts to remove all smith tables and stored procedures, so you don't have to do it manually:

Remove all tables

DECLARE @SQL VARCHAR(1000)
DECLARE @tempName VARCHAR(1000)
DECLARE @count VARCHAR(1000)
select @count = COUNT(*) from dbo.sysobjects where type = 'U' and name like 'smith%'
while @count > 0
Begin
Select @tempName = name from dbo.sysobjects where type = 'U' and name like 'smith%'
exec('drop table ' + @tempName)
set @count = @count - 1
END

Remove all Stored Procs

DECLARE @SQL VARCHAR(1000)
DECLARE @tempName VARCHAR(1000)
DECLARE @count VARCHAR(1000)
select @count = COUNT(*) from dbo.sysobjects where type = 'p' and name like 'smith%'
while @count > 0
Begin
Select @tempName = name from dbo.sysobjects where type = 'p' and name like 'smith%'
exec('drop procedure ' + @tempName)
set @count = @count - 1
END

Page 1 of 1

Home

Product Discus...

Payment Registr...

Error During Final Step of Checkout

You have no items in your shopping cart.

You have 1 item in your shopping cart.

{{multiCartItemsStr.replace('[COUNT]', minicart.cartList.length)}}

Item(s): {{minicart.countCart().Number | number : 2}}

Questions? Contact us for answers!

Services

DNN Modules

Support

Contact Us