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

Jared Luxenberg ziplux at comcast.net
Tue Apr 20 00:43:43 EDT 2004

I imagine something is messed up with your database.  To confirm, try this:

# 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
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
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...

More information about the mythtv-dev mailing list