Ticket #271 (closed Bug report: fixed)
Distinguish by mac adress seem broken
Reported by: | pascal.charest@… | Owned by: | |
---|---|---|---|
Priority: | low | Milestone: | |
Component: | Auth server, Other | Version: | |
Keywords: | Cc: |
Description
On ISF-Auth server: log as an administrator, go in statistics, use "distinguish by mac adresse"
little bug 01: it doesn't change automatically "restrict stats to the following user" to "restrict stats to the following mac"... you must do a "blank request first". (Under Flock 0.7.7 (firefox 1.5.0.7)).
BUG: if you ask for an "individual server report" you get (I did obscure the mac in the following error:
**********
execSql() : An error occured while executing the following SQL query : SELECT * FROM connections JOIN nodes ON (connections.node_id = nodes.node_id) JOIN users ON (connections.user_id = users.user_id) WHERE (incoming!=0 OR outgoing!=0) AND (nodes.network_id = 'LOCAL_USER') AND (users.user_mac = 'XX:XX:XX:XX:XX:XX') ORDER BY timestamp_in DESC
Error message : ERROR: column users.user_mac does not exist
execSql() : An error occured while executing the following SQL query : SELECT connections.user_id,username, count(connections.user_id) as nb FROM connections JOIN nodes ON (connections.node_id = nodes.node_id) JOIN users ON (connections.user_id = users.user_id) WHERE (incoming!=0 OR outgoing!=0) AND (nodes.network_id = 'LOCAL_USER') AND (users.user_mac = 'XX:XX:XX:XX:XX:XX') group by connections.user_id, username order by nb desc, connections.user_id,username
Error message : ERROR: column users.user_mac does not exist
**********
Similar error for all reports (with date include or left-out).