<br><br><b><i>Steve Daniels <steve.p.daniels@googlemail.com></i></b> wrote:<blockquote class="replbq" style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> 2008/5/4 Dave Phillips <family_of_phillips@yahoo.com>:<br>> Okay the problem with the Channel table seems to be a column called<br>> "default_authority"<br>> The insert statement is trying to put something into that column.<br>> But it doesn't exit :-(<br>> And the diseqc query is trying to enter a field called "address"<br>> It would seem my structure is not correct somehow.<br>> Does anyone have any suggestions on correcting it?<br>><br>><br>> Dave<br>><br>><br>> Dave Phillips <family_of_phillips@yahoo.com> wrote:<br>><br>> Has anyone ran into this?<br>> Any suggestions?<br>> Thanks<br>> Dave<br>> Dave Phillips <family_of_phillips@yahoo.com> wrote:<br>> Further update on this.<br>> I also can't add channels for some
reason.<br>> I deleted all cards and then re added them.<br>> I also deleted all of the channels.<br>> Now when I try to scan and add channels they don't add.<br>> For sat channels it looks okay but then they don't stay around.<br>> When I scan tv channels on a cable connection I get a message<br>> "Failed to add channel "######" "<br>> Did I screw something up on the upgrade.<br>> Thanks<br>> Dave<br>><br>> Dave Phillips <family_of_phillips@yahoo.com> wrote:<br>> Hi,<br>> I have just upgraded to 0.21<br>> http://svn.mythtv.org/svn/branches/release-0-21-fixes/<br>> Everything seemed to go okay, except for mythmusic but I can fix that later.<br>> But for some reason I can't add a diseqc to any of the cards.<br>> I go into the diseqc settings add the switch and setup the inputs.<br>> But if I exit and go back into the settings they are all gone and it says<br>> "disconnected" again.<br>> I did delete all of the
cards on the machine first.<br>> This happens both on a slave machine and the master backend.<br>> Has anyone ran into this?<br>> Thanks<br>><br><br><br>Hi Dave,<br><br>I'd suggest restoring the backup of your DB from before the upgrade<br>and trying again. Keep a close eye out for errors.<br>Check the schema from before hand.<br>What version are you upgrading from?<br>What branch/revision from? to?<br><br>I'm surprised the God of the MythTV user help (Michael T. Dean) hasn't<br>jumped in on this thread. (Though it might be the top posting, the<br>vast majority of the folks round here can't stand top posting and<br>steer clear of it at all costs..) I wonder if he's got a filter on his<br>name in email content ;-)<br><br>Another suggestion would be to do a fresh install as per the docs.<br>Then, using your latest working back up do the following to import the<br>recordings: http://www.mythtv.org/docs/mythtv-HOWTO-23.html#ss23.5<br><br>Good luck,<br><br>Steve
Daniels<br>_______________________________________________<br>mythtv-users mailing list<br>mythtv-users@mythtv.org<br>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users<br></family_of_phillips@yahoo.com></family_of_phillips@yahoo.com></family_of_phillips@yahoo.com></family_of_phillips@yahoo.com></blockquote>Thanks for the response Steve (that's two),<br>I did try restoring the database and I ran into the same thing.<br>I didn't see any messages and there were no complaints.<br>I didn't check the schema before I upgraded again though.<br>I can have a look at the dump I guess.<br>I was running Knoppmyth R5E50 that I upgraded using <br><pre class="wiki">http://svn.mythtv.org/svn/branches/release-0-20-fixes/mythtv<br>I am upgrading to <br><br>http://svn.mythtv.org/svn/branches/release-0-21-fixes/<br>I suppose I "could" do a fresh install but that seems extreme to me.<br>By adding those columns I was able to add channels and get my diseqc defined.<br>I am just not sure if
the columns not being there was the problem or the queries are wrong.<br>I do have a new problem though where the cards on the slave backend are unavailable but I think I have seen that noted somewhere so I am hoping it is unrelated.<br><br></pre>Dave<br>p.s. I forgot that some people are a little sensitive about top posting. Although I admit I get lazy because yahoo sucks for that sorta thing. But is it really top posting if I am the only one responding?<br><p> 
<hr size=1>Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. <a href="http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ "> Try it now.</a>