I'm new to DNN.
When i try and add a new user using the user management module i get the following error, any pointer as to where to issue could be?
AssemblyVersion: 5.1.4
PortalID: 0
PortalName: tsp
UserID: 1
UserName: host
ActiveTabID: 48
ActiveTabName: User Accounts
RawURL: /Admin/UserAccounts/tabid/48/ctl/Edit/mid/365/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://tsp.org/Admin/UserAccounts/tabid/48/ctl/Edit/mid/365/Default.aspx
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.3) Gecko/20100401 Firefox/3.6.3 ( .NET CLR 3.5.30729)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 3f5eb2c2-940c-46a9-9c94-2e917a8cdf6c
InnerException: Cannot insert the value NULL into column 'IsDeleted', table 'DNN_CERF.dbo.Users'; column does not allow nulls. INSERT fails. Cannot insert the value NULL into column 'RefreshRoles', table 'DNN_CERF.dbo.UserPortals'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
Message: System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'IsDeleted', table 'DNN_CERF.dbo.Users'; column does not allow nulls. INSERT fails. Cannot insert the value NULL into column 'RefreshRoles', table 'DNN_CERF.dbo.UserPortals'; 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(TdsParserStateObject stateObj) 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 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Security.Membership.Data.SqlDataProvider.AddUser(Int32 PortalID, String Username, String FirstName, String LastName, Int32 AffiliateId, Boolean IsSuperUser, String Email, String DisplayName, Boolean UpdatePassword, Boolean IsApproved, Int32 createdByUserID) at DotNetNuke.Security.Membership.AspNetMembershipProvider.CreateDNNUser(UserInfo& user)
Source:
Server Name:
|