{"action":"created","issue":{"url":"https://api.github.com/repos/volatilityfoundation/volatility/issues/191","labels_url":"https://api.github.com/repos/volatilityfoundation/volatility/issues/191/labels{/name}","comments_url":"https://api.github.com/repos/volatilityfoundation/volatility/issues/191/comments","events_url":"https://api.github.com/repos/volatilityfoundation/volatility/issues/191/events","html_url":"https://github.com/volatilityfoundation/volatility/issues/191","id":59835255,"number":191,"title":"OverflowError: Python int too large to convert to SQLite INTEGER","user":{"login":"Sebastienbr","id":2241339,"avatar_url":"https://avatars.githubusercontent.com/u/2241339?v=3","gravatar_id":"","url":"https://api.github.com/users/Sebastienbr","html_url":"https://github.com/Sebastienbr","followers_url":"https://api.github.com/users/Sebastienbr/followers","following_url":"https://api.github.com/users/Sebastienbr/following{/other_user}","gists_url":"https://api.github.com/users/Sebastienbr/gists{/gist_id}","starred_url":"https://api.github.com/users/Sebastienbr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Sebastienbr/subscriptions","organizations_url":"https://api.github.com/users/Sebastienbr/orgs","repos_url":"https://api.github.com/users/Sebastienbr/repos","events_url":"https://api.github.com/users/Sebastienbr/events{/privacy}","received_events_url":"https://api.github.com/users/Sebastienbr/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-03-04T17:54:21Z","updated_at":"2015-03-04T20:02:18Z","closed_at":null,"body":"Seems there's a problem with long value (>0x7FFFFFFFFFFFFFFF) and sqlite...\r\n\r\nC:\\Volatility\\volatility-e9cbdcc6c7>python vol.py -f Win7-64.vmem --profile=Win7SP1x64 pslist --output=sqlite --output-file=test.sqlite\r\nVolatility Foundation Volatility Framework 2.4\r\nINSERT INTO PSList VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [1, 0, 18446738026408463152L, 'System', 4, 0, 81, 526, -1, 0, '2013-11-29 16:39:19 UTC+0000', '']\r\nTraceback (most recent call last):\r\n  File \"vol.py\", line 192, in <module>\r\n    main()\r\n  File \"vol.py\", line 183, in main\r\n    command.execute()\r\n  File \"C:\\Volatility\\volatility-e9cbdcc6c7\\volatility\\commands.py\", line 140, in execute\r\n    func(outfd, data)\r\n  File \"C:\\Volatility\\volatility-e9cbdcc6c7\\volatility\\commands.py\", line 284, in render_sqlite\r\n    self._render(outfd, SqliteRenderer(self.__class__.__name__, self._config), data)\r\n  File \"C:\\Volatility\\volatility-e9cbdcc6c7\\volatility\\commands.py\", line 269, in _render\r\n    renderer.render(outfd, output)\r\n  File \"C:\\Volatility\\volatility-e9cbdcc6c7\\volatility\\renderers\\sqlite.py\", line 44, in render\r\n    grid.visit(None, self._add_row, {None: 0})\r\n  File \"C:\\Volatility\\volatility-e9cbdcc6c7\\volatility\\renderers\\__init__.py\", line 254, in visit\r\n    accumulator = self._visit(children, function, accumulator, sort_key)\r\n  File \"C:\\Volatility\\volatility-e9cbdcc6c7\\volatility\\renderers\\__init__.py\", line 261, in _visit\r\n    accumulator = function(n, accumulator)\r\n  File \"C:\\Volatility\\volatility-e9cbdcc6c7\\volatility\\renderers\\sqlite.py\", line 32, in _add_row\r\n    self._db.execute(insert, [accumulator[node], accumulator[node.parent]] + list(node.values))\r\n\r\n\r\nThanks!\r\n\r\nSebastien"},"comment":{"url":"https://api.github.com/repos/volatilityfoundation/volatility/issues/comments/77234658","html_url":"https://github.com/volatilityfoundation/volatility/issues/191#issuecomment-77234658","issue_url":"https://api.github.com/repos/volatilityfoundation/volatility/issues/191","id":77234658,"user":{"login":"Sebastienbr","id":2241339,"avatar_url":"https://avatars.githubusercontent.com/u/2241339?v=3","gravatar_id":"","url":"https://api.github.com/users/Sebastienbr","html_url":"https://github.com/Sebastienbr","followers_url":"https://api.github.com/users/Sebastienbr/followers","following_url":"https://api.github.com/users/Sebastienbr/following{/other_user}","gists_url":"https://api.github.com/users/Sebastienbr/gists{/gist_id}","starred_url":"https://api.github.com/users/Sebastienbr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Sebastienbr/subscriptions","organizations_url":"https://api.github.com/users/Sebastienbr/orgs","repos_url":"https://api.github.com/users/Sebastienbr/repos","events_url":"https://api.github.com/users/Sebastienbr/events{/privacy}","received_events_url":"https://api.github.com/users/Sebastienbr/received_events","type":"User","site_admin":false},"created_at":"2015-03-04T20:02:18Z","updated_at":"2015-03-04T20:02:18Z","body":"Thanks Michael.\r\n\r\nI think the value is already stored as TEXT in the db?\r\n\r\n```\r\ni.type = <class 'volatility.renderers.basic.Address'>\r\n\r\nself._column_type(i.type) = TEXT\r\n```\r\n> https://github.com/volatilityfoundation/volatility/blob/master/volatility/renderers/sqlite.py#L42\r\n\r\n\r\n\r\n"}}