id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc	mlocked
13096	Previously Recorded' screen is only showing ancient history	J.Pilk@…	Peter Bennett	"My main mythbox says it is running frontend

Revision: v30-Pre-v30-Pre-3-g538f99e

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 I used to see.

> 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)

I tried  'select starttime from oldrecorded ;' and got 44596 rows.  'recorded' gave 862 rows.

But I only noticed the change in the page very recently.

The above is largely copied, with a little updating, from posts on mythusers in mid-June 2017.  I was afraid that the problem might result from some form of database abuse.


"	Bug Report - General	closed	minor	29.1	MythTV - General	Master Head	medium	fixed			0