Developers of Sympa

[Hadmut Danisch <address@concealed>]

Hi,

I just found a SQL bug in sympa 2.6.1 (and also seems to be
in sympa 2.7.3):

To calculate the bounce rate is calls an SQL expression:

select count(*) from subscriber_table where (list_subscriber="news"
AND bounce_subscriber != 'NULL'); 


which gives a wrong result with the current version of mysql, since
comparing a NULL value with the != operator is always true.

It must be

...  bounce_subscriber is not NULL


regards
Hadmut