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

Melvin J. Cureton melvincureton at MELCRYS.COM
Wed Dec 20 14:26:26 UTC 2006


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 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 8198 bytes
Desc: not available
Url : http://mythtv.org/pipermail/mythtv-users/attachments/20061220/cd5e9399/attachment.bin 


More information about the mythtv-users mailing list