{"action":"created","issue":{"url":"https://api.github.com/repos/AHAAAAAAA/PokemonGo-Map/issues/711","repository_url":"https://api.github.com/repos/AHAAAAAAA/PokemonGo-Map","labels_url":"https://api.github.com/repos/AHAAAAAAA/PokemonGo-Map/issues/711/labels{/name}","comments_url":"https://api.github.com/repos/AHAAAAAAA/PokemonGo-Map/issues/711/comments","events_url":"https://api.github.com/repos/AHAAAAAAA/PokemonGo-Map/issues/711/events","html_url":"https://github.com/AHAAAAAAA/PokemonGo-Map/issues/711","id":166717060,"number":711,"title":"too many SQL variables","user":{"login":"Biztactix-Ryan","id":357433,"avatar_url":"https://avatars.githubusercontent.com/u/357433?v=3","gravatar_id":"","url":"https://api.github.com/users/Biztactix-Ryan","html_url":"https://github.com/Biztactix-Ryan","followers_url":"https://api.github.com/users/Biztactix-Ryan/followers","following_url":"https://api.github.com/users/Biztactix-Ryan/following{/other_user}","gists_url":"https://api.github.com/users/Biztactix-Ryan/gists{/gist_id}","starred_url":"https://api.github.com/users/Biztactix-Ryan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Biztactix-Ryan/subscriptions","organizations_url":"https://api.github.com/users/Biztactix-Ryan/orgs","repos_url":"https://api.github.com/users/Biztactix-Ryan/repos","events_url":"https://api.github.com/users/Biztactix-Ryan/events{/privacy}","received_events_url":"https://api.github.com/users/Biztactix-Ryan/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-07-21T01:17:11Z","updated_at":"2016-07-21T01:29:31Z","closed_at":null,"body":"\r\n### Environment info\r\nOperating System: Server 2012 R2\r\n\r\nInstalled version of Python:\r\n2.712\r\n\r\n### Steps to reproduce\r\n1. c:\\python27\\python.exe runserver.py -u <user> -p <Pass> -dp -dg -H <IP> -P 85 -l \"400 Collins Street,Melbourne,Australia\" -st 20 -k <Key>\r\n2. Within a few scan steps i Get the below log\r\n\r\n\r\n### What have you tried?\r\n1. Deleting the PogoDB and let it rebuild\r\n2. It's working fine at other locations... \r\n\r\n### Logs or other output that would be helpful\r\n2016-07-21 11:13:19,476 [     search] [   INFO] Scanning step 12 of 2500.\r\n2016-07-21 11:13:20,615 [     models] [   INFO] Upserting 1 pokemon\r\n2016-07-21 11:13:20,618 [     models] [   INFO] Upserting 188 pokestops\r\nException in thread search_thread:\r\nTraceback (most recent call last):\r\n  File \"c:\\python27\\lib\\threading.py\", line 801, in __bootstrap_inner\r\n    self.run()\r\n  File \"c:\\python27\\lib\\threading.py\", line 754, in run\r\n    self.__target(*self.__args, **self.__kwargs)\r\n  File \"C:\\PokemonGo\\pogom\\search.py\", line 100, in search_loop\r\n    search(args)\r\n  File \"C:\\PokemonGo\\pogom\\search.py\", line 89, in search\r\n    parse_map(response_dict)\r\n  File \"C:\\PokemonGo\\pogom\\models.py\", line 143, in parse_map\r\n    InsertQuery(Pokestop, rows=pokestops.values()).upsert().execute()\r\n  File \"c:\\python27\\lib\\site-packages\\peewee.py\", line 3244, in execute\r\n    cursor = self._execute()\r\n  File \"c:\\python27\\lib\\site-packages\\peewee.py\", line 2656, in _execute\r\n    return self.database.execute_sql(sql, params, self.require_commit)\r\n  File \"c:\\python27\\lib\\site-packages\\peewee.py\", line 3492, in execute_sql\r\n    self.commit()\r\n  File \"c:\\python27\\lib\\site-packages\\peewee.py\", line 3316, in __exit__\r\n    reraise(new_type, new_type(*exc_args), traceback)\r\n  File \"c:\\python27\\lib\\site-packages\\peewee.py\", line 3485, in execute_sql\r\n    cursor.execute(sql, params or ())\r\nOperationalError: too many SQL variables\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/AHAAAAAAA/PokemonGo-Map/issues/comments/234132296","html_url":"https://github.com/AHAAAAAAA/PokemonGo-Map/issues/711#issuecomment-234132296","issue_url":"https://api.github.com/repos/AHAAAAAAA/PokemonGo-Map/issues/711","id":234132296,"user":{"login":"NgJason","id":6984333,"avatar_url":"https://avatars.githubusercontent.com/u/6984333?v=3","gravatar_id":"","url":"https://api.github.com/users/NgJason","html_url":"https://github.com/NgJason","followers_url":"https://api.github.com/users/NgJason/followers","following_url":"https://api.github.com/users/NgJason/following{/other_user}","gists_url":"https://api.github.com/users/NgJason/gists{/gist_id}","starred_url":"https://api.github.com/users/NgJason/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/NgJason/subscriptions","organizations_url":"https://api.github.com/users/NgJason/orgs","repos_url":"https://api.github.com/users/NgJason/repos","events_url":"https://api.github.com/users/NgJason/events{/privacy}","received_events_url":"https://api.github.com/users/NgJason/received_events","type":"User","site_admin":false},"created_at":"2016-07-21T01:29:31Z","updated_at":"2016-07-21T01:29:31Z","body":"duplicate: https://github.com/AHAAAAAAA/PokemonGo-Map/issues/699"}}
{"actor":{"display_login":"NgJason"}}