netghost
  • Posts: 51
  • Joined: 30/09/2011
i just installed yaf 1.9.6.1 .. when i try to login it redirects me back to the default page on internet explorer , when i try to register a new user it displays the following error



Cannot insert the value NULL into column 'Name', table 'justnaij_YAFNET.dbo.yaf_User'; column does not allow nulls. INSERT fails.
Cannot insert the value NULL into column 'UserID', table 'justnaij_YAFNET.dbo.yaf_UserGroup'; column does not allow nulls. INSERT fails.
The statement has been terminated.
The statement has been terminated.
Sponsor
acidtrash
  • Posts: 11
  • Joined: 18/07/2012
Having pretty much the same problem.
tha_watcha
  • Posts: 4079
  • Joined: 06/03/2010
Originally Posted by: acidtrash

Having pretty much the same problem.



A few more informations would be helpfully to solve the problem.

Are you using the default installation with the standard membership provider and without any modification?

UserPostedImage
acidtrash
  • Posts: 11
  • Joined: 18/07/2012
No modifications, standard membership provider - Using YAF 1.9.6.1

It was working fine til it hit 95 users then it suddenly stopped allowing registrations.
acidtrash
  • Posts: 11
  • Joined: 18/07/2012
It seems the record is being created in the members table but not being passed to user or usergroup.

rian.weaver@earthsoft.com
  • Posts: 5
  • Joined: 27/08/2012
I thought i'd fixed this, but it's still happening. This is what I'm getting:

ASP.default_aspx
System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "FK_yaf_CheckEmail_yaf_User". The conflict occurred in database "YAForum", table "dbo.yaf_User", column 'UserID'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at YAF.Classes.Data.YafDBAccess.ExecuteNonQuery(SqlCommand cmd, Boolean transaction) at YAF.Classes.Data.DB.checkemail_save(Object userID, Object hash, Object email) at YAF.Pages.register.SendVerificationEmail(MembershipUser user, Nullable`1 userID) at YAF.Pages.register.CreateUserWizard1_CreatedUser(Object sender, EventArgs e) at System.Web.UI.WebControls.CreateUserWizard.OnCreatedUser(EventArgs e) at System.Web.UI.WebControls.CreateUserWizard.AttemptCreateUser() at System.Web.UI.WebControls.CreateUserWizard.OnNextButtonClick(WizardNavigationEventArgs e) at System.Web.UI.WebControls.Wizard.OnBubbleEvent(Object source, EventArgs e) at System.Web.UI.WebControls.CreateUserWizard.OnBubbleEvent(Object source, EventArgs e) at System.Web.UI.WebControls.Wizard.WizardChildTable.OnBubbleEvent(Object source, EventArgs args) at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) at System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


Anyone with any ideas?
rian.weaver@earthsoft.com
  • Posts: 5
  • Joined: 27/08/2012
I am able to find users in yaf_prov_Membership, but they do not show up in yaf_USER
Chetan Bavarva
  • Posts: 19
  • Joined: 17/11/2016
Try this

--> replace NVARCHAR(50) with the actual type of your column


ALTER TABLE  yaf_User ALTER COLUMN Name NVARCHAR(50) NULL
ALTER TABLE  yaf_UserGroup ALTER COLUMN UserID NVARCHAR(50) NULL

Chetan Patel
Custom software company India 
iFour Technolab Pvt. Ltd
Users browsing this topic
    Forum Jump  
    • You cannot post new topics in this forum.
    • You cannot reply to topics in this forum.
    • You cannot delete your posts in this forum.
    • You cannot edit your posts in this forum.
    • You cannot create polls in this forum.
    • You cannot vote in polls in this forum.

    About Us

    The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

    Powered by Resharper Donate with PayPal button

    Project Twitter Updates

    Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved