[htpc_ion]

Hi,

I recently installed Dharma RC1 using LiveCD on my ASRock ION 330HT and imported all my content freshly. After importing I cannot navigate into Music Videos-->Albums. I can navigate to Genres, Title, Year, Artists, Directors and Studios but no Albums. When I select I get the item selection sound but nothing happens.

All my music videos have local NFO file and this used to work in Camelot. But of course in Camelot I had the option of choosing NFO scrapper for content type where as in current release MTV or Yahoo are the only option.

Can someone please verify if this is a bug or some setting problem on my end

Thanks and Regards,

[jmarshall]

A debug log is the first thing to do.

[htpc_ion]

Thanks for your response.

Below is the log snippet when navigating to Music Videos-> Albums:

Code:

08:20:31 T:3079440256 M:1279946752   DEBUG: CGUIMediaWindow::GetDirectory (videodb://3/5/)
08:20:31 T:3079440256 M:1279946752   DEBUG:   ParentPath = [videodb://3/]
08:20:31 T:2720844656 M:1279946752   DEBUG: GetMusicVideoAlbumsNav query: select musicvideo.c09,musicvideo.idMVideo,actors.strActor,path.strPath from musicvideo,path,files join artistlinkmusicvideo on artistlinkmusicvideo.idMVideo=musicvideo.idMVideo join actors on actors.idActor=artistlinkmusicvideo.idArtist join files on files.idFile=musicvideo.idFile join path on path.idPath=files.idPath group by musicvideo.c09
08:20:31 T:2720844656 M:1279946752   ERROR: SQL: SQL error or missing database
                                            Query: select musicvideo.c09,musicvideo.idMVideo,actors.strActor,path.strPath from musicvideo,path,files join artistlinkmusicvideo on artistlinkmusicvideo.idMVideo=musicvideo.idMVideo join actors on actors.idActor=artistlinkmusicvideo.idArtist join files on files.idFile=musicvideo.idFile join path on path.idPath=files.idPath group by musicvideo.c09
08:20:31 T:2720844656 M:1279946752   ERROR: GetMusicVideoAlbumsNav failed
08:20:31 T:3079440256 M:1279946752   ERROR: GetDirectory - Error getting videodb://3/5/
08:20:31 T:3079440256 M:1279946752   ERROR: CGUIMediaWindow::GetDirectory(videodb://3/5/) failed

I have uploaded the complete log to MF which you can download from here.

Thanks and Regards,

[jmarshall]

If you could upload your videodb that would be great - with that I'll be able to fix the query in a few minutes.

Cheers,
Jonathan

[htpc_ion]

Thanks. Where can I find this file?

Also, is this problem with me only or a bug?

[jmarshall]

Looks like a bug to me. You can find it in %APPDATA/XBMC/userdata/Database/MyVideos34.db

[htpc_ion]

If this is a bug then should I create a new ticket?

I have uploaded the said file here.

[jmarshall]

I'll take a look this evening - I can probably fix it reasonably quickly.

[htpc_ion]

no urgency.. thank you :-)

[jmarshall]

What's the password on the rar?

[htpc_ion]

oops.. it's your user id.. jmarshall

[jmarshall]

Thanks - about the only thing I didn't try

[jmarshall]

r35511 fixes it, backported to dharma in r35512 for the final release.

Cheers,
Jonathan

[htpc_ion]

Thank you for the quick fix :-)

[htpc_ion]

Hi,

I installed current xbmc final release and imported all my Music Videos into library and I still face this same problem. Below is the debug log snippet:

Code:

17:43:33 T:3077769088 M:1469222912  NOTICE: Starting XBMC, Platform: Linux (Ubuntu 10.04.1 LTS - XBMCLive Dharma, 2.6.32-26-generic i686). Built on Dec 17 2010 (SVN:35648)
17:43:33 T:3077769088 M:1469222912  NOTICE: special://xbmc/ is mapped to: /usr/share/xbmc
17:43:33 T:3077769088 M:1469222912  NOTICE: special://xbmcbin/ is mapped to: /usr/lib/xbmc
17:43:33 T:3077769088 M:1469222912  NOTICE: special://masterprofile/ is mapped to: /home/xbmc/.xbmc/userdata
17:43:33 T:3077769088 M:1469222912  NOTICE: special://home/ is mapped to: /home/xbmc/.xbmc
17:43:33 T:3077769088 M:1469222912  NOTICE: special://temp/ is mapped to: /home/xbmc/.xbmc/temp
17:43:33 T:3077769088 M:1469222912  NOTICE: The executable running is: /usr/lib/xbmc/xbmc.bin
17:43:33 T:3077769088 M:1469222912  NOTICE: Log File is located: /home/xbmc/.xbmc/temp/xbmc.log
17:43:33 T:3077769088 M:1469222912  NOTICE: -----------------------------------------------------------------------
18:29:56 T:3077769088 M:1357684736   DEBUG: CGUIMediaWindow::GetDirectory (videodb://3/4/16525/)
18:29:56 T:3077769088 M:1357684736   DEBUG:   ParentPath = [videodb://3/4/]
18:29:56 T:2678410096 M:1357684736   DEBUG: GetMusicVideoAlbumsNav query: select musicvideo.c09,musicvideo.idMVideo,actors.strActor,path.strPath from musicvideo join artistlinkmusicvideo on artistlinkmusicvideo.idMVideo=musicvideo.idMVideo join actors on actors.idActor=artistlinkmusicvideo.idArtist join files on files.idFile=musicvideo.idFile join path on path.idPath=files.idPath where artistlinkmusicvideo.idArtist=16525 group by musicvideo.c09
18:29:56 T:2678410096 M:1357684736   ERROR: SQL: Dataset state is Inactive
18:29:56 T:2678410096 M:1357684736   ERROR: GetMusicVideoAlbumsNav failed
18:29:56 T:3077769088 M:1357684736   ERROR: GetDirectory - Error getting videodb://3/4/16525/
18:29:56 T:3077769088 M:1357684736   ERROR: CGUIMediaWindow::GetDirectory(videodb://3/4/16525/) failed
18:29:56 T:3077769088 M:1357684736   DEBUG: CGUIMediaWindow::GetDirectory (videodb://3/4/)
18:29:56 T:3077769088 M:1357684736   DEBUG:   ParentPath = [videodb://3/]

I guess the fix didn't make it to the final release. Is there anyway I can fix my DB locally?

Also, I noticed that for some Music Videos thumbnails aren't generated even though the file format is recognized and playable by xbmc. Is there any way to fix this as well?

Thanks and Regards,