+1-888-365-2779
Try Now
More in this section

Forums / Deployment / Public Users Management

Public Users Management

3 posts, 0 answered
  1. Tushar Pradhan
    Tushar Pradhan avatar
    20 posts
    Registered:
    27 Mar 2006
    10 Jul 2006
    Link to this post

    Hi,

    I was trying out the Public User Management, where exactly is this user data stored; which table?

    As given in the Sitefinity v2.6 Manual, I tried adding a Registration Form control to register the user under a "TestUser" role. When I create a new user it creates it "Complete Your account has been successfully created." but when i try to log in usint the Login From control it gives the following error..

    "Cannot insert the value NULL into column 'Password', table   'SF2Proj1.dbo.RadDesignerPublicUsers'; column does not allow nulls. INSERT fails. The statement has been terminated."


    Any suggestions,
    Thanks in advance
    Tushar




    The complete stack trace



    Server Error in '/Proj1' Application.



    --------------------------------------------------------------------------------


    Cannot insert the value NULL into column 'Password', table 'SF2Proj1.dbo.RadDesignerPublicUsers'; column does not allow nulls. INSERT fails.
    The statement has been terminated.

    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.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'Password', table 'SF2Proj1.dbo.RadDesignerPublicUsers'; column does not allow nulls. INSERT fails.
    The statement has been terminated.

    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:



    [SqlException (0x80131904): Cannot insert the value NULL into column 'Password', table 'SF2Proj1.dbo.RadDesignerPublicUsers'; column does not allow nulls. INSERT fails.The statement has been terminated.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857418 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735030 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838 System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +31 System.Data.SqlClient.SqlDataReader.get_MetaData() +62 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +886 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32 System.Data.SqlClient.SqlCommand.ExecuteScalar() +137 Telerik.ContentManagement.Db.SqlDatabase.ExecuteScalar(IDbCommand command) +7 Telerik.ContentManagement.Db.Database.GetInsertedId(IDbCommand command) +4 Telerik.ContentManagement.UserManagement.UserProvider.MapMembershipUser(String userName) +467 Telerik.Web.UI.UserManagement.Login.btnLogin_Click(Object sender, EventArgs e) +302 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102



  2. John Pether
    John Pether avatar
    10 posts
    Registered:
    14 May 2006
    11 Jul 2006
    Link to this post

    Hi

    It appears that functionality has been removed and the manual and sql scripts have not been updated, I reported this issue a few weeks back and got the reply below, hope it helps!

    John Pether

    'Hello John,

    It seems that we omitted to drop the obsolete columns from RadDesignerPublicUsers table in the script that generates SQL Server Database. Excuse us for this bug.

    You can repair the database by yourself if you drop 'Email', 'Password', 'FirstName', 'LastName' fields from the RadDesignerPublicUsers table in the database.

    Sorry for the inconvenience. Let us know if you experience other problems.

    Have a nice day,
    Vlad
    the telerik team '

  3. Yavor
    Yavor avatar
    11 posts
    Registered:
    24 Sep 2012
    11 Jul 2006
    Link to this post

    Indeed, Tushar, this is a small omission on our side, please excuse us for the inconvenience.

    The response we gave John will help you fix this. If you still experience the problem please let us know.


    Sincerely yours,

    Yavor
    the telerik team
3 posts, 0 answered