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

sven waeyenbergh sven.waeyenbergh at gmail.com
Wed Dec 20 13:15:41 UTC 2006


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

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 --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20061220/4149291f/attachment-0001.htm 


More information about the mythtv-users mailing list