hi,

can you show us the exception that occured.

oliver

On effority.RoleMemberCounter

DotNetNuke.Services.Exceptions.ModuleLoadException: Cannot insert the value NULL into column 'SettingValue', table 'dnn453.dbo.vp_ModuleSettings'; column does not allow nulls. INSERT fails. The statement has been terminated. ---> System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'SettingValue', table 'dnn453.dbo.vp_ModuleSettings'; column does not allow nulls. INSERT fails. The statement has been terminated. 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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddModuleSetting(Int32 ModuleId, String SettingName, String SettingValue) at DotNetNuke.Entities.Modules.ModuleController.UpdateModuleSetting(Int32 ModuleId, String SettingName, String SettingValue) at effority.RoleMemberCounter.Settings.UpdateSettings() at DotNetNuke.Modules.Admin.Modules.ModuleSettingsPage.cmdUpdate_Click(Object Sender, EventArgs e) --- End of inner exception stack trace ---

hi,

the exception you post is caused by the RoleMemberCounter.

But in the error message I regonized that you are you using a database objectQualifier.

I think this cause your problems with the UserDirectory und the User&Roles Manager.

To prevent this problem, I have updated the UserDirectory und the User&Roles Manager.

The User&Roles Manager version on snowcovered will be updated soon.

I hope this will solve your problems.

oliver

I think I have the same problem with the object qualifier, what is the solution i cannot get rid of it

yes I downloaded the latest version.

only ud

Hi,

I guess this error is caused by null values in the UserProfile table. I fixed this error in the code for the next release.

If you can't wait, please excute the sql code on your DB

SELECT     *
FROM         UserProfile
WHERE     (PropertyValue IS NULL)

and replace the Null values.

Then the module should work.

oliver

okay, I'm only using the ud that is why I only have the updated version from that module. 

I ran that sql cleanup and it worked, for some reason the PropertyValue for the Biography's for my users had the null value, I tried to move the contents from the Property Text, which seemed to hold the info for the Biography into the  PropertyValue field, it fixed the module, but broke the Biography for a couple of users.  Oh well!!!  LOL, I'm sure more users will get benefit of the searchable feature than will be hurt by killing a couple of Biographies.  Any body know why this would happen anyway?