For those who read some of this in another threat, I decided to start a new thread for this since I have a bit of new information and this isn't really related to the OP's original question anymore. Using IIS on a 2008 server, with 1.9.6 RC1 of YAF. Creating a new user, both through the admin panel and by attempting to register, results in the following errors:

System.Data.SqlClient.SqlException (0x80131904): Cannot insert the value NULL into column 'Name', table 'GameForum.dbo.yaf_User'; column does not allow nulls. INSERT fails.

Cannot insert the value NULL into column 'UserID', table 'GameForum.dbo.yaf_UserGroup'; column does not allow nulls. INSERT fails.

The statement has been terminated.

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.MsSqlDbAccess.ExecuteNonQuery(IDbCommand cmd, Boolean transaction)

at YAF.Types.Interfaces.IDbAccessExtensions.ExecuteNonQuery(IDbAccess dbAccess, IDbCommand cmd)

at YAF.Classes.Data.LegacyDb.user_save(Object userID, Object boardID, Object userName, Object displayName, Object email, Object timeZone, Object languageFile, Object culture, Object themeFile, Object useSingleSignOn, Object textEditor, Object useMobileTheme, Object approved, Object pmNotification, Object autoWatchTopics, Object dSTUser, Object hideUser, Object notificationType)

at YAF.Pages.Admin.reguser.ForumRegister_Click(Object sender, EventArgs e)

at System.Web.UI.WebControls.Button.OnClick(EventArgs 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)

Error System 3/17/2012 9:53:23 PM System.String Show | Delete

System.Data.SqlClient.SqlException (0x80131904): Cannot insert the value NULL into column 'UserID', table 'GameForum.dbo.yaf_UserGroup'; column does not allow nulls. INSERT fails.

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.MsSqlDbAccess.ExecuteNonQuery(IDbCommand cmd, Boolean transaction)

at YAF.Types.Interfaces.IDbAccessExtensions.ExecuteNonQuery(IDbAccess dbAccess, IDbCommand cmd)

at YAF.Classes.Data.LegacyDb.user_setrole(Int32 boardID, Object providerUserKey, Object role)

at YAF.Core.RoleMembershipHelper.CreateForumUser(MembershipUser user, String displayName, Int32 pageBoardID)

Error System 3/17/2012 9:53:23 PM user_aspnet in YAF.Classes.Data.DB.cs Show | Delete

System.Data.SqlClient.SqlException (0x80131904): Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

Cannot insert the value NULL into column 'TimeZone', table 'GameForum.dbo.yaf_User'; column does not allow nulls. INSERT fails.

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.SqlDataReader.ConsumeMetaData()

at System.Data.SqlClient.SqlDataReader.get_MetaData()

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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

at System.Data.SqlClient.SqlCommand.ExecuteScalar()

at YAF.Classes.Data.MsSqlDbAccess.ExecuteScalar(IDbCommand cmd, Boolean transaction)

at YAF.Types.Interfaces.IDbAccessExtensions.ExecuteScalar(IDbAccess dbAccess, IDbCommand cmd)

at YAF.Classes.Data.LegacyDb.user_aspnet(Int32 boardID, String userName, String displayName, String email, Object providerUserKey, Object isApproved)

As I listed before, user information is created in yaf_prov_Membership and yaf_prov_Profile, but nothing is created in yaf_User or yaf_CheckEmail. Which, as you can see from the errors above, makes sense. I have no idea what to do about this error though, I'm not sure why its attempting to input NULL's for the fields listed since they are, of course, supplied when making the new user. Any thoughts?

Is there a chance any of your stored procedures on your SQL database have been altered or corrupted? I have a Win 2008 Server running SQL 2008 R2 and I cannot reproduce the error on my end on a clean install --

I don't know the code well enough to tell if that's a stored_proc gone bad or something else - but I can't reproduce it on a fairly identical setup (for the most part) -- so that's what I'd lean towards --

Are you using default providers (I think you answered before but I can't remember as I post this) --

I don't know for sure without knowing what values are passed in each case. He needs to fetch db and reprocude it on a local machine.

I'd like to get into the middle of this with you and help you out -- I've just been extremely stacked up on projects as of late and haven't been able to get caught up.