<div dir="ltr"><br><div class="gmail_extra"><br><br><div class="gmail_quote">On 23 April 2014 23:47, Karl Newman <span dir="ltr"><<a href="mailto:newmank1@asme.org" target="_blank">newmank1@asme.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div class="gmail_extra"><div class="gmail_quote"><div class="">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:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);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><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...<span class=""><font color="#888888"><br>
<br></font></span></div><span class=""><font color="#888888"><div>Karl<br></div></font></span></div></div></div>
<br></blockquote><div><br></div><div>Thanks Karl,<br><br></div><div>found the offending records in oldrecorded and fixed them, this is not entirely correct due to the data manipulation which I think is caused by either mythepisode or perhaps mythmediamonitor<br>
<br><div id="general_stats" class="">
<dl><dt>Number of shows:
</dt><dd>495</dd><dt>Number of episodes:</dt><dd>15211</dd><dt>First recording:</dt><dd>Thursday January 23rd, 2003</dd><dt>Last recording:</dt><dd>Thursday April 24th, 2014</dd><dt>Total Running Time:</dt><dd>
11 years 3 months 7 hrs 52 mins</dd><dt>Total Recorded:</dt><dd>1 year 3 days 21 hrs 44 mins</dd><dt>Percent of time spent recording:</dt><dd>8%</dd></dl>
</div></div></div><br></div><div class="gmail_extra">looking at the db I think I'd be closer to 7 or 8 years<br><br></div><div class="gmail_extra">Cheers,<br><br></div><div class="gmail_extra">Anthony<br></div></div>