search

feathersjs-ecosystem / feathers-authentication-management

Adds sign up verification, forgotten password reset, and other capabilities to local feathers-authentication
https://feathers-a-m.netlify.app/
MIT License
246 stars 98 forks source link

MYSQL Error Verifying e-mail Token #129

Closed mikerhino closed 4 years ago

mikerhino commented 4 years ago

Getting a mysql error upon email verification:

error: message=update users set isVerified = true, verifyToken = NULL, verifyShortToken = NULL, verifyExpires = NULL, verifyChanges = {} where id = 6 - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where id = 6' at line 1, type=FeathersError, name=BadRequest, code=400, className=bad-request, data=undefined, , stack=BadRequest: update users set isVerified = true, verifyToken = NULL, verifyShortToken = NULL, verifyExpires = NULL, verifyChanges = {} where id = 6 - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where id = 6' at line 1

The problem is the verifyChanges = {}, mysql rejects the curly braces as an error.

in lib/verifySignup.js line 62 if I change it from:

verifyChanges: {}

to

verifyChanges: NULL

I'm able to get by the error.

claustres commented 4 years ago

This issue being old we close it as we are trying to give a fresh look, please reopen if required and provide as much information as possible to reproduce it.