Skip to Content.
Sympa Menu

en - [sympa-users] Postgres problem...

Subject: The mailing list for listmasters using Sympa

List archive

Chronological Thread  
  • From: Marco Gaiarin <address@concealed>
  • To: address@concealed
  • Subject: [sympa-users] Postgres problem...
  • Date: Tue, 18 Oct 2005 18:27:52 +0200


I've upgraded my sympa installation uprgading a woody box to sarge (so
from sympa 3.X to 4.1).

I've updated my database schema too, using:

/usr/share/doc/sympa/examples/db/create_db.Pg

as reference.


But i got:

Oct 18 11:06:40 rita task_manager[15770]: Unable to execute SQL
statement "UPDATE subscriber_table SET
bounce_score_subscriber='174.649350649351' WHERE
(user_subscriber='some@email' AND list_subscriber='ac-sg')" : ERROR: invalid
input syntax for integer: "174.649350649351"

on shema definition i have:

bounce_score_subscriber int4,

I've put to float or some other type?

--
dott. Marco Gaiarin GNUPG Key ID: 240A3D66
Associazione ``La Nostra Famiglia'' http://www.sv.lnf.it/
Polo FVG - Via della Bontà, 7 - 33078 - San Vito al Tagliamento (PN)
gaio(at)sv.lnf.it tel +39-0434-842711 fax +39-0434-842797

Grazie parlamento europeo!
http://punto-informatico.it/p.asp?i=53925&r=PI



Archive powered by MHonArc 2.6.19+.

Top of Page