<div class="im"><div>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?<br>
</div><blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">DBD::mysql::st execute failed: Column 'starttime' cannot be null at /usr/share/perl5/site_perl/5.10.0/MythTV/Recording.pm line 69.<br>
</blockquote><div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
DBD::mysql::st fetchrow_array failed: fetch() without execute() at /usr/share/perl5/site_perl/5.10.0/MythTV/Recording.pm line 70.<br>
</blockquote></div>
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.<br>
_______________________________________________<br></blockquote></div><br></div><blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">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?</blockquote><div><br>Thanks for any help<br>Bob <br></div>