Closed 001123 closed 6 years ago
BadRequest: insert into users (google, googleId) values ({"profile":{"id":"112530535560973408540","displayName":"Duy Bui","name":{"familyName":"Bui","givenName":"Duy"},"emails":[{"value":"duy.bui@maplestudio.vn","type":"account"}],"photos":[{"value":"https://lh4.googleusercontent.com/-btDj0gKXq5M/AAAAAAAAAAI/AAAAAAAAACA/AD8zX4kVBpg/photo.jpg?sz=50"}],"provider":"google","_raw":"{\n \"kind\": \"plus#person\",\n \"etag\": \"\\"RKS4-q7QGL10FxltAebpjqjKQR0/phfzBas9_c1ddpX_v6X7PGSbLS4\\"\",\n \"emails\": [\n {\n \"value\": \"duy.bui@maplestudio.vn\",\n \"type\": \"account\"\n }\n ],\n \"objectType\": \"person\",\n \"id\": \"112530535560973408540\",\n \"displayName\": \"Duy Bui\",\n \"name\": {\n \"familyName\": \"Bui\",\n \"givenName\": \"Duy\"\n },\n \"image\": {\n \"url\": \"https://lh4.googleusercontent.com/-btDj0gKXq5M/AAAAAAAAAAI/AAAAAAAAACA/AD8zX4kVBpg/photo.jpg?sz=50\",\n \"isDefault\": false\n },\n \"isPlusUser\": false,\n \"language\": \"en\",\n \"verified\": false,\n \"domain\": \"maplestudio.vn\"\n}\n","_json":{"kind":"plus#person","etag":"\"RKS4-q7QGL10FxltAebpjqjKQR0/phfzBas9_c1ddpX_v6X7PGSbLS4\"","emails":[{"value":"duy.bui@maplestudio.vn","type":"account"}],"objectType":"person","id":"112530535560973408540","displayName":"Duy Bui","name":{"familyName":"Bui","givenName":"Duy"},"image":{"url":"https://lh4.googleusercontent.com/-btDj0gKXq5M/AAAAAAAAAAI/AAAAAAAAACA/AD8zX4kVBpg/photo.jpg?sz=50","isDefault":false},"isPlusUser":false,"language":"en","verified":false,"domain":"maplestudio.vn"}},"accessToken":"hidden"}, '112530535560973408540') - Column count doesn't match value count at row 1
users
google
googleId
Im using 'users' service with knexjs
You may have to customize the verifier or oAuth response to match your user schema.
Thanks for help , feathers is awesome 😃
👍
BadRequest: insert into
users
(google
,googleId
) values ({"profile":{"id":"112530535560973408540","displayName":"Duy Bui","name":{"familyName":"Bui","givenName":"Duy"},"emails":[{"value":"duy.bui@maplestudio.vn","type":"account"}],"photos":[{"value":"https://lh4.googleusercontent.com/-btDj0gKXq5M/AAAAAAAAAAI/AAAAAAAAACA/AD8zX4kVBpg/photo.jpg?sz=50"}],"provider":"google","_raw":"{\n \"kind\": \"plus#person\",\n \"etag\": \"\\"RKS4-q7QGL10FxltAebpjqjKQR0/phfzBas9_c1ddpX_v6X7PGSbLS4\\"\",\n \"emails\": [\n {\n \"value\": \"duy.bui@maplestudio.vn\",\n \"type\": \"account\"\n }\n ],\n \"objectType\": \"person\",\n \"id\": \"112530535560973408540\",\n \"displayName\": \"Duy Bui\",\n \"name\": {\n \"familyName\": \"Bui\",\n \"givenName\": \"Duy\"\n },\n \"image\": {\n \"url\": \"https://lh4.googleusercontent.com/-btDj0gKXq5M/AAAAAAAAAAI/AAAAAAAAACA/AD8zX4kVBpg/photo.jpg?sz=50\",\n \"isDefault\": false\n },\n \"isPlusUser\": false,\n \"language\": \"en\",\n \"verified\": false,\n \"domain\": \"maplestudio.vn\"\n}\n","_json":{"kind":"plus#person","etag":"\"RKS4-q7QGL10FxltAebpjqjKQR0/phfzBas9_c1ddpX_v6X7PGSbLS4\"","emails":[{"value":"duy.bui@maplestudio.vn","type":"account"}],"objectType":"person","id":"112530535560973408540","displayName":"Duy Bui","name":{"familyName":"Bui","givenName":"Duy"},"image":{"url":"https://lh4.googleusercontent.com/-btDj0gKXq5M/AAAAAAAAAAI/AAAAAAAAACA/AD8zX4kVBpg/photo.jpg?sz=50","isDefault":false},"isPlusUser":false,"language":"en","verified":false,"domain":"maplestudio.vn"}},"accessToken":"hidden"}, '112530535560973408540') - Column count doesn't match value count at row 1