Hi,

We've been happily using this module on our Intranet when suddenly we've got this error in the error log:

ModuleId: 395
ModuleDefId: 129
FriendlyName: Contacts
ModuleControlSource: DesktopModules/effority.UserDirectory/View.ascx
AssemblyVersion: 04.09.00
PortalID: 1
PortalName: <title>
UserID: 7
UserName: <user>
ActiveTabID: 66
ActiveTabName: Directory
RawURL: /Home/Directory/tabid/66/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://<address>/Home/tabid/36/Default.aspx
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9.0.5) Gecko/2008120122 Firefox/3.0.5 (.NET CLR 3.5.30729)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: ce0c915f-81b9-43f4-9bf5-06bce6c40ae8
InnerException: Data is Null. This method or property cannot be called on Null values.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlBuffer.get_String
StackTrace:
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: Data is Null. This method or property cannot be called on Null values. ---> System.Data.SqlTypes.SqlNullValueException: Data is Null. This method or property cannot be called on Null values. at System.Data.SqlClient.SqlBuffer.get_String() at System.Data.SqlClient.SqlDataReader.GetString(Int32 i) at effority.UserDirectory.Controller.GetUserProfileDic(List`1 ProfileDefinitions, Int32 PortalId) at effority.UserDirectory.View.GetUserTable(Boolean FromCache) at effority.UserDirectory.View.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---
Source:
Server Name: <host>

Any ideas what could have caused this error? (I've removed certain details for security reasons)

Thanks,
Matt

Aaah, that could be a possibility. If this is the case, how do I edit the User Directory settings? I can't get into the settings with the error?

Thanks!

Seems this error is still  around. I am using DNN 5.6.0 with UserDirectory 1.01.09.

I made a backup and went about deleting all profile properties (which is how I interpreted the advice above). The module still raised the original error. After much hair pulling, I eventually went to the source for this method:

effority.UserDirectory.Controller.GetUserProfileDic(List`1 ProfileDefinitions, Int32 PortalId)

and examined the SQL it was running. If I ran the following SQL:

delete from UserProfile where PropertyValue is null

it seemed to fix it. I also confirmed that the propfile property is re-inserted into the UserProfile table once the user has entered some data against the property.