mysql To Delete A Recording From the Job Queue

[jamoody]

I have 2 recordings in the job queue (commercial flagging) which show in the frontend System Status but never move off Queued. I tried deleting them via the panel but they just won't delete. The recordings are valid.

What is the mysql command to display and then delete specific items from the job queue? Thanks.

[daraden]

Code: Select all

mysql -u mythtv -p mythconverg -e "SELECT * from jobqueue WHERE type=2"

will give you a list of commercial flagging jobs in the job queue. If you remove the WHERE type=2 it will list all entries in the job queue.

After you find the offending entries use

Code: Select all

mysql -u mythtv -p mythconverg -e "DELETE from jobqueue WHERE id=<IdNumber>"

you could use WHERE chanid=<chanid> starttime=<starttime>, but that would also remove any other jobs you have for that recording.

If you have more than a couple you may want to log into mysql to avoid typing the password every time.

[jamoody]

Thanks for the help.