The mailing list for listmasters using Sympa

[David Verdin <address@concealed>]

Yes. Looking at the PostgreSQL database ( 
http://www.postgresql.org/docs/8.3/interactive/datatype-numeric.html ) 
int4 is too small. We moved this setting to int8 (also named bigint). It 
should work with the patch linked below:

http://sourcesup.cru.fr/viewvc/viewvc/trunk/src/etc/script/create_db.Pg?r1=4829&r2=4828&pathrev=4829

Regards,

Ståle Kristoffersen a écrit :
> Hi, we tried to upgrade our test-install to the new beta, the upgrade
> failed so now we are trying to install the new version from scratch.
>
> The error we are stuck on now is this:
> Feb  5 15:13:55 sunda wwsympa[1302]: SympaSession::store() Unable to update
> session information in database while execute SQL statement "INSERT INTO
> session_table (id_session, date_session, remote_addr_session,
> robot_session, email_session, start_date_session, hit_session,
> data_session) VALUES
> ('4273810882781','1202220835','129.240.6.251','sympa-test1.uio.no','nobody','1202220835','1',';data=""')"
> : ERROR:  value "4273810882781" is out of range for type integer  
>
> Should perhaps the id_session be something else than int4 in Pg or is
> something else amiss?
>
>   

--
David Verdin
Comité réseau des universités