did I break my database?
#1
I had XBMC running smooth music/videos (TV+Movies) using native scanning. Oh- default of portable mode.

I decided I wanted to switch to EMM to really flesh out all the info to give it that "shine".

anyways, after I finally finished getting all the media done in EMM and had all the nfos, tbns, etc... I went into XBMC and I reloaded all the media. Unfortunately for TV it kept the old thumbs that had been cached in the userdata folder.

So I decided to do the only sane thing and start *semi*-fresh. I blew away the myvideos34.db (ok, actually I made a copy of it to myvideos34.db.bak). I went into sources in XBMC and removed TV source and Movie source and told it to remove all library references. I then went and deleted myvideos34.db and the /thumbnails folder contents in user data.

Then I added back the sources, and it scraped in everything from the local nfo/tbns just fine. Except for one thing: The video count from myvideos doesn't work anymore- or for mymusic - which I didn't touch!

It doesn't just say 0, it says:

TV Shows: | Episodes: | Watched:
Movies: | Watched: | Unwatched:
Albums: | Songs: | Artists:

I can sort of figure out why the videos stopped working (user error) but can't figure out how to fix it, but I can't for the life of me figure out why music stopped working. I'm sorry if this is a skin issue, but I figured that since I didn't mess with the skins folder or update anything except my video library, it was a generic XBMC problem.

Here's the logs:

relevant:
Code:
1113690112  NOTICE: -->Python Interpreter Initialized<--
17:16:00 T:3052 M:1130450944   ERROR: SQL: SQL error or missing database
                                            Query: select count(1), sum(totalCount), sum(watched), sum(watchedCount) from tvshowview
17:16:00 T:3052 M:1130450944   ERROR: CVideoDatabase::GetArbitraryQuery failed
17:16:00 T:3920 M:1130450944   ERROR: Error Type: exceptions.IndexError
17:16:00 T:3920 M:1130450944   ERROR: Error Contents: list index out of range
17:16:00 T:3920 M:1130434560   ERROR: Traceback (most recent call last):
                                              File "C:\Program Files\XBMC\skin\Aeon Phil65\extras\RecentlyAdded.py", line 275, in ?
                                                Main()
                                              File "C:\Program Files\XBMC\skin\Aeon Phil65\extras\RecentlyAdded.py", line 77, in __init__
                                                self._fetch_totals()
                                              File "C:\Program Files\XBMC\skin\Aeon Phil65\extras\RecentlyAdded.py", line 118, in _fetch_totals
                                                if ( tvshows_totals[ 0 ] == "0" ):
                                            IndexError: list index out of range

