Re: Re: [mythtv-users] DVB OTA EPG in Finland: wrong time
On Wed, 2005-03-23 at 11:33 +0100, borgi2008 wrote: > I think if you have FC3 and all Updates you got the Qt 3.4.0 Libaries > which are broken. You must install the old qt3.3.8 libaries from the > CD/DVD to get the EPG working again. I had have the same problem some > days ago Thanks, that was exactly what was wrong! ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] DVB OTA EPG in Finland: wrong time
skuli puli wrote: anymore. Just used mythweb to check it, and all programs are off two hours again. Mythbackend must have changed it by itself, since I haven't touched the box after I first got the times ok. Just recorded on program and left it running for a day. /var/log/mythtv/mythbackend.log gets filled with this kind of errors: === DB Error (Adding Event): Query was: INSERT INTO program (chanid,starttime,endtime,title,description,subtitle,categor y,programid,stereo,closecaptioned,hdtv)VALUES (1003,'2005-03-27 21:15:00','2005- 03-27 23:10:00','Alien Saga (K15)','Kiehtovassa amerikkalaisdokumentissa perehdy tään neljän Alien-elokuvan värikkääseen historiaan. Elokuvien tekovaiheista kert ovat mm. ohjaajat Ridley Scott ja James Cameron, näyttelijät Sigourney Weaver, Tom Skerritt, Michael Biehn,','','Education/Science/Factual',690,0,0,0); Driver error was [2/1062]: QMYSQL3: Unable to execute query Database error was: Duplicate entry '1003-2005-03-27 21:15:00' for key 1 === I don't know where it gets the program data what it tryes to insert into CVS. When I get home I need to check I don't have any automatic mythfilldatabase option set in mythtvsetup. My myth is also the latest from atrpms on FC3. This is the OTA (on-the-air) program data that is constantly received (when the backend is recording, I think). You probably should not run mythfilldatabase at all if you also receive program data this way. At least for me the update to 0.17 broke the EPG while I still run mythfilldatabase periodically. I also have my logs filled with these messages. In my opinion, this kind of database errors should not be logged to the log file. ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] DVB OTA EPG in Finland: wrong time
--- skuli puli <[EMAIL PROTECTED]> wrote: > > --- Osma Ahvenlampi <[EMAIL PROTECTED]> wrote: > > me after a few hours of debugging: the EPG for my > > DVB-T channels is a > > couple of too early. > > Any ideas would be quite appreciated. Thanks! > > > > //osma > > Worked for me... well, now that you mentioned it... doesn't work anymore. Just used mythweb to check it, and all programs are off two hours again. Mythbackend must have changed it by itself, since I haven't touched the box after I first got the times ok. Just recorded on program and left it running for a day. /var/log/mythtv/mythbackend.log gets filled with this kind of errors: === DB Error (Adding Event): Query was: INSERT INTO program (chanid,starttime,endtime,title,description,subtitle,categor y,programid,stereo,closecaptioned,hdtv)VALUES (1003,'2005-03-27 21:15:00','2005- 03-27 23:10:00','Alien Saga (K15)','Kiehtovassa amerikkalaisdokumentissa perehdy tään neljän Alien-elokuvan värikkääseen historiaan. Elokuvien tekovaiheista kert ovat mm. ohjaajat Ridley Scott ja James Cameron, näyttelijät Sigourney Weaver, Tom Skerritt, Michael Biehn,','','Education/Science/Factual',690,0,0,0); Driver error was [2/1062]: QMYSQL3: Unable to execute query Database error was: Duplicate entry '1003-2005-03-27 21:15:00' for key 1 === I don't know where it gets the program data what it tryes to insert into CVS. When I get home I need to check I don't have any automatic mythfilldatabase option set in mythtvsetup. My myth is also the latest from atrpms on FC3. __ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: Re: [mythtv-users] DVB OTA EPG in Finland: wrong time
Hi, I think if you have FC3 and all Updates you got the Qt 3.4.0 Libaries which are broken. You must install the old qt3.3.8 libaries from the CD/DVD to get the EPG working again. I had have the same problem some days ago Borgi2008 ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] DVB OTA EPG in Finland: wrong time
--- Osma Ahvenlampi <[EMAIL PROTECTED]> wrote: > me after a few hours of debugging: the EPG for my > DVB-T channels is a > couple of too early. > Any ideas would be quite appreciated. Thanks! > > //osma Happened to mee too couple nights ago. I don't know what is OTA, but I run mythfilldatabase occationally. I also use atrpms, and there was somekind of update to myth couple days ago. Anyways, I got it fixed by nuking the (old)programs tables from mysql. After that I changed TimeOffset from mysql. Then I run the mythfilldatabase again. I don't know what really did the trick, but now myth is back in finnish time. mysql> select * from settings where value="TimeOffset" ; ++---+--+ | value | data | hostname | ++---+--+ | TimeOffset | +0200 | NULL | ++---+--+ There was no offset previously set. I don't know if there is GUI for that, mythtvsetup or something, but since I wasn't near the box I had to do it this way. Worked for me... By the way, do you get finnish channel icons automatically from somewhere (HTV cable)? I just went around the web and downloaded some images for those. Don't look exactly nice __ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] DVB OTA EPG in Finland: wrong time
On Wed, 2005-03-23 at 09:16 +, John Pullan wrote: > Just a thought, you haven't just switched to daylight savings time have > you ? As I mentioned in the original, DST switch happens next Sunday. Could be relevant, but the offsets don't match: Finnish time is now UTC+2 (matching the current error), DST will be UTC+3. > On Wed, 2005-03-23 at 11:14 +0200, Osma Ahvenlampi wrote: > > Thanks for your reply. I am using OTA data, have been since 0.17 - and > > it worked fine before, yesterday being the first day when program data > > was broken (first with programs appearing twice in the EPG, once at the > > correct time, another two hours earlier, then only at the wrong time > > after I wiped the programs table of the MythTV database and let it > > refill). -- Osma Ahvenlampi <[EMAIL PROTECTED]> http://www.fishpool.org ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] DVB OTA EPG in Finland: wrong time
Just a thought, you haven't just switched to daylight savings time have you ? On Wed, 2005-03-23 at 11:14 +0200, Osma Ahvenlampi wrote: > On Wed, 2005-03-23 at 10:37 +0200, Kalle Pokki wrote: > > >After happily using MythTV for months, and v0.17 since almost the day it > > >was released, today I ran into a new problem, the reason to which eludes > > >me after a few hours of debugging: the EPG for my DVB-T channels is a > > >couple of too early. > > > > > I just checked that with 0.17 my recording set to begin at 10:15 did > > start at the correct time. Perhaps there is something broken in your > > ATrpms update. > > > > Have you run mythfilldatabase or are you using the on-the-air program data? > > Thanks for your reply. I am using OTA data, have been since 0.17 - and > it worked fine before, yesterday being the first day when program data > was broken (first with programs appearing twice in the EPG, once at the > correct time, another two hours earlier, then only at the wrong time > after I wiped the programs table of the MythTV database and let it > refill). > ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] DVB OTA EPG in Finland: wrong time
On Wed, 2005-03-23 at 10:37 +0200, Kalle Pokki wrote: > >After happily using MythTV for months, and v0.17 since almost the day it > >was released, today I ran into a new problem, the reason to which eludes > >me after a few hours of debugging: the EPG for my DVB-T channels is a > >couple of too early. > > > I just checked that with 0.17 my recording set to begin at 10:15 did > start at the correct time. Perhaps there is something broken in your > ATrpms update. > > Have you run mythfilldatabase or are you using the on-the-air program data? Thanks for your reply. I am using OTA data, have been since 0.17 - and it worked fine before, yesterday being the first day when program data was broken (first with programs appearing twice in the EPG, once at the correct time, another two hours earlier, then only at the wrong time after I wiped the programs table of the MythTV database and let it refill). -- Osma Ahvenlampi <[EMAIL PROTECTED]> http://www.fishpool.org ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] DVB OTA EPG in Finland: wrong time
Osma Ahvenlampi wrote: After happily using MythTV for months, and v0.17 since almost the day it was released, today I ran into a new problem, the reason to which eludes me after a few hours of debugging: the EPG for my DVB-T channels is a couple of too early. I don't know if this is related to installing the ATrpms updates (now mythtv-0.17-97.rhfc3.at), or the upcoming daylight savings time (next weekend in Finland along with the rest of EU), or some other factor, but a program which actually will start at 22:00 is marked in the EPG as starting at 20:00, and so forth. Obviously, this means no recordings contain what they should contain. Yesterday, things still were fine (but that EPG data could be a few days old, while I was still running an older ATrpms build of 0.17). I just checked that with 0.17 my recording set to begin at 10:15 did start at the correct time. Perhaps there is something broken in your ATrpms update. Have you run mythfilldatabase or are you using the on-the-air program data? ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users