Here's the error I get:
ModuleId: 615
ModuleDefId: 153
FriendlyName: Syncing Activity
ModuleControlSource: DesktopModules/Dynamic User Directory/Dynamic-User-Directory.ascx
AssemblyVersion: 5.2.3
PortalID: 0
PortalName: MyTalkTools
UserID: 2
UserName: admin
ActiveTabID: 162
ActiveTabName: Syncing Activity
RawURL: /dnn/ActivityReports/SyncingActivity.aspx
AbsoluteURL: /DNN/Default.aspx
AbsoluteURLReferrer:
http://www.mytalktools.com/dnn/Acti...fault.aspx
UserAgent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US; rv:1.9.2.6) Gecko/20100625 Firefox/3.6.6
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 71f1e6ad-5046-4e02-ae69-13410827be03
InnerException: Invalid column name 'UserRoles'.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: DataSprings.DNN.Modules.DynamicUserDirectory.DynamicUserDirectory.GenerateReport
StackTrace:
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: Invalid column name 'UserRoles'. ---> System.Data.SqlClient.SqlException: Invalid column name 'UserRoles'. at DataSprings.DNN.Modules.DynamicUserDirectory.DynamicUserDirectory.GenerateReport(String Status, String strNewRecordsPerPage) at DataSprings.DNN.Modules.DynamicUserDirectory.DynamicUserDirectory.GetData(String Status, String strNewPageSize) at DataSprings.DNN.Modules.DynamicUserDirectory.DynamicUserDirectory.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---
Source:
Server Name: MYTALKTOOLS
So - this report has a Filter that references "UserRoles". If I remove that filter the report works. Unfortunately, that filter is required.
Can you help?