<br><br><div class="gmail_quote">On Tue, Jun 1, 2010 at 8:06 AM, Nasa <span dir="ltr"><<a href="mailto:nasa01@comcast.net">nasa01@comcast.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div class="im"><br>
----- "Jack Perveiler" <<a href="mailto:perveilerj@gmail.com">perveilerj@gmail.com</a>> wrote:<br>
<br>
</div><div><div></div><div class="h5">> > But if I run the same command again<br>
><br>
> Here's what I noted as a problem. The 'R' option updates only the<br>
> reference number -- it doesn't download anything. The next<br>
> run should have been without the 'R'.<br>
><br>
><br>
><br>
><br>
> Yeah, I thought of that too. Oddly, if I run with -I (interactive)<br>
> instead of -R I get prompted for the missing entries like with -R<br>
> except it also pulls the fanart, etc from <a href="http://themoviedb.org" target="_blank">themoviedb.org</a> . The files<br>
> are sitting in the right place on my system. The inetref is still all<br>
> 0's though. If I run in maintenance mode after that (after -I or -R,<br>
> doesn't matter) I get a message telling me that X-Men has no inetref<br>
> so it won't fetch anything.<br>
> <br>
><br>
><br>
> > I get the same prompting for X-Men<br>
> > again. Thinking this was odd, I checked the database after the run:<br>
> ><br>
> > mysql> select title,inetref from videometadata where title like<br>
> > "X-Men";<br>
> > +-------+----------+<br>
> > | title | inetref |<br>
> > +-------+----------+<br>
> > | X-Men | 00000000 |<br>
> > +-------+----------+<br>
> ><br>
><br>
> Yeah, This seems odd. Jamu shouldn't have done anything, as file<br>
> was already in database with a inetref number.<br>
><br>
><br>
<br>
</div></div>I was thinking about this.... Could you set the inetref number to NULL?<br>
That's what the db defaults that field too. Then try again with the 'R'<br>
option and see what happens.<br>
<div class="im"><br></div></blockquote><div><br>Hmm, that is wierd. According to mysql the default value for inetref IS NULL, but immediately following a mythvideo rescan (delete all entries from videometadata and rescan upon entering mythvideo) it is populated with the 8 0's. If I jam in NULL instead with:<br>
<br>mysql> update videometadata set inetref=NULL where title="X-Men";<br>Query OK, 1 row affected, 1 warning (0.00 sec)<br>Rows matched: 1 Changed: 1 Warnings: 1<br><br>mysql> select title,inetref from videometadata where title = "X-Men";<br>
+-------+---------+<br>| title | inetref |<br>+-------+---------+<br>| X-Men | | <br>+-------+---------+<br><br><br>and then run jamu with -r again I get the same results (ie inetref not updated, only now it's still NULL instead of all 0's)<br>
<br></div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div class="im">
<br>
><br>
><br>
><br>
> Well, at least the file SHOULD have been in the database with an<br>
> inetref number :)<br>
<br>
</div>The file is in the DB with an inetref number... But is 00000000 a valid<br>
inetref number?<br>
<div><div></div><div class="h5"><br></div></div></blockquote><div><br>Couldn't tell you if it's a valid one, but it's what mythvideo put there following it's scan.<br></div></div><br>--Jack<br>