What about GitHub users w/o (or non-public) email?
I get this for the GH account
splattael (no public email):
Hanami::Model::NotNullConstraintViolationError: SQLite3::ConstraintException: NOT NULL constraint failed: users.email /home/ps/.rvm/gems/ruby-2.3.3@pg/gems/hanami-model-0.7.0/lib/hanami/repository.rb:302:in `rescue in create' /home/ps/.rvm/gems/ruby-2.3.3@pg/gems/hanami-model-0.7.0/lib/hanami/repository.rb:300:in `create' /opt/ps/home/devel/_private/collaborators/lib/collaborators/repositories/user_repository.rb:4:in `find_or_create' /opt/ps/home/devel/_private/collaborators/apps/web/controllers/sessions/create.rb:11:in `call' /home/ps/.rvm/gems/ruby-2.3.3@pg/gems/hanami-controller-0.8.0/lib/hanami/action/callbacks.rb:195:in `call' /home/ps/.rvm/gems/ruby-2.3.3@pg/gems/hanami-controller-0.8.0/lib/hanami/action/callable.rb:71:in `block in call'
This testing organization, has also an OAuth2 application for authentication. Please check it here: https://github.com/organizations/hanami-workshop/settings/applications/443165 and copy the "Client Secret" in your .env.development
Sequel::DatabaseError: PG::UndefinedObject: ERROR: constraint "email" of relation "users" does not exist
drop_constraintwith the name of the constraint. and they don't match
psql template1 \l # to list existing databases CREATE DATABASE organizations; \l # to see the db in the list \q # to quit