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

[Max Horváth]

Yeah, this fixed the bug - thanks.

I also commited the bugfix to the CVS, so you don't have to do that.

Cheers, Max!

Am 06.12.2005 um 01:19 schrieb 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
>
> _______________________________________________
> WiFiDog mailing list
> WiFiDog at listes.ilesansfil.org
> http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog
>