Posts: 854
Joined: May 2007
Reputation:
6
Numus
Posting Freak
Posts: 854
If you are an idiot like me, you managed to corrupt your video database more then once before you learned to create backups of them.. Would be nice to have the ability to scan and fix errors in the database if possible...
Posts: 12,706
Joined: Nov 2003
Reputation:
129
spiff
Team-Kodi Member
Posts: 12,706
in 95% of the cases, there's absolutely no way to fix a db automagically. waste of time.
Posts: 16
Joined: May 2010
Reputation:
0
peleda
Junior Member
Posts: 16
I got my database corrupted, some how, but what can I do to create a new one.
I don't mind loosing all videos data, but how do I create a new videos database.
Posts: 646
Joined: May 2009
Reputation:
30
2012-01-17, 18:26
(This post was last modified: 2012-01-17, 18:31 by Eldorado.)
Was doing some searching around on this topic as it seems to be popping up quite often for those I've setup ATV's for
Most common DB to be corrupted seems to be the Addons15.db which of course causes XBMC to be unable to check repositories and get updates, deleting the DB allowing it to get rebuilt corrects this
I've also seen in more than just one instance where another DB became corrupted, the log didn't identify which one, but caused XBMC to crash when loading.. again deleting all DB's in the Database folder corrected it - I have access to an ATV currently with this issue, will get the log within a couple days if needed
Now these errors I've also seen happen on my own Win7 machine, always running latest nightlies, so can't be pinned squarely on the ATV
I know database repairing isn't the answer, but how about detection of corruption and notifying the user, also prompting them to rebuild the affected database?
This could go a long way to help some of the user frustration when this happens, not all users are savvy enough to know how to correct
edit - just to note I always try to keep everyone updated to most recently builds as possibly, all are now on Eden Beta 1, but has still been happening, hard to pin down the trigger.. one thing in common has been most are running wireless
Posts: 26
Joined: Sep 2006
Reputation:
0
Why not just have a backup of last good config one. Ie when a change is made to addons15.db create a copy of addons15.db.oldButGood. Then if addons15.db is corrupted we go back to addons15.db.oldButGood .