<div dir="ltr"><div>ok.... so I fixed that by putting the script on the master backend also (but it still ran on a remote backend...... thats REALLY cool [how does that work]) anyway.... it doesn't like the query in the middle.... I have no idea about the structure of the database, how can i fix the query??<br>
<br>[<br>Query was:<br>INSERT INTO inuseprograms (chanid, starttime, recusage, hostname, lastupdatetime, rechost, recdir ) VALUES ('1015', '2008-08-08T21:30:00', 'flagger', 'mythbox1-LR', '2008-08-08T21:36:15', 'mythmasterb', NULL);<br>
Driver error was [2/1048]:<br>QMYSQL3: Unable to execute query<br>Database error was:<br>Column 'recdir' cannot be null<br>]<br><br>if more output is needed let me know!<br><br>thank you!<br>hope all is well!<br>-J <br>
</div><blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote"><div id=":kv" class="ArwC7c ckChnd">On Aug 8, 2008, at 5:46 PM, J wrote:<br>
<br>
> hello,<br>
> I'm trying to add a commercial removing script to my user jobs.....<br>
> but I can't figure how to use the parameters..... the script needs<br>
> [ Usage: /usr/share/comRemove/comRemoveScript <VideoDirectory><br>
> <FileName> ] and when I give it %DIR% %FILE% it really gets myth://<br>
> <a href="http://192.168.1.50:6543/1038_20080805215900.mpg/1038_20080805215900.mpg" target="_blank">192.168.1.50:6543/1038_20080805215900.mpg/1038_20080805215900.mpg</a> am<br>
> I doing something or are the parameters incorrect that %DIR% gives?<br>
><br>
> script found here: <a href="http://www.mythtv.org/wiki/index.php/Script_-_RemoveCommercials" target="_blank">http://www.mythtv.org/wiki/index.php/Script_-_RemoveCommercials</a><br>
> user jobs page found here: <a href="http://www.mythtv.org/wiki/index.php/User_Jobs" target="_blank">http://www.mythtv.org/wiki/index.php/User_Jobs</a><br>
><br>
> thank you!<br>
> any other information that people know about using this script would<br>
> be appreciated......<br>
><br>
> hope all is well,<br>
<br>
Do you have your videos on another backend somewhere else? Or maybe<br>
you have "Always stream files from backend" turned on? In order to use<br>
a script on remote file, you'll need to NFS mount remote videos to the<br>
same path on each backend to it can find them locally and turn off the<br>
"Always stream files from backend" setting so it will look locally for<br>
the files instead of giving you a network path to them.</div></blockquote></div>