search

jared-dykstra / 180-decibels-website

Website for the (now decommissioned) 180Decibels.com
https://dashboard.heroku.com/apps/decibels-website/settings
1 stars 0 forks source link

Server Error - Duplicate email #66

Open jared-dykstra opened 5 years ago

jared-dykstra commented 5 years ago

If a user fills out the survey on two devices, but enters the same email on both, the 2nd attempt will fail.

2019-01-18T15:25:30+00:00 app[postgres.10041]: [DATABASE] [28-1]  sql_error_code = 23505 ERROR:  duplicate key value violates unique constraint "users_email"
2019-01-18T15:25:30+00:00 app[postgres.10041]: [DATABASE] [28-2]  sql_error_code = 23505 DETAIL:  Key (email)=(daytonfoster@gmail.com) already exists.
2019-01-18T15:25:30+00:00 app[postgres.10041]: [DATABASE] [28-3]  sql_error_code = 23505 STATEMENT:  update "users" set "uid" = $1, "aliases" = $2, "email" = $3, "properties" = $4 where "uid" = $5
jared-dykstra commented 5 years ago

Reported by @DaytonF

jared-dykstra commented 5 years ago

This hasn't yet been resolved. I think it's a high-priority issue