I created a new DNN security role and added a new user to that new role (so that they can login tot he web site and create and send newsletters without being able to modify the rest of the web site).  When I login as this new user, the Advanced Email module displays an error message "An error has occurred. Error: is currently unavailable."

The DNN Event Viewer shows this error under the new user:

Message: DotNetNuke.Services.Exceptions.ModuleLoadException: Conversion failed when converting from a character string to uniqueidentifier. ---> System.Data.SqlClient.SqlException: Conversion failed when converting from a character string to uniqueidentifier. 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.SqlDataReader.HasMoreRows() at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) at System.Data.SqlClient.SqlDataReader.Read() at DotNetNuke.Common.Utilities.CBO.FillListFromReader(Type objType, IDataReader dr, IList objList, Boolean closeReader) at DotNetNuke.Common.Utilities.CBO.FillCollection(IDataReader dr, Type objType) at Dataspring.DNN.Modules.OptInAdvanceEmail.OptInPreviousNewsletterController.SearchPreviousNewsletters(Int32 PortalID, String Filter) at Dataspring.DNN.Modules.OptInAdvanceEmail.MyNewsLetters.GetData() at Dataspring.DNN.Modules.OptInAdvanceEmail.MyNewsLetters.DoSearch() --- End of inner exception stack trace ---

Anyone know what is going on here?  Why can't I have a specific user login and handle the newsletters?  I believe I have the page and module permissions set correctly.  I even have the Module Configuration set to allow this new DNN security role to distribute the newsletters.

Thanks.

Hi Joe,

Let me ask you a couple of quetions:

1. Can you please tell us your exact module version? Also, what is your DNN version?

2. I understand you're trying to do this with the Opt In - Advanced Email component. Is this role given edit rights to the page/module where you have the Opt In - Opt In where lists and subscirbers are managed?

Thanks!
Candace

I resolved the issue.  At least one list (in the Opt-In Email module) must have its distribution security role set to the security role that was set in the Advanced Email module.

Glad to hear that you resolved it. Thanks for letting us know!

Candace