#1
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.
Topic Starter
  • netghost
  • Rank: YAF Lover
  • Reputation:
    Honored
    80.6%
  • Joined: 30/09/2011
  • Posts: 51
  • Thanks: 11 times
#2
Having pretty much the same problem.
  • acidtrash
  • Rank: YAF Camper
  • Reputation:
    Neutral
    50.2%
  • Joined: 18/07/2012
  • Posts: 11
#3
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
  • tha_watcha
  • Rank: YAF.NET Project Lead
  • Reputation:
    Exalted
    100%
  • Medals:
    Medal of Honor: Portal Puzzle Master: Portal Puzzle Master for DNNMedal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.DNN Master: DNN Module ManBug Killer Medal of Honor: Medal for being a kick-ass bug killer!Medal of Honor for the Support King: Support King! Amazing asset to the YAF.NET Community.
  • Joined: 06/03/2010
  • Posts: 4,016
  •  Germany
  • Thanks: 73 times
  • Was thanked: 1211 time(s) in 1036 post(s)
#4
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
  • Rank: YAF Camper
  • Reputation:
    Neutral
    50.2%
  • Joined: 18/07/2012
  • Posts: 11
#5
It seems the record is being created in the members table but not being passed to user or usergroup.

  • acidtrash
  • Rank: YAF Camper
  • Reputation:
    Neutral
    50.2%
  • Joined: 18/07/2012
  • Posts: 11
#6
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
  • Rank: YAF Forumling
  • Reputation:
    Neutral
    50.2%
  • Joined: 27/08/2012
  • Posts: 5
#7
I am able to find users in yaf_prov_Membership, but they do not show up in yaf_USER
  • rian.weaver@earthsoft.com
  • Rank: YAF Forumling
  • Reputation:
    Neutral
    50.2%
  • Joined: 27/08/2012
  • Posts: 5
#8
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
  • Chetan Bavarva
  • Rank: YAF Camper
  • Reputation:
    Friendly
    62.6%
  • Joined: 17/11/2016
  • Posts: 19
  •  Man  India
  • Location: ahmedabad
  • Thanks: 1 times
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