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

  1. Could not create table %s in database %s : user_table
  2. Could not create table %s in database %s : subscriber_table
  3. 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

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

with

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

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