My mythtv box has skipped recording Law and Order for the past three weeks. I had assumed that they were not new episodes. But atleast last night it was a new episode and it still didn't record.

So I was looking arround in my settings and I first saw that where I listed today's schedule over mythweb, any show that starts at 10pm says "NO DATA". The listings work for before 10pm and after 10pm just not for exactly 10pm. Shows that start earlier and continue into 10pm show up normal. Has anybody seen this? Maybe it is a problem with my SQL database getting corupted?

I checked tomarrow's schedule at 10pm and it shows up just fine. Then I checked yesterday's schedule at 10pm and it shows up fine too. Except it says that it recorded Law and Order. It actually says "This showing was recorded". No episodes of Law and Order are listed under the recorded programs page on mythweb. And there is no entry for it being recorded in the backend logs. (Law and Order is on at 10pm if you didn't know)

Has anybody seen an error like this before? Is there a "SQL repaire" script I can run?

Did some more looking through the listings page and saw there were more times where the programs were missing. Sun Oct 23 at 11pm & Wed Oct 26th at 11pm is all "NO DATA". How can I tell mythtv to redownload the data from zap2it?

Nobaody else has seen this problem before?

Yes, been there seen that.

http://mysettopbox.tv/phpBB2/viewtopic.php?t=6041

(searching for "no data" with the forum search doesn't really help, searching the forum via Google, it turned up as thread #3)

So far my clump of "no data" has been far enough out that I haven't needed to mess with it, but I think mjl's suggestion to rerun mythtv-setup is probably the best. Let me know if it fixes things.