full:
Code:
17:17:58 T:7548 M:1211789312  NOTICE: -----------------------------------------------------------------------
17:17:58 T:7548 M:1211785216  NOTICE: Starting XBMC, Platform: Windows  build 7600. Built on Feb 27 2010 (SVN:28183, compiler 1500)
17:17:58 T:7548 M:1211785216  NOTICE: AMD Athlon(tm) 64 X2 Dual-Core Processor TK-57
17:17:58 T:7548 M:1211785216  NOTICE: Desktop Resolution: 1024x768 15Bit at 60Hz
17:17:58 T:7548 M:1211785216  NOTICE: Running with administrator rights
17:17:58 T:7548 M:1211785216  NOTICE: special://xbmc/ is mapped to: C:\Program Files\XBMC
17:17:58 T:7548 M:1211785216  NOTICE: special://masterprofile/ is mapped to: C:\Program Files\XBMC\userdata
17:17:58 T:7548 M:1211785216  NOTICE: special://home/ is mapped to: C:\Program Files\XBMC
17:17:58 T:7548 M:1211785216  NOTICE: special://temp/ is mapped to: C:\Program Files\XBMC\cache
17:17:58 T:7548 M:1211785216  NOTICE: The executable running is: C:\Program Files\XBMC\XBMC.exe
17:17:58 T:7548 M:1211785216  NOTICE: Log File is located: C:\Program Files\XBMC\xbmc.log
17:17:58 T:7548 M:1211785216  NOTICE: -----------------------------------------------------------------------
17:17:58 T:7548 M:1211768832  NOTICE: Setup SDL
17:17:58 T:7548 M:1211400192  NOTICE: load settings...
17:17:58 T:7548 M:1211334656   ERROR: Win32DllLoader::Load: Unable to load special://xbmc/system/players/dvdplayer/bcmDIL.dll (126)
17:17:58 T:7548 M:1211318272  NOTICE: special://profile/ is mapped to: special://masterprofile/
17:17:58 T:7548 M:1211318272  NOTICE: loading special://masterprofile/guisettings.xml
17:17:58 T:7548 M:1210900480  NOTICE: Getting hardware information now...
17:17:58 T:7548 M:1210900480  NOTICE: Checking resolution 11
17:17:58 T:7548 M:1210880000  NOTICE: Loading player core factory settings from special://xbmc/system/playercorefactory.xml.
17:17:58 T:7548 M:1210871808  NOTICE: Loaded playercorefactory configuration
17:17:58 T:7548 M:1210867712  NOTICE: Loading player core factory settings from special://masterprofile/playercorefactory.xml.
17:17:58 T:7548 M:1210867712  NOTICE: special://masterprofile/playercorefactory.xml does not exist. Skipping.
17:17:58 T:7548 M:1210863616  NOTICE: No advancedsettings.xml to load (special://masterprofile/advancedsettings.xml)
17:17:58 T:7548 M:1210863616  NOTICE: Default DVD Player: dvdplayer
17:17:58 T:7548 M:1210863616  NOTICE: Default Video Player: dvdplayer
17:17:58 T:7548 M:1210863616  NOTICE: Default Audio Player: paplayer
17:17:58 T:7548 M:1211006976  NOTICE: Loading media sources from special://masterprofile/sources.xml
17:17:59 T:7548 M:1194225664  NOTICE: initializing playlistplayer
17:17:59 T:7548 M:1194225664  NOTICE: DONE initializing playlistplayer
17:17:59 T:7548 M:1194213376  NOTICE: load default skin:[Aeon Phil65]
17:18:02 T:7548 M:1171595264  NOTICE: CApplication::UpdateLibraries - Starting video library startup scan
17:18:02 T:7548 M:1171456000  NOTICE: initialize done
17:18:02 T:7548 M:1171456000  NOTICE: Running the application...
17:18:02 T:7548 M:1171464192  NOTICE: Webserver: Starting...
17:18:02 T:7548 M:1171443712  NOTICE: WebServer: Started the webserver
17:18:02 T:7548 M:1171427328  NOTICE: starting upnp server
17:18:02 T:7548 M:1170743296  NOTICE: starting upnp renderer
17:18:02 T:7548 M:1170534400  NOTICE: ES: Starting event server
17:18:02 T:4136 M:1166114816  NOTICE: ES: Starting UDP Event server on 0.0.0.0:9777
17:18:02 T:4136 M:1166082048  NOTICE: UDP: Listening on port 9777
17:18:02 T:5972 M:1145503744  NOTICE: -->Python Interpreter Initialized<--
17:18:05 T:7548 M:1140609024   ERROR: SQL: SQL error or missing database
                                            Query: select count(1), sum(totalCount), sum(watched), sum(watchedCount) from tvshowview
17:18:05 T:7548 M:1140580352   ERROR: CVideoDatabase::GetArbitraryQuery failed
17:18:05 T:5972 M:1140580352   ERROR: Error Type: exceptions.IndexError
17:18:05 T:5972 M:1140580352   ERROR: Error Contents: list index out of range
17:18:05 T:5972 M:1140563968   ERROR: Traceback (most recent call last):
                                              File "C:\Program Files\XBMC\skin\Aeon Phil65\extras\RecentlyAdded.py", line 275, in ?
                                                Main()
                                              File "C:\Program Files\XBMC\skin\Aeon Phil65\extras\RecentlyAdded.py", line 77, in __init__
                                                self._fetch_totals()
                                              File "C:\Program Files\XBMC\skin\Aeon Phil65\extras\RecentlyAdded.py", line 118, in _fetch_totals
                                                if ( tvshows_totals[ 0 ] == "0" ):
                                            IndexError: list index out of range
17:18:07 T:1848 M:1140453376  NOTICE: My Videos: Scanning for video info using worker thread, operation took 00:05
17:18:10 T:7548 M:1140649984  NOTICE: Storing total System Uptime
17:18:10 T:7548 M:1140649984  NOTICE: Saving settings
17:18:10 T:7548 M:1140555776  NOTICE: stop all
17:18:10 T:7548 M:1140555776  NOTICE: ES: Stopping event server
17:18:10 T:7548 M:1140555776  NOTICE: stopping upnp
17:18:11 T:4136 M:1140428800  NOTICE: ES: UDP Event server stopped
17:18:12 T:7548 M:1140756480  NOTICE: Webserver: Stopping...
17:18:12 T:7548 M:1140756480  NOTICE: WebServer: Stopped the webserver
17:18:12 T:7548 M:1140756480  NOTICE: Webserver: Stopped...
17:18:12 T:7548 M:1140768768  NOTICE: stop sap announcement listener
17:18:12 T:7548 M:1140768768  NOTICE: clean cached files!
17:18:12 T:7548 M:1140760576  NOTICE: unload skin
17:18:12 T:7548 M:1151832064  NOTICE: stop python
17:18:12 T:7548 M:1151832064  NOTICE: stopped
17:18:12 T:7548 M:1151832064  NOTICE: destroy
17:18:12 T:7548 M:1151787008  NOTICE: unload sections

thanks.
Reply
#2
Turn off that python script that's running. Enable debug logging. Restart Xbmc. Try entering the music or video libraries, then post a LINK to the debug log. You can use pastebin.

http://wiki.xbmc.org/index.php?title=Log..._Debugging
Always read the XBMC online-manual, FAQ and search the forum before posting.
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
For troubleshooting and bug reporting please make sure you read this first.
Reply
#3
Ok, I disabled the library statistics, which I thought was running the script, except it still tried to execute. I don't know where to dig up the script from being called to disable it.

I enabled debug logging and have the log:

http://paste2.org/p/793208

thanks
Reply
#4
I don't think your database is corrupt. It appears like you have scan on update enabled. So please disable that. It just adds to the log.

And temporarily rename "C:\Program Files\XBMC\skin\Aeon Phil65\extras\RecentlyAdded.py" to something else so it can not execute.

After that, restart Xbmc. Browse the database and post a log.

You're getting a lot of "Not adding item to library as no info was found Sad" errors which means Xbmc isn't scraping any data, or finding your NFO files.

Since you want to rebuild your database anyway, dump the video thumbnails entirely, and rename the video database. Xbmc should make a completely fresh database. You'll have to set up content type on your sources again and then rescan. It should find your NFO files and your local thumbs and fanart.
Always read the XBMC online-manual, FAQ and search the forum before posting.
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
For troubleshooting and bug reporting please make sure you read this first.
Reply

Logout Mark Read Team Forum Stats Members Help
did I break my database?0