The mailing list for listmasters using Sympa

[Riccardo Veraldi <address@concealed>]

Hello, I write because of my problem after sympa update to 5.2.4 on 
FreeBSD starting from 5.2.2


/usr/local/lib/sympa/List.pm

@ line 10761

       foreach my $t1 (keys %{$db_struct{'mysql'}}) {
           my $found;
           foreach my $t2 (@tables) {
               $found = 1 if ($t1 eq $t2);
           }
           unless ($found) {
               unless ($dbh->do("CREATE TABLE $t1 (temporary INT)")) {
                   &do_log('err', 'Could not create table %s in 
database %s : %s', $t1, $Conf{'db_name'}, $dbh->errstr
);
                   next;
               }

it creates table and I do not understand WHY ??
tables are in the sympa database they are created.
The same thing happens if I REinstall hte new version of sympa from scratch.
after I create the database with create_db.mysql with the sympa schema
sympa.pl complains with these errors:

Starting module sympa.pl: DBD::mysql::db do failed: Table 'admin_table' 
already exists at /usr/local/lib/sympa/List.pm line 10767.
DBD::mysql::db do failed: Table 'user_table' already exists at 
/usr/local/lib/sympa/List.pm line 10767.
DBD::mysql::db do failed: Table 'subscriber_table' already exists at 
/usr/local/lib/sympa/List.pm line 10767.
DBD::mysql::db do failed: Table 'netidmap_table' already exists at 
/usr/local/lib/sympa/List.pm line 10767.
DBD::mysql::st execute failed: You have an error in your SQL syntax; 
check the manual that corresponds to your MySQL server version for the 
right syntax to use near '.`admin_table' at line 1 at 
/usr/local/lib/sympa/List.pm line 10789.
Database sympa defined in sympa.conf has not the right structure or is 
unreachable. If you don't use any database, comment db_xxx parameters in 
sympa.conf


I can't get out of this...


Riccardo