{"action":"created","issue":{"url":"https://api.github.com/repos/substrakt/engine-wrangler/issues/1","labels_url":"https://api.github.com/repos/substrakt/engine-wrangler/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/substrakt/engine-wrangler/issues/1/comments","events_url":"https://api.github.com/repos/substrakt/engine-wrangler/issues/1/events","html_url":"https://github.com/substrakt/engine-wrangler/issues/1","id":62783187,"number":1,"title":"mysql issue","user":{"login":"smithellis","id":1088460,"avatar_url":"https://avatars.githubusercontent.com/u/1088460?v=3","gravatar_id":"","url":"https://api.github.com/users/smithellis","html_url":"https://github.com/smithellis","followers_url":"https://api.github.com/users/smithellis/followers","following_url":"https://api.github.com/users/smithellis/following{/other_user}","gists_url":"https://api.github.com/users/smithellis/gists{/gist_id}","starred_url":"https://api.github.com/users/smithellis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/smithellis/subscriptions","organizations_url":"https://api.github.com/users/smithellis/orgs","repos_url":"https://api.github.com/users/smithellis/repos","events_url":"https://api.github.com/users/smithellis/events{/privacy}","received_events_url":"https://api.github.com/users/smithellis/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-03-18T19:48:51Z","updated_at":"2015-03-19T12:48:46Z","closed_at":null,"body":"I'm getting a MySQL error when I run; it looks like:\r\n\r\n    Traceback (most recent call last):\r\n      File \"/home/XXXX/wrangler/bin/ew\", line 128, in <module>\r\n        'entry_date': lambda v: (\r\n      File \"/home/XXXX/wrangler/local/lib/python2.7/site-packages/enginewrangler/__init__.py\", line 277, in describe\r\n        for key, value in self._prepare(item, prefix, fields, aliases, transformers).items():\r\n      File \"/home/XXXX/wrangler/local/lib/python2.7/site-packages/enginewrangler/__init__.py\", line 259, in _prepare\r\n        k, v = t(a(key), value)\r\n      File \"/home/XXXX/wrangler/local/lib/python2.7/site-packages/enginewrangler/__init__.py\", line 243, in t\r\n    v = transformers[key](value)\r\n      File \"/home/XXXX/wrangler/bin/ew\", line 122, in <lambda>\r\n    member_id = v\r\n      File \"/home/XXXX/wrangler/local/lib/python2.7/site-packages/enginewrangler/__init__.py\", line 138, in _pivot\r\n        cursor.execute(sql, params)\r\n      File \"/home/XXXX/wrangler/local/lib/python2.7/site-packages/MySQLdb/cursors.py\", line 205, in execute\r\n    self.errorhandler(self, exc, value)\r\n      File \"/home/XXXX/wrangler/local/lib/python2.7/site-packages/MySQLdb/connections.py\", line 36, in defaulterrorhandler\r\n        raise errorclass, errorvalue\r\n    _mysql_exceptions.ProgrammingError: (1064, \"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM exp_member_data AS d WHERE (d.member_id = 1)' at line 1\")\r\n    \r\nAny ideas?"},"comment":{"url":"https://api.github.com/repos/substrakt/engine-wrangler/issues/comments/83542584","html_url":"https://github.com/substrakt/engine-wrangler/issues/1#issuecomment-83542584","issue_url":"https://api.github.com/repos/substrakt/engine-wrangler/issues/1","id":83542584,"user":{"login":"iamsteadman","id":3310393,"avatar_url":"https://avatars.githubusercontent.com/u/3310393?v=3","gravatar_id":"","url":"https://api.github.com/users/iamsteadman","html_url":"https://github.com/iamsteadman","followers_url":"https://api.github.com/users/iamsteadman/followers","following_url":"https://api.github.com/users/iamsteadman/following{/other_user}","gists_url":"https://api.github.com/users/iamsteadman/gists{/gist_id}","starred_url":"https://api.github.com/users/iamsteadman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/iamsteadman/subscriptions","organizations_url":"https://api.github.com/users/iamsteadman/orgs","repos_url":"https://api.github.com/users/iamsteadman/repos","events_url":"https://api.github.com/users/iamsteadman/events{/privacy}","received_events_url":"https://api.github.com/users/iamsteadman/received_events","type":"User","site_admin":false},"created_at":"2015-03-19T12:48:46Z","updated_at":"2015-03-19T12:48:46Z","body":"Looks like a custom-field subquery that's gone awry. Do you have the facility to provide any SQL logs for recent queries? It'd be good to try and see the full query there (I hadn't built any better logging into the script itself, but I'm hoping maybe you can get that form MySQL?)"}}