[mythtv] [mythtv-commits] mythtv commit: r12760 - in trunk/mythtv/libs/libmythtv by stuarta

[Jim Westfall]

The db update causes problems for me.

2007-02-08 18:46:21.622 Current Schema Version: 1178
2007-02-08 18:46:21.622 Newest Schema Version : 1179
2007-02-08 18:46:21.623 New DB connection, total: 2
2007-02-08 18:46:21.623 Connected to database 'mythconverg' at host: localhost
2007-02-08 18:46:21.624 Setting Lock for Database Schema upgrade. If you 
see a long pause here it means the Schema is already locked and is being 
upgraded by another Myth process.
2007-02-08 18:46:21.624 New DB connection, total: 3
2007-02-08 18:46:21.624 Connected to database 'mythconverg' at host: localhost
2007-02-08 18:46:21.625 Upgrading to schema version 1179
2007-02-08 18:46:26.599 DB Error (Performing database upgrade):
Query was: ALTER TABLE record_tmp      CHANGE seriesid  seriesid  VARCHAR(40) NOT NULL DEFAULT '';
Error was: Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.record_tmp' doesn't exist

jim

mythtv at cvs.mythtv.org <mythtv at cvs.mythtv.org> wrote [02.08.07]:
>       Author: stuarta
>         Date: 2007-02-08 22:31:54 +0000 (Thu, 08 Feb 2007)
> New Revision: 12760
>    Changeset: http://cvs.mythtv.org/trac/changeset/12760
> 
> Modified:
> 
>    trunk/mythtv/libs/libmythtv/channelutil.cpp
>    trunk/mythtv/libs/libmythtv/channelutil.h
>    trunk/mythtv/libs/libmythtv/dbcheck.cpp
>    trunk/mythtv/libs/libmythtv/eit.cpp
>    trunk/mythtv/libs/libmythtv/eit.h
>    trunk/mythtv/libs/libmythtv/eithelper.cpp
>    trunk/mythtv/libs/libmythtv/mpeg/dvbdescriptors.h
>    trunk/mythtv/libs/libmythtv/siscan.cpp
> 
> Log:
> 
> Closes #2811. Implements BBC Series link functionality
> 
> With this changeset users of EIT in the UK will now have
> useful programid & seriesid information which allows the
> scheduler to better detect duplicates of shows, even when
> the EPG monkeys manage to describe the same episode 3
> different ways.
> 
> This adds support for the default_authority that is currently
> being broadcast in the SDT, and stores that with the channel info.
> 
> Database Update!
> 
> This increases the size of seriesid & programid to accomodate
> the larger size of the CRID based seriesid & programid info.
> Also adds default_authority to the channel table.
> 
> UK users wishing to take full advantage of this new functionality
> will need to rescan their channels to populate the default
> authority information for each channel.
> 
> 
> 
> 
> 
> _______________________________________________
> mythtv-commits mailing list
> mythtv-commits at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-commits