[mythtv-users] Requeue All Shows Not Commflagged?

[Thomas Boehm]

Drew Tomlinson wrote:
> After upgrading from 0.24 to 0.26, all my commflag jobs exited on error
> 140.  After learning that it was because of the commflag command and
> fixing that in the general setup, I wanted to commflag all the
> recordings that had erred.  With some reading and fiddling, I came up
> with this:
> 
> mysql mythconverg -umythtv -pmythtv < ~/commflag.sql | sed '1d;
> s/-//g;s/://g' | awk '{print "/usr/bin/mythcommflag --queue --chanid",
> $1, "--starttime",$2$3}'
> 
> Commflag.sql contains:
> SELECT chanid, starttime FROM `mythconverg`.`recorded`where commflagged
> <> 1;
> 
> Which prints this:
> 
> /usr/bin/mythcommflag --queue --chanid 2581 --starttime 20130513045900
> /usr/bin/mythcommflag --queue --chanid 1278 --starttime 20130513045900
> /usr/bin/mythcommflag --queue --chanid 3031 --starttime 20130509045900

Why don't you write that output into a file instead of stout, make it
executable and run it?