Hi,<br><br>I installed a new fedora core 6 (atrpms) backend machine and remote frontend machine.<br>Installation went ok, was able to setup the backend and also to add tv listings that show up in mythweb.<br>Install of the frontend also went fine.
<br><br>However, every time i try to access live tv, the backend crashes immediately.<br>Much to my surprise, the reason seems to be database structure errors ???<br><br>I was able to replicate this problem again and again.
<br>I also checked the files i used to import tv listings and channels.<br>The one that instaals the channels redefines the channel tables as such:<br>CREATE TABLE channel (<br> chanid int(10) unsigned NOT NULL default '0',
<br> channum varchar(5) NOT NULL default '',<br> freqid varchar(5) NOT NULL default '',<br> sourceid int(10) unsigned default NULL,<br> callsign varchar(20) default NULL,<br> name varchar(20) default NULL,
<br> icon varchar(255) default NULL,<br> finetune int(11) default NULL,<br> videofilters varchar(255) default NULL,<br> xmltvid varchar(64) default NULL,<br> recpriority int(10) NOT NULL default '0',<br> contrast int(11) default '32768',
<br> brightness int(11) default '32768',<br> colour int(11) default '32768',<br> hue int(11) default '32768',<br> tvformat varchar(10) NOT NULL default 'Default',<br> commfree tinyint(4) NOT NULL default '0',
<br> visible tinyint(1) NOT NULL default '1',<br> PRIMARY KEY (chanid)<br>) TYPE=MyISAM;<br>--> is that ok ?<br><br>Version (for both) is <a href="http://mythtv-suite-0.20-148.fc6.at/" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
mythtv-suite-0.20-148.fc6.at
</a><br><br>This log shows startup of the backend, crash, and (manual) restart:<br><br>2006-12-19 22:12:49.048 Using runtime prefix = /usr<br>2006-12-19 22:12:49.126 New DB connection, total: 1<br>2006-12-19 22:12:49.142
Connected to database 'mythconverg' at host: localhost
<br>2006-12-19 22:12:49.156 Current Schema Version: 1160<br>Starting up as the master server.<br>2006-12-19 22:12:49.182 New DB connection, total: 2<br>2006-12-19 22:12:49.187 Connected to database 'mythconverg' at host: localhost
<br>2006-12-19 22:12:49.190 EITHelper: localtime offset 1:00:00<br>2006-12-19 22:12:49.206 TVRec(1) Error: Start channel from DB is empty, setting to '1' instead.<br>2006-12-19 22:12:49.208 New DB connection, total: 3
<br>2006-12-19 22:12:49.219 Connected to database 'mythconverg' at host: localhost<br>2006-12-19 22:12:49.222 DB Error (get channels -- sourceid):<br>Query was:<br>SELECT
channum, callsign, chanid, atsc_major_chan,
atsc_minor_chan, name, icon, visible FROM channel WHERE
sourceid='1'
<br>Driver error was [2/1054]:<br>QMYSQL3: Unable to execute query<br>Database error was:<br>Unknown column 'atsc_major_chan' in 'field list'<br><br>2006-12-19 22:12:49.239 DB Error (GetChannelData):<br>Query was:
<br>SELECT finetune, freqid, tvformat, freqtable, commfree,
mplexid, atsc_major_chan, atsc_minor_chan, serviceid FROM
channel, videosource WHERE vi<br>deosource.sourceid = channel.sourceid AND channum = '1' AND
channel.sourceid = 1<br>Driver error was [2/1054]:<br>QMYSQL3: Unable to execute query<br>Database error was:<br>Unknown column 'mplexid' in 'field list'<br><br>2006-12-19 22:12:49.245 TVRec(1) Error: Setting start channel '1' failed,
<br> and no other channels were found on input.<br>2006-12-19 22:12:49.280 EITHelper: localtime offset 1:00:00<br>2006-12-19 22:12:49.297 TVRec(2) Error: Start channel from DB is empty, setting to '1' instead.
<br>2006-12-19 22:12:49.299 DB Error (get channels -- sourceid):<br>Query was:<br>SELECT
channum, callsign, chanid, atsc_major_chan,
atsc_minor_chan, name, icon, visible FROM channel WHERE
sourceid='1'
<br>Driver error was [2/1054]:<br>QMYSQL3: Unable to execute query<br>Database error was:<br>Unknown column 'atsc_major_chan' in 'field list'<br><br>2006-12-19 22:12:49.380 DB Error (GetChannelData):<br>Query was:
<br>SELECT finetune, freqid, tvformat, freqtable, commfree,
mplexid, atsc_major_chan, atsc_minor_chan, serviceid FROM
channel, videosource WHERE vi<br>deosource.sourceid = channel.sourceid AND channum = '1' AND
channel.sourceid = 1<br>Driver error was [2/1054]:<br>QMYSQL3: Unable to execute query<br>Database error was:<br>Unknown column 'mplexid' in 'field list'<br><br>2006-12-19 22:12:49.382 TVRec(2) Error: Setting start channel '1' failed,
<br> and no other channels were found on input.<br>2006-12-19 22:12:49.397 New DB scheduler connection<br>2006-12-19 22:12:49.423 Connected to database 'mythconverg' at host: localhost