Developers of Sympa

[Antonio Sevilla Rodriguez <address@concealed>]

I detected a problem in the archive List.pm in sympa 5.4.3

In the file List.pm there is a wrong query that prevents removing a list 
of subscribers when the database is oracle.

Missing quotes before FROM.

The correct judgement is as follows:

$statement = sprintf "SELECT user_subscriber \"email\", 
comment_subscriber \"gecos\", reception_subscriber \"reception\", 
topics_subscriber \"topics\", visibility_subscriber \"visibility\", 
bounce_subscriber \"bounce\", bounce_score_subscriber \"bounce_score\", 
bounce_address_subscriber \"bounce_address\", %s \"date\", %s 
\"update_date\", subscribed_subscriber \"subscribed\", 
included_subscriber \"included\", include_sources_subscriber \"id\", 
custom_attribute_subscriber \"custom_attribute\*"* %s FROM 
subscriber_table WHERE (list_subscriber = %s AND robot_subscriber = %s %s)",

       $date_field,

       $update_field,

       $additional,

       $dbh->quote($name),

       $dbh->quote($self->{'domain'}),

       $selection;