Wanted to add the very first post to the new Product Forums module!

For customers that are integrating our Opt In Email product with Dynamic Registration, depending on which module was installed first you might need to execute the attached script. This script will allow you to choose which opt in email categories you would like to have integrated with Dynamic Registration.

You can get the script here:

http://www.datasprings.comuserguide...ration.zip

After downloading open up the SQL script within the zip file and execute it under Host, SQL.

-Chad

Hi

Error of "Unable to load Opt In email Categories" still showing after running sql script.
Have you got any idea?
I am using Dynamic Registration 2.4 and Opt In email 2.6

FYI - I needed to run this script after installing Opt-in after Dynamic Registration. The script failed initially not because of the object qualifier but because the Store Procedures already existed. I changed the script entries from "CREATE" to "ALTER" and was successful at getting everything to work properly.

I am getting still getting the "Unable to load Opt In Email Categories. Please review this: forum post." message after running the script. I am not versed in SQL and a newbie to DNN. Can you direct me on what to do next?

Ann

Ann,

Hi. Well if your site uses object qualifiers you would need a SQL script that included these. I am attaching an updated SQL script to reflect the {objectqualifier} parameter.

After unzipping the attached file simply open the contents of the .SQL file into notepad and then copy them into the textbox under Host, SQL. Check the box that this is a SQL Script and click execute. After this you should receive a sucess message if everything went ok.

Let me know!

-Chad

Also... I uploaded the updated script to the same location so that we won't run into this down the road. The updated script also removes any old stored procedure just case in case it was already added.

http://www.datasprings.comuserguidesDynamic_OptInIntegration.zip



I also uploaded it as standard text in case you don't want to have to unzip it you can just load this text file and copy/paste the contents under Host, SQL.

http://www.datasprings.comuserguidesDynamic_OptInIntegration_WithDNNObjectQualifier.txt


-Chad

Hi Chad,

There is no error on SQL Script it execute succesfully, then also it shows error "Unable to load Opt In Email Categories. Please review this: forum post. "

Please give me suggestion.

Regards

venkat

No, we are not using object qualifiers, we are using dbo.table [name]. user registration module was installed properly but when i was select the check box of "Opt In Email Module Installed?:" then it shows this error "Unable to load Opt In Email Categories. Please review this: forum post."

As i said that i was installed updated script then also same error occur, please help me out to solve this error.

Sorry i am not able to give you the temporary host access.

From where i can open the support ticket, please specify

Regards

venkat

Where can I get hold of the script? The links are broken..?

EDIT: Sorry links are not broken. I have the script now. My bad.