<br><div class="gmail_quote"><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div><div class="h5">
><br>
><br>
> > > 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<br>
> files<br>
> > are sitting in the right place on my system. The inetref is still<br>
> all<br>
> > 0's though. If I run in maintenance mode after that (after -I or<br>
> -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<br>
> 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>
> I was thinking about this.... Could you set the inetref number to<br>
> NULL?<br>
> That's what the db defaults that field too. Then try again with the<br>
> 'R'<br>
> option and see what happens.<br>
><br>
><br>
><br>
><br>
> Hmm, that is wierd. According to mysql the default value for inetref<br>
> IS NULL, but immediately following a mythvideo rescan (delete all<br>
> entries from videometadata and rescan upon entering mythvideo) it is<br>
> 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<br>
> updated, only now it's still NULL instead of all 0's)<br>
><br>
><br>
><br>
<br>
</div></div>While from reading your messages this seems unlikely, but I figured I would<br>
ask just to make sure... You are editing the database with the same user<br>
that is running Jamu? Or stated another way, all users who interact with<br>
the database have write access to it..<br>
<div class="im"><br></div></blockquote></div><br>Correct. I run jamu as part of a cron job as user mythtv. As user mythtv I can use mysql to modify the inetref manually. I run mythfrontend as user perveil. I can also update the inetref manually via mysql as this user. Running jamu as user perveil has the same results as running as user mythtv (ie inetref isn't updated).<br>
<br>Basically, both users can modify the fields using mysql, neither user can modify the fields using jamu.<br><br>