{"id":756,"date":"2016-09-26T07:14:03","date_gmt":"2016-09-26T13:14:03","guid":{"rendered":"https:\/\/wmbuck.net\/blog\/?p=756"},"modified":"2016-09-26T07:14:03","modified_gmt":"2016-09-26T13:14:03","slug":"correcting-corrupted-kodi-database","status":"publish","type":"post","link":"https:\/\/wmbuck.net\/blog\/?p=756","title":{"rendered":"Correcting Corrupted Kodi Database"},"content":{"rendered":"<p>I&#8217;ve had several cases where one of the Kodi sqlite3 databases becomes corrupted on Coriander. It has happened to Textures, Addons and EPG at different times.\u00a0 The error that manifests in the Kodi log is The Database Disk Image is Malformed, and once it happens the log is full of this and transactions in the affected database don&#8217;t take place.<\/p>\n<p>Did some reading, and discovered that usually you can dump the database, and the dump will be ok.\u00a0 Try this:<\/p>\n<pre><code>echo '.dump' | sqlite3 fred | sqlite3 new_fred\r\nmv fred bad_fred\r\nmv new_fred fred<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;ve had several cases where one of the Kodi sqlite3 databases becomes corrupted on Coriander. It has happened to Textures, Addons and EPG at different times.\u00a0 The error that manifests in the Kodi log is The Database Disk Image is Malformed, and once it happens the log is full of this and transactions in the &hellip; <a href=\"https:\/\/wmbuck.net\/blog\/?p=756\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Correcting Corrupted Kodi Database<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,27,4,25,9,6],"tags":[],"class_list":["post-756","post","type-post","status-publish","format-standard","hentry","category-fedora","category-kodi","category-linux","category-mac","category-ubuntu","category-xbmc"],"_links":{"self":[{"href":"https:\/\/wmbuck.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/756"}],"collection":[{"href":"https:\/\/wmbuck.net\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wmbuck.net\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wmbuck.net\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/wmbuck.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=756"}],"version-history":[{"count":1,"href":"https:\/\/wmbuck.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/756\/revisions"}],"predecessor-version":[{"id":757,"href":"https:\/\/wmbuck.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/756\/revisions\/757"}],"wp:attachment":[{"href":"https:\/\/wmbuck.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=756"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wmbuck.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=756"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wmbuck.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=756"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}