[mythtv] Problems in new checkout of mythtv -- dbcheck.cpp

[David]

I found this at line 380:
    if (dbver == "1014")
    {
        const QString updates[] = {
"ALTER TABLE dvb_sat CHANGE lnb_log_switch lnb_lof_switch INTEGER 
DEFAULT 11700000;",
"UPDATE settings SET value='RecPriorityOrder' WHERE 
value='RecPriorityingOrder';",
""
};

David

Jared Luxenberg wrote:

>I imagine something is messed up with your database.  To confirm, try this:
>BACKUP YOUR DATABASE!!!  then:
>
># mysql -u root
>mysql> drop database mythconverg;
>mysql> create database mythconverg;
>
>Then restart mythbackend.  It should recreate your database.  If this works,
>then something is messed up with your database.  If that's the case, then
>I'm not sure what to do.
>
>- Jared
>
>-----Original Message-----
>From: mythtv-dev-bounces at mythtv.org
>[mailto:mythtv-dev-bounces at mythtv.org]On Behalf Of David Shay
>Sent: Monday, April 19, 2004 11:09 PM
>To: mythtv-dev at mythtv.org
>Subject: [mythtv] Problems in new checkout of mythtv -- dbcheck.cpp
>
>
>Tried to download most recent CVS  -- even deleted my whole local tree and
>re-downloaded.  A few problems in dbcheck.cpp.  First of all, there is a new
>version "1039" which appears to just recreate "programgenres" using the same
>syntax as was in version "1038".
>
>Before it even gets that far, however, a fresh install dies on "1015".  Here
>is the error:
>
>DB Error (Performing database upgrade):
>Query was:
>ALTER TABLE dvb_sat CHANGE lnb_log_switch lnb_lof_switch INTEGER DEFAULT
>11700000;
>Driver error was [2/1054]:
>QMYSQL3: Unable to execute query
>Database error was:
>Unknown column 'lnb_log_switch' in 'dvb_sat'
>
>In looking at the source, it would appear that the the column is currently
>called lnb_log_switch not lnb_lof_switch.  There was a reference to this a
>while back, don't know what happened.  I *SWEAR* I did this yesterday on a
>different machine and had no problem.  Now, however. I delete the whole
>"mythtv " directory, do a cvs login and then a cvs checkout of mythtv, and I
>have this problem.  I'm 99 44/100% sure this is user error, just can't
>identify what the problem is right now...  Anybody?
>
>This might be related to the fact that now that an update fails, it drops
>out
>entirely.  My guess is that before that patch, this would have been OK, but
>no longer is.  Anyway, looks like it needs some work, but I figure the last
>thing we need right now is another patch to dbcheck.cpp -- I'll let the
>experts handle that one...
>
>  
>
>------------------------------------------------------------------------
>
>_______________________________________________
>mythtv-dev mailing list
>mythtv-dev at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
>  
>