[mythtv-users] Help Diseqc Trouble .21

Dave Phillips family_of_phillips at yahoo.com
Tue May 6 05:06:04 UTC 2008

Steve Daniels <steve.p.daniels at googlemail.com> wrote: 2008/5/4 Dave Phillips :
> Okay the problem with the Channel table seems to be a column called
> "default_authority"
> The insert statement is trying to put something into that column.
> But it doesn't exit :-(
> And the diseqc query is trying to enter a field called "address"
> It would seem my structure is not correct somehow.
> Does anyone have any suggestions on correcting it?
> Dave
> Dave Phillips  wrote:
> Has anyone ran into this?
> Any suggestions?
> Thanks
> Dave
> Dave Phillips  wrote:
>  Further update on this.
> I also can't add channels for some reason.
> I deleted all cards and then re added them.
> I also deleted all of the channels.
> Now when I try to scan and add channels they don't add.
> For sat channels it looks okay but then they don't stay around.
> When I scan tv channels on a cable connection I get a message
> "Failed to add channel "######" "
> Did I screw something up on the upgrade.
> Thanks
> Dave
> Dave Phillips  wrote:
>  Hi,
> I have just upgraded to 0.21
> http://svn.mythtv.org/svn/branches/release-0-21-fixes/
> Everything seemed to go okay, except for mythmusic but I can fix that later.
> But for some reason I can't add a diseqc to any of the cards.
> I go into the diseqc settings add the switch and setup the inputs.
> But if I exit and go back into the settings they are all gone and it says
> "disconnected" again.
> I did delete all of the cards on the machine first.
> This happens both on a slave machine and the master backend.
> Has anyone ran into this?
> Thanks

Hi Dave,

I'd suggest restoring the backup of your DB from before the upgrade
and trying again. Keep a close eye out for errors.
Check the schema from before hand.
What version are you upgrading from?
What branch/revision from? to?

I'm surprised the God of the MythTV user help (Michael T. Dean) hasn't
jumped in on this thread. (Though it might be the top posting, the
vast majority of the folks round here can't stand top posting and
steer clear of it at all costs..) I wonder if he's got a filter on his
name in email content ;-)

Another suggestion would be to do a fresh install as per the docs.
Then, using your latest working back up do the following to import the
recordings: http://www.mythtv.org/docs/mythtv-HOWTO-23.html#ss23.5

Good luck,

Steve Daniels
mythtv-users mailing list
mythtv-users at mythtv.org
Thanks for the response Steve (that's two),
I did try restoring the database and I ran into the same thing.
I didn't see any messages and there were no complaints.
I didn't check the schema before I upgraded again though.
I can have a look at the dump I guess.
I was running Knoppmyth R5E50 that I upgraded using 

I am upgrading to 

I suppose I "could" do a fresh install but that seems extreme to me.
By adding those columns I was able to add channels and get my diseqc defined.
I am just not sure if the columns not being there was the problem or the queries are wrong.
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.

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?

Be a better friend, newshound, and know-it-all with Yahoo! Mobile.  Try it now.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20080505/827a5607/attachment.htm 

More information about the mythtv-users mailing list