{"action":"created","issue":{"url":"https://api.github.com/repos/wolfcms/wolfcms/issues/651","repository_url":"https://api.github.com/repos/wolfcms/wolfcms","labels_url":"https://api.github.com/repos/wolfcms/wolfcms/issues/651/labels{/name}","comments_url":"https://api.github.com/repos/wolfcms/wolfcms/issues/651/comments","events_url":"https://api.github.com/repos/wolfcms/wolfcms/issues/651/events","html_url":"https://github.com/wolfcms/wolfcms/pull/651","id":148937280,"number":651,"title":"Fixed bug #520: childrenCount() and children() not working on PostgreSQL","user":{"login":"korbeljak","id":17032800,"avatar_url":"https://avatars.githubusercontent.com/u/17032800?v=3","gravatar_id":"","url":"https://api.github.com/users/korbeljak","html_url":"https://github.com/korbeljak","followers_url":"https://api.github.com/users/korbeljak/followers","following_url":"https://api.github.com/users/korbeljak/following{/other_user}","gists_url":"https://api.github.com/users/korbeljak/gists{/gist_id}","starred_url":"https://api.github.com/users/korbeljak/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/korbeljak/subscriptions","organizations_url":"https://api.github.com/users/korbeljak/orgs","repos_url":"https://api.github.com/users/korbeljak/repos","events_url":"https://api.github.com/users/korbeljak/events{/privacy}","received_events_url":"https://api.github.com/users/korbeljak/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-04-17T10:11:13Z","updated_at":"2016-04-17T10:11:54Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/wolfcms/wolfcms/pulls/651","html_url":"https://github.com/wolfcms/wolfcms/pull/651","diff_url":"https://github.com/wolfcms/wolfcms/pull/651.diff","patch_url":"https://github.com/wolfcms/wolfcms/pull/651.patch"},"body":"Fixes #520 \r\n\r\nChanges proposed in this pull request:\r\n\r\n- Use valid_until IS NULL instead of COALESCE(valid_until, '') = '' to get the PostgreSQL working.\r\n\r\n- SQLite checked locally and working.\r\n- MySQL checked locally and working.\r\n\r\n@wolfcms/core-developers\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/wolfcms/wolfcms/issues/comments/210990944","html_url":"https://github.com/wolfcms/wolfcms/pull/651#issuecomment-210990944","issue_url":"https://api.github.com/repos/wolfcms/wolfcms/issues/651","id":210990944,"user":{"login":"korbeljak","id":17032800,"avatar_url":"https://avatars.githubusercontent.com/u/17032800?v=3","gravatar_id":"","url":"https://api.github.com/users/korbeljak","html_url":"https://github.com/korbeljak","followers_url":"https://api.github.com/users/korbeljak/followers","following_url":"https://api.github.com/users/korbeljak/following{/other_user}","gists_url":"https://api.github.com/users/korbeljak/gists{/gist_id}","starred_url":"https://api.github.com/users/korbeljak/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/korbeljak/subscriptions","organizations_url":"https://api.github.com/users/korbeljak/orgs","repos_url":"https://api.github.com/users/korbeljak/repos","events_url":"https://api.github.com/users/korbeljak/events{/privacy}","received_events_url":"https://api.github.com/users/korbeljak/received_events","type":"User","site_admin":false},"created_at":"2016-04-17T10:11:54Z","updated_at":"2016-04-17T10:11:54Z","body":"Sorry for the additional pull request, I had to put my repository in order for multiple bugfixes in separate branches."}}