Over 3000 days of guide data.

Have a MythTV related problem? Ask for help from other MythTV users here.

Moderator: Forum Moderators

Post Reply
Posts: 446
Joined: Mon Jun 23, 2014 6:54 pm
Location: Wylie TX, USA
United States of America

Over 3000 days of guide data.

Post by wesnewell » Mon Jul 23, 2018 4:30 pm

Just switched to the new format of SD guide to get 20 days of guide data. Got more than I though I would. :o
Check how many days of guide data.
status.jpg (62.97 KiB) Viewed 103 times
There's really only 20. Don't know where this came from.
BE/FE-Asrock AB350 Pro AMD Ryzen 3 2200G, 6 atsc tuners. Frontends-GF8200's,,AMD Athlon II's. Mythtv user since 2005.

User avatar
Posts: 1181
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

Re: Over 3000 days of guide data.

Post by bill6502 » Mon Jul 23, 2018 4:59 pm

Most likely a corrupt endtime in the guide. The query used to
compute the number of days is:

SELECT max(endtime) FROM program WHERE manualid=0;

You could search for it, or just wait and it will go away when
the episode is no longer in the program table.

Post Reply