{"action":"opened","issue":{"url":"https://api.github.com/repos/inverse-inc/packetfence/issues/1621","repository_url":"https://api.github.com/repos/inverse-inc/packetfence","labels_url":"https://api.github.com/repos/inverse-inc/packetfence/issues/1621/labels{/name}","comments_url":"https://api.github.com/repos/inverse-inc/packetfence/issues/1621/comments","events_url":"https://api.github.com/repos/inverse-inc/packetfence/issues/1621/events","html_url":"https://github.com/inverse-inc/packetfence/issues/1621","id":165614077,"number":1621,"title":"Admin : Ordering nodes by a field that is not in the node table gives an SQL error","user":{"login":"julsemaan","id":3857942,"avatar_url":"https://avatars.githubusercontent.com/u/3857942?v=3","gravatar_id":"","url":"https://api.github.com/users/julsemaan","html_url":"https://github.com/julsemaan","followers_url":"https://api.github.com/users/julsemaan/followers","following_url":"https://api.github.com/users/julsemaan/following{/other_user}","gists_url":"https://api.github.com/users/julsemaan/gists{/gist_id}","starred_url":"https://api.github.com/users/julsemaan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/julsemaan/subscriptions","organizations_url":"https://api.github.com/users/julsemaan/orgs","repos_url":"https://api.github.com/users/julsemaan/repos","events_url":"https://api.github.com/users/julsemaan/events{/privacy}","received_events_url":"https://api.github.com/users/julsemaan/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/inverse-inc/packetfence/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/inverse-inc/packetfence/milestones/20","html_url":"https://github.com/inverse-inc/packetfence/milestones/+1%20(patch%20release)","labels_url":"https://api.github.com/repos/inverse-inc/packetfence/milestones/20/labels","id":1869064,"number":20,"title":"+1 (patch release)","description":"DO NOT DELETE / CLOSE\r\nMETA milestone used to track what should go in the next \"patch\" release (X.X.Y) (in this case, Y is the \"patch\" release)\r\nCan be used to decide whether or not to do a \"patch\" release.\r\n","creator":{"login":"dwlfrth","id":633234,"avatar_url":"https://avatars.githubusercontent.com/u/633234?v=3","gravatar_id":"","url":"https://api.github.com/users/dwlfrth","html_url":"https://github.com/dwlfrth","followers_url":"https://api.github.com/users/dwlfrth/followers","following_url":"https://api.github.com/users/dwlfrth/following{/other_user}","gists_url":"https://api.github.com/users/dwlfrth/gists{/gist_id}","starred_url":"https://api.github.com/users/dwlfrth/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dwlfrth/subscriptions","organizations_url":"https://api.github.com/users/dwlfrth/orgs","repos_url":"https://api.github.com/users/dwlfrth/repos","events_url":"https://api.github.com/users/dwlfrth/events{/privacy}","received_events_url":"https://api.github.com/users/dwlfrth/received_events","type":"User","site_admin":false},"open_issues":4,"closed_issues":2,"state":"open","created_at":"2016-07-07T02:51:35Z","updated_at":"2016-07-14T17:21:46Z","due_on":null,"closed_at":null},"comments":0,"created_at":"2016-07-14T17:21:46Z","updated_at":"2016-07-14T17:21:46Z","closed_at":null,"body":"```\r\nJul 14 13:20:54 httpd.admin(10085) DEBUG: SELECT `node`.`mac`, `node`.`pid`, `node`.`voip`, `node`.`bypass_vlan`, `node`.`status`, `node`.`category_id`, `node`.`bypass_role_id`, `node`.`user_agent`, `node`.`computername`, `node`.`last_arp`, `node`.`last_dhcp`, `node`.`notes`, IF(lastskip = '0000-00-00 00:00:00', '', lastskip) as lastskip, IF(detect_date = '0000-00-00 00:00:00', '', detect_date) as detect_date, IF(regdate = '0000-00-00 00:00:00', '', regdate) as regdate, IF(unregdate = '0000-00-00 00:00:00', '', unregdate) as unregdate, IFNULL(node_category.name, '') as category, IFNULL(node_category_bypass_role.name, '') as bypass_role, IFNULL(device_class, ' ') as dhcp_fingerprint, IF(r1.acctstarttime IS NULL,'unknown',IF(r1.acctstoptime IS NULL, 'on', 'off')) as online, `iplog`.`ip` as last_ip, `locationlog`.`switch` as switch_id, `locationlog`.`switch_ip` as switch_ip_address, `locationlog`.`switch_mac` as switch_mac, `locationlog`.`port` as switch_port FROM `node` LEFT JOIN `node_category` on `node_category`.`category_id` = `node`.`category_id` LEFT JOIN `node_category` as node_category_bypass_role on `node_category_bypass_role`.`category_id` = `node`.`bypass_role_id` LEFT JOIN `iplog` on `iplog`.`ip` = ( SELECT `ip` FROM `iplog` WHERE `mac` = `node`.`mac`\r\n                                        ORDER BY `start_time` DESC LIMIT 1 ) LEFT JOIN `locationlog` on `node`.`mac` = `locationlog`.`mac` AND `locationlog`.`end_time` = '0000-00-00 00:00:00' LEFT JOIN `radacct` as r1 on `node`.`mac` = `r1`.`callingstationid` LEFT JOIN `radacct` as r2 on `node`.`mac` = `r2`.`callingstationid` AND ( `r1`.`acctstarttime` < `r2`.`acctstarttime` OR ( `r1`.`acctstarttime` = `r2`.`acctstarttime` AND `r1`.`radacctid` < `r2`.`radacctid` ) ) WHERE `r2`.`radacctid` IS NULL   ORDER BY `node`.`last_ssid` ASC LIMIT 0 , 26 (pf::node::node_custom_search)\r\nJul 14 13:20:54 httpd.admin(10085) DEBUG: statement provided is a SQL string, preparing statement... (pf::db::db_query_execute)\r\nJul 14 13:20:54 httpd.admin(10085) INFO: database query failed with: Unknown column 'node.last_ssid' in 'order clause' (errno: 1054) (pf::db::db_query_execute)\r\n```"}}
{"actor":{"display_login":"julsemaan"}}