[mythtv-users] Help w/DB error with mythrename since adding .avi's into Recordings

[Bobby Gill]

Just sending this out as I asked it in response to another thread but it's
probably been overlooked, I am getting this error when running mythrename.pl
since I added some .avi's into Recordings. I had forgotten to use the ChanID
on a few first additions (done properly on all additions since), so how can
I go and fix this?


> DBD::mysql::st execute failed: Column 'starttime' cannot be null at
> /usr/share/perl5/site_perl/5.10.0/MythTV/Recording.pm line 69.
>
DBD::mysql::st fetchrow_array failed: fetch() without execute() at
>> /usr/share/perl5/site_perl/5.10.0/MythTV/Recording.pm line 70.
>>
> The problem is exactly what it says it is.  You manually added files to the
> recordings improperly (without proper chanid and starttime).  MythTV uses
> those two values to index recorded content, and so if those are not
> available and distinct, bad things will happen.
> _______________________________________________
>

Ah yes, I see what I have done wrong now when having added them. I got the
> ChanID list going properly and added a few correctly, but now how do I go
> and change the channel ID for all these ones I've added before?


Thanks for any help
Bob
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20090921/04ada247/attachment.htm>