I recently changed providers (sky to telewest) and manually cleared what I thought was all the program guide data and reconfigured xmltv to get the new listings, I have started to notice errors in the listings in that the wrong data is being populated therefore I want to clear all guide data and start from scratch. Can anyone confirm the exact tables I need to clear to completely wipe the guide data.

Cheers

I suppose you are using a grabber?
should perform a non-destructive update for users of grabbers, where no channel info ...

will give the complete info for --update option.
So maybe your problem can be solved using the mythfilldatabase program, avoiding corruption of your database.

_________________
Estimated time to start your thread and solve the problem: 1 to 20 hours
Estimated time to post your solution: 1 to 20 minutes

I am using the radio times grabber. I take it running mythfilldatabase --update will just delete all the guide data and wont affect any channel data?

I've googled and it turns out, that the option --update will prevent that channels unknown to the mythconverg-database are added to the database. So this won't help you!

I will try to delete the guide data from my box and restore them by running mythfilldatabase again (don't tell my wife and kids)

Meanwhile hoping that some mythtv-knoppmyth-database-guru will answer your question about the tables..

_________________
Estimated time to start your thread and solve the problem: 1 to 20 hours
Estimated time to post your solution: 1 to 20 minutes

Run mythtv-setup and answer "yes" to both questions.

but dont forget to resetup your channel source (the acount name, and paswd)
then re run mythfilldatabase

If I do this it will delete my channels as well, I dont want to have to se my channels up again I just want to delete all guide data as I think something has got messed up as a few channels show as having no data available however I am fairly confident that the xmltv side of it is configured correctly so just wanted to zap all the data and run mythfilldatabase again to see if it fills in the 'blanks'

Also Ive noticed that some of the data showing on particular channels is wrong.....

I think that the way described by tjc is right. But lets be creative: just deleting some or all rows is triggy, as one won't know how they are related to other tables or files. I just had a look into the XMLTV file and noticed, that all programs are within tags. Programs data start with


Maybe one could cheet the mythfilldatabase program by manipulating this file. You could delete everything within these tags <programme...
and </programme> including the tags. But maybe the tags are very important and have to stay as:
.

At the beginning of the xmltv file there are other tags, I would leave them!

After preparing this XMLTV file you could run mythfilldatabase with the --file parameter and other parameters.

tjc, could this work? It would be fine to find a way to clear just the program guide..

_________________
Estimated time to start your thread and solve the problem: 1 to 20 hours
Estimated time to post your solution: 1 to 20 minutes

There is a far simpler way if all you want is the program data:

it also takes care of little gotchas like rerunning the scheduler...

This is what I use when experimental program guide hacking via SQL scripts goes off the rails, but it's not recommended for regular use.

tjc: did that version of mythfilldatabase come with a newer version of KnoppMyth? My R5A16 does not seem to have a "refresh-all" option available. I used some MySQL commands to clear my guide info:

http://mysettopbox.tv/phpBB2/viewtopic. ... 2887#42887

Duh-oh! Darn, sometime I forget that my version is a bit "forward looking". I don't know when this appeared, I'm running something like R5A22++. I'm pretty sure all it does is purge the data from the program tables. I think the tables that need to be cleared are "program", "credits", "programgenres", and "programrating", although I may have missed one or two.

That little bit of code is a lifesaver. For some reason at least 10 important channels on my guide were wrong for the next 5 days. (For example the History channel data moved from channel 55 to channel 57 according to the guide data). Strangely, the data was correct at 6 days out and beyond. Anyway, using that code blasted away the errors and filled the database correctly. Sweet!

_________________
R5.5; PVR-250; FX5200; Dell 4300 with Intel Pentium 4 (1.5 GHz);
BIOS Revision A02; 512MB RAM; 500GB PATA HDD