{"action":"opened","issue":{"url":"https://api.github.com/repos/az0/bleachbit/issues/120","repository_url":"https://api.github.com/repos/az0/bleachbit","labels_url":"https://api.github.com/repos/az0/bleachbit/issues/120/labels{/name}","comments_url":"https://api.github.com/repos/az0/bleachbit/issues/120/comments","events_url":"https://api.github.com/repos/az0/bleachbit/issues/120/events","html_url":"https://github.com/az0/bleachbit/issues/120","id":133851227,"number":120,"title":"SQLite Python Traceback - DatabaseError: UNIQUE constraint failed","user":{"login":"brahmastra2016","id":16824407,"avatar_url":"https://avatars.githubusercontent.com/u/16824407?v=3","gravatar_id":"","url":"https://api.github.com/users/brahmastra2016","html_url":"https://github.com/brahmastra2016","followers_url":"https://api.github.com/users/brahmastra2016/followers","following_url":"https://api.github.com/users/brahmastra2016/following{/other_user}","gists_url":"https://api.github.com/users/brahmastra2016/gists{/gist_id}","starred_url":"https://api.github.com/users/brahmastra2016/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/brahmastra2016/subscriptions","organizations_url":"https://api.github.com/users/brahmastra2016/orgs","repos_url":"https://api.github.com/users/brahmastra2016/repos","events_url":"https://api.github.com/users/brahmastra2016/events{/privacy}","received_events_url":"https://api.github.com/users/brahmastra2016/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2016-02-16T00:40:08Z","updated_at":"2016-02-16T00:40:08Z","closed_at":null,"body":"Please can anybody help me understand/fix SQLite traceback error.\r\n\r\n#########\r\n   Issue:\r\n#########\r\nError in execution of <bleachbit.Command.Function instance at 0x106c7bcb0>\r\nTraceback (most recent call last):\r\n  File \"/Users/user/bleachbit/bleachbit/Worker.py\", line 84, in execute\r\n    for ret in cmd.execute(self.really_delete):\r\n  File \"/Users/user/bleachbit/bleachbit/Command.py\", line 146, in execute\r\n    self.func(self.path)\r\n  File \"/Users/user/bleachbit/bleachbit/Special.py\", line 280, in delete_mozilla_url_history\r\n    FileUtilities.execute_sqlite3(path, cmds)\r\n  File \"/Users/user/bleachbit/bleachbit/FileUtilities.py\", line 307, in execute_sqlite3\r\n    '%s: %s' % (Common.decode_str(exc), path))\r\nDatabaseError: UNIQUE constraint failed: moz_places.url: /Users/user/Library/Application Support/Firefox/Profiles/lawxndmw.default/places.sqlite\r\n\r\n##########\r\nSystem Info:\r\n##########\r\n\r\nplatform.mac_ver() = ('10.10.5', ('', '', ''), 'x86_64')\r\nplatform.platform = Darwin-14.5.0-x86_64-i386-64bit\r\nplatform.version = Darwin Kernel Version 14.5.0: Tue Sep  1 21:23:09 PDT 2015; root:xnu-2782.50.1~1/RELEASE_X86_64\r\nsys.argv = ['bleachbit.py', '--sysinfo']\r\nsys.executable = /usr/local/opt/python/bin/python2.7\r\nsys.version = 2.7.11 (default, Jan 22 2016, 08:28:37)\r\n"}}