Ticket #271 (closed Bug report: fixed)

Opened 14 years ago

Last modified 14 years ago

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).

Change History

Changed 14 years ago by benoitg

Ok, I fixed the breakage in my local copy, should be comited in the next few days.

Changed 14 years ago by benoitg

  • status changed from new to closed
  • resolution set to fixed

Forgot to close, I don't know when this was committed, but it was.

Note: See TracTickets for help on using tickets.