Developers of Sympa

[Olivier Salaun <address@concealed>]

Hadmut Danisch wrote:

> 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

Both solutions were working with our version of MySQL (3.22.25).
I patched the development version of Sympa.

Thanks

--
Olivier Salaün
Comité Réseaux des Universités