I got openproject up and running on my server. When I went to register an account however i got an internal error. I thought it was that I had the smtp settings punched in wrong (I’m using a third party smtp service), so i created a gmail and tried to use that. Same issue. These are the errors in my production.log that I think might be relevant

I, [2016-11-10T06:09:57.562237 #6716] INFO — : Rendered account/_login.html.erb (3.1ms)
I, [2016-11-10T06:09:57.563161 #6716] INFO — : Rendered layouts/_action_menu.html.erb (0.0ms)
I, [2016-11-10T06:09:57.563767 #6716] INFO — : Completed 200 OK in 43ms (Views: 30.6ms | ActiveRecord: 6.7ms)
W, [2016-11-10T06:10:26.441586 #8280] WARN — : [auth_saml] Missing settings from ‘/home/openproject/openproject-ce/config/plugins/auth_saml/settings.yml’, skipping omniauth r$
W, [2016-11-10T06:10:26.474261 #8280] WARN — : hook registered
I, [2016-11-10T06:10:31.042043 #8301] INFO — : Started GET “/account/register” for 67.168.247.190 at 2016-11-10 06:10:31 +0100
I, [2016-11-10T06:10:31.195952 #8301] INFO — : Processing by AccountController#register as HTML
I, [2016-11-10T06:10:31.343205 #8301] INFO — : Rendered customizable/_field.html.erb (0.0ms)
I, [2016-11-10T06:10:31.388845 #8301] INFO — : Rendered hooks/login/_auth_provider.html.erb (0.5ms)
I, [2016-11-10T06:10:31.393273 #8301] INFO — : Rendered vendored-plugins/openproject-auth_plugins/app/views/hooks/login/_providers.html.erb (1.0ms)
I, [2016-11-10T06:10:31.393360 #8301] INFO — : Rendered account/_auth_providers.html.erb (28.0ms)
I, [2016-11-10T06:10:31.393827 #8301] INFO — : Rendered account/register.html.erb within layouts/base (100.7ms)
I, [2016-11-10T06:10:31.436944 #8301] INFO — : Rendered common/_favicons.html.erb (1.8ms)
I, [2016-11-10T06:10:31.500762 #8301] INFO — : Rendered search/_mini_form.html.erb (1.4ms)
I, [2016-11-10T06:10:31.548399 #8301] INFO — : Rendered hooks/login/_auth_provider.html.erb (0.0ms)
I, [2016-11-10T06:10:31.393273 #8301] INFO — : Rendered vendored-plugins/openproject-auth_plugins/app/views/hooks/login/_providers.html.erb (1.0ms)
I, [2016-11-10T06:10:31.393360 #8301] INFO — : Rendered account/_auth_providers.html.erb (28.0ms)
I, [2016-11-10T06:10:31.393827 #8301] INFO — : Rendered account/register.html.erb within layouts/base (100.7ms)
I, [2016-11-10T06:10:31.436944 #8301] INFO — : Rendered common/_favicons.html.erb (1.8ms)
I, [2016-11-10T06:10:31.500762 #8301] INFO — : Rendered search/_mini_form.html.erb (1.4ms)
I, [2016-11-10T06:10:31.548399 #8301] INFO — : Rendered hooks/login/_auth_provider.html.erb (0.0ms)
I, [2016-11-10T06:10:31.548748 #8301] INFO — : Rendered vendored-plugins/openproject-auth_plugins/app/views/hooks/login/_providers.html.erb (0.2ms)
I, [2016-11-10T06:10:31.548834 #8301] INFO — : Rendered account/_auth_providers.html.erb (1.3ms)
I, [2016-11-10T06:10:31.550359 #8301] INFO — : Rendered account/_login.html.erb (29.1ms)
I, [2016-11-10T06:10:31.573139 #8301] INFO — : Rendered layouts/_action_menu.html.erb (0.5ms)
I, [2016-11-10T06:10:31.574707 #8301] INFO — : Completed 200 OK in 379ms (Views: 317.4ms | ActiveRecord: 14.6ms)
I, [2016-11-10T06:11:05.515706 #8301] INFO — : Started POST “/account/register” for 67.168.247.190 at 2016-11-10 06:11:05 +0100
I, [2016-11-10T06:11:05.517521 #8301] INFO — : Processing by AccountController#register as HTML
I, [2016-11-10T06:11:05.517594 #8301] INFO — : Parameters: {“utf8”=>“✓”, “authenticity_token”=>"KwKxUwO9YpX7cyeeZsI8waR2vomJKvyl3HQvnMtIf1GFKjnCfu2/kvBunUwXDhvLjL5Hi2Hwc+Ah$
I, [2016-11-10T06:11:05.564768 #8301] INFO — : Completed 500 Internal Server Error in 47ms (ActiveRecord: 10.8ms)
F, [2016-11-10T06:11:05.565961 #8301] FATAL — :
ActiveRecord::StatementInvalid (Mysql2::Error: Field ‘type’ doesn’t have a default value: INSERT INTO `user_passwords` (`user_id`, `created_at`, `updated_at`, `salt`, `hashed_p$
app/models/user.rb:170:in `update_password’
app/controllers/account_controller.rb:493:in `register_manually_by_administrator’
app/controllers/account_controller.rb:452:in `register_user_according_to_setting’
app/controllers/account_controller.rb:286:in `self_registration!’
app/controllers/account_controller.rb:123:in `register’
app/middleware/reset_current_user.rb:47:in `call’
app/middleware/params_parser_with_exclusion.rb:40:in `call’