usernoconsole error when logging in

Press Ctrl / CMD + C to copy this to your clipboard.

Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

Fredrik Esseen 610 posts 906 karma points

Nov 24, 2009 @ 10:58

When a customer tries to login he gets following error:

usernoconsole 
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.IndexOutOfRangeException: usernoconsole

Source Error: 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. 

Stack Trace: 

[IndexOutOfRangeException: usernoconsole]
   System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName) +4841826
   System.Data.SqlClient.SqlDataReader.GetOrdinal(String name) +67
   umbraco.DataLayer.RecordsReaderAdapter`1.GetOrdinal(String fieldName) +23
   umbraco.DataLayer.RecordsReaderAdapter`1.GetBoolean(String fieldName) +26
   umbraco.BusinessLogic.User.setupUser(Int32 ID) +167
   umbraco.BusinessLogic.User..ctor(String Login) +108
   umbraco.providers.UsersMembershipProvider.ValidateUser(String username, String password) +31
   umbraco.cms.presentation.login.Button1_Click(Object sender, EventArgs e) +84
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565

Its a 4.0.2.1 installation with MS SQL

Copy Link

Sebastiaan Janssen 5060 posts 15522 karma points MVP admin hq

Nov 24, 2009 @ 11:21

0

This older post might help..?

Copy Link
Sebastiaan Janssen 5060 posts 15522 karma points MVP admin hq

Nov 24, 2009 @ 11:23
0
Also, your user account might not have been set-up correctly, the following SQL is executed for your user, maybe the "usernoconsole" column doesn't have the correct value?
```
public static int getUserId(string lname, string passw) {
return getUserId("select id from umbracoUser where userDisabled = 0 and userNoConsole = 0 and userLogin = @login and userPassword = @pw",
SqlHelper.CreateParameter("@login", lname),
SqlHelper.CreateParameter("@pw", passw));
}
```
Copy Link
Fredrik Esseen 610 posts 906 karma points

Nov 24, 2009 @ 12:01

0

We restarted the IIS and then it started to work again. The table umbracoUser table looked fine.

I couldnt find anything related in the old post.

I little bit troublesome if it should happen again!

Copy Link
BJ Patel 84 posts 210 karma points

Jul 18, 2016 @ 09:47

0

Following steps worked for me In my case it was Umbraco 7.4.2

1) setting "userNoConsole" to 0 (executing following sql query Umbraco DB)

update [umbracoUser] set userNoConsole = 0 where UserLogin='Admin' -- respective user

2) restarting website from IIS OR can also touch web.conf to do so.

Copy Link
is working on a reply...

Please Sign in or register to post replies