{"action":"created","issue":{"url":"https://api.github.com/repos/tbar0970/jethro-pmm/issues/345","repository_url":"https://api.github.com/repos/tbar0970/jethro-pmm","labels_url":"https://api.github.com/repos/tbar0970/jethro-pmm/issues/345/labels{/name}","comments_url":"https://api.github.com/repos/tbar0970/jethro-pmm/issues/345/comments","events_url":"https://api.github.com/repos/tbar0970/jethro-pmm/issues/345/events","html_url":"https://github.com/tbar0970/jethro-pmm/issues/345","id":216609893,"number":345,"title":"Too many custom field options causes errors","user":{"login":"tbar0970","id":2133676,"avatar_url":"https://avatars0.githubusercontent.com/u/2133676?v=4","gravatar_id":"","url":"https://api.github.com/users/tbar0970","html_url":"https://github.com/tbar0970","followers_url":"https://api.github.com/users/tbar0970/followers","following_url":"https://api.github.com/users/tbar0970/following{/other_user}","gists_url":"https://api.github.com/users/tbar0970/gists{/gist_id}","starred_url":"https://api.github.com/users/tbar0970/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tbar0970/subscriptions","organizations_url":"https://api.github.com/users/tbar0970/orgs","repos_url":"https://api.github.com/users/tbar0970/repos","events_url":"https://api.github.com/users/tbar0970/events{/privacy}","received_events_url":"https://api.github.com/users/tbar0970/received_events","type":"User","site_admin":false},"labels":[{"id":93621671,"url":"https://api.github.com/repos/tbar0970/jethro-pmm/labels/bug","name":"bug","color":"000000","default":true},{"id":176716613,"url":"https://api.github.com/repos/tbar0970/jethro-pmm/labels/severity-medium","name":"severity-medium","color":"eb6420","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-03-24T00:18:43Z","updated_at":"2017-08-10T02:11:38Z","closed_at":null,"body":"A system with many options in a custom field triggers the errors below.\r\nIt's because big group_concat of options is getting too long and is being truncated as it comes out of the DB.\r\nProbably need to stop using the group_concat and run a separate query for the options.\r\n\r\n```\r\nUndefined offset: 1 \r\nLine 208 of /home/jethro/code/2.19.2/db_objects/custom_field.class.php\r\n\r\nREQUEST: \r\nArray\r\n(\r\n   [view] => persons__search\r\n   [name] => xyz\r\n)\r\n\r\n\r\nBACKTRACE:\r\nArray\r\n(\r\n   [0] => Array\r\n       (\r\n           [file] => /home/jethro/code/2.19.2/include/system_controller.class.php\r\n           [line] => 209\r\n           [function] => getInstancesData\r\n           [class] => Custom_Field\r\n           [type] => ->\r\n           [args] => Array\r\n               (\r\n                   [0] => [Object/Array]\r\n                   [1] => OR\r\n                   [2] => rank\r\n               )\r\n\r\n       )\r\n\r\n   [1] => Array\r\n       (\r\n           [file] => /home/jethro/code/2.19.2/templates/bulk_actions.template.php\r\n           [line] => 85\r\n           [function] => getDBObjectData\r\n           [class] => System_Controller\r\n           [type] => ->\r\n           [args] => Array\r\n               (\r\n                   [0] => custom_field\r\n                   [1] => [Object/Array]\r\n                   [2] => OR\r\n                   [3] => rank\r\n               )\r\n\r\n       )\r\n\r\n   [2] => Array\r\n       (\r\n           [file] => /home/jethro/code/2.19.2/templates/person_list.template.php\r\n           [line] => 133\r\n           [args] => Array\r\n               (\r\n                   [0] => /home/jethro/code/2.19.2/templates/bulk_actions.template.php\r\n               )\r\n\r\n           [function] => include\r\n       )\r\n\r\n   [3] => Array\r\n       (\r\n           [file] => /home/jethro/code/2.19.2/views/view_3_persons__2_search.class.php\r\n           [line] => 63\r\n           [args] => Array\r\n               (\r\n                   [0] => /home/jethro/code/2.19.2/templates/person_list.template.php\r\n               )\r\n\r\n           [function] => include\r\n       )\r\n\r\n   [4] => Array\r\n       (\r\n           [file] => /home/jethro/code/2.19.2/include/system_controller.class.php\r\n           [line] => 181\r\n           [function] => printView\r\n           [class] => View_Persons__Search\r\n           [type] => ->\r\n           [args] => Array\r\n               (\r\n               )\r\n\r\n       )\r\n\r\n   [5] => Array\r\n       (\r\n           [file] => /home/jethro/code/2.19.2/templates/main.template.php\r\n           [line] => 90\r\n           [function] => printBody\r\n           [class] => System_Controller\r\n           [type] => ->\r\n           [args] => Array\r\n               (\r\n               )\r\n\r\n       )\r\n\r\n   [6] => Array\r\n       (\r\n           [file] => /home/jethro/code/2.19.2/include/system_controller.class.php\r\n           [line] => 129\r\n           [args] => Array\r\n               (\r\n                   [0] => /home/jethro/code/2.19.2/templates/main.template.php\r\n               )\r\n\r\n           [function] => require\r\n       )\r\n\r\n   [7] => Array\r\n       (\r\n           [file] => /home/jethro/code/2.19.2/index.php\r\n           [line] => 58\r\n           [function] => run\r\n           [class] => System_Controller\r\n           [type] => ->\r\n           [args] => Array\r\n               (\r\n               )\r\n\r\n       )\r\n\r\n)\r\n```"},"comment":{"url":"https://api.github.com/repos/tbar0970/jethro-pmm/issues/comments/321430900","html_url":"https://github.com/tbar0970/jethro-pmm/issues/345#issuecomment-321430900","issue_url":"https://api.github.com/repos/tbar0970/jethro-pmm/issues/345","id":321430900,"user":{"login":"tbar0970","id":2133676,"avatar_url":"https://avatars0.githubusercontent.com/u/2133676?v=4","gravatar_id":"","url":"https://api.github.com/users/tbar0970","html_url":"https://github.com/tbar0970","followers_url":"https://api.github.com/users/tbar0970/followers","following_url":"https://api.github.com/users/tbar0970/following{/other_user}","gists_url":"https://api.github.com/users/tbar0970/gists{/gist_id}","starred_url":"https://api.github.com/users/tbar0970/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tbar0970/subscriptions","organizations_url":"https://api.github.com/users/tbar0970/orgs","repos_url":"https://api.github.com/users/tbar0970/repos","events_url":"https://api.github.com/users/tbar0970/events{/privacy}","received_events_url":"https://api.github.com/users/tbar0970/received_events","type":"User","site_admin":false},"created_at":"2017-08-10T02:11:38Z","updated_at":"2017-08-10T02:11:38Z","body":"Recurring."}}
{"actor":{"display_login":"tbar0970"}}