The mailing list for listmasters using Sympa

[IKEDA Soji <address@concealed>]

Hi,

You may set invalid string as family name.  For example run

  UPDATE exclusion_table SET family_exclusion = ''
  WHERE family_exclusion IS NULL;

Then retry "sympa.pl --upgrade".


Regards,

-- Soji

On Sun, 14 Feb 2016 17:41:11 +0100
Ruud BAART <address@concealed> wrote:

> 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
> 


-- 
IKEDA Soji <address@concealed>