Errors with an oauth2 clients and Postgresql
Created by: ma1uta
When tried add new oauth application:
2018-05-20T11:37:58Z:LOG_ERR:hm3dd5luukav3njiku3fv1lord:dba_driver.php:459:db_logger: dba_pdo: ERROR: SELECT oauth_clients.*, oauth_access_tokens.access_token as oauth_token, (oauth_clients.user_id = '2') AS my
FROM oauth_clients
LEFT JOIN oauth_access_tokens ON oauth_clients.client_id=oauth_access_tokens.client_id
WHERE oauth_clients.user_id IN ('2',0);
SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: character varying = integer
LINE 4: WHERE oauth_clients.user_id IN ('2',0);
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
2018-05-20T11:38:07Z:LOG_ERR:hm3dd5luukav3njiku3fv1lord:dba_driver.php:459:db_logger: dba_pdo: ERROR: INSERT INTO oauth_clients (client_id, client_secret, redirect_uri, grant_types, scope, user_id)
VALUES ('acpub','e9935616e4443dde','','','','2');
SQLSTATE[42501]: Insufficient privilege: 7 ERROR: permission denied for relation oauth_clients
2018-05-20T11:38:07Z:LOG_ERR:hm3dd5luukav3njiku3fv1lord:dba_driver.php:459:db_logger: dba_pdo: ERROR: SELECT oauth_clients.*, oauth_access_tokens.access_token as oauth_token, (oauth_clients.user_id = '2') AS my
FROM oauth_clients
LEFT JOIN oauth_access_tokens ON oauth_clients.client_id=oauth_access_tokens.client_id
WHERE oauth_clients.user_id IN ('2',0);
SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: character varying = integer
LINE 4: WHERE oauth_clients.user_id IN ('2',0);
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
2018-05-20T11:38:11Z:LOG_ERR:hm3dd5luukav3njiku3fv1lord:dba_driver.php:459:db_logger: dba_pdo: ERROR: SELECT oauth_clients.*, oauth_access_tokens.access_token as oauth_token, (oauth_clients.user_id = '2') AS my
FROM oauth_clients
LEFT JOIN oauth_access_tokens ON oauth_clients.client_id=oauth_access_tokens.client_id
WHERE oauth_clients.user_id IN ('2',0);
SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: character varying = integer
LINE 4: WHERE oauth_clients.user_id IN ('2',0);
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.