{"action":"created","issue":{"url":"https://api.github.com/repos/yikesinc/yikes-inc-easy-mailchimp-extender/issues/563","repository_url":"https://api.github.com/repos/yikesinc/yikes-inc-easy-mailchimp-extender","labels_url":"https://api.github.com/repos/yikesinc/yikes-inc-easy-mailchimp-extender/issues/563/labels{/name}","comments_url":"https://api.github.com/repos/yikesinc/yikes-inc-easy-mailchimp-extender/issues/563/comments","events_url":"https://api.github.com/repos/yikesinc/yikes-inc-easy-mailchimp-extender/issues/563/events","html_url":"https://github.com/yikesinc/yikes-inc-easy-mailchimp-extender/issues/563","id":171395334,"number":563,"title":"several KILLED QUERY errors filling up my servers logs. ","user":{"login":"joe704la","id":1458631,"avatar_url":"https://avatars.githubusercontent.com/u/1458631?v=3","gravatar_id":"","url":"https://api.github.com/users/joe704la","html_url":"https://github.com/joe704la","followers_url":"https://api.github.com/users/joe704la/followers","following_url":"https://api.github.com/users/joe704la/following{/other_user}","gists_url":"https://api.github.com/users/joe704la/gists{/gist_id}","starred_url":"https://api.github.com/users/joe704la/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/joe704la/subscriptions","organizations_url":"https://api.github.com/users/joe704la/orgs","repos_url":"https://api.github.com/users/joe704la/repos","events_url":"https://api.github.com/users/joe704la/events{/privacy}","received_events_url":"https://api.github.com/users/joe704la/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-08-16T12:27:21Z","updated_at":"2016-08-16T14:15:36Z","closed_at":null,"body":"The error below is being thrown over and over again on my wordpress site. I just installed this plugin yesterday. Any Ideas?\r\n\r\nThis is part of the code that appears to be causing the error and causing the very long query to be killed. We have thousands of posts it is trying to pull into the query. \r\n\r\n// loop over registered post types, and query!\r\nforeach( $post_types as $registered_post_type ) {\r\n// exclude a few built in custom post types\r\nif( ! in_array( $registered_post_type , array( 'attachment' , 'revision' , 'nav_menu_item' ) ) ) {\r\n// run our query, to retreive the posts\r\n$pages = get_posts( array(...\r\n\r\nHere is part of the error it throws. I shortened it to post here. But it was much longer showing thousands of post ids.\r\nMon Aug 15 23:28:10.460525 2016] [:error] [pid 22817] [client 174.53.132.4:41702] KILLED QUERY (72434 characters long generated in ...wp-content/plugins/yikes-inc-easy-mailchimp-extender/admin/class-yikes-inc-easy-mailchimp-extender-admin.php:1561): SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id  WHERE tt.taxonomy IN ('event-tags', 'event-categories') AND tr.object_id IN (11520, 11776, 11521, ..."},"comment":{"url":"https://api.github.com/repos/yikesinc/yikes-inc-easy-mailchimp-extender/issues/comments/240115007","html_url":"https://github.com/yikesinc/yikes-inc-easy-mailchimp-extender/issues/563#issuecomment-240115007","issue_url":"https://api.github.com/repos/yikesinc/yikes-inc-easy-mailchimp-extender/issues/563","id":240115007,"user":{"login":"EvanHerman","id":5321364,"avatar_url":"https://avatars.githubusercontent.com/u/5321364?v=3","gravatar_id":"","url":"https://api.github.com/users/EvanHerman","html_url":"https://github.com/EvanHerman","followers_url":"https://api.github.com/users/EvanHerman/followers","following_url":"https://api.github.com/users/EvanHerman/following{/other_user}","gists_url":"https://api.github.com/users/EvanHerman/gists{/gist_id}","starred_url":"https://api.github.com/users/EvanHerman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/EvanHerman/subscriptions","organizations_url":"https://api.github.com/users/EvanHerman/orgs","repos_url":"https://api.github.com/users/EvanHerman/repos","events_url":"https://api.github.com/users/EvanHerman/events{/privacy}","received_events_url":"https://api.github.com/users/EvanHerman/received_events","type":"User","site_admin":false},"created_at":"2016-08-16T14:15:36Z","updated_at":"2016-08-16T14:15:36Z","body":"Hi Joe,\r\n\r\nWhat version of WordPress is your site running? There shouldn't be any errors when querying and looping over the post types, removing them etc.\r\n\r\nWhat version of PHP does your server run?\r\n\r\nI haven't seen that error popup before for any of our users, so I'm curious as to what may be the root of the problem.\r\n\r\n\r\nThanks,\r\nEvan"}}
{"actor":{"display_login":"EvanHerman"}}