<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">On Wed, Apr 23, 2014 at 5:20 AM, Anthony Giggins <span dir="ltr"><<a href="mailto:seven@seven.dorksville.net" target="_blank">seven@seven.dorksville.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div class="gmail_extra"><div>
<dl><dt>Number of shows:
</dt><dd>495</dd><dt>Number of episodes:</dt><dd>15203</dd><dt>First recording:</dt><dd>Thursday January 1st, 1970</dd><dt>Last recording:</dt><dd>Wednesday April 23rd, 2014</dd><dt>Total Running Time:</dt><dd>
44 years 3 months 21 days 12 hrs 17 mins</dd><dt>Total Recorded:</dt><dd>1 year 3 days 18 hrs 42 mins</dd><dt>Percent of time spent recording:</dt><dd>2%</dd></dl>
ahhhh obviously some dirty data in there, strangely I cannot see recordings in oldrecorded where starttime = '0000-00-00 00:00:00'<br><br></div><div>anyone got any hints where to look?<br>
<br></div><div>Cheers,<br><br></div><div>Anthony<br></div></div></div></blockquote><div><br></div><div>You probably used some program which manipulated the database directly, such as to insert videos as if they were recordings. You could find out what it is with the following SQL: SELECT title, subtitle, starttime FROM recorded ORDER BY starttime LIMIT 10; (the LIMIT 10 just keeps it from running off the screen--you can adjust it as necessary). You could then adjust the starttime for the entries in question, but it's not advised to manipulate the database directly. Other than affecting your statistics, the "bad" data doesn't appear to be causing any problems, so you could just leave it...<br>
<br></div><div>Karl<br></div></div></div></div>