{"action":"created","issue":{"url":"https://api.github.com/repos/beetbox/beets/issues/2230","repository_url":"https://api.github.com/repos/beetbox/beets","labels_url":"https://api.github.com/repos/beetbox/beets/issues/2230/labels{/name}","comments_url":"https://api.github.com/repos/beetbox/beets/issues/2230/comments","events_url":"https://api.github.com/repos/beetbox/beets/issues/2230/events","html_url":"https://github.com/beetbox/beets/issues/2230","id":184064016,"number":2230,"title":"sqlite error: \"too many SQL variables\"","user":{"login":"RX14","id":2788811,"avatar_url":"https://avatars.githubusercontent.com/u/2788811?v=3","gravatar_id":"","url":"https://api.github.com/users/RX14","html_url":"https://github.com/RX14","followers_url":"https://api.github.com/users/RX14/followers","following_url":"https://api.github.com/users/RX14/following{/other_user}","gists_url":"https://api.github.com/users/RX14/gists{/gist_id}","starred_url":"https://api.github.com/users/RX14/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RX14/subscriptions","organizations_url":"https://api.github.com/users/RX14/orgs","repos_url":"https://api.github.com/users/RX14/repos","events_url":"https://api.github.com/users/RX14/events{/privacy}","received_events_url":"https://api.github.com/users/RX14/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/beetbox/beets/labels/needinfo","name":"needinfo","color":"e102d8"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2016-10-19T20:21:34Z","updated_at":"2016-10-20T11:28:49Z","closed_at":null,"body":"### Problem\r\n\r\nRunning a relatively simple query:\r\n\r\n```sh\r\n$ beet -vv ls 'porter robinson' ^worlds\r\n```\r\n\r\nThis happened:\r\n\r\n```\r\nuser configuration: /home/rx14/.config/beets/config.yaml\r\ndata directory: /home/rx14/.config/beets\r\nplugin paths:\r\nSending event: pluginload\r\nlibrary database: /media/media/Music/beets.db\r\nlibrary directory: /media/media/Music\r\nSending event: library_opened\r\nTraceback (most recent call last):\r\n  File \"/usr/bin/beet\", line 9, in <module>\r\n    load_entry_point('beets==1.3.19', 'console_scripts', 'beet')()\r\n  File \"/usr/lib/python2.7/site-packages/beets/ui/__init__.py\", line 1266, in main\r\n    _raw_main(args)\r\n  File \"/usr/lib/python2.7/site-packages/beets/ui/__init__.py\", line 1253, in _raw_main\r\n    subcommand.func(lib, suboptions, subargs)\r\n  File \"/usr/lib/python2.7/site-packages/beets/ui/commands.py\", line 1069, in list_func\r\n    list_items(lib, decargs(args), opts.album)\r\n  File \"/usr/lib/python2.7/site-packages/beets/ui/commands.py\", line 1064, in list_items\r\n    for item in lib.items(query):\r\n  File \"/usr/lib/python2.7/site-packages/beets/library.py\", line 1295, in items\r\n    return self._fetch(Item, query, sort or self.get_default_item_sort())\r\n  File \"/usr/lib/python2.7/site-packages/beets/library.py\", line 1270, in _fetch\r\n    model_cls, query, sort\r\n  File \"/usr/lib/python2.7/site-packages/beets/dbcore/db.py\", line 838, in _fetch\r\n    rows = tx.query(sql, subvals)\r\n  File \"/usr/lib/python2.7/site-packages/beets/dbcore/db.py\", line 670, in query\r\n    cursor = self.db._connection().execute(statement, subvals)\r\nsqlite3.OperationalError: too many SQL variables\r\n```\r\n\r\nI'm not 100% sure but it seems to only happen when using a NOT query.\r\n\r\n### Setup\r\n\r\n* OS: Arch linux x86_64\r\n* Python version: 2.7.12\r\n* beets version: 1.3.19 (can hardly tell because you borked the version)\r\n* Turning off plugins made problem go away (yes/no): no\r\n\r\nMy configuration (output of `beet config`) is:\r\n\r\n```yaml\r\npaths:\r\n    default: $albumartist/%if{$original_year,$original_year }$album%aunique{}/%if{$track,$track }$artist - $album - $title\r\n    singleton: $artist/%if{$original_year,$original_year }$artist - $title\r\n    comp: Compilations/$album%aunique{}/%if{$track,$track }$artist - $title\r\nsmartplaylist:\r\n    playlist_dir: /media/media/Music/Playlists/\r\n    playlists: [{name: all.m3u, query: ''}]\r\n    auto: yes\r\n    relative_to:\r\nlibrary: /media/media/Music/beets.db\r\nreplaygain:\r\n    backend: bs1770gain\r\n    targetlevel: 89\r\n    auto: yes\r\n    overwrite: no\r\n    chunk_at: 5000\r\n    method: replaygain\r\n\r\nplugins: lastgenre chroma fromfilename web duplicates replaygain smartplaylist scrub\r\ndirectory: /media/media/Music\r\ntimid: yes\r\nacoustid:\r\n    apikey: REDACTED\r\nscrub:\r\n    auto: yes\r\nlastgenre:\r\n    count: 1\r\n    source: album\r\n    force: yes\r\n    min_weight: 10\r\n    auto: yes\r\n    whitelist: yes\r\n    separator: ', '\r\n    fallback:\r\n    canonical: no\r\nchroma:\r\n    auto: yes\r\nweb:\r\n    host: 127.0.0.1\r\n    port: 8337\r\n    cors: ''\r\nduplicates:\r\n    count: no\r\n    full: no\r\n    format: ''\r\n    keys: []\r\n    move: ''\r\n    tag: ''\r\n    path: no\r\n    copy: ''\r\n    tiebreak: {}\r\n    album: no\r\n    strict: no\r\n    checksum: ''\r\n    merge: no\r\n    delete: no\r\n```\r\n"},"comment":{"url":"https://api.github.com/repos/beetbox/beets/issues/comments/255080303","html_url":"https://github.com/beetbox/beets/issues/2230#issuecomment-255080303","issue_url":"https://api.github.com/repos/beetbox/beets/issues/2230","id":255080303,"user":{"login":"sampsyo","id":188033,"avatar_url":"https://avatars.githubusercontent.com/u/188033?v=3","gravatar_id":"","url":"https://api.github.com/users/sampsyo","html_url":"https://github.com/sampsyo","followers_url":"https://api.github.com/users/sampsyo/followers","following_url":"https://api.github.com/users/sampsyo/following{/other_user}","gists_url":"https://api.github.com/users/sampsyo/gists{/gist_id}","starred_url":"https://api.github.com/users/sampsyo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sampsyo/subscriptions","organizations_url":"https://api.github.com/users/sampsyo/orgs","repos_url":"https://api.github.com/users/sampsyo/repos","events_url":"https://api.github.com/users/sampsyo/events{/privacy}","received_events_url":"https://api.github.com/users/sampsyo/received_events","type":"User","site_admin":false},"created_at":"2016-10-20T11:28:49Z","updated_at":"2016-10-20T11:28:49Z","body":"Strange. Any other guesses? Since I can't reproduce here, I'm not sure how to proceed."}}
{"actor":{"display_login":"sampsyo"}}