The mailing list for listmasters using Sympa

[Ruud BAART <address@concealed>]

I have installed a new sympa server but I want to use the "old"one.

I installed symap 6.2.13 and the old one on another server is 6.1.23.

After installation I want to check and upgrade the Postgres 9.1 database:
usr/local/sympa/bin/sympa.pl --upgrade 
--config=/usr/local/sympa/etc/sympa.conf --from=6.1.23 --to=6.2.13 --debug

Result:
notice main:: Sympa 6.2.13 Started
notice main:: Upgrade process...
notice main:: Upgrading from 6.1.23 to 6.2.13...
notice Sympa::DatabaseManager::_check_primary_key() Primary key 
exclusion_table 
[family_exclusion,user_exclusion,robot_exclusion,list_exclusion] is 
missing. Adding it
err main::#798 > Sympa::Upgrade::upgrade#119 > 
Sympa::DatabaseManager::probe_db#214 > 
Sympa::DatabaseManager::_check_primary_key#453 > 
Sympa::DatabaseDriver::PostgreSQL::set_primary_key#472 > 
Sympa::Database::do_query#277 Unable to execute SQL statement "ALTER 
TABLE exclusion_table ADD CONSTRAINT "ind_exclusion" PRIMARY KEY 
(family_exclusion,user_exclusion,robot_exclusion,list_exclusion)": 
(23502) ERROR:  column "family_exclusion" contains null values
err main::#798 > Sympa::Upgrade::upgrade#119 > 
Sympa::DatabaseManager::probe_db#214 > 
Sympa::DatabaseManager::_check_primary_key#453 > 
Sympa::DatabaseDriver::PostgreSQL::set_primary_key#478 Could not set 
fields family_exclusion,user_exclusion,robot_exclusion,list_exclusion as 
primary key for table exclusion_table in database sympa
err main::#798 > Sympa::Upgrade::upgrade#119 > 
Sympa::DatabaseManager::probe_db#223 Unable to check the validity of 
primary key for table exclusion_table. Aborting
err main::#798 > Sympa::Upgrade::upgrade#120 Database sympa defined in 
sympa.conf has not the right structure or is unreachable. verify db_xxx 
parameters in sympa.conf
err main::#801 Migration from 6.1.23 to 6.2.13 failed

The logfile of the Postgres database server:
2016-02-14 17:19:31 CET ERROR:  column "family_exclusion" contains null 
values
2016-02-14 17:19:31 CET STATEMENT:  ALTER TABLE exclusion_table ADD 
CONSTRAINT "ind_exclusion" PRIMARY KE
Y (user_exclusion,robot_exclusion,family_exclusion,list_exclusion)

I suppose I need to replace the null values in table exclusion_table, 
column "family_exclusion" with a value. What value?

--

Cordialement,


R.J. Baart