I have a huge problem with my production portal which I'm not able to solve.
1. When new users try to create a new user account, they get a message "invalid username". Checking the database tables, the user is created in dbo.users but not in dbo.UserPortals or dbo.UserRoles. The user is also created in dbo.aspnet.Users but again, not in dbo.aspnet_UsersInRoles or dbo.aspnet_profile.
2. When I try to access the User Account admin page, I get the following error:
Server Error in '/Stjerneporten' Application.
Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
Source Error:
Line 50: <ItemStyle Width="20px"></ItemStyle>
Line 51: <ItemTemplate>
Line 52: <asp:HyperLink NavigateUrl='<%# FormatURL("UserID",CType(Container.DataItem, DotNetNuke.Entities.Users.UserInfo).UserID) %>' Visible="<%# IsEditable %>" runat="server" ID="Hyperlink1">
Line 53: <asp:Image ImageUrl="~/images/edit.gif" AlternateText="Edit" Visible="<%# IsEditable %>" runat="server" ID="Hyperlink1Image" resourcekey="Edit"/>
Line 54: </asp:HyperLink>
|
Source File: E:\Develop\Stjerneporten\StjerneportenTest\Admin\Users\Users.ascx Line: 52
Stack Trace:
[NullReferenceException: Object reference not set to an instance of an object.]
ASP.Users_ascx.__DataBind__control19(Object sender, EventArgs e) in E:\Develop\Stjerneporten\StjerneportenTest\Admin\Users\Users.ascx:52
System.Web.UI.Control.OnDataBinding(EventArgs e) +66
System.Web.UI.Control.DataBind() +26
System.Web.UI.Control.DataBind() +86
System.Web.UI.Control.DataBind() +86
System.Web.UI.WebControls.DataGrid.CreateItem(Int32 itemIndex, Int32 dataSourceIndex, ListItemType itemType, Boolean dataBind, Object dataItem, DataGridColumn[] columns, TableRowCollection rows, PagedDataSource pagedDataSource) +169
System.Web.UI.WebControls.DataGrid.CreateControlHierarchy(Boolean useDataSource) +1403
System.Web.UI.WebControls.BaseDataList.OnDataBinding(EventArgs e) +48
System.Web.UI.WebControls.BaseDataList.DataBind() +23
DotNetNuke.Modules.Admin.Users.UserAccounts.BindData(String SearchText, String SearchField) +1344
DotNetNuke.Modules.Admin.Users.UserAccounts.Page_Load(Object sender, EventArgs e) +430
[ModuleLoadException: Error: User Accounts is currently unavailable.]
DotNetNuke.Services.Exceptions.Exceptions.ProcessModuleLoadException(String FriendlyMessage, PortalModuleBase ctrlModule, Exception exc, Boolean DisplayErrorMessage) +447
DotNetNuke.Services.Exceptions.Exceptions.ProcessModuleLoadException(PortalModuleBase ctrlModule, Exception exc) +84
DotNetNuke.Modules.Admin.Users.UserAccounts.Page_Load(Object sender, EventArgs e) +452
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Page.ProcessRequestMain() +750
[PageLoadException: Error: User Accounts is currently unavailable.]
DotNetNuke.Services.Exceptions.Exceptions.ProcessPageLoadException(Exception exc, String URL) +345
DotNetNuke.Framework.PageBase.Page_Error(Object Source, EventArgs e) +363
System.Web.UI.TemplateControl.OnError(EventArgs e) +109
System.Web.UI.Page.HandleError(Exception e) +68
System.Web.UI.Page.ProcessRequestMain() +2100
System.Web.UI.Page.ProcessRequest() +218
System.Web.UI.Page.ProcessRequest(HttpContext context) +18
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() +179
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +87
|
I use DNN 3.2.2, .NET 1.1.4322.2032 and SQL Server 2005.
I have made an exact copy of the production web on my localhost to be able to trace the error and I'm able to reproduce it.
Tracing the error in SQL Server profiler gives me the following info:
exec dbo.AddEventLog
@LogGUID='c044450c-37a4-49b7-b257-ea88dbe5c1a4',@LogTypeKey=N'GENERAL_EXCEPTION',@LogUserID=NULL,@LogUserName=N'host',@LogPortalID=2,@LogPortalName=NULL,@LogCreateDate=''2006-03-05
22:11:34:267'',@LogServerName=N'MADMAX',@LogProperties=N'<ArrayOfAnyType xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><anyType xsi:type="LogDetailInfo"><name>AssemblyVersion</name><value>03.02.02</value></anyType><anyType
xsi:type="LogDetailInfo"><name>Method</name><value>ASP.Users_ascx.__DataBind__control19</value></anyType><anyType
xsi:type="LogDetailInfo"><name>FileName</name><value>E:\Develop\Stjerneporten\StjerneportenTest\Admin\Users\Users.ascx</value></anyType><anyType
xsi:type="LogDetailInfo"><name>FileLineNumber</name><value>52</value></anyType><anyType xsi:type="LogDetailInfo"><name>FileColumnNumber</name><value>13</value></anyType><anyType
xsi:type="LogDetailInfo"><name>PortalID</name><value>2</value></anyType><anyType xsi:type="LogDetailInfo"><name>PortalName</name><value>Stjerneporten</value></anyType><anyType
xsi:type="LogDetailInfo"><name>UserID</name><value>1</value></anyType><anyType xsi:type="LogDetailInfo"><name>UserName</name><value>host</value></anyType><anyType
xsi:type="LogDetailInfo"><name>ActiveTabID</name><value>88</value></anyType><anyType xsi:type="LogDetailInfo"><name>ActiveTabName</name><value>User
Accounts</value></anyType><anyType xsi:type="LogDetailInfo"><name>AbsoluteURL</name><value>/Stjerneporten/Default.aspx</value></anyType><anyType
xsi:type="LogDetailInfo"><name>AbsoluteURLReferrer</name><value /></anyType><anyType
xsi:type="LogDetailInfo"><name>ExceptionGUID</name><value>c68d28d0-7023-4be9-8b4a-f13b1422e288</value></anyType><anyType
xsi:type="LogDetailInfo"><name>DefaultDataProvider</name><value>DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider</value></anyType><anyType
xsi:type="LogDetailInfo"><name>InnerException</name><value>Unhandled Error: </value></anyType><anyType xsi:type="LogDetailInfo"><name>Message</name><value>System.Exception:
Unhandled Error: ---> DotNetNuke.Services.Exceptions.PageLoadException: Error: User Accounts is currently unavailable. --->
DotNetNuke.Services.Exceptions.ModuleLoadException: Error: User Accounts is currently unavailable. ---> System.NullReferenceException: Object reference not set to an instance
of an object.
at ASP.Users_ascx.__DataBind__control19(Object sender, EventArgs e) in E:\Develop\Stjerneporten\StjerneportenTest\Admin\Users\Users.ascx:line 52
at System.Web.UI.Control.OnDataBinding(EventArgs e)
at System.Web.UI.Control.DataBind()
at System.Web.UI.Control.DataBind()
at System.Web.UI.Control.DataBind()
at System.Web.UI.WebControls.DataGrid.CreateItem(Int32 itemIndex, Int32 dataSourceIndex, ListItemType itemType, Boolean dataBind, Object dataItem, DataGridColumn[] columns,
TableRowCollection rows, PagedDataSource pagedDataSource)
at System.Web.UI.WebControls.DataGrid.CreateControlHierarchy(Boolean useDataSource)
at System.Web.UI.WebControls.BaseDataList.OnDataBinding(EventArgs e)
at System.Web.UI.WebControls.BaseDataList.DataBind()
at DotNetNuke.Modules.Admin.Users.UserAccounts.BindData(String SearchText, String SearchField)
at DotNetNuke.Modules.Admin.Users.UserAccounts.Page_Load(Object sender, EventArgs e)
--- End of inner exception stack trace ---
at DotNetNuke.Services.Exceptions.Exceptions.ProcessModuleLoadException(String FriendlyMessage, PortalModuleBase ctrlModule, Exception exc, Boolean DisplayErrorMessage)
at DotNetNuke.Services.Exceptions.Exceptions.ProcessModuleLoadException(PortalModuleBase ctrlModule, Exception exc)
at DotNetNuke.Modules.Admin.Users.UserAccounts.Page_Load(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain()
--- End of inner exception stack trace ---
at DotNetNuke.Services.Exceptions.Exceptions.ProcessPageLoadException(Exception exc, String URL)
at DotNetNuke.Framework.PageBase.Page_Error(Object Source, EventArgs e)
at System.Web.UI.TemplateControl.OnError(EventArgs e)
at System.Web.UI.Page.HandleError(Exception e)
at System.Web.UI.Page.ProcessRequestMain()
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at System.Web.CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
--- End of inner exception stack trace ---</value></anyType><anyType xsi:type="LogDetailInfo"><name>StackTrace</name></anyType><anyType
xsi:type="LogDetailInfo"><name>Source</name></anyType></ArrayOfAnyType>',@LogConfigID=4
Please, can anyone help me resolve this problem? As you can understand, I'm a bit desperate here, not being able to pin thisone down.
Thanks in advance.
Best regard,
Eirik Sorensen