PERSONAL 520

SPIRITUAL 416

LDS 312

BOOK OF MORMON 237

SCRIPTURES 154

STUDIO-JOURNEY 129

RELIGION 112

LINUX 79

COMPUTERS 65

LIFE 60

GENERAL CONFERENCE 46

GENTOO 39

MISCELLANEOUS 37

MUSIC 37

PROGRAMMING 33

CARS 29

MICROSOFT 23

FAMILY 23

AUDIO 21

I LOVE MY JOURNAL 18

FUN 15

CHILDREN 12

CURRENT EVENTS 10

NATURE'S WAY 10

VIDEO 9

DRM 9

CONEXM 7

BABBLINGS 7

PROVO CITY CENTER TEMPLE 6

FRIENDS 6

HEROD THE FINK 5

GAMES 5

COMPUTER HARDWARE 5

DRUMS 4

HAND OF GOD 3

ADVERSITY 3

KDENLIVE 3

AUDIO HARDWARE 3

GENERAL INSANITY 3

STUDIO 3

THANKS4GIVING 2

CATS 2

MY JOURNAL 1

POETRY 1

FOREVERGREEN 1

EVERYDAY THOUGHTS 1

GOSPEL 1

PARENTING 1

YOUTH CONFERENCE 1

CHURCH NOTES 1

POLITICS 1

Just thought I'd let you all know something that isn't readily apparent from googling - at least it wasn't for me.

For two channels, I had program data which was approximately 1.5 hours off.  This did me absolutely no good when it came to recording shows from mythtv.

I'm using MythTV .21

I came across a mailing list thread which had the answer.

After correcting the error I had in my channel section, I simply went to a MySQL editor, ran a quick SQL query, and re-populated the database with mythfilldatabase.

The SQL query issued was "DELETE FROM program"

I would highly recommend backing up your data before doing this.  It destructively deletes data from a table within MythTV.

With that said, after doing so and running mythfilldatabase, all my channel data came up correctly, and all is good.

It's very hack-ish, but I know of no other way to get rid of bad program data.

Worked like a charm.  So, to sum up:

1. BACK-UP ALL YOUR DATA!!!!
2. Run the SQL statement: DELETE FROM program
   
3. Run mythfilldatabase.
   
4. re-start myth.

and you should be good to go.