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 590 posts 806 karma points
    Nov 24, 2009 @ 10:58
    Fredrik Esseen

    Usernoconsole error when logging in

    When a customer tries to login he gets following error:



    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 installation with MS SQL

  • Sebastiaan Janssen 4890 posts 14567 karma points MVP admin hq
    Nov 24, 2009 @ 11:21
    Sebastiaan Janssen

    This older post might help..?

  • Sebastiaan Janssen 4890 posts 14567 karma points MVP admin hq
    Nov 24, 2009 @ 11:23
    Sebastiaan Janssen

    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));
  • Fredrik Esseen 590 posts 806 karma points
    Nov 24, 2009 @ 12:01
    Fredrik Esseen

    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!

  • BJ Patel 68 posts 173 karma points
    Jul 18, 2016 @ 09:47
    BJ Patel

    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.

Please Sign in or register to post replies

Write your reply to: