search

snowdriftcoop / snowdrift

Infrastructure for Snowdrift.coop. This is a MIRROR of https://gitlab.com/snowdrift/snowdrift. Your issue reports and merge requests are welcome, but they will be moved to gitlab.com. You are encouraged to start there instead!
https://snowdrift.coop
GNU Affero General Public License v3.0
92 stars 36 forks source link

Creating account with Persona causes Internal Server Error #230

Closed maiki closed 10 years ago

maiki commented 10 years ago

The Persona sign-in works for both new and existing accounts.

I am trying to create a new account with Persona. When Persona passes focus back to the site, it loads https://snowdrift.coop/auth/page/browserid/eyJhbGciOiJS... (it is a long string of characters), and gives me the following message:

Internal Server Error

SqlError {sqlState = "42601", sqlExecStatus = FatalError, sqlErrorMsg = "syntax error at or near \"user\"", sqlErrorDetail = "", sqlErrorHint = ""}

And I am not logged in.

Looking forward to trying it out! ^_^

dlthomas commented 10 years ago

Looks like this was a bug in Esqueleto (insertSelect was not quoting our column named "user"). Worked around it in Haskell for now (slow, but not going to matter unless we have a tremendous number of people signing up), and created a ticket on the esqueleto project.