[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