Re: [mythtv-users] mythfilldatabase full refresh
On Apr 5, 2005 5:32 PM, Lane Schwartz <[EMAIL PROTECTED]> wrote: > On Apr 4, 2005 8:27 AM, Mario L <[EMAIL PROTECTED]> wrote: > > The way I did was running mythtv-setup, and blowing my sources, and then > > rechoosing them. Next time I ran mythfilldatabase, I got it all. > > Hmm... I wonder what's different in my setup. > > I stopped mythfrontend and mythbackend, then ran mythtvsetup, kept my > card configs, blew away my sources, then re-added my sources, linked > them to my cards and exited mythtvsetup. > > I ran mythfilldatabase, restarted mythbackend and mythfrontend, but > the times for shows are still one hour off. > > Any thoughts? Let's see: 1. You didn't search the list and read the threads on how to fix the problem. 2. You didn't apply the workaround in said threads from step #1 before re-running mythfilldatabase. (Hint: you either need to adjust your timezone, apply a patch from CVS and or use the latest CVS and recompile, or simply wait for the next release due out any day now). -Dave ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] mythfilldatabase full refresh
On Apr 5, 2005 5:20 PM, Lane Schwartz <[EMAIL PROTECTED]> wrote: > On Apr 4, 2005 8:22 AM, Bill Oberman <[EMAIL PROTECTED]> wrote > > I was bit by the QT 3.3.4 bug + daylight savings, and have it fixed up with > > one of the posted workarounds. The problem is that I can't figure out how > > to do a full refresh of mythfilldatabase. If I run it with: > > I got hit by these as well. Just out of curiosity, are these myth bugs > or are they bugs in the QT libs and the DataDirect code? Come on Lane, search the list, it's been reiterated at least a few times already. -Dave ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] mythfilldatabase full refresh
On Apr 4, 2005 6:22 AM, Bill Oberman <[EMAIL PROTECTED]> wrote: > I was bit by the QT 3.3.4 bug + daylight savings, and have it fixed up with > one of the posted workarounds. The problem is that I can't figure out how > to do a full refresh of mythfilldatabase. If I run it with: Why bother? When mythfilldatabase does it's nightly run it will update tomorrow's listings for you. -Dave ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] mythfilldatabase full refresh
On Apr 4, 2005 8:27 AM, Mario L <[EMAIL PROTECTED]> wrote: > The way I did was running mythtv-setup, and blowing my sources, and then > rechoosing them. Next time I ran mythfilldatabase, I got it all. Hmm... I wonder what's different in my setup. I stopped mythfrontend and mythbackend, then ran mythtvsetup, kept my card configs, blew away my sources, then re-added my sources, linked them to my cards and exited mythtvsetup. I ran mythfilldatabase, restarted mythbackend and mythfrontend, but the times for shows are still one hour off. Any thoughts? Lane -- Meetup with other Myth users! http://mythtv.info/moin.cgi/MUG ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] mythfilldatabase full refresh
On Apr 4, 2005 8:22 AM, Bill Oberman <[EMAIL PROTECTED]> wrote > I was bit by the QT 3.3.4 bug + daylight savings, and have it fixed up with > one of the posted workarounds. The problem is that I can't figure out how > to do a full refresh of mythfilldatabase. If I run it with: I got hit by these as well. Just out of curiosity, are these myth bugs or are they bugs in the QT libs and the DataDirect code? Lane -- Meetup with other Myth users! http://mythtv.info/moin.cgi/MUG ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] mythfilldatabase full refresh
- Original Message - >From: "Bill Oberman" <[EMAIL PROTECTED]> >To: "Discussion about mythtv" >Sent: Monday, April 04, 2005 3:45 PM >Subject: RE: [mythtv-users] mythfilldatabase full refresh > >Thanks to everyone for posting ways I can replace bad program data :-) > >My 2 cents: I think an official command line option to mythfilldatabase >would be a more intuitive option long term. > >william Actually, in the code there is an option for "dd-grab-all" that will grab all available data direct data, effectively forcing a refresh. In some cases, if you've got multiple data sources defined (I have 3), you can actually grab LESS total bytes from datadirect's servers and actually refresh ALL of the data. That is because of the way that the current code first refreshes tomorrow, then today, then the last day of available schedule -- multiply that times the multiple data sources and the total data retrieved is pretty comparable. The downside of this option is that the Qt XML parser is fairly inefficient and uses quite a bit of memory and CPU time if you use this approach. I still use it from time to time. The option is currently commented out in filldata.cpp because of concerns over wasting datadirect bandwidth, but if you uncomment the lines, and continue to use CVS, the uncommenting stays put when CVS merges the changes. In most "standard" cases with a simple one-tuner setup, you wouldn't want or need to use the option. ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
RE: [mythtv-users] mythfilldatabase full refresh
Thanks to everyone for posting ways I can replace bad program data :-) My 2 cents: I think an official command line option to mythfilldatabase would be a more intuitive option long term. william -Original Message- From: aaron [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 1:15 PM To: Discussion about mythtv Subject: Re: [mythtv-users] mythfilldatabase full refresh On Apr 4, 2005 8:39 AM, aaron <[EMAIL PROTECTED]> wrote: > > Hm, something else occurs to me... I have not tried this. But it might > be as simple as: > mysql> DELETE FROM program; > > And then run mythfilldatabase. But again, I have not tried this. Take > a backup first. ;) Okay, I just tried it. Seems to work. I deleted everything from my program table, then ran mythfilldatabase. Afterward, my scheduled recordings look the same as before I did the test. -- aaron ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] mythfilldatabase full refresh
On Apr 4, 2005 8:39 AM, aaron <[EMAIL PROTECTED]> wrote: > > Hm, something else occurs to me... I have not tried this. But it might > be as simple as: > mysql> DELETE FROM program; > > And then run mythfilldatabase. But again, I have not tried this. Take > a backup first. ;) Okay, I just tried it. Seems to work. I deleted everything from my program table, then ran mythfilldatabase. Afterward, my scheduled recordings look the same as before I did the test. -- aaron ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
RE: [mythtv-users] mythfilldatabase full refresh
I think the easiest way might be to run the mythtvsetup and when it asks if you want to keep all channels select no (keep capture card settings when it asks), then reset up your capture card to point your input sources and just re-verify all is well, exit setup and then re-run mythfilldatabase -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of aaron Sent: Monday, April 04, 2005 7:39 AM To: Discussion about mythtv Subject: Re: [mythtv-users] mythfilldatabase full refresh On Apr 4, 2005 9:22 AM, Bill Oberman <[EMAIL PROTECTED]> wrote: > > I got updated data for those days, but days 3 -> N are wrong. I don't see a > command for "refresh-all" or anything like that, is there? I assume you're using the DataDirect stuff? If so, there is a way to refresh everything, but it's disabled by default (I think Isaac didn't want to add too much unnecessary load to the DD servers). There's an option in the code for --dd-grab-all , which will grab all the data available for your lineup, replacing whatever's in the database. But, as I said, it's not enabled by default. You'd have to uncomment the relevant code in the source (sorry, I forget where exactly), and recompile. Hm, something else occurs to me... I have not tried this. But it might be as simple as: mysql> DELETE FROM program; And then run mythfilldatabase. But again, I have not tried this. Take a backup first. ;) Anyone else want to jump in and let us know if we can just delete the contents of the program table? :) -- aaron ___ 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
Re: [mythtv-users] mythfilldatabase full refresh
On Apr 4, 2005 9:22 AM, Bill Oberman <[EMAIL PROTECTED]> wrote: > > I got updated data for those days, but days 3 -> N are wrong. I don't see a > command for "refresh-all" or anything like that, is there? I assume you're using the DataDirect stuff? If so, there is a way to refresh everything, but it's disabled by default (I think Isaac didn't want to add too much unnecessary load to the DD servers). There's an option in the code for --dd-grab-all , which will grab all the data available for your lineup, replacing whatever's in the database. But, as I said, it's not enabled by default. You'd have to uncomment the relevant code in the source (sorry, I forget where exactly), and recompile. Hm, something else occurs to me... I have not tried this. But it might be as simple as: mysql> DELETE FROM program; And then run mythfilldatabase. But again, I have not tried this. Take a backup first. ;) Anyone else want to jump in and let us know if we can just delete the contents of the program table? :) -- aaron ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] mythfilldatabase full refresh
The way I did was running mythtv-setup, and blowing my sources, and then rechoosing them. Next time I ran mythfilldatabase, I got it all.On Apr 4, 2005 9:22 AM, Bill Oberman <[EMAIL PROTECTED]> wrote: Hi, I was bit by the QT 3.3.4 bug + daylight savings, and have it fixed up with one of the posted workarounds. The problem is that I can't figure out how to do a full refresh of mythfilldatabase. If I run it with: --refresh-today or --refresh-second I got updated data for those days, but days 3 -> N are wrong. I don't see a command for "refresh-all" or anything like that, is there? Thanks, William ___mythtv-users mailing listmythtv-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