{"url":"https://api.github.com/repos/dogsheep/swarm-to-sqlite/issues/11","repository_url":"https://api.github.com/repos/dogsheep/swarm-to-sqlite","labels_url":"https://api.github.com/repos/dogsheep/swarm-to-sqlite/issues/11/labels{/name}","comments_url":"https://api.github.com/repos/dogsheep/swarm-to-sqlite/issues/11/comments","events_url":"https://api.github.com/repos/dogsheep/swarm-to-sqlite/issues/11/events","html_url":"https://github.com/dogsheep/swarm-to-sqlite/issues/11","id":743400216,"node_id":"MDU6SXNzdWU3NDM0MDAyMTY=","number":11,"title":"Error thrown: sqlite3.OperationalError: table users has no column named lastName","user":{"login":"beaugunderson","id":61791,"node_id":"MDQ6VXNlcjYxNzkx","avatar_url":"https://avatars.githubusercontent.com/u/61791?v=4","gravatar_id":"","url":"https://api.github.com/users/beaugunderson","html_url":"https://github.com/beaugunderson","followers_url":"https://api.github.com/users/beaugunderson/followers","following_url":"https://api.github.com/users/beaugunderson/following{/other_user}","gists_url":"https://api.github.com/users/beaugunderson/gists{/gist_id}","starred_url":"https://api.github.com/users/beaugunderson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/beaugunderson/subscriptions","organizations_url":"https://api.github.com/users/beaugunderson/orgs","repos_url":"https://api.github.com/users/beaugunderson/repos","events_url":"https://api.github.com/users/beaugunderson/events{/privacy}","received_events_url":"https://api.github.com/users/beaugunderson/received_events","type":"User","user_view_type":"public","site_admin":false},"labels":[{"id":1528446243,"node_id":"MDU6TGFiZWwxNTI4NDQ2MjQz","url":"https://api.github.com/repos/dogsheep/swarm-to-sqlite/labels/bug","name":"bug","color":"d73a4a","default":true,"description":"Something isn't working"}],"state":"closed","locked":false,"assignees":[],"milestone":null,"comments":2,"created_at":"2020-11-16T01:21:18Z","updated_at":"2021-01-18T04:35:22Z","closed_at":"2021-01-18T04:35:22Z","assignee":null,"author_association":"NONE","type":null,"active_lock_reason":null,"sub_issues_summary":{"total":0,"completed":0,"percent_completed":0},"issue_dependencies_summary":{"blocked_by":0,"total_blocked_by":0,"blocking":0,"total_blocking":0},"body":"Just installed `swarm-to-sqlite-0.3.2` and tried according to the docs:\r\n\r\n```\r\nTraceback (most recent call last):\r\n  File \"/usr/local/bin/swarm-to-sqlite\", line 8, in <module>\r\n    sys.exit(cli())\r\n  File \"/usr/local/lib/python3.9/site-packages/click/core.py\", line 829, in __call__\r\n    return self.main(*args, **kwargs)\r\n  File \"/usr/local/lib/python3.9/site-packages/click/core.py\", line 782, in main\r\n    rv = self.invoke(ctx)\r\n  File \"/usr/local/lib/python3.9/site-packages/click/core.py\", line 1066, in invoke\r\n    return ctx.invoke(self.callback, **ctx.params)\r\n  File \"/usr/local/lib/python3.9/site-packages/click/core.py\", line 610, in invoke\r\n    return callback(*args, **kwargs)\r\n  File \"/usr/local/lib/python3.9/site-packages/swarm_to_sqlite/cli.py\", line 73, in cli\r\n    save_checkin(checkin, db)\r\n  File \"/usr/local/lib/python3.9/site-packages/swarm_to_sqlite/utils.py\", line 82, in save_checkin\r\n    checkins_table.m2m(\"users\", user, m2m_table=\"likes\", pk=\"id\")\r\n  File \"/usr/local/lib/python3.9/site-packages/sqlite_utils/db.py\", line 1914, in m2m\r\n    id = other_table.insert(record, pk=pk, replace=True).last_pk\r\n  File \"/usr/local/lib/python3.9/site-packages/sqlite_utils/db.py\", line 1647, in insert\r\n    return self.insert_all(\r\n  File \"/usr/local/lib/python3.9/site-packages/sqlite_utils/db.py\", line 1765, in insert_all\r\n    self.insert_chunk(\r\n  File \"/usr/local/lib/python3.9/site-packages/sqlite_utils/db.py\", line 1575, in insert_chunk\r\n    result = self.db.execute(query, params)\r\n  File \"/usr/local/lib/python3.9/site-packages/sqlite_utils/db.py\", line 200, in execute\r\n    return self.conn.execute(sql, parameters)\r\nsqlite3.OperationalError: table users has no column named lastName\r\n```","closed_by":{"login":"simonw","id":9599,"node_id":"MDQ6VXNlcjk1OTk=","avatar_url":"https://avatars.githubusercontent.com/u/9599?v=4","gravatar_id":"","url":"https://api.github.com/users/simonw","html_url":"https://github.com/simonw","followers_url":"https://api.github.com/users/simonw/followers","following_url":"https://api.github.com/users/simonw/following{/other_user}","gists_url":"https://api.github.com/users/simonw/gists{/gist_id}","starred_url":"https://api.github.com/users/simonw/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/simonw/subscriptions","organizations_url":"https://api.github.com/users/simonw/orgs","repos_url":"https://api.github.com/users/simonw/repos","events_url":"https://api.github.com/users/simonw/events{/privacy}","received_events_url":"https://api.github.com/users/simonw/received_events","type":"User","user_view_type":"public","site_admin":false},"reactions":{"url":"https://api.github.com/repos/dogsheep/swarm-to-sqlite/issues/11/reactions","total_count":0,"+1":0,"-1":0,"laugh":0,"hooray":0,"confused":0,"heart":0,"rocket":0,"eyes":0},"timeline_url":"https://api.github.com/repos/dogsheep/swarm-to-sqlite/issues/11/timeline","performed_via_github_app":null,"state_reason":"completed","pinned_comment":null}