Hi, I am using DNN 06.01.01. I can login through host user but I am unable to create a new user. From the Event viewer of DNN i got the following error / exception.

Message: DotNetNuke.Services.Exceptions.ModuleLoadException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_UserProfile_Users". The conflict occurred in database "SO-Upgrade", table "dbo.Users", column 'UserID'. The statement has been terminated. ---> System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_UserProfile_Users". The conflict occurred in database "SO-Upgrade", table "dbo.Users", column 'UserID'. The statement has been terminated. at System.Data.SqlClient.SqlConnection. (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 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Security.Membership.Data.SqlDataProvider.UpdateProfileProperty(Int32 profileId, Int32 userId, Int32 propertyDefinitionID, String propertyValue, Int32 visibility, DateTime lastUpdatedDate) at DotNetNuke.Security.Profile.DNNProfileProvider.UpdateUserProfile(UserInfo user) at DotNetNuke.Security.Profile.DNNProfileProvider.UpdateTimeZoneInfo(UserInfo user, ProfilePropertyDefinitionCollection properties) at DotNetNuke.Security.Profile.DNNProfileProvider.GetUserProfile(UserInfo& user) at DotNetNuke.Entities.Users.UserInfo.get_Profile() at DotNetNuke.Entities.Modules.UserModuleBase.InitialiseUser() at DotNetNuke.Entities.Modules.UserModuleBase.get_User() at DotNetNuke.Modules.Admin.Users.ManageUsers.BindData() at DotNetNuke.Modules.Admin.Users.ManageUsers.OnLoad(EventArgs e) --- End of inner exception stack trace ---

Can some one help ??

Thanks In Advance.

Steven, SO-Upgrade is name of the database, i.e. no 3rd party extension involved.
Imran, it looks like the Database tries to insert userprofile data for users, who don't exist in user table any longer. Since there is no other user table the userID might reside in, I assume the procedure tries inserting a Null value. In this case, there is an issue with your installation, the code doesn't fit database structure, either due to files not replaced during the upgrade or database scripts not being run. Please re-unzip all files from DNN upgrade package (make sure, you unblocked the zip file before!!) and check database upgrade log files inside /providers/dataproviders/sqldataprovider folder.

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN

it is very strange, I haven't seen it before. Please check the database and stored procedures to add user - maybe one of it hasn't properly replaced during upgrade (check upgrade logs inside /providers/dataprooviders/sqldataprovider folder as well!)

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN