[isf-wifidog] Bug in statistics

[Proulx François]

Sounds like a pretty simple bug fix. simply add the add the reference  
to the table containning the user_id field


> .... AND (nodes.network_id = 'maxspot') AND (user_id = '3bfedc ....


On 16-Dec-2005, at 16:19 , Max Horváth wrote:

> 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 outgoc6b77b58f2ce3ad91aa813') 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!
> _______________________________________________
> WiFiDog mailing list
> WiFiDog at listes.ilesansfil.org
> http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog