[isf-wifidog] Bug report: access statistics for node owners

[Proulx François]

If you have time to change it, it's just a matter of adding   nodes  
in front of node_id
As in :

SELECT nodes.node_id, nodes.name from nodes JOIN ....

It should be fine that way


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

> When logged in as a node owner and clicking "Get access statistics"  
> on the "edit node"-page I'll get a SQL-error on the "report  
> configuration"-page:
>
> ExecSql() : An error occured while executing the following SQL query :
> SELECT node_id, name from nodes JOIN node_stakeholders ON  
> (nodes.node_id=node_stakeholders.node_id AND  
> user_id='a3e97e6efc415d5b3080313e507806c7') WHERE 1=1 ORDER BY node_id
>
> Error message :
> ERROR: column reference "node_id" is ambiguous
>
> Cheers, Max!
> _______________________________________________
> WiFiDog mailing list
> WiFiDog at listes.ilesansfil.org
> http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog