The mailing list for listmasters using Sympa

["Michael D. Sofka" <address@concealed>]

I'm upgrading Sympa from version 6.1.4 to 6.1.17 by way of 6.1.7.  This 
is through a pair of Ubuntu upgrades: 11.10 -> 12.04 -> 14.04.

I'm testing the upgrade on a VM clone.  During the 12.04 to 14.04 
upgrade (Sympa 6.1.7. to Sympa 6.1.17), a series of PostgreSQL errors 
appeared:

2014-10-08 15:37:35 EDT STATEMENT:  INSERT INTO list_table (status_list, 
name_list, robot_
list, subject_list, web_archive_list, topics_list, owners_list, 
editors_list) VALUES ('ope
n', 'alumni-grad', 'cs.lists.rpi.edu', 'alumni-grad', 1, 'departmental', 
'address@concealed,
address@concealed', 'address@concealed,address@concealed')
2014-10-08 15:37:35 EDT ERROR:  relation "list_table" does not exist at 
character 8
2014-10-08 15:37:35 EDT STATEMENT:  UPDATE list_table SET status_list = 
'open', name_list
= 'alumni-grad', robot_list = 'cs.lists.rpi.edu', subject_list = 
'alumni-grad', web_archiv
e_list = 1, topics_list = 'departmental', owners_list = 
'address@concealed,address@concealed',
editors_list = 'address@concealed,address@concealed' WHERE robot_list = 
'cs.lists.rpi.edu' AND n
ame_list = 'alumni-grad'
2014-10-08 15:37:35 EDT ERROR:  relation "list_table" does not exist at 
character 13

and so on.


The upgrades server appears to function correctly, perhaps in a 
compatibility mode?  Or perhaps it is only partly correct.

I recall that at some point list configuration information was moved to 
the database.  Apparently this process is not automatic, or at least was 
not done correctly during the upgrades.

I've been googling for any explanation of the upgrade process, but so 
far all I've found are the DB schema descriptions/code on sympa.org.  I 
could recreate and reload the DB.  Should this be done before the 
upgrade?  After?  And if after does sympa.pl --sync_list_db load the 
configs?  Any guidance on where to look, or how to continue appreciated.

Mike


--
Michael D. Sofka               address@concealed
C&MT Sr. Systems Programmer,   Email, TeX, Epistemology
Rensselaer Polytechnic Institute, Troy, NY.  http://www.rpi.edu/~sofkam/