create new user error with SQLite
Created by: ghost
Hello, I got an error when tried to create new user using SQLite. (No problem when switched to MySQL) (gitlab-2.7, issue reproduced in branch stable & master)
Started POST "/admin/users" for 93.215.46.27 at 2012-08-17 14:35:50 +0200
Processing by Admin::UsersController#create as HTML
Parameters: {"utf8"=>"✓", "authenticity_token"=>"NuViJ5y/qsFdsGEsuk9XWorbwu5u94y52J55YVpoD9U=", "user"=>{"name"=>"gloglo", "email"=>"[email protected]", "force_random_password"=>"[FILTERED]", "skype"=>"", "linkedin"=>"", "twitter"=>"", "projects_limit"=>"10", "admin"=>"0"}}
User Load (1.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 0 LIMIT 1
(0.4ms) begin transaction
User Exists (1.0ms) SELECT 1 FROM "users" WHERE "users"."email" = '[email protected]' LIMIT 1
User Load (1.1ms) SELECT "users".* FROM "users" WHERE "users"."authentication_token" = 'zoMaHjSdnGJPMsgndbyy' LIMIT 1
Binary data inserted for string type on column encrypted_password
SQL (5.6ms) INSERT INTO "users" ("admin", "authentication_token", "bio", "blocked", "created_at", "current_sign_in_at", "current_sign_in_ip", "dark_scheme", "email", "encrypted_password", "failed_attempts", "id", "last_sign_in_at", "last_sign_in_ip", "linkedin", "locked_at", "name", "projects_limit", "remember_created_at", "reset_password_sent_at", "reset_password_token", "sign_in_count", "skype", "theme_id", "twitter", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [["admin", false], ["authentication_token", "zoMaHjSdnGJPMsgndbyy"], ["bio", ""], ["blocked", false], ["created_at", Fri, 17 Aug 2012 12:35:51 UTC +00:00], ["current_sign_in_at", nil], ["current_sign_in_ip", ""], ["dark_scheme", false], ["email", "[email protected]"], ["encrypted_password", "$2a$10$lgp13i43WaUsPy1qyCSpp.3FWmje4BIeWtDkI8wBEbTnNtxv8vYuu"], ["failed_attempts", 0], ["id", 0], ["last_sign_in_at", nil], ["last_sign_in_ip", ""], ["linkedin", ""], ["locked_at", nil], ["name", "robot"], ["projects_limit", 10], ["remember_created_at", nil], ["reset_password_sent_at", nil], ["reset_password_token", ""], ["sign_in_count", 0], ["skype", ""], ["theme_id", 1], ["twitter", ""], ["updated_at", Fri, 17 Aug 2012 12:35:51 UTC +00:00]]
SQLite3::SQLException: SQL logic error or missing database: INSERT INTO "users" ("admin", "authentication_token", "bio", "blocked", "created_at", "current_sign_in_at", "current_sign_in_ip", "dark_scheme", "email", "encrypted_password", "failed_attempts", "id", "last_sign_in_at", "last_sign_in_ip", "linkedin", "locked_at", "name", "projects_limit", "remember_created_at", "reset_password_sent_at", "reset_password_token", "sign_in_count", "skype", "theme_id", "twitter", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
(1.0ms) rollback transaction
Completed 500 Internal Server Error in 563ms
ActiveRecord::StatementInvalid (SQLite3::SQLException: SQL logic error or missing database: INSERT INTO "users" ("admin", "authentication_token", "bio", "blocked", "created_at", "current_sign_in_at", "current_sign_in_ip", "dark_scheme", "email", "encrypted_password", "failed_attempts", "id", "last_sign_in_at", "last_sign_in_ip", "linkedin", "locked_at", "name", "projects_limit", "remember_created_at", "reset_password_sent_at", "reset_password_token", "sign_in_count", "skype", "theme_id", "twitter", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)):
app/controllers/admin/users_controller.rb:71:in block in create' app/controllers/admin/users_controller.rb:70:increate'