Skip to Content.
Sympa Menu

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

Subject: The mailing list for listmasters using Sympa

List archive

Chronological Thread  
  • From: Olivier Salaün - CRU <address@concealed>
  • To: Marco Gaiarin <address@concealed>
  • Cc: address@concealed
  • Subject: Re: [sympa-users] Postgres problem...
  • Date: Wed, 19 Oct 2005 10:45:09 +0200

This was an integer vs float bug in task_manager.pl but it was fixed back in august 2004.
I'd recommend you upgrade to the latest release : sympa 5.1

Marco Gaiarin wrote:

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?



Attachment: smime.p7s
Description: S/MIME Cryptographic Signature




Archive powered by MHonArc 2.6.19+.

Top of Page