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.