[mythtv] Error in updating dvb_sat as of db ver 1014 ??

[Iskander]

List gang,

I think this is a small typo
 From cvs 20031230 in file mythtv/libs/libmythtv/dbcheck.cpp on line 372 
i see:

"ALTER TABLE dvb_sat CHANGE lnb_log_switch lnb_lof_switch INTEGER 
DEFAULT 11700000;",

I think this has to be:

"ALTER TABLE dvb_sat CHANGE lnb_lof_switch lnb_lof_switch INTEGER 
DEFAULT 11700000;",

because column 'lnb_log_switch' does not exist.

I executed the command by hand, and the db is ok now.
Attached a little patch.

Iskander

-------------- next part --------------
--- libs/libmythtv/dbcheck.cpp.orig	2003-12-21 20:15:28.000000000 +0100
+++ libs/libmythtv/dbcheck.cpp	2004-01-02 16:03:03.000000000 +0100
@@ -369,7 +369,7 @@
     if (dbver == "1014")
     {
         const QString updates[] = {
-"ALTER TABLE dvb_sat CHANGE lnb_log_switch lnb_lof_switch INTEGER DEFAULT 11700000;",
+"ALTER TABLE dvb_sat CHANGE lnb_lof_switch lnb_lof_switch INTEGER DEFAULT 11700000;",
 "UPDATE settings SET value='RecPriorityOrder' WHERE value='RecPriorityingOrder';",
 ""
 };