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"=>"glo@glo.com", "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" = 'glo@glo.com' 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", "glo@glo.com"], ["encrypted_password", "$2a10
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:in
create'