[mythtvnz] KM R5E50 out, and MythMusic problems
Steve Hodge
mythtvnz@lists.linuxnut.co.nz
Tue, 9 Jan 2007 18:32:36 +1300
------=_Part_49629_10262311.1168320756927
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
On 1/9/07, AlanP <alan.p@orcon.net.nz> wrote:
>
> At 03:02 p.m. 9/01/2007, you wrote:
> >>Also, I tried deleting a few rows from the db for the music
> >>collection, but it wouldn't pick up the songs I removed from the db. (On
> >>reflection that's a bit strange, that the music is all in the database,
> but
> >>isn't displaying in MythMusic at all.)
> >Which table? musicmetadata is no longer used, AFAICT. Mythmusic now uses
> >music_songs, music_artists, music_albums, etc.
>
> musicmetadata and musicplaylist are the only two tables there... it looks
> like your theory about the missing DB tables was on the money.
Well, it looks like the cause of the trouble is identified. Next order of
> business, to make the tables.
>
> Uh...
>
> Help? As I said, musicmetadata and musicplaylist are the only two present.
> It looks like upgrading from R5C7 to R5E50 is not without it's problems.
> The main being that it doesn't magically create missing tables.
>
I'm not too familiar with how Myth upgrades the database. I thought it was
supposed to happen automatically if it noticed an old version. In your
settings table, what have you got for DBSchemaVer? Mine is 1160, I'm running
Gentoo mythtv-0.20_p11444 (which should be one of the fixes releases).
Cheers,
Steve
------=_Part_49629_10262311.1168320756927
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
On 1/9/07, <b class="gmail_sendername">AlanP</b> <<a href="mailto:alan.p@orcon.net.nz">alan.p@orcon.net.nz</a>> wrote:<div><span class="gmail_quote"></span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
At 03:02 p.m. 9/01/2007, you wrote:<br>>>Also, I tried deleting a few rows from the db for the music<br>>>collection, but it wouldn't pick up the songs I removed from the db. (On<br>>>reflection that's a bit strange, that the music is all in the database, but
<br>>>isn't displaying in MythMusic at all.)<br>>Which table? musicmetadata is no longer used, AFAICT. Mythmusic now uses<br>>music_songs, music_artists, music_albums, etc.<br><br>musicmetadata and musicplaylist are the only two tables there... it looks
<br>like your theory about the missing DB tables was on the money.</blockquote><div><br> </div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Well, it looks like the cause of the trouble is identified. Next order of<br>business, to make the tables.<br><br>Uh...<br><br>Help? As I said, musicmetadata and musicplaylist are the only two present.<br>It looks like upgrading from R5C7 to R5E50 is not without it's problems.
<br>The main being that it doesn't magically create missing tables.<br></blockquote></div><br>I'm not too familiar with how Myth upgrades the database. I thought it was supposed to happen automatically if it noticed an old version. In your settings table, what have you got for DBSchemaVer? Mine is 1160, I'm running Gentoo
mythtv-0.20_p11444 (which should be one of the fixes releases).<br><br>Cheers,<br>Steve<br><br><br>
------=_Part_49629_10262311.1168320756927--