[isf-wifidog] Bug in statistics

[Max Horváth]

Hi,

just another bug: I opened user statistics, entered "user" as  
username for the stats and selected "user report" and "connection log".

Following SQL errors occured:
ExecSql() : An error occured while executing the following SQL query :
SELECT connections.user_id, count(distinct connections.user_mac) as  
nb_mac, COUNT(DISTINCT connections.user_id) AS nb_users,  
username,count(connections.user_id) as nb_cx,max(timestamp_in) as  
last_seen 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 = 'maxspot')  
AND (user_id = '3bfedcbf68a6b77b58f2ce3ad91aa813') GROUP BY  
connections.user_id,username ORDER BY nb_cx desc,username

Error message :
ERROR: column reference "user_id" is ambiguous

ExecSql() : An error occured while executing the following SQL query :
SELECT users.username, nodes.name, EXTRACT('EPOCH' FROM date_trunc 
('second',timestamp_out-timestamp_in)) AS time_spent, EXTRACT('EPOCH'  
FROM timestamp_in) AS timestamp_in, connections.user_id, user_mac  
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 = 'maxspot') AND (user_id =  
'3bfedcbf68a6b77b58f2ce3ad91aa813') ORDER BY timestamp_in DESC

Error message :
ERROR: column reference "user_id" is ambiguous

Cheers, Max!