netghost
  •  netghost
  • 80.6% (Honored)
  • YAF Lover Topic Starter
2012-04-26T12:07:05Z
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
2012-07-18T12:30:13Z
Having pretty much the same problem.
tha_watcha
2012-07-18T13:51:52Z
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
2012-07-18T14:02:33Z
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
2012-07-18T15:24:10Z
It seems the record is being created in the members table but not being passed to user or usergroup.

rian.weaver@earthsoft.com
2012-08-27T19:19:47Z
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
2012-08-27T21:17:49Z
I am able to find users in yaf_prov_Membership, but they do not show up in yaf_USER
Chetan Bavarva
2016-11-22T07:01:42Z
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

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