[mythtv-users] 'Previously Recorded' screen shows only ancient history

[John Pilkington]

On 15/06/17 10:25, John Pilkington wrote:
> My main mythbox says it is running frontend
> 
> Revision: v29-Pre-v0.29-pre-415-g27d348f
> 
> locally built for SL7 using an rpm specfile based on that from rpmfusion.
> 
> I recently noticed that the Manage Recordings > Previously Recorded 
> screen lists only recordings made between Jan 2005 and Nov 2014, with 
> one exception from Mar 2015.  I remember that it used to show a detailed 
> list of recent stuff too, but I don't know when I lost that.
> 
> I have before-and-after DB backups from Nov 2014 when I started using 
> this hardware, and it seems quite likely that I messed up a hostname 
> change then.  I've also imported a few recordings from other boxes, 
> using MythArchive native mode, perhaps with mismatched Myth versions; 
> they never appeared in this screen.
> 
> The system still knows about at least some of the 'missing' recordings. 
> It finds them with select > Edit > Schedule info > Previously recorded.
> 
> Another independent box, Fedora 25, same revision, seems ok but isn't 
> showing the list of recent unrecorded repeats etc that ISTR
> 
> Any hints on what it might be worth investigating?
> 
> TIA
> 
> John P

This looks a likely suspect; from 'mythfrontend -v database'

2017-06-16 23:45:18.924742 I  MSqlQuery::exec(DBManager2) SELECT 
oldrecorded.chanid, starttime, endtime, title, subtitle, description, 
season, episode, category, seriesid, programid, inetref, 
channel.channum, channel.callsign, channel.name, findid, rectype, 
recstatus, recordid, duplicate  FROM oldrecorded LEFT JOIN channel ON 
oldrecorded.chanid = channel.chanid WHERE oldrecorded.future = 0  LIMIT 
20000  <<<< Took 161ms, Returned 20000 row(s)