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

Created by: riyad

I had this in another project and could not find the source of the error. A lot of poking and prodding as well as online research yielded no results. Switching to MySQL solved it for me too.

Through that I remembered a piece of advice: "always make your dev env as similar to your production env as possible" so, if you don't need SQLite (in production), don't use SQLite (in development)! ;)

By Administrator on 2012-08-23T17:28:12 (imported from GitLab project)

By Administrator on 2012-08-23T17:28:12 (imported from GitLab)

Created by: rcrosbourne

I just had this problem. It turned out to be a permission problem. http://surgeworks.com/blog/error-or-missing-database solved it for me.

By Administrator on 2012-11-16T14:48:32 (imported from GitLab project)

By Administrator on 2012-11-16T14:48:32 (imported from GitLab)