{"action":"created","issue":{"url":"https://api.github.com/repos/MISP/MISP/issues/1180","repository_url":"https://api.github.com/repos/MISP/MISP","labels_url":"https://api.github.com/repos/MISP/MISP/issues/1180/labels{/name}","comments_url":"https://api.github.com/repos/MISP/MISP/issues/1180/comments","events_url":"https://api.github.com/repos/MISP/MISP/issues/1180/events","html_url":"https://github.com/MISP/MISP/issues/1180","id":157077614,"number":1180,"title":"Error When Scheduling Tasks","user":{"login":"I-am-Sherlocked","id":10660968,"avatar_url":"https://avatars.githubusercontent.com/u/10660968?v=3","gravatar_id":"","url":"https://api.github.com/users/I-am-Sherlocked","html_url":"https://github.com/I-am-Sherlocked","followers_url":"https://api.github.com/users/I-am-Sherlocked/followers","following_url":"https://api.github.com/users/I-am-Sherlocked/following{/other_user}","gists_url":"https://api.github.com/users/I-am-Sherlocked/gists{/gist_id}","starred_url":"https://api.github.com/users/I-am-Sherlocked/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/I-am-Sherlocked/subscriptions","organizations_url":"https://api.github.com/users/I-am-Sherlocked/orgs","repos_url":"https://api.github.com/users/I-am-Sherlocked/repos","events_url":"https://api.github.com/users/I-am-Sherlocked/events{/privacy}","received_events_url":"https://api.github.com/users/I-am-Sherlocked/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-05-26T20:57:53Z","updated_at":"2016-05-27T16:09:57Z","closed_at":null,"body":"As explained before in #1123 , task scheduling is currently throwing \r\n\r\n>Error: [PDOException] SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_id' at row 1\r\nRequest URL: /tasks/setTask\r\n\r\nSince the process_id returned by CakeResque.php is a hex string, but TasksController.php is trying to save it as the job_id field in tasks, which is an int.\r\nThe actual jobs (scheduled for each server) are created in ServerShell.php. That field save either needs to be dropped, or a separate job needs to be created for that process_id, and the job_id be put in the task.\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/MISP/MISP/issues/comments/222187825","html_url":"https://github.com/MISP/MISP/issues/1180#issuecomment-222187825","issue_url":"https://api.github.com/repos/MISP/MISP/issues/1180","id":222187825,"user":{"login":"sfossen","id":26934,"avatar_url":"https://avatars.githubusercontent.com/u/26934?v=3","gravatar_id":"","url":"https://api.github.com/users/sfossen","html_url":"https://github.com/sfossen","followers_url":"https://api.github.com/users/sfossen/followers","following_url":"https://api.github.com/users/sfossen/following{/other_user}","gists_url":"https://api.github.com/users/sfossen/gists{/gist_id}","starred_url":"https://api.github.com/users/sfossen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sfossen/subscriptions","organizations_url":"https://api.github.com/users/sfossen/orgs","repos_url":"https://api.github.com/users/sfossen/repos","events_url":"https://api.github.com/users/sfossen/events{/privacy}","received_events_url":"https://api.github.com/users/sfossen/received_events","type":"User","site_admin":false},"created_at":"2016-05-27T16:09:57Z","updated_at":"2016-05-27T16:09:57Z","body":"PDO error\r\nSQLSTATE[HY000]: General error: 1366 Incorrect integer value: 'ee345b7c8fb9cfeee43cfa561c672c5e' for column 'job_id' at row 1\r\nError: An Internal Error Has Occurred.\r\n\r\nStack Trace\r\n\r\nAPP/Lib/cakephp/lib/Cake/Model/Datasource/DboSource.php line 461 → PDOStatement->execute(array)\r\nAPP/Lib/cakephp/lib/Cake/Model/Datasource/DboSource.php line 427 → DboSource->_execute(string, array)\r\nAPP/Lib/cakephp/lib/Cake/Model/Datasource/Database/Mysql.php line 415 → DboSource->execute(string)\r\nAPP/Lib/cakephp/lib/Cake/Model/Model.php line 1917 → Mysql->update(Task, array, array)\r\nAPP/Lib/cakephp/lib/Cake/Model/Model.php line 1751 → Model->_doSave(array, array)\r\nAPP/Lib/cakephp/lib/Cake/Model/Model.php line 1703 → Model->save(array, array)\r\nAPP/Controller/TasksController.php line 120 → Model->saveField(string, string)\r\nAPP/Controller/TasksController.php line 85 → TasksController->_pullScheduler(integer, string)\r\nAPP/Controller/TasksController.php line 70 → TasksController->_jobScheduler(string, integer, string)\r\n[internal function] → TasksController->setTask()\r\nAPP/Lib/cakephp/lib/Cake/Controller/Controller.php line 491 → ReflectionMethod->invokeArgs(TasksController, array)\r\nAPP/Lib/cakephp/lib/Cake/Routing/Dispatcher.php line 193 → Controller->invokeAction(CakeRequest)\r\nAPP/Lib/cakephp/lib/Cake/Routing/Dispatcher.php line 167 → Dispatcher->_invoke(TasksController, CakeRequest)\r\nAPP/webroot/index.php line 92 → Dispatcher->dispatch(CakeRequest, CakeResponse)"}}
{"actor":{"display_login":"sfossen"}}