<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Arial Narrow";
panose-1:2 11 5 6 2 2 2 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Arial Narrow";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:595.3pt 841.9pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-AU link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=black face=Verdana><span
style='font-size:10.0pt;font-family:Verdana;color:black'>Hi,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Verdana><span
style='font-size:10.0pt;font-family:Verdana;color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Verdana><span
style='font-size:10.0pt;font-family:Verdana;color:black'>I am having the same
problem described below. <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Verdana><span
style='font-size:10.0pt;font-family:Verdana;color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Verdana><span
style='font-size:10.0pt;font-family:Verdana;color:black'>Slave backend errors
when inserting into recorded and oldrecorded. Running .16 CVS from about the
same time.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Verdana><span
style='font-size:10.0pt;font-family:Verdana;color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Verdana><span
style='font-size:10.0pt;font-family:Verdana;color:black'>Did you get this
fixed? Does anyone know the answer?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Verdana><span
style='font-size:10.0pt;font-family:Verdana;color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Verdana><span
style='font-size:10.0pt;font-family:Verdana;color:black'>Thanks.<o:p></o:p></span></font></p>
<div style='mso-element:para-border-div;border:none;border-bottom:solid windowtext 1.0pt;
padding:0cm 0cm 1.0pt 0cm'>
<p class=MsoNormal style='border:none;padding:0cm'><font size=2 color=black
face=Verdana><span style='font-size:10.0pt;font-family:Verdana;color:black'><o:p> </o:p></span></font></p>
</div>
<p class=MsoNormal><font size=2 color=black face=Verdana><span
style='font-size:10.0pt;font-family:Verdana;color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Verdana><span
style='font-size:10.0pt;font-family:Verdana;color:black'>Mark Wrote:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Verdana><span
style='font-size:10.0pt;font-family:Verdana;color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Verdana><span
style='font-size:10.0pt;font-family:Verdana;color:black'>Hi all, <br>
<br>
(switched to the user list as it seems to be a problem more related to <br>
my setup) <br>
<br>
On Wed, 2004-10-13 at 23:39, Mark Cooke wrote: <br>
</span></font><font size=2 color="#660066" face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:#660066'>> Hi all, <br>
> <br>
> I upgraded my setup with current CVS code today, and since then after a <br>
> recording starts, I have been getting the following from the backend: <br>
> <br>
> DB Error (WriteRecordedToDB): <br>
> Query was: <br>
> INSERT INTO recorded <br>
>
(chanid,starttime,endtime,title,subtitle,description,hostname,category,recgroup,autoexpire,recordid,seriesid,programid,stars,previouslyshown,originalairdate)
VALUES(:CHANID,:STARTS,:ENDS,:TITLE,:SUBTITLE,:DESC,:HOSTNAME,:CATEGORY,:RECGROUP,:AUTOEXP,:RECORDID,:SERIESID,:PROGRAMID,:STARS,:REPEAT,:ORIGAIRDATE);
<br>
> Driver error was [2/1048]: <br>
> QMYSQL3: Unable to execute query <br>
> Database error was: <br>
> Column 'seriesid' cannot be null <br>
> <br>
> Recordings are written to disk correctly, but they don't appear in the <br>
> recorded programmes list. <br>
</span></font><font size=2 color=black face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:black'><br>
An update: <br>
<br>
The SQL error also happens for the oldrecorded table with DB Error <br>
(addHistory), showing the same error that seriesid cannot be null. <br>
<br>
It only appears to happen with my remote backend. Recordings on the <br>
local backend appear in the table as expected. The entry in the <br>
recorded table shows 'seriesid' as an empty string for these successful <br>
recordings. <br>
<br>
The other differences are that the remote backend has 2 x PVR-x50 cards, <br>
and the local backend has a bt8x8 V4L device. <br>
<br>
<br>
I've tried dropping all entries in the 'program' table, and re-running <br>
mythfilldatabase with the latest tv_grab_rt_uk instead of <br>
tv_grab_uk_bleb. I wasn't particularly expecting this to help, and it <br>
didn't. <br>
<br>
This issue is still present for my setup in today's CVS. <br>
<br>
Best regards, <br>
<br>
Mark <br>
<br>
<br>
More information on my setup: <br>
<br>
Machine 'gw', 10.2.3.1, front+backend+mysql, 1 x bt8x8, 2.6.8-1 <br>
Machine 'tv', 10.2.3.150, backend, 2 x ivtv, nfsroot 2.4.26 <br>
<br>
Both are running the same cvs release of mythtv, fedora core 2. </span></font><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'><o:p></o:p></span></font></p>
</div>
</body>
</html>