The mailing list for listmasters using Sympa

[Aumont - Comite Reseaux des Universites <address@concealed>]

Johann Spies wrote:

> Are there any Debian Woody adminstrators out there who have upgraded
> sympa on Woody?
>
> I have a sympa installation on Woody which uses postgresql as database
> and I am uncertain whether it is possible to upgrade sympa
> (3.3.3-3woody2) the latest stable version.
>
> Regards
> Johann
>  
Yes it is possible but as postgresql user you will need to modify the 
database structure (Sympa does that automatically only for MySQL). It is 
easy to list all changes checking for http://www.sympa.org/release.html.

Changes that make incompatibilties with previous version are listed with 
"*****" Most of them are details such as change a default for a 
parameter etc. Here are thoses related to data base structure since 3.3.3 :

4.0.a7          18 October 2003

  New features :

***** 	New 'attributes_user' field in the 'subscriber_table' 
***** 	If you are using MySQL, Sympa.pl will change the database structure 
***** 	at startup. If using Pg, Oracle or Sybase you should ALTER the table
*****   structure according to the provided create_db.x scripts.

4.0.a4          14 August 2003

****    You should update your database structure based on the create_db.xxx 
scripts
*****   unless you are using MySQL (Sympa tries to update the database 
automatically at startup)

4.0.a3
	  
***** If you are upgrading from	a previous Sympa version, you should update 
***** your sympa DB as	follows : 
***** ALTER TABLE subscriber_table CHANGE date_subscriber timestamp with time zone NOT NULL; 
***** ALTER TABLE subscriber_table CHANGE update_subscriber timestamp with time zone;

3.3.6


*****   New database fields added to subscriber_table
*****   With MySQL :
*****           ALTER TABLE subscriber_table ADD subscribed_subscriber enum 
('0','1');
*****           ALTER TABLE subscriber_table ADD included_subscriber enum 
('0','1');
*****           ALTER TABLE subscriber_table ADD include_sources_subscriber 
varchar(50);
*****   If you are using another RDBMS, please check create_db.xxx scripts


3.3.4b.6        10 Apr 2002


*****	[reported by Daniel Pittman] extend 'bounce_subscriber' database field. 
*****	Could lead to errors in	Mysql : "value too long for type character varying(30)"
*****   With MySQL sympa.pl will make database structure changes at startup 
(if
*****   it has the alter_table privilege)

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature