Subject: The mailing list for listmasters using Sympa
List archive
- 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
-
[sympa-users] Sympa 5.0b + postgres bug,
Hargitai Gábor, 01/07/2005
- Re: [sympa-users] Sympa 5.0b + postgres bug, Olivier Salaün - CRU, 01/07/2005
Archive powered by MHonArc 2.6.19+.