Skip to Content.
Sympa Menu

devel - MySQL patch

Subject: Developers of Sympa

List archive

Chronological Thread  
  • From: Olivier Salaun <address@concealed>
  • To: address@concealed, address@concealed, address@concealed
  • Subject: MySQL patch
  • Date: Mon, 16 Oct 2000 12:22:23 +0200

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



Archive powered by MHonArc 2.6.19+.

Top of Page