ActiveRecord::StatementInvalid (TinyTds::Error: Cannot insert the value NULL into column...
Added by Md Raihan Majumder over 10 years ago
I m new to ruby as well as in redmine. When i am going to create a new user in redmine it is showing
the below error message.
" Internal error
An error occurred on the page you were trying to access.
If you continue to experience problems please contact your Redmine administrator for assistance.
If you are the Redmine administrator, check your log files for details about the error. "
I checked the development.log file. it is showing following error:
ActiveRecord::StatementInvalid (TinyTds::Error: Cannot insert the value NULL into column 'status', table 'Table-1'; column does not allow nulls. INSERT fails.: EXEC sp_executesql N'INSERT INTO users VALUES (Rangicaadmice Rangicaadmice, @1, 2 2, Яна Титаренко, @4, rqrrimewab rqrrimewab, @6, @7, WillSmith WillSmith, @9, Juan Guerrero, a a, @12, aaa aaa, @14, @15); SELECT CAST AS bigint) AS Ident', N'@0 bit, @1 int, @2 datetime, @3 nvarchar(30), @4 nvarchar(40), @5 nvarchar(255), @6 nvarchar(5), @7 datetime, @8 nvarchar(255), @9 nvarchar(255), @10 nvarchar(60), @11 nvarchar(255), @12 nvarchar(64), @13 int, @14 nvarchar(255), @15 datetime', @0 = 1, @1 = NULL, @2 = '2015-02-19T15:40:19.239', @3 = N'Brick', @4 = N'674e6d855f354edae2e92c021718798ba2912edf', @5 = NULL, @6 = N'en', @7 = NULL, @8 = N'Fill', @9 = N'olx', @10 = N'xxxx@gmail.com', a a = N'only_my_events', @12 = N'9375cf7435ac289920a9336fe8e5f34c', aaa aaa = NULL, @14 = N'User', @15 = '2015-02-19T15:40:19.239'):
app/controllers/users_controller.rb:93:in `create'
Please help if anyone went through similar problem!