{"action":"created","issue":{"url":"https://api.github.com/repos/ansible/ansible-modules-core/issues/3818","repository_url":"https://api.github.com/repos/ansible/ansible-modules-core","labels_url":"https://api.github.com/repos/ansible/ansible-modules-core/issues/3818/labels{/name}","comments_url":"https://api.github.com/repos/ansible/ansible-modules-core/issues/3818/comments","events_url":"https://api.github.com/repos/ansible/ansible-modules-core/issues/3818/events","html_url":"https://github.com/ansible/ansible-modules-core/pull/3818","id":157934764,"number":3818,"title":"Fix cursor.execute requiring an iterable","user":{"login":"jnerin","id":2012580,"avatar_url":"https://avatars.githubusercontent.com/u/2012580?v=3","gravatar_id":"","url":"https://api.github.com/users/jnerin","html_url":"https://github.com/jnerin","followers_url":"https://api.github.com/users/jnerin/followers","following_url":"https://api.github.com/users/jnerin/following{/other_user}","gists_url":"https://api.github.com/users/jnerin/gists{/gist_id}","starred_url":"https://api.github.com/users/jnerin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jnerin/subscriptions","organizations_url":"https://api.github.com/users/jnerin/orgs","repos_url":"https://api.github.com/users/jnerin/repos","events_url":"https://api.github.com/users/jnerin/events{/privacy}","received_events_url":"https://api.github.com/users/jnerin/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/ansible/ansible-modules-core/labels/bugfix_pull_request","name":"bugfix_pull_request","color":"ded270"},{"url":"https://api.github.com/repos/ansible/ansible-modules-core/labels/needs_revision","name":"needs_revision","color":"eb6420"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2016-06-01T15:20:55Z","updated_at":"2016-09-16T09:27:31Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/ansible/ansible-modules-core/pulls/3818","html_url":"https://github.com/ansible/ansible-modules-core/pull/3818","diff_url":"https://github.com/ansible/ansible-modules-core/pull/3818.diff","patch_url":"https://github.com/ansible/ansible-modules-core/pull/3818.patch"},"body":"##### ISSUE TYPE\r\n - Bugfix Pull Request\r\n\r\n##### COMPONENT NAME\r\nansible_module_mysql_user\r\n\r\n##### ANSIBLE VERSION\r\nansible 2.1.0.0\r\n  config file = /etc/ansible/ansible.cfg\r\n  configured module search path = Default w/o overrides\r\n\r\n##### SUMMARY\r\nThis fixes the error I got when using host_all:\r\n\r\nAn exception occurred during task execution. The full traceback is:\r\nTraceback (most recent call last):\r\n  File \"/tmp/ansible_7Rvlhp/ansible_module_mysql_user.py\", line 582, in <module>\r\n    main()\r\n  File \"/tmp/ansible_7Rvlhp/ansible_module_mysql_user.py\", line 571, in main\r\n    if user_exists(cursor, user, host, host_all):\r\n  File \"/tmp/ansible_7Rvlhp/ansible_module_mysql_user.py\", line 216, in user_exists\r\n    cursor.execute(\"SELECT count(*) FROM user WHERE user = %s\", user)\r\n  File \"/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py\", line 198, in execute\r\n    query = query % args\r\nTypeError: not all arguments converted during string formatting"},"comment":{"url":"https://api.github.com/repos/ansible/ansible-modules-core/issues/comments/247557317","html_url":"https://github.com/ansible/ansible-modules-core/pull/3818#issuecomment-247557317","issue_url":"https://api.github.com/repos/ansible/ansible-modules-core/issues/3818","id":247557317,"user":{"login":"gregdek","id":252125,"avatar_url":"https://avatars.githubusercontent.com/u/252125?v=3","gravatar_id":"","url":"https://api.github.com/users/gregdek","html_url":"https://github.com/gregdek","followers_url":"https://api.github.com/users/gregdek/followers","following_url":"https://api.github.com/users/gregdek/following{/other_user}","gists_url":"https://api.github.com/users/gregdek/gists{/gist_id}","starred_url":"https://api.github.com/users/gregdek/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gregdek/subscriptions","organizations_url":"https://api.github.com/users/gregdek/orgs","repos_url":"https://api.github.com/users/gregdek/repos","events_url":"https://api.github.com/users/gregdek/events{/privacy}","received_events_url":"https://api.github.com/users/gregdek/received_events","type":"User","site_admin":false},"created_at":"2016-09-16T09:27:31Z","updated_at":"2016-09-16T09:27:31Z","body":"@jnerin A friendly reminder: this pull request has been marked as needing your action. If you still believe that this PR applies, and you intend to address the issues with this PR, just let us know in the PR itself and we will keep it open pending your changes. When you do address the issues, please respond with ready_for_review in your comment, so that we can notify the maintainer.\n\n[This message brought to you by your friendly Ansibull-bot.]"}}
{"actor":{"display_login":"gregdek"}}