{"action":"created","issue":{"url":"https://api.github.com/repos/fcturner/passwords/issues/211","repository_url":"https://api.github.com/repos/fcturner/passwords","labels_url":"https://api.github.com/repos/fcturner/passwords/issues/211/labels{/name}","comments_url":"https://api.github.com/repos/fcturner/passwords/issues/211/comments","events_url":"https://api.github.com/repos/fcturner/passwords/issues/211/events","html_url":"https://github.com/fcturner/passwords/issues/211","id":155946160,"number":211,"title":"postgres UNION","user":{"login":"mtahiue","id":6840712,"avatar_url":"https://avatars.githubusercontent.com/u/6840712?v=3","gravatar_id":"","url":"https://api.github.com/users/mtahiue","html_url":"https://github.com/mtahiue","followers_url":"https://api.github.com/users/mtahiue/followers","following_url":"https://api.github.com/users/mtahiue/following{/other_user}","gists_url":"https://api.github.com/users/mtahiue/gists{/gist_id}","starred_url":"https://api.github.com/users/mtahiue/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mtahiue/subscriptions","organizations_url":"https://api.github.com/users/mtahiue/orgs","repos_url":"https://api.github.com/users/mtahiue/repos","events_url":"https://api.github.com/users/mtahiue/events{/privacy}","received_events_url":"https://api.github.com/users/mtahiue/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/fcturner/passwords/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":25,"created_at":"2016-05-20T11:50:54Z","updated_at":"2016-06-10T11:44:36Z","closed_at":null,"body":"Hi many thanks for your contribution\r\n\r\nI've done a fresh owncloud install, with postgres db\r\n\r\nI've added password apps from github master, freshly pulled from repo\r\n\r\nWhen loading the app in oc , there is an error 500\r\n\r\nLogs says  :\r\n\r\n`\"message\":\"Exception: {\\\"Exception\\\":\\\"Doctrine\\\\\\\\DBAL\\\\\\\\Exception\\\\\\\\DriverException\\\",\\\"Message\\\":\\\"An exception occurred while executing 'SELECT id, user_id, loginname, website, address, pass, properties, notes, creation_date, deleted FROM oc_passwords WHERE user_id = ? OR id IN (SELECT pwid FROM oc_passwords_share WHERE sharedto = ?) UNION ALL SELECT  uid as id, CASE WHEN displayname IS NULL THEN uid ELSE displayname END as user_id, NULL as loginname, uid as website, NULL as address, NULL as pass, NULL as properties, NULL as notes, NULL as creation_date, NULL as deleted FROM oc_users ORDER BY LOWER(website) ASC' with params [\\\\\\\"user\\\\\\\", \\\\\\\"user\\\\\\\"]:\\\\n\\\\nSQLSTATE[42804]: Datatype mismatch: 7 ERROR:  UNION types bigint and character varying cannot be matched\\\\nLINE 1: ...ords_share WHERE sharedto = $2) UNION ALL SELECT  uid as id,...\\\\n                                                             ^\\\",\\\"Code\\\":0,\\\"Trace\\\":\\\"#0 \\\\\\/var\\\\\\/www\\\\\\/owncloud\\\\\\/3rdparty\\\\\\/doctrine\\\\\\/dbal\\\\\\/lib\\\\\\/Doctrine\\\\\\/DBAL\\\\\\/DBALException.php(116): Doctrine\\\\\\\\DBAL\\\\\\\\Driver\\\\\\\\AbstractPostgreSQLDriver-`\r\n"},"comment":{"url":"https://api.github.com/repos/fcturner/passwords/issues/comments/225161268","html_url":"https://github.com/fcturner/passwords/issues/211#issuecomment-225161268","issue_url":"https://api.github.com/repos/fcturner/passwords/issues/211","id":225161268,"user":{"login":"abishai","id":2972428,"avatar_url":"https://avatars.githubusercontent.com/u/2972428?v=3","gravatar_id":"","url":"https://api.github.com/users/abishai","html_url":"https://github.com/abishai","followers_url":"https://api.github.com/users/abishai/followers","following_url":"https://api.github.com/users/abishai/following{/other_user}","gists_url":"https://api.github.com/users/abishai/gists{/gist_id}","starred_url":"https://api.github.com/users/abishai/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/abishai/subscriptions","organizations_url":"https://api.github.com/users/abishai/orgs","repos_url":"https://api.github.com/users/abishai/repos","events_url":"https://api.github.com/users/abishai/events{/privacy}","received_events_url":"https://api.github.com/users/abishai/received_events","type":"User","site_admin":false},"created_at":"2016-06-10T11:44:36Z","updated_at":"2016-06-10T11:44:36Z","body":"Are blob fields has stream values in case of mysql or sqlite?\r\n[\"pass\":protected]=>\r\nresource(44) of type (stream)\r\n\r\ntype stream breaks json_encode()"}}
{"actor":{"display_login":"abishai"}}