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

Proulx François fproulx at edito.qc.ca
Jeu 1 Déc 01:02:33 EST 2005


I suspect the query was written for Postgresql 7.4 and they changed  
something related to the syntax of intervals in Postgresql 8 .... Our  
live server is running 7.4.7


On 1-Dec-2005, at 0:37 , Benoit Grégoire wrote:

> On November 30, 2005 01:24 pm, Philippe April wrote:
>> 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.........
>
> WOW, I fixed it is CVS, and checked that the change doesn't harm  
> anything.
> However, I simply do not understand why we don't encounter the bug  
> on our
> production server, it just doesn't make sense!  I even ran the  
> query from
> psql on the server, and have the same error Max got.  I registered  
> a new user
> from a real hotspot, everything went fine.
>
> I am stumped.
>
> -- 
> Benoit Grégoire, http://benoitg.coeus.ca/
> _______________________________________________
> WiFiDog mailing list
> WiFiDog at listes.ilesansfil.org
> http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog



More information about the WiFiDog mailing list