MySQL patch

[Olivier Salaun <adresse@cachée>]

Hadmut Danisch recently reported a bug with Sympa when used with 
recent versions of MySQL :

The bug report :
http://listes.cru.fr/wws/arc/sympa-dev/2000-10/msg00003.html

Consequences of this bug :
Sympa considers that 100% of subscribers are bouncing

Here is a patch for Sympa 2.7.3 that fixes this problem :
(Also available at
http://listes.cru.fr/sympa/distribution/patch/patch.isnotnull)

You should apply it to the sources (cd sympa-2.7.3/src/ ; patch <
patch.isnotnull)
And then reinstall the whole stuff (make install)

*** List.pm.orig        Mon Oct 16 12:06:48 2000
--- List.pm     Mon Oct 16 12:10:20 2000
***************
*** 1851,1857 ****
        ## "AS" not supported by Oracle
        $statement = sprintf "SELECT email_user \"email\", gecos_user
\"gecos\", reception_subscriber \"reception\", visibility_subscriber
\"visibility\", cookie_delay_user \"cookie_delay\", lang_user \"lang\",
bounce_subscriber \"bounce\", %s \"date\" FROM user_table,
subscriber_table WHERE (list_subscriber = %s AND bounce_subscriber !=
'NULL' AND email_user = user_subscriber )", $date_field,
$dbh->quote($name);
      }else {
!       $statement = sprintf "SELECT email_user AS email, gecos_user AS
gecos, reception_subscriber AS reception, visibility_subscriber AS
visibility, cookie_delay_user AS cookie_delay, lang_user AS lang,
bounce_subscriber AS bounce, %s AS date FROM user_table,
subscriber_table WHERE (list_subscriber = %s AND bounce_subscriber !=
'NULL' AND email_user = user_subscriber )", $date_field,
$dbh->quote($name);
      }
  
      push @sth_stack, $sth;
--- 1851,1857 ----
        ## "AS" not supported by Oracle
        $statement = sprintf "SELECT email_user \"email\", gecos_user
\"gecos\", reception_subscriber \"reception\", visibility_subscriber
\"visibility\", cookie_delay_user \"cookie_delay\", lang_user \"lang\",
bounce_subscriber \"bounce\", %s \"date\" FROM user_table,
subscriber_table WHERE (list_subscriber = %s AND bounce_subscriber !=
'NULL' AND email_user = user_subscriber )", $date_field,
$dbh->quote($name);
      }else {
!       $statement = sprintf "SELECT email_user AS email, gecos_user AS
gecos, reception_subscriber AS reception, visibility_subscriber AS
visibility, cookie_delay_user AS cookie_delay, lang_user AS lang,
bounce_subscriber AS bounce, %s AS date FROM user_table,
subscriber_table WHERE (list_subscriber = %s AND bounce_subscriber IS
NOT NULL AND email_user = user_subscriber )", $date_field,
$dbh->quote($name);
      }
  
      push @sth_stack, $sth;
***************
*** 1910,1916 ****
      }    
      
      ## Query the Database
!     $statement = sprintf "SELECT count(*) FROM subscriber_table WHERE
(list_subscriber = %s  AND bounce_subscriber != 'NULL')",
$dbh->quote($name);
      
      push @sth_stack, $sth;
  
--- 1910,1916 ----
      }    
      
      ## Query the Database
!     $statement = sprintf "SELECT count(*) FROM subscriber_table WHERE
(list_subscriber = %s  AND bounce_subscriber IS NOT NULL)",
$dbh->quote($name);
      
      push @sth_stack, $sth;
  


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