[mythtv-users] user jobs - commercial removal

J jsweepstakes at gmail.com
Sat Aug 9 01:42:23 UTC 2008


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??

[
Query was:
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);
Driver error was [2/1048]:
QMYSQL3: Unable to execute query
Database error was:
Column 'recdir' cannot be null
]

if more output is needed let me know!

thank you!
hope all is well!
-J

> On Aug 8, 2008, at 5:46 PM, J wrote:
>
> > hello,
> > I'm trying to add a commercial removing script to my user jobs.....
> > but I can't figure how to use the parameters..... the script needs
> > [ Usage: /usr/share/comRemove/comRemoveScript <VideoDirectory>
> > <FileName> ] and when I give it %DIR% %FILE% it really gets myth://
> > 192.168.1.50:6543/1038_20080805215900.mpg/1038_20080805215900.mpg am
> > I doing something or are the parameters incorrect that %DIR% gives?
> >
> > script found here:
> http://www.mythtv.org/wiki/index.php/Script_-_RemoveCommercials
> > user jobs page found here:
> http://www.mythtv.org/wiki/index.php/User_Jobs
> >
> > thank you!
> > any other information that people know about using this script would
> > be appreciated......
> >
> > hope all is well,
>
> Do you have your videos on another backend somewhere else? Or maybe
> you have "Always stream files from backend" turned on? In order to use
> a script on remote file, you'll need to NFS mount remote videos to the
> same path on each backend to it can find them locally and turn off the
> "Always stream files from backend" setting so it will look locally for
> the files instead of giving you a network path to them.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20080808/d4083f0b/attachment.htm 


More information about the mythtv-users mailing list