[mythtv-users] backend crashing when live tv on fedora 6

sven waeyenbergh sven.waeyenbergh at gmail.com
Wed Dec 20 17:26:41 UTC 2006


Melvin,

thanks for the tip, i'll try tonight.

it looks like also i fucked up my channel/listings table with an outdated
sync script.


Greetz,
Ban

On 12/20/06, Melvin J. Cureton <melvincureton at melcrys.com> wrote:
>
> You may want to try setting you starting channel to 3 or 4 (which ever
> your channels start at) in the setup. I had a similar problem then I changed
> mine to start at channel 3 and all worked fine.
>
> Thank You
> Melvin Cureton
> melvincureton at melcrys.com
>
> ________________________________
>
> From: mythtv-users-bounces at mythtv.org on behalf of sven waeyenbergh
> Sent: Wed 12/20/2006 8:15 AM
> To: Discussion about mythtv
> Subject: [mythtv-users] backend crashing when live tv on fedora 6
>
>
> Hi,
>
> I installed a new fedora core 6 (atrpms) backend machine and remote
> frontend machine.
> Installation went ok, was able to setup the backend and also to add tv
> listings that show up in mythweb.
> Install of the frontend also went fine.
>
> However, every time i try to access live tv, the backend crashes
> immediately.
> Much to my surprise, the reason seems to be database structure errors ???
>
> I was able to replicate this problem again and again.
> I also checked the files i used to import tv listings and channels.
> The one that instaals the channels redefines the channel tables as such:
> CREATE TABLE channel (
>   chanid int(10) unsigned NOT NULL default '0',
>   channum varchar(5) NOT NULL default '',
>   freqid varchar(5) NOT NULL default '',
>   sourceid int(10) unsigned default NULL,
>   callsign varchar(20) default NULL,
>   name varchar(20) default NULL,
>   icon varchar(255) default NULL,
>   finetune int(11) default NULL,
>   videofilters varchar(255) default NULL,
>   xmltvid varchar(64) default NULL,
>   recpriority int(10) NOT NULL default '0',
>   contrast int(11) default '32768',
>   brightness int(11) default '32768',
>   colour int(11) default '32768',
>   hue int(11) default '32768',
>   tvformat varchar(10) NOT NULL default 'Default',
>   commfree tinyint(4) NOT NULL default '0',
>   visible tinyint(1) NOT NULL default '1',
>   PRIMARY KEY  (chanid)
> ) TYPE=MyISAM;
> --> is that ok ?
>
> Version (for both) is mythtv-suite-0.20-148.fc6.at <
> http://mythtv-suite-0.20-148.fc6.at/>
>
> This log shows startup of the backend, crash, and (manual) restart:
>
> 2006-12-19 22:12:49.048 Using runtime prefix = /usr
> 2006-12-19 22:12:49.126 New DB connection, total: 1
> 2006-12-19 22:12:49.142 Connected to database 'mythconverg' at host:
> localhost
> 2006-12-19 22:12:49.156 Current Schema Version: 1160
> Starting up as the master server.
> 2006-12-19 22:12:49.182 New DB connection, total: 2
> 2006-12-19 22:12:49.187 Connected to database 'mythconverg' at host:
> localhost
> 2006-12-19 22:12:49.190 EITHelper: localtime offset 1:00:00
> 2006-12-19 22:12:49.206 TVRec(1) Error: Start channel from DB is empty,
> setting to '1' instead.
> 2006-12-19 22:12:49.208 New DB connection, total: 3
> 2006-12-19 22:12:49.219 Connected to database 'mythconverg' at host:
> localhost
> 2006-12-19 22:12:49.222 DB Error (get channels -- sourceid):
> Query was:
> SELECT channum, callsign, chanid,        atsc_major_chan,
> atsc_minor_chan,        name, icon, visible FROM channel WHERE sourceid='1'
> Driver error was [2/1054]:
> QMYSQL3: Unable to execute query
> Database error was:
> Unknown column 'atsc_major_chan' in 'field list'
>
> 2006-12-19 22:12:49.239 DB Error (GetChannelData):
> Query was:
> SELECT finetune, freqid, tvformat, freqtable,        commfree,
> mplexid,        atsc_major_chan, atsc_minor_chan, serviceid FROM channel,
> videosource WHERE vi
> deosource.sourceid = channel.sourceid AND       channum              =
> '1'         AND       channel.sourceid     = 1
> Driver error was [2/1054]:
> QMYSQL3: Unable to execute query
> Database error was:
> Unknown column 'mplexid' in 'field list'
>
> 2006-12-19 22:12:49.245 TVRec(1) Error: Setting start channel '1' failed,
>                         and no other channels were found on input.
> 2006-12-19 22:12:49.280 EITHelper: localtime offset 1:00:00
> 2006-12-19 22:12:49.297 TVRec(2) Error: Start channel from DB is empty,
> setting to '1' instead.
> 2006-12-19 22:12:49.299 DB Error (get channels -- sourceid):
> Query was:
> SELECT channum, callsign, chanid,        atsc_major_chan,
> atsc_minor_chan,        name, icon, visible FROM channel WHERE sourceid='1'
> Driver error was [2/1054]:
> QMYSQL3: Unable to execute query
> Database error was:
> Unknown column 'atsc_major_chan' in 'field list'
>
> 2006-12-19 22:12:49.380 DB Error (GetChannelData):
> Query was:
> SELECT finetune, freqid, tvformat, freqtable,        commfree,
> mplexid,        atsc_major_chan, atsc_minor_chan, serviceid FROM channel,
> videosource WHERE vi
> deosource.sourceid = channel.sourceid AND       channum              =
> '1'         AND       channel.sourceid     = 1
> Driver error was [2/1054]:
> QMYSQL3: Unable to execute query
> Database error was:
> Unknown column 'mplexid' in 'field list'
>
> 2006-12-19 22:12:49.382 TVRec(2) Error: Setting start channel '1' failed,
>                         and no other channels were found on input.
> 2006-12-19 22:12:49.397 New DB scheduler connection
> 2006-12-19 22:12:49.423 Connected to database 'mythconverg' at host:
> localhost
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20061220/17cbfe09/attachment.htm 


More information about the mythtv-users mailing list