[isf-wifidog] URGENT: SQL error when a new user signs up

[Philippe April]

It looks like it's the "isUserValid()" method from User, but I can't  
replicate the issue here.

Signing up and validation all works here... but the SQL query you  
gave doesn't work on our database either.

So either the code doesn't get run on our end at creation, or.........

I'll try to figure out more informations.

Philippe April
GnuPG http://key.philippeapril.com

On 30-Nov-05, at 11:11 AM, Max Horváth wrote:

> Hi folks,
>
> this one is urgent! When a new user signs up at maxspot, he'll see  
> this error message twice:
>
> ExecSqlUniqueRes() : An error occured while executing the following  
> SQL query :
> SELECT CASE WHEN ((NOW() - reg_date) > interval  
> networks.validation_grace_time) THEN true ELSE false END AS  
> validation_grace_time_expired, networks.validation_grace_time FROM  
> users JOIN networks ON (users.account_origin = networks.network_id)  
> WHERE (user_id='8470778cac0e5c66475aa571d7ded30b')
>
> Error message :
> ERROR: syntax error at or near "networks" at character 49
>
> Anyone knows what went wrong?
>
> Thanks and cheers, Max!
>
> _______________________________________________
> WiFiDog mailing list
> WiFiDog at listes.ilesansfil.org
> http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog