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.
mysql To Delete A Recording From the Job Queue
Moderator: Forum Moderators
Re: mysql To Delete A Recording From the Job Queue
Code: Select all
mysql -u mythtv -p mythconverg -e "SELECT * from jobqueue WHERE type=2"
After you find the offending entries use
Code: Select all
mysql -u mythtv -p mythconverg -e "DELETE from jobqueue WHERE id=<IdNumber>"
If you have more than a couple you may want to log into mysql to avoid typing the password every time.
Re: mysql To Delete A Recording From the Job Queue
Thanks for the help.