Snapin task exists but doesn't show

[Joseph Hales]

Back in this thread <[url]http://fogproject.org/forum/threads/host-name-already-exists.12368/>we[/url] removed a bad record from the database manually I need some advice for a complete sql noob on how to open the correct database for active tasks select the record and delete it. OS is ubuntu 12.04 SVN 3084.

[Tom Elliott]

Without Mysql password
[code]mysql -u root fog
SELECT * FROM snapinTasks;
DELETE FROM snapinTasks WHERE stID=‘IDfoundneededdeletefrom priorselectstatement’;[/code]

With mysql password only line changed is the first:
[code]mysql -u root -p fog[/code]

[Joseph Hales]

Is the select the Host Name?

[Joseph Hales]

Ok waited till everyone was done imaging today and ran it and no change so I went back to the forums and truncate table snapinJobs; truncate table snapinTasks; which solved the issue.