{"action":"created","issue":{"url":"https://api.github.com/repos/derekp7/snebu/issues/8","labels_url":"https://api.github.com/repos/derekp7/snebu/issues/8/labels{/name}","comments_url":"https://api.github.com/repos/derekp7/snebu/issues/8/comments","events_url":"https://api.github.com/repos/derekp7/snebu/issues/8/events","html_url":"https://github.com/derekp7/snebu/issues/8","id":75672207,"number":8,"title":"SQL syntax error in expire","user":{"login":"TripleEmcoder","id":550209,"avatar_url":"https://avatars.githubusercontent.com/u/550209?v=3","gravatar_id":"","url":"https://api.github.com/users/TripleEmcoder","html_url":"https://github.com/TripleEmcoder","followers_url":"https://api.github.com/users/TripleEmcoder/followers","following_url":"https://api.github.com/users/TripleEmcoder/following{/other_user}","gists_url":"https://api.github.com/users/TripleEmcoder/gists{/gist_id}","starred_url":"https://api.github.com/users/TripleEmcoder/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/TripleEmcoder/subscriptions","organizations_url":"https://api.github.com/users/TripleEmcoder/orgs","repos_url":"https://api.github.com/users/TripleEmcoder/repos","events_url":"https://api.github.com/users/TripleEmcoder/events{/privacy}","received_events_url":"https://api.github.com/users/TripleEmcoder/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-05-12T17:13:10Z","updated_at":"2015-05-13T08:46:37Z","closed_at":"2015-05-13T08:46:37Z","body":"When running any expire command like stated in the docs:\r\n`snebu expire -a 14 -r daily`\r\n\r\nI get an error message like the following:\r\n```\r\nsqlite3_exec_return: 1\r\nnear \"''\": syntax error\r\ninsert or ignore into expirelist   select e.backupset_id from backupsets as e  left join (    select c.backupset_id, d.ranknum    from backupsets as c      inner join (        select a.backupset_id, count(*) as ranknum        from backupsets as a         inner join backupsets as b on (a.name = b.name)           and (a.retention = b.retention)           and (a.serial <= b.serial)       group by a.backupset_id        having ranknum <= 3      ) as d on (c.backupset_id = d.backupset_id)    order by c.name, d.ranknum  ) as f on e.backupset_id = f.backupset_id  where f.backupset_id is null and e.retention = 'daily' and e.serial < 1430241138''\r\n```\r\n"},"comment":{"url":"https://api.github.com/repos/derekp7/snebu/issues/comments/101577267","html_url":"https://github.com/derekp7/snebu/issues/8#issuecomment-101577267","issue_url":"https://api.github.com/repos/derekp7/snebu/issues/8","id":101577267,"user":{"login":"TripleEmcoder","id":550209,"avatar_url":"https://avatars.githubusercontent.com/u/550209?v=3","gravatar_id":"","url":"https://api.github.com/users/TripleEmcoder","html_url":"https://github.com/TripleEmcoder","followers_url":"https://api.github.com/users/TripleEmcoder/followers","following_url":"https://api.github.com/users/TripleEmcoder/following{/other_user}","gists_url":"https://api.github.com/users/TripleEmcoder/gists{/gist_id}","starred_url":"https://api.github.com/users/TripleEmcoder/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/TripleEmcoder/subscriptions","organizations_url":"https://api.github.com/users/TripleEmcoder/orgs","repos_url":"https://api.github.com/users/TripleEmcoder/repos","events_url":"https://api.github.com/users/TripleEmcoder/events{/privacy}","received_events_url":"https://api.github.com/users/TripleEmcoder/received_events","type":"User","site_admin":false},"created_at":"2015-05-13T08:46:37Z","updated_at":"2015-05-13T08:46:37Z","body":"I was already using master so it was easy to confirm. There are no errors now when expiring."}}