Skip to content

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", "$2a10lgp13i43WaUsPy1qyCSpp.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'