<BR><BR><B><I>"Michael T. Dean" <mtdean@thirdcontact.com></I></B> wrote: <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid"> <div>On 05/06/2008 03:23 AM, Dave Phillips wrote:<BR>> Well I couldn't see anything in the log so I have attached it here.<BR>> Please have a look when you get a chance.<BR><BR>Well, what I can tell you is that:<BR><BR>a) your database upgrade succeeded.<BR>b) your database does not seem to be the problem.<BR><BR>The failing query:<BR><BR>> 2008-05-06 01:09:44.858 DB Error (DiSEqCDevSwitch::Store):<BR>> Query was:<BR>> INSERT INTO diseqc_tree ( parentid, ordinal, type, <BR>> description, address, subtype, switch_ports, <BR>> cmd_repeat )VALUES (NULL, 0, 'switch', <BR>> 'Switch', 16, 'diseqc', 4, 1 )<BR>> Driver error was [2/1054]:<BR>> QMYSQL3: Unable to execute query<BR>> Database error was:<BR>> Unknown column 'address' in 'field list'<BR><BR>does not exist
anywhere in MythTV 0.21. Therefore, the problem is <BR>likely old library version somewhere on the system. Do you have 2 <BR>installations of Myth? Maybe an old pre-0.21 trunk install you compiled <BR>into /usr/local and a new 0.21-fixes install from packages in /usr?<BR><BR>OK, nevermind. Just checked the history of the disecq_tree table, and <BR>myth has never had an address column in there. You've got a Myth built <BR>with http://svn.mythtv.org/trac/ticket/3787 but without the required <BR>database update.</div> <div> </div> <div><BR><BR>You can get what you need (for your currently installed Myth) with:<BR><BR>mysql -umythtv -p mythconverg<BR><BR>ALTER TABLE diseqc_tree ADD COLUMN address TINYINT(3) UNSIGNED NOT NULL <BR>default 0 AFTER description;<BR>UPDATE diseqc_tree SET address = 16 WHERE type = 'switch';<BR><BR>Note, though, that you will be running in a nonstandard configuration <BR>and at the point where DiSEqC switch address selection is added to
<BR>MythTV in the future, you'll need to undo the change so that Myth will <BR>be able to upgrade your database properly. (Something like, "ALTER <BR>TABLE diseqc_tree DROP COLUMN address;") Then, you'll have to <BR>reconfigure things.<BR><BR>If you don't need DiSEqC switch address selection, you should probably <BR>find a standard build of MythTV, and then drop your database, restore <BR>the pre-0.21 backup, and let it upgrade your DB.<BR><BR>Mike<BR>_______________________________________________<BR>mythtv-users mailing list<BR>mythtv-users@mythtv.org<BR>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users<BR></div></BLOCKQUOTE> <div>Thanks Mike,</div> <div>I am not sure how I got that changeset in there as well the one for "default_authority", <A href="http://svn.mythtv.org/trac/changeset/12760">http://svn.mythtv.org/trac/changeset/12760</A>, but obviously I did somehow.</div> <div>I have already added in the two offending columns but I was really hoping to figure
out what was out of sync, the database or the program. You have confirmed that it is the programs so that is good.</div> <div>I don't need the multiple switch selection so I could drop it. </div> <div>But I am confused as to why doing the install didn't replace all of those libraries.</div> <div>When I get home I will check and see if I can find any old files kicking around.</div> <div> </div> <div>Dave</div> <div><BR> </div><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>