{"action":"closed","issue":{"url":"https://api.github.com/repos/jprochazka/adsb-receiver/issues/161","repository_url":"https://api.github.com/repos/jprochazka/adsb-receiver","labels_url":"https://api.github.com/repos/jprochazka/adsb-receiver/issues/161/labels{/name}","comments_url":"https://api.github.com/repos/jprochazka/adsb-receiver/issues/161/comments","events_url":"https://api.github.com/repos/jprochazka/adsb-receiver/issues/161/events","html_url":"https://github.com/jprochazka/adsb-receiver/issues/161","id":148814142,"number":161,"title":"Error about missing mysql module","user":{"login":"stevepmitchell","id":8756248,"avatar_url":"https://avatars.githubusercontent.com/u/8756248?v=3","gravatar_id":"","url":"https://api.github.com/users/stevepmitchell","html_url":"https://github.com/stevepmitchell","followers_url":"https://api.github.com/users/stevepmitchell/followers","following_url":"https://api.github.com/users/stevepmitchell/following{/other_user}","gists_url":"https://api.github.com/users/stevepmitchell/gists{/gist_id}","starred_url":"https://api.github.com/users/stevepmitchell/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/stevepmitchell/subscriptions","organizations_url":"https://api.github.com/users/stevepmitchell/orgs","repos_url":"https://api.github.com/users/stevepmitchell/repos","events_url":"https://api.github.com/users/stevepmitchell/events{/privacy}","received_events_url":"https://api.github.com/users/stevepmitchell/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/jprochazka/adsb-receiver/labels/bug","name":"bug","color":"fc2929"}],"state":"closed","locked":false,"assignee":{"login":"jprochazka","id":2583357,"avatar_url":"https://avatars.githubusercontent.com/u/2583357?v=3","gravatar_id":"","url":"https://api.github.com/users/jprochazka","html_url":"https://github.com/jprochazka","followers_url":"https://api.github.com/users/jprochazka/followers","following_url":"https://api.github.com/users/jprochazka/following{/other_user}","gists_url":"https://api.github.com/users/jprochazka/gists{/gist_id}","starred_url":"https://api.github.com/users/jprochazka/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jprochazka/subscriptions","organizations_url":"https://api.github.com/users/jprochazka/orgs","repos_url":"https://api.github.com/users/jprochazka/repos","events_url":"https://api.github.com/users/jprochazka/events{/privacy}","received_events_url":"https://api.github.com/users/jprochazka/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/jprochazka/adsb-receiver/milestones/3","html_url":"https://github.com/jprochazka/adsb-receiver/milestones/v2.0.1","labels_url":"https://api.github.com/repos/jprochazka/adsb-receiver/milestones/3/labels","id":1701019,"number":3,"title":"v2.0.1","description":"Fixes and minor changes.","creator":{"login":"jprochazka","id":2583357,"avatar_url":"https://avatars.githubusercontent.com/u/2583357?v=3","gravatar_id":"","url":"https://api.github.com/users/jprochazka","html_url":"https://github.com/jprochazka","followers_url":"https://api.github.com/users/jprochazka/followers","following_url":"https://api.github.com/users/jprochazka/following{/other_user}","gists_url":"https://api.github.com/users/jprochazka/gists{/gist_id}","starred_url":"https://api.github.com/users/jprochazka/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jprochazka/subscriptions","organizations_url":"https://api.github.com/users/jprochazka/orgs","repos_url":"https://api.github.com/users/jprochazka/repos","events_url":"https://api.github.com/users/jprochazka/events{/privacy}","received_events_url":"https://api.github.com/users/jprochazka/received_events","type":"User","site_admin":false},"open_issues":1,"closed_issues":10,"state":"open","created_at":"2016-04-12T11:26:51Z","updated_at":"2016-04-28T03:50:46Z","due_on":"2016-04-27T04:00:00Z","closed_at":null},"comments":5,"created_at":"2016-04-16T04:04:26Z","updated_at":"2016-04-28T03:50:46Z","closed_at":"2016-04-28T03:50:46Z","body":"Just updated to the newest available client on two systems.  After choosing to use the advanced mode, and setting up SQLite in the UI, I am continually getting a python error at the command line:\r\n\r\nImportError: No module named MySQLdb\r\nTraceback (most recent call last):\r\n  File \"/home/pi/adsb-feeder/build/portal/logging/flights.py\", line 45, in <module>\r\n\r\nLooks like even though I'm not using MySQL that module is being called.  After installing the module (my distribution it is through apt \"apt-get install python-mysqldb\") I am getting SQL errors for what looks like MySQL commands, even though I do have it setup for SQLite:\r\n\r\nTraceback (most recent call last):\r\n  File \"/home/pi/adsb-feeder/build/portal/logging/flights.py\", line 77, in <module>\r\n    cursor.execute(\"SELECT COUNT(*) FROM adsb_aircraft WHERE icao = %s\", aircraft[\"hex\"])\r\nsqlite3.OperationalError: near \"%\": syntax error\r\n"}}