Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Passport returns SQL-query error message when requesting access token with client_id that contains non numeric characters #241

Closed
noini opened this issue Jan 19, 2017 · 4 comments

Comments

@noini
Copy link

noini commented Jan 19, 2017

Passport returns SQL-query error message when you request access token (aouth/token) with grant_type:password and use valid credentials (client_secret, username, password, scopes) with client_id that contains non numeric character (ie. 123A). Should be minor problem as you need to have all other credentials correct to reproduce the error.

Error message:
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'client_id' at row 1 (SQL: insert into 'oauth_access_tokens' ('id', 'user_id', 'client_id', 'scopes', 'revoked', 'created_at', 'updated_at', 'expires_at') values (57abbf96384a122df3f4a..., 1, 123A, [], 0, 2017-01-19 10:27:56, 2017-01-19 10:27:56, 2017-01-20 10:27:56))

@frijj2k
Copy link

frijj2k commented Feb 14, 2017

Please see this thread: #14

You need to use the numeric id for the client_id.

@themsaid
Copy link
Member

themsaid commented Jul 5, 2017

Closing for lack of activity, hope you got the help you needed :)

@themsaid themsaid closed this as completed Jul 5, 2017
@baig772
Copy link

baig772 commented Nov 20, 2018

Any update on this? I am facing the same issue

@kolozjnr
Copy link

please any update this, i'm also having same issue in 2022

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

5 participants