[PacketFence-users] CLI /usr/local/pf/bin/pfcmd node view all output

[Dmitry A. A. <DAA...@Gr...>]

Hello.
Cli command
/usr/local/pf/bin/pfcmd node view all
Outputs nothing, except table header.
In usr/local/pf/logs/packetfence.log appears error:
Feb  4 12:08:41 core-s-pf01 packetfence: ERROR pfcmd.pl(12612): Database query failed with non retryable error: Unknown column 'locationlog' in 'on clause' (errno: 1054) [SELECT `node`.`mac`, `node`.`pid`, `node`.`voip`, `node`.`bypass_vlan`, `node`.`status`, IF(ISNULL(nc.name), '', nc.name) as category, IF(ISNULL(nr.name), '', nr.name) as bypass_role, IF(node.detect_date = '0000-00-00 00:00:00', '', node.detect_date) as detect_date, IF(node.regdate = '0000-00-00 00:00:00', '', node.regdate) as regdate, IF(node.unregdate = '0000-00-00 00:00:00', '', node.unregdate) as unregdate, IF(node.lastskip = '0000-00-00 00:00:00', '', node.lastskip) as lastskip, `node`.`user_agent`, `node`.`computername`, `device_class` AS `dhcp_fingerprint`, `node`.`last_arp`, `node`.`last_dhcp`, `node`.`last_seen`, `locationlog`.`switch` AS `last_switch`, `locationlog`.`port` AS `last_port`, `locationlog`.`vlan` AS `last_vlan`, IF(ISNULL(locationlog.connection_type), '', locationlog.connection_type) as last_connection_type, `locationlog`.`dot1x_username` AS `last_dot1x_username`, `locationlog`.`ssid` AS `last_ssid`, `locationlog`.`stripped_user_name` AS `stripped_user_name`, `locationlog`.`realm` AS `realm`, `locationlog`.`switch_mac` AS `last_switch_mac`, `ip4log`.`ip` AS `last_ip`, COUNT(DISTINCT security_event.id) as nbopensecurity_events, `node`.`notes` FROM node LEFT OUTER JOIN `node_category` AS `nr` ON ( `nr`.`category_id` = `node`.`bypass_role_id` ) LEFT OUTER JOIN `node_category` AS `nc` ON ( `node`.`category_id` = `nc`.`category_id` ) LEFT OUTER JOIN security_event ON ( ( `security_event`.`status` = ? AND `node`.`mac` = `security_event`.`mac` ) ) LEFT OUTER JOIN locationlog ON ( ( `locationlog` = ? AND `node`.`mac` = `locationlog`.`mac` ) ) LEFT OUTER JOIN ip4log ON ( ( ( `ip4log` = ? OR `ip4log` > NOW() ) AND `node`.`mac` = `ip4log`.`mac` ) ) WHERE ( `node`.`tenant_id` = ? ) GROUP BY `node`.`mac`]{open, 0000-00-00 00:00:00, 0000-00-00 00:00:00, 1} (pf::dal::db_execute)



If I add mac
/usr/local/pf/bin/pfcmd node view 14:9d:09:17:f2:1e
Cli Outputs proper result.

How to fix it?