Snapin task exists but doesn't show
Back in this thread http://fogproject.org/forum/threads/host-name-already-exists.12368/we 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.
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.
Is the select the Host Name?
Without Mysql password
mysql -u root fog SELECT * FROM snapinTasks; DELETE FROM snapinTasks WHERE stID='IDfoundneededdeletefrom priorselectstatement';
With mysql password only line changed is the first:
mysql -u root -p fog