<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">On 10/24/2014 2:40 PM, Anthony Brummett
wrote:<br>
</div>
<blockquote
cite="mid:CADWoVqeO=Dn6Y5mqypyaRZPX6Es_J2LpFALT5e7dKgGSz1QpCg@mail.gmail.com"
type="cite">
<div dir="ltr">On Thu, Oct 23, 2014 at 4:55 PM, Bill Meek <span
dir="ltr"><<a moz-do-not-send="true"
href="mailto:keemllib@gmail.com" target="_blank">keemllib@gmail.com</a>></span>
wrote:<br>
<div class="gmail_extra">
<div class="gmail_quote">
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">
<div class="">
<div class="h5">On 10/23/2014 03:14 PM, Anthony Brummett
wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px
0px 0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">
I've switched to the new server using the /etc/hosts
method using IP<br>
54.85.117.227. I'm using MythTV 0.24. I'm running
mfd with this command<br>
line:<br>
mythfilldatabase --dd-grab-all -v file,network ><br>
/tmp/mythfilldatabase-newserver.log 2>&1<br>
</blockquote>
</div>
</div>
</blockquote>
<div> </div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">
That's some great data collection work. The timestamp says
you ran it<br>
today, so this *shouldn't* be the cause:<br>
<br>
<a moz-do-not-send="true"
href="http://forums.schedulesdirect.org/viewtopic.php?f=6&t=2599&start=70#p7985"
target="_blank">http://forums.schedulesdirect.org/viewtopic.php?f=6&t=2599&start=70#p7985</a><br>
<br>
I'm just wondering if you've got some stale data and if it
would<br>
be worth running again tomorrow before jumping in to
trouble-<br>
shooting this one.<br>
</blockquote>
<div><br>
</div>
<div>Probably not. I've been trying from time to time all
week, and it was failing in the same way. I ran it again
today, and it's still failing with the same kind of
errors. Just looking at the first failure:<br>
2014-10-24 11:16:05.054 DB Error (Inserting into
dd_program):<br>
Query was:<br>
INSERT INTO dd_program ( programid, title,
subtitle, description, showtype,
category_type, mpaara<br>
ting, starrating, stars, runtime,
year, seriesid, colorcode,
syndicatedepisodenumber, ori<br>
ginalairdate) VALUES (?, ?, ?, ?,
?, ?, ?, ?, ?, ?,
?, ?, ?<br>
, ?, ?) <br>
Bindings were:<br>
:CATTYPE=series, :COLORCODE=, :DESCRIPTION=, :MPAARATING=,<br>
:ORIGAIRDATE=2009-01-01, :PROGRAMID=EP000009935605,
:RUNTIME=,<br>
:SERIESID=EP00000993, :SHOWTYPE=Series, :STARRATING=,
:STARS=0,<br>
:SUBTITLE=Teams TBA, :SYNDNUM=TBA, :TITLE=College
Football, :YEAR=<br>
Driver error was [2/1062]:<br>
QMYSQL3: Unable to execute statement<br>
Database error was:<br>
Duplicate entry 'EP000009935605' for key 'PRIMARY'<br>
<br>
</div>
<div>When I grep for 'EP000009935605' in the download data,
there are 104 'schedule' tags (many, like yours). There
also 2 'program' tags and 2 'programGenre' tags, where
yours only has one of each. When I download from the old
server, it also has only a single 'program' and
'programGenre' tags with that ID/program.<br>
</div>
</div>
</div>
</div>
</blockquote>
<br>
I think I see how this can happen, although it's pretty rare. I
just submitted a fix, please try again.<br>
<br>
If it doesn't work, please email me or admin@sd your
username/password or tell me it's ok to reset it so I can test it.<br>
<br>
Robert<br>
<br>
</body>
</html>