James the Watchman Tasks Not working

[volek_the_fn_dwarf]

I also encountered this issue with James. Though I also had to enable his spawn as by default he was turned off.

UPDATE spawn2 SET enabled = 1, animation = 1 wHERE id = 148628;

I had a more complex query also, though yours is for sure simpler

UPDATE task_activities SET delivertonpc = 202390
WHERE delivertonpc != 0 AND activitytype = 1 AND taskid IN ( SELECt * FROM (
	SELECT ta.taskid
	FROM tasks t
	JOIN task_activities ta ON(t.id = ta.taskid)
	WHERE t.title LIKE '%repair my watch%'
) as RepairTasks);