Re: [mythtv-users] TV sched is wrong; how to fix it?
Michael T. Dean wrote: ># mythfilldatabase --help > >... > >--refresh-today >--refresh-second >--refresh-all > (Only valid for grabbers: na, se_swedb, no, ee, de_tvtoday) > Force a refresh today or two days (or every day) from now, > to catch the latest changes > >--- > >(BTW, the "na" is North America--based on the old name for the >zap2it/DataDirect stuff). > > > Wow. Now that's efficient. Robert committed a fix in SVN ( http://cvs.mythtv.org/trac/changeset/8677 ) 10 minutes after I sent this e-mail (and before I got a chance to do up a patch to request the change). Thanks, Robert. Mike ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] TV sched is wrong; how to fix it?
David A. De Graaf wrote: >On Fri, Jan 20, 2006 at 09:28:58PM -0800, Joe Votour wrote: > > >>Please forgive the numbered bullets, but this doesn't >>really fit into proper paragraphs. >>1. Check that Zap2It didn't change your channel >>numbers. If they did, then you'll need to reset them. >>2. You can delete the schedule information by running >>the SQL command "delete from program;". >>3. To check your channels in the database and compare >>them against Zap2It, or what you think they should be, >>you can do the SQL command, "select * from channel;". >>4. After deleting the schedule information (step 2), >>you can re-run mythfilldatabase, and it should >>(hopefully) pull down the correct info. >> >> >Thank you Joe Votour. Your solution of running "delete from program;" >followed by "mythfilldatabase" fixed my schedule database. > >I need to learn more of these mysql commands. They're not exactly >obvious... > > > Or to use "--help" # mythfilldatabase --help ... --refresh-today --refresh-second --refresh-all (Only valid for grabbers: na, se_swedb, no, ee, de_tvtoday) Force a refresh today or two days (or every day) from now, to catch the latest changes --- (BTW, the "na" is North America--based on the old name for the zap2it/DataDirect stuff). Mike ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] TV sched is wrong; how to fix it?
On Fri, Jan 20, 2006 at 09:28:58PM -0800, Joe Votour wrote: > > > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] Behalf Of > > David A. De Graaf > > Sent: Friday, January 20, 2006 6:39 PM > > To: mythtv-users@mythtv.org > > Subject: [mythtv-users] TV sched is wrong; how to > > fix it? > > > > > > Somehow, my TV schedule database got some wrong > > info. Possibly it > > happened as a consequence of a recent power failure; > > I don't know. > > > > I'd like to delete just the schedule data and rerun > > mythfilldatatbase, > > but I don't see how to do this selective deletion. > > How do I delete and renew the schedule data from the > > mysql database? > > Any advice is welcome. > > > > > > -- > > David A. De GraafDATIX, Inc.Hendersonville, > > > > Please forgive the numbered bullets, but this doesn't > really fit into proper paragraphs. > 1. Check that Zap2It didn't change your channel > numbers. If they did, then you'll need to reset them. > 2. You can delete the schedule information by running > the SQL command "delete from program;". > 3. To check your channels in the database and compare > them against Zap2It, or what you think they should be, > you can do the SQL command, "select * from channel;". > 4. After deleting the schedule information (step 2), > you can re-run mythfilldatabase, and it should > (hopefully) pull down the correct info. > > -- Joe > Thank you Joe Votour. Your solution of running "delete from program;" followed by "mythfilldatabase" fixed my schedule database. I need to learn more of these mysql commands. They're not exactly obvious... -- David A. De GraafDATIX, Inc.Hendersonville, NC [EMAIL PROTECTED] www.datix.us ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] TV sched is wrong; how to fix it?
--- Tim <[EMAIL PROTECTED]> wrote: > check your system clock and time zone. i had this > problem because my clock > and timezone were not correct. tzconfig, and i > think the date command. > later. > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of > David A. De Graaf > Sent: Friday, January 20, 2006 6:39 PM > To: mythtv-users@mythtv.org > Subject: [mythtv-users] TV sched is wrong; how to > fix it? > > > Somehow, my TV schedule database got some wrong > info. Possibly it > happened as a consequence of a recent power failure; > I don't know. > The result is that the channels listed are off by > one. That is, > the programs for channel 9 are listed as showing on > channel 10, etc. > Thus, it is impossible to record the correct > program. > This bad data extends only through Sat. 1/21, so all > I have to do is > wait out the problem. > > Nonetheless, there are some programs on Sat night > that I'd really like > to record, which are not broadcast later. And I'd > like to know how > such a problem can be dealt with in the future. > > I'd like to delete just the schedule data and rerun > mythfilldatatbase, > but I don't see how to do this selective deletion. > How do I delete and renew the schedule data from the > mysql database? > Any advice is welcome. > > If it matters, I am running mythtv svn from 0107, > with a pcHDTV HD-3000 > card on Fedora Core 4, x86_64. TV signals are from > a Mediacom cable, > using plain old analog NTSC modulation. The TV > schedules are downloaded > from DataDirect for Mediacom cable for our zipcode > of 28739. > > -- > David A. De GraafDATIX, Inc.Hendersonville, > NC > [EMAIL PROTECTED] www.datix.us > ___ > mythtv-users mailing list > mythtv-users@mythtv.org > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users > > ___ > mythtv-users mailing list > mythtv-users@mythtv.org > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users > Please forgive the numbered bullets, but this doesn't really fit into proper paragraphs. 1. Check that Zap2It didn't change your channel numbers. If they did, then you'll need to reset them. 2. You can delete the schedule information by running the SQL command "delete from program;". 3. To check your channels in the database and compare them against Zap2It, or what you think they should be, you can do the SQL command, "select * from channel;". 4. After deleting the schedule information (step 2), you can re-run mythfilldatabase, and it should (hopefully) pull down the correct info. -- Joe __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] TV sched is wrong; how to fix it?
check your system clock and time zone. i had this problem because my clock and timezone were not correct. tzconfig, and i think the date command. later. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David A. De Graaf Sent: Friday, January 20, 2006 6:39 PM To: mythtv-users@mythtv.org Subject: [mythtv-users] TV sched is wrong; how to fix it? Somehow, my TV schedule database got some wrong info. Possibly it happened as a consequence of a recent power failure; I don't know. The result is that the channels listed are off by one. That is, the programs for channel 9 are listed as showing on channel 10, etc. Thus, it is impossible to record the correct program. This bad data extends only through Sat. 1/21, so all I have to do is wait out the problem. Nonetheless, there are some programs on Sat night that I'd really like to record, which are not broadcast later. And I'd like to know how such a problem can be dealt with in the future. I'd like to delete just the schedule data and rerun mythfilldatatbase, but I don't see how to do this selective deletion. How do I delete and renew the schedule data from the mysql database? Any advice is welcome. If it matters, I am running mythtv svn from 0107, with a pcHDTV HD-3000 card on Fedora Core 4, x86_64. TV signals are from a Mediacom cable, using plain old analog NTSC modulation. The TV schedules are downloaded from DataDirect for Mediacom cable for our zipcode of 28739. -- David A. De GraafDATIX, Inc.Hendersonville, NC [EMAIL PROTECTED] www.datix.us ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
