Skip to Content.
Sympa Menu

en - Re: [sympa-users] Sympa 5.0b + postgres bug

Subject: The mailing list for listmasters using Sympa

List archive

Chronological Thread  
  • From: Olivier Salaün - CRU <address@concealed>
  • To: Hargitai Gábor <address@concealed>
  • Cc: address@concealed
  • Subject: Re: [sympa-users] Sympa 5.0b + postgres bug
  • Date: Fri, 07 Jan 2005 15:52:10 +0100

There might be the same problems with Oracle.
I've fixed this in the CVS tree :
http://sourcesup.cru.fr/cgi/viewcvs.cgi/sympa/src/List.pm.diff?r1=1.512&r2=1.513&cvsroot=sympa

Thank you.

Hargitai Gábor wrote:

I found a bug in 5.0b:
in List.pm in Line 9210
my $statement = "UPDATE subscriber_table SET subscribed_subscriber='1' WHERE
((included_subscriber IS NULL || included_subscriber!='1') && (subscribed_subscriber IS
NULL || subscribed_subscriber!='1'))";

the || and && operators aren't supported by postgresql. Replacing them with
OR and AND works fine.

--
Olivier Salaün
Comité Réseau des Universités
-------------------------------------------
Validation signature / Trusting signature: --> http://igc.cru.fr/trust.html
-------------------------------------------

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




Archive powered by MHonArc 2.6.19+.

Top of Page