The mailing list for listmasters using Sympa

[address@concealed]

> > Did you migrate the database content ? Subscription are store in teh 
> > database to when you move sympa to another server you have to move tha 
> > database content.
> >
> >    
>
> Yes.  I basically moved /var/lib/mysql/sympa from one server to another.
> The two servers have different hostnames, though - which resulted in some 
> conflict related to previously existing web archives and aliases.
>  
I guess that you had the following problem : the database structure as 
changed in version 5.2 because of "full virtual robot" feature. When 
installing sympa 5.2 the database is created with the right structure. 
When upgrading from 4.X to 5.2 on the same server, the database is 
upgraded by sympa.pl at first start. I Imagine the following history :

  1. install 5.2
  2. copy database from old host with previous version

After that you are running 5.2 with database structure of a previous 
version.

The solution :
-1 Stop all demon including fastcgi (it require to stop apache).
-2 save the database
-3 edit /home/sympa/etc/data_structure.version change the version 
number to the version of Sympa that was running on your old host
-4 run sympa.pl -d

This way Sympa should start upgrading the database.

Serge Aumont