<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; ">This has happened 3 or 4 times now. starts after doing a rescan I raised a ticket for it to daniel to look into it.<DIV>The only solution I have found is to dump the database and start again from scratch.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>So in short no.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Tim<BR><DIV><DIV>On 24 Jul 2006, at 20:33, Jan Kleinig wrote:</DIV><BR class="Apple-interchange-newline"><BLOCKQUOTE type="cite"> <FONT face="Arial">Hey Tim, did you solve your problem? Having the same here with today's svn... :(<BR> I already deleted every channel and did a complete new scan... No success...<BR> <BR> <BR> </FONT><BR> Tim Jordan schrieb: <BLOCKQUOTE cite="mid9B68F921-296B-464B-B78E-C59DC8F406C9@wheresrover.co.uk" type="cite">Having a bit of a weird problem. As of todays tranche of commits I am unable to watch live tv. <DIV>The backend on starting complains of</DIV> <DIV><I><FONT class="Apple-style-span" size="1"><SPAN class="Apple-style-span" style="font-size: 9px;">2006-07-18 20:10:27.296 TVRec(12) Error: Start channel invalid, setting to '3' on input DVBInput instead.</SPAN></FONT></I></DIV> <DIV><I><FONT class="Apple-style-span" size="1"><SPAN class="Apple-style-span" style="font-size: 9px;">2006-07-18 20:10:27.349 New DB connection, total: 3</SPAN></FONT></I></DIV> <DIV><I><FONT class="Apple-style-span" size="1"><SPAN class="Apple-style-span" style="font-size: 9px;">2006-07-18 20:10:27.349 Connected to database 'mythconverg' at host: localhost</SPAN></FONT></I></DIV> <DIV><I><FONT class="Apple-style-span" size="1"><SPAN class="Apple-style-span" style="font-size: 9px;">2006-07-18 20:10:27.352 TVRec(12) Error: Setting start channel '3' failed, </SPAN></FONT></I></DIV> <DIV><I><FONT class="Apple-style-span" size="1"><SPAN class="Apple-style-span" style="font-size: 9px;"> and backup '1' failed as well.</SPAN></FONT></I></DIV> <DIV><I><FONT class="Apple-style-span" size="1"><SPAN class="Apple-style-span" style="font-size: 9px;">2006-07-18 20:10:27.296 TVRec(12) Error: Start channel invalid, setting to '3' on input DVBInput instead.</SPAN></FONT></I></DIV> <DIV><I><FONT class="Apple-style-span" size="1"><SPAN class="Apple-style-span" style="font-size: 9px;">2006-07-18 20:10:27.349 New DB connection, total: 3</SPAN></FONT></I></DIV> <DIV><I><FONT class="Apple-style-span" size="1"><SPAN class="Apple-style-span" style="font-size: 9px;">2006-07-18 20:10:27.349 Connected to database 'mythconverg' at host: localhost</SPAN></FONT></I></DIV> <DIV><I><FONT class="Apple-style-span" size="1"><SPAN class="Apple-style-span" style="font-size: 9px;">2006-07-18 20:10:27.352 TVRec(12) Error: Setting start channel '3' failed, </SPAN></FONT></I></DIV> <DIV><I><FONT class="Apple-style-span" size="1"><SPAN class="Apple-style-span" style="font-size: 9px;"> and backup '1' failed as well</SPAN></FONT>.</I></DIV> <DIV>for each one of my 3 capture cards.</DIV> <DIV>When I try to watch live tv I get this error on the backend</DIV> <DIV><I><FONT class="Apple-style-span" size="1"><SPAN class="Apple-style-span" style="font-size: 9px;">2006-07-18 21:02:00.360 DB Error (insert_program -- insert):</SPAN></FONT></I></DIV> <DIV><I><FONT class="Apple-style-span" size="1"><SPAN class="Apple-style-span" style="font-size: 9px;">Query was:</SPAN></FONT></I></DIV> <DIV><I><FONT class="Apple-style-span" size="1"><SPAN class="Apple-style-span" style="font-size: 9px;">INSERT INTO recorded (chanid, starttime, endtime, title, subtitle, description, hostname, category, recgroup, autoexpire, recordid, seriesid, programid, stars, previouslyshown, originalairdate, findid, transcoder, playgroup, recpriority, basename, progstart, progend, profile, duplicate) VALUES (NULL, '2006-07-18T23:51:39', '2006-07-18T22:01:22', '', '', '', 'mythtv', '', 'Default', 1, 0, '', '',0, 0, '1900-01-01', 0, 27, 'Default', 0, '_20060718235139.mpg', '2006-07-18T21:01:22', '2006-07-18T22:01:22', 'Default', 0)</SPAN></FONT></I></DIV> <DIV><I><FONT class="Apple-style-span" size="1"><SPAN class="Apple-style-span" style="font-size: 9px;">Driver error was [2/1048]:</SPAN></FONT></I></DIV> <DIV><I><FONT class="Apple-style-span" size="1"><SPAN class="Apple-style-span" style="font-size: 9px;">QMYSQL3: Unable to execute query</SPAN></FONT></I></DIV> <DIV><I><FONT class="Apple-style-span" size="1"><SPAN class="Apple-style-span" style="font-size: 9px;">Database error was:</SPAN></FONT></I></DIV> <DIV><I><FONT class="Apple-style-span" size="1"><SPAN class="Apple-style-span" style="font-size: 9px;">Column 'chanid' cannot be null</SPAN></FONT></I></DIV> <DIV>In a very fast repetitive pattern.</DIV> <DIV><BR class="khtml-block-placeholder"> </DIV> <DIV>I have deleted all the cards and the sources and readded but to no avail.</DIV> <DIV><BR class="khtml-block-placeholder"> </DIV> <DIV>Any ideas?</DIV> <DIV><BR class="khtml-block-placeholder"> </DIV> <PRE wrap=""><HR size="4" width="90%">_______________________________________________
mythtv-dev mailing list
<A class="moz-txt-link-abbreviated" href="mailto:mythtv-dev@mythtv.org">mythtv-dev@mythtv.org</A>
<A class="moz-txt-link-freetext" href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev</A>
</PRE></BLOCKQUOTE><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">_______________________________________________</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">mythtv-dev mailing list</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><A href="mailto:mythtv-dev@mythtv.org">mythtv-dev@mythtv.org</A></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><A href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev</A></DIV> </BLOCKQUOTE></DIV><BR></DIV></BODY></HTML>