John Pullan wrote:
Well dvb_channel, and dvb_pids are no longer used. We wanted to delete
them to avoid confusion, but that's another story.
OK, this time I did
- restore .16
- run setup to upgrade the schema, then exit
- empty those two tables (with mysql)
- run setup and add the trasports with Advanced
- do a scan. No improvement.
I then noticed that the setup program was logging errors like
2005-02-16 09:06:53.046 DVB#0 DVB SI Table Parser Started
2005-02-16 09:06:53.807 DVB#0 Using DVB card 0, with frontend Zarlink MT352
DVB-T.
2005-02-16 09:06:53.808 DVB#0 DVB Signal Monitor Starting
2005-02-16 09:06:55.332 DVB#0 Signal Locked
2005-02-16 09:06:55.794 DVB#0 DVB signal dc3 | snr bebe | ber 0 | unc 0
2005-02-16 09:06:55.794 DVB#0 Status: LOCK.
Setting currenTID = 1
DB Error (Adding new DVB Channel):
Query was:
INSERT INTO channel (chanid, channum, sourceid, callsign, name, mplexid,
serviceid, atscsrcid, useonairguide ) VALUES (1026,2055,2,'SC10 Canberra','SC10
Canberra',1,2055,0,0);
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '1026' for key 1
So I repeated the above steps but emptied 'channel' table too
(mysql again). The errors went away.
So what happened when you scanned existing transports ?
Doing "scan all existing transports" scanned four of the five
transports and the channels were created. I then scanned the
fifth transport explicitly (scan existing transport). I now
have all 15 channels defined.
Examining the channels shows that I lost the details from my
original channel table (icon filename, xmltvid etc.). I also
note that the channels did not keep the old chanid so maybe
I lost my recording details? No, they are still there, good.
Starting the backend now gets even further:
2005-02-16 09:21:48.551 DVB#0 DVB SI Table Parser Started
2005-02-16 09:21:49.312 DVB#0 Using DVB card 0, with frontend Zarlink MT352
DVB-T.
2005-02-16 09:21:49.314 DVB#0 DVB Signal Monitor Starting
2005-02-16 09:21:49.315 DVB#0 ERROR - Unable to find channel in database.
2005-02-16 09:21:49.315 DVB#0 ERROR - Failed to get channel options for channel
.
OK, now do the last recommended step and fix the channel numbers,
now all seems to work. Moreover, Win HDTV works well (as it did
before) but also ABC HDTV now works (the backend was always
crashing before). Very good.
I also lost the program guide. I manually added the xmltvid field
and ran mythfilldatabase, now the guide is back. My scheduled
recordings are still there too. Nice.
I should probably also add the icons manually. Did it and I now have
icons too. Excellent.
I can start start using mythtv for real and see how it performs. Great.
Last few small questions.
- Should I have allowed mythtv-setup to remove the channel data (as
it prompts up-front and I declined) instead of fiddling with mysql?
- How do I get the old recordings to be associated with the correct
channels? They have unknown chanid in their name so they do not
list nicely in the "watch recordings" list. They show as #1012 instead
of the text name.
Thanks everyone, and especially John.
--
Eyal Lebedinsky ([EMAIL PROTECTED]) <http://samba.org/eyal/>
attach .zip as .dat
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
