[mythtv-users] reconciling database and recorded files

[R. G. Newbury]

Michael T. Dean wrote:
> On 09/04/2008 05:59 AM, Jerome Yuzyk wrote:
>> On Wednesday 03 September 2008 20:50, Jerome Yuzyk wrote:
>>   
>>> Then this got me wondering about the subject of this message. Is there any
>>> tool that would reconcile database entries vs recorded files (probably
>>> including the PNG thumbnails)? Maybe someone has a handy SQL query snippet
>>> or pointer to such to get me started?
>>>     
>> Before anyone takes the time to reply,
> 
> heh.  http://www.gossamer-threads.com/lists/mythtv/users/348043#348043
> 
>>  I have answered my own question, and 
>> wrote a Perl script to give me a little report on all the 'recorded' records 
>> in the db, files with no record, records with no file, and thumbnails with no 
>> record. It's not fancy, but it answered part of my question.
> 
> So, basically, instead of reading Brad's response, you were busy 
> rewriting the functionality provided by the two scripts to which he 
> referred you.  ;)
> 
> If you're still really motivated, perhaps you could re-re-do those 
> scripts.  Both myth.rebuilddatabase.pl and myth.find_orphans.pl are old, 
> semi-maintained hacks that need to be ported to use the MythTV perl 
> bindings.  Your rewriting them to use the bindings and cleaning them up 
> (and, IMHO, combining them into a single script) would be very useful to 
> the project.  And, since you seem to know Perl... :)
> 
> If you are interested and you have questions, I'd be happy to provide 
> some pointers/recommendations.


And IF you are going to re-write these (hint, hint!), ISTR that the 
rebuilddatabase script had a problem at one time (maybe fixed now) that 
it failed to insert a file size into the database for the records it 
inserted, so myth choked on trying to play those recordings, (even 
though the file existed).

Geoff