{"action":"created","issue":{"url":"https://api.github.com/repos/BurntSushi/nfldb/issues/134","labels_url":"https://api.github.com/repos/BurntSushi/nfldb/issues/134/labels{/name}","comments_url":"https://api.github.com/repos/BurntSushi/nfldb/issues/134/comments","events_url":"https://api.github.com/repos/BurntSushi/nfldb/issues/134/events","html_url":"https://github.com/BurntSushi/nfldb/issues/134","id":124702394,"number":134,"title":"2015 postseason schedule","user":{"login":"andr3w321","id":1230185,"avatar_url":"https://avatars.githubusercontent.com/u/1230185?v=3","gravatar_id":"","url":"https://api.github.com/users/andr3w321","html_url":"https://github.com/andr3w321","followers_url":"https://api.github.com/users/andr3w321/followers","following_url":"https://api.github.com/users/andr3w321/following{/other_user}","gists_url":"https://api.github.com/users/andr3w321/gists{/gist_id}","starred_url":"https://api.github.com/users/andr3w321/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/andr3w321/subscriptions","organizations_url":"https://api.github.com/users/andr3w321/orgs","repos_url":"https://api.github.com/users/andr3w321/repos","events_url":"https://api.github.com/users/andr3w321/events{/privacy}","received_events_url":"https://api.github.com/users/andr3w321/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2016-01-04T06:12:54Z","updated_at":"2016-01-28T22:32:29Z","closed_at":"2016-01-05T11:48:39Z","body":"It's been released http://www.nfl.com/news/story/0ap3000000616555/article/nfl-playoff-schedule-released but maybe not in the format that nfldb pulls it from?  I've ran nfldb-update but I don't see any 2015 postseason games in the db."},"comment":{"url":"https://api.github.com/repos/BurntSushi/nfldb/issues/comments/176455972","html_url":"https://github.com/BurntSushi/nfldb/issues/134#issuecomment-176455972","issue_url":"https://api.github.com/repos/BurntSushi/nfldb/issues/134","id":176455972,"user":{"login":"andr3w321","id":1230185,"avatar_url":"https://avatars.githubusercontent.com/u/1230185?v=3","gravatar_id":"","url":"https://api.github.com/users/andr3w321","html_url":"https://github.com/andr3w321","followers_url":"https://api.github.com/users/andr3w321/followers","following_url":"https://api.github.com/users/andr3w321/following{/other_user}","gists_url":"https://api.github.com/users/andr3w321/gists{/gist_id}","starred_url":"https://api.github.com/users/andr3w321/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/andr3w321/subscriptions","organizations_url":"https://api.github.com/users/andr3w321/orgs","repos_url":"https://api.github.com/users/andr3w321/repos","events_url":"https://api.github.com/users/andr3w321/events{/privacy}","received_events_url":"https://api.github.com/users/andr3w321/received_events","type":"User","site_admin":false},"created_at":"2016-01-28T22:32:28Z","updated_at":"2016-01-28T22:32:28Z","body":"I'm having trouble getting all the 2015 postseason games loaded.  I have two versions of nfldb running on difference computers.  One is an exact copy of your version and regularly runs nfldb upgrade and update.  It has postseason for week 1 and week 2 and has the following error that looks like a utf-8 encoding error.\r\n\r\n```\r\n$ nfldb-update \r\n-------------------------------------------------------------------------------\r\nSTARTING NFLDB UPDATE AT 2016-01-28 14:24:29.944773\r\nConnecting to nfldb... done.\r\nSetting timezone to UTC... done.\r\nLocking write access to tables... done.\r\nUpdating season phase, year and week... done.\r\nAdding schedule data for 3 games... done.\r\nBulk inserting data for 6 games...\r\n\tSending batch of data to database.\r\nTraceback (most recent call last):\r\n  File \"/home/jane/.local/bin/nfldb-update\", line 39, in <module>\r\n    nfldb.update.run(**vars(args))\r\n  File \"/home/jane/.local/lib/python2.7/site-packages/nfldb/update.py\", line 535, in run\r\n    doit()\r\n  File \"/home/jane/.local/lib/python2.7/site-packages/nfldb/update.py\", line 525, in doit\r\n    update_games(db, batch_size=batch_size)\r\n  File \"/home/jane/.local/lib/python2.7/site-packages/nfldb/update.py\", line 397, in update_games\r\n    bulk_insert_game_data(cursor, scheduled, batch_size=batch_size)\r\n  File \"/home/jane/.local/lib/python2.7/site-packages/nfldb/update.py\", line 195, in bulk_insert_game_data\r\n    do()\r\n  File \"/home/jane/.local/lib/python2.7/site-packages/nfldb/update.py\", line 188, in do\r\n    nfldb.db._big_insert(cursor, table, bulk[table])\r\n  File \"/home/jane/.local/lib/python2.7/site-packages/nfldb/db.py\", line 353, in _big_insert\r\n    values = ', '.join(_mogrify(cursor, times(vals(data))) for data in datas)\r\n  File \"/home/jane/.local/lib/python2.7/site-packages/nfldb/db.py\", line 353, in <genexpr>\r\n    values = ', '.join(_mogrify(cursor, times(vals(data))) for data in datas)\r\n  File \"/home/jane/.local/lib/python2.7/site-packages/nfldb/db.py\", line 231, in _mogrify\r\n    return cursor.mogrify('%s', (tuple(xs),))\r\n  File \"/home/jane/.local/lib/python2.7/site-packages/psycopg2/extensions.py\", line 134, in getquoted\r\n    qobjs = [o.getquoted() for o in pobjs]\r\nUnicodeEncodeError: 'ascii' codec can't encode character u'\\u2019' in position 20: ordinal not in range(128)\r\n```\r\n\r\n```\r\nselect week,away_team,home_team from game where season_type = 'Postseason' and season_year = 2015;\r\n week | away_team | home_team \r\n------+-----------+-----------\r\n    1 | KC        | HOU\r\n    1 | PIT       | CIN\r\n    1 | SEA       | MIN\r\n    1 | GB        | WAS\r\n    2 | KC        | NE\r\n    2 | GB        | ARI\r\n    2 | SEA       | CAR\r\n    2 | PIT       | DEN\r\n(8 rows)\r\n```\r\n\r\nA modified version of mine of nfldb which I run locally and update not so often is only missing week 2.\r\n```\r\nselect week,away_team,home_team from game where season_type = 'Postseason' and season_year = 2015;\r\n week | away_team | home_team \r\n------+-----------+-----------\r\n    1 | GB        | WAS\r\n    1 | KC        | HOU\r\n    1 | PIT       | CIN\r\n    1 | SEA       | MIN\r\n    3 | NE        | DEN\r\n    3 | ARI       | CAR\r\n    4 | CAR       | DEN\r\n(7 rows)\r\n```\r\n\r\nnfldb-update seems to run fine on this machine"}}