Archive for the ‘sympa’ Category

Sympa 4.1.2 and MySQL 5.0.XX

Friday, January 12th, 2007

Upgrading MySQL server to version 5.0.XX brought the following errors while starting Sympa 4.1.2 under FreeBSD 6.2

Could not create table %s in database %s : user_table
Could not create table %s in database %s : subscriber_table
Table user_table not found in database sympa

The fix was found here http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=418836.

Edit /usr/local/sympa/bin/List.pm and look for probe_db. Replace

foreach my $t (@tables) {
$t =~ s/^\\`(.+)\\`$/\1/;
}

with

foreach my $t (@tables) {
$t =~ s/^([^.]+\\.)?(.+)$/\2/;
$t =~ s/^\\`(.+)\\`$/\1/;
}

http://sourcesup.cru.fr/viewvc/viewvc/branches/sympa-5.2-branch/src/List.pm?root=sympa&r1=4244&r2=4377