Dear Chad and Datasprings. I have been a client for some time now, registered user of Opt In Email and Dynamic Registration. I have been trying from the beginning to get Opt in Email to integrate using the information in the Instruction Manual:
1. Open the Dynamic_OptInIntegration.sql in a text editor 2. Navigate to Host, SQL and copy/paste the information from the text editor into the SQL Query textbox 3. Select run as script and then execute
I have the following setup:
DNN: 3.3.4 DotNet Framework: 1.1.4322.2300 Dynamic Reg: 2.3 Opt In Email: 2.6
When I go to the HOST / SQl and then paste the information, run as script and the execute I get the following error:
System.Data.SqlClient.SqlException: There is already an object named 'DynamicRegistration_GetOptInCategoriesByPortal' in the database. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /* Opt In Email / Dynamic Registration Installation Script */ create procedure dbo.DynamicRegistration_GetOptInCategoriesByPortal @PortalID as integer AS select * from dbo.DataSprings_OptInCategory where PortalID = @PortalID System.Data.SqlClient.SqlException: There is already an object named 'DynamicRegistration_GetOptInEmailByEmailAddress' in the database. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) Create Procedure dbo.DynamicRegistration_GetOptInEmailByEmailAddress @EmailAddress as varchar(255), @PortalID as integer AS select * from DataSprings_OptInEmail where EmailAddress = @EmailAddress And Inactive=0 AND PortalID = @PortalID System.Data.SqlClient.SqlException: There is already an object named 'DynamicRegistration_UpdateOptInEmail' in the database. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) Create Procedure dbo.DynamicRegistration_UpdateOptInEmail @OptInEmailId as uniqueidentifier, @FirstName as varchar(255), @LastName as varchar(255), @EmailAddress as varchar(255), @IsVerified as Integer, @PortalID as integer AS Update DataSprings_OptInEmail Set FirstName = @FirstName, LastNAme = @LastName, EmailAddress = @EmailAddress, IsVerified = @IsVerified, PortalID = @PortalID Where OptInEmailID = @OptInEmailID System.Data.SqlClient.SqlException: There is already an object named 'DynamicRegistration_AddOptInEmail' in the database. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) Create Procedure dbo.DynamicRegistration_AddOptInEmail @FirstName as varchar(255), @LastName as varchar(255), @EmailAddress as varchar(255), @IsVerified as Integer, @PortalID as integer AS Insert Into DataSprings_OptInEmail (FirstName, LastName, EmailAddress, IsVerified, PortalID) Values (@FirstName, @LastName, @EmailAddress, @IsVerified, @PortalID) System.Data.SqlClient.SqlException: There is already an object named 'DynamicRegistration_UpdateOptInCategoryEmail' in the database. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) Create Procedure dbo.DynamicRegistration_UpdateOptInCategoryEmail @OptInEmailCategoryID as uniqueidentifier, @OptInCategoryID as uniqueidentifier, @OptIn as integer, @OptInEmailID as uniqueidentifier AS Update DataSprings_OptInEmailCategory Set @OptInCategoryID = @OptInCategoryID, OptIn = @OptIn, OptInEmailID = @OptInemailID Where OptInEmailCategoryID = @OptInEmailCategoryID System.Data.SqlClient.SqlException: There is already an object named 'DynamicRegistration_AddOptInCategoryEmail' in the database. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) Create Procedure dbo.DynamicRegistration_AddOptInCategoryEmail @OptInCategoryID as uniqueidentifier, @OptIn as integer, @OptInEmailID as uniqueidentifier AS Insert Into DataSprings_OptInEmailCategory (OptInCategoryID, OptIn, OptInEmailID) Values(@OptInCategoryID, @OptIn, @OptInEmailID) System.Data.SqlClient.SqlException: Line 15: Incorrect syntax near 'GO'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) Create Procedure dbo.DynamicRegistration_GetOptInCategoryEmail @EmailAddress as varchar(255), @PortalID Integer, @OptInCategoryID uniqueidentifier AS select A.OptInEmailCategoryID, A.OptInEmailID, A.OptInCategoryID, A.OptIn, A.Inactive from DataSprings_OptInEmailCategory A Inner Join DataSprings_OptInEmail B on A.OptInEmailID = B.OptInEmailID Where EmailAddress = @EmailAddress AND PortalID = @PortalID AND OptInCategoryID = @OptInCategoryID GO
Thanks a lot for any help on this one...Niclas
|