The mailing list for listmasters using Sympa

[Redmond Militante <address@concealed>]

I followed the steps below, it sympa.pl -d seems to run into an error when 
attempting to upgrade the database structure.

I am attaching the output of sympa.pl -d, including the error message.

Thanks,
Redmond

+++ address@concealed <address@concealed> [06/05/19 08:59]:
> 
> >>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
> 

-- 
Redmond Militante / NSIT / The University of Chicago
PGP Public Key: <http://home.uchicago.edu/~rjm/pubkey.asc>
List::_load_admin_users_config(editor) for list hey
Got lock for write on /home/sympa/expl/hey/include_admin_user.lock
List:sync_include_admin(hey): 0 editor(s) updated
Release lock on /home/sympa/expl/hey/include_admin_user.lock
List::savestats
List::_save_stats_file(/home/sympa/expl/hey/stats, 0, 0, 1148052089)
List::get_first_admin_user(hey,owner,domain,0,0)
SQL: SELECT user_admin AS email, comment_admin AS gecos, reception_admin AS 
reception, UNIX_TIMESTAMP(date_admin) AS date, UNIX_TIMESTAMP(update_admin) 
AS update_date, info_admin AS info, profile_admin AS profile, 
subscribed_admin AS subscribed, included_admin AS included, 
include_sources_admin AS id, REVERSE(SUBSTRING(user_admin FROM position('@' 
IN user_admin) FOR 50)) AS dom FROM admin_table WHERE (list_admin = 'hey' AND 
robot_admin = 'announce.uchicago.edu' AND role_admin = 'owner' ) ORDER BY dom
List::get_next_admin_user
List:sync_include_admin(heyman)
List::get_first_admin_user(heyman,owner,domain,0,0)
SQL: SELECT user_admin AS email, comment_admin AS gecos, reception_admin AS 
reception, UNIX_TIMESTAMP(date_admin) AS date, UNIX_TIMESTAMP(update_admin) 
AS update_date, info_admin AS info, profile_admin AS profile, 
subscribed_admin AS subscribed, included_admin AS included, 
include_sources_admin AS id, REVERSE(SUBSTRING(user_admin FROM position('@' 
IN user_admin) FOR 50)) AS dom FROM admin_table WHERE (list_admin = 'heyman' 
AND robot_admin = 'announce.uchicago.edu' AND role_admin = 'owner' ) ORDER BY 
dom
List::get_next_admin_user
List::_load_admin_users_include(owner) for list heyman
List::_load_admin_users_config(owner) for list heyman
Got lock for write on /home/sympa/expl/heyman/include_admin_user.lock
List::is_update_param
List:sync_include_admin(heyman): 0 owner(s) updated
Release lock on /home/sympa/expl/heyman/include_admin_user.lock
List::get_first_admin_user(heyman,editor,domain,0,0)
SQL: SELECT user_admin AS email, comment_admin AS gecos, reception_admin AS 
reception, UNIX_TIMESTAMP(date_admin) AS date, UNIX_TIMESTAMP(update_admin) 
AS update_date, info_admin AS info, profile_admin AS profile, 
subscribed_admin AS subscribed, included_admin AS included, 
include_sources_admin AS id, REVERSE(SUBSTRING(user_admin FROM position('@' 
IN user_admin) FOR 50)) AS dom FROM admin_table WHERE (list_admin = 'heyman' 
AND robot_admin = 'announce.uchicago.edu' AND role_admin = 'editor' ) ORDER 
BY dom
List::_load_admin_users_include(editor) for list heyman
List::_load_admin_users_config(editor) for list heyman
Got lock for write on /home/sympa/expl/heyman/include_admin_user.lock
List:sync_include_admin(heyman): 0 editor(s) updated
Release lock on /home/sympa/expl/heyman/include_admin_user.lock
List::savestats
List::_save_stats_file(/home/sympa/expl/heyman/stats, 0, 0, 1148052089)
List::get_first_admin_user(heyman,owner,domain,0,0)
SQL: SELECT user_admin AS email, comment_admin AS gecos, reception_admin AS 
reception, UNIX_TIMESTAMP(date_admin) AS date, UNIX_TIMESTAMP(update_admin) 
AS update_date, info_admin AS info, profile_admin AS profile, 
subscribed_admin AS subscribed, included_admin AS included, 
include_sources_admin AS id, REVERSE(SUBSTRING(user_admin FROM position('@' 
IN user_admin) FOR 50)) AS dom FROM admin_table WHERE (list_admin = 'heyman' 
AND robot_admin = 'announce.uchicago.edu' AND role_admin = 'owner' ) ORDER BY 
dom
List::get_next_admin_user
List:sync_include_admin(music)
List::get_first_admin_user(music,owner,domain,0,0)
SQL: SELECT user_admin AS email, comment_admin AS gecos, reception_admin AS 
reception, UNIX_TIMESTAMP(date_admin) AS date, UNIX_TIMESTAMP(update_admin) 
AS update_date, info_admin AS info, profile_admin AS profile, 
subscribed_admin AS subscribed, included_admin AS included, 
include_sources_admin AS id, REVERSE(SUBSTRING(user_admin FROM position('@' 
IN user_admin) FOR 50)) AS dom FROM admin_table WHERE (list_admin = 'music' 
AND robot_admin = 'announce.uchicago.edu' AND role_admin = 'owner' ) ORDER BY 
dom
List::get_next_admin_user
List::_load_admin_users_include(owner) for list music
List::_load_admin_users_config(owner) for list music
Got lock for write on /home/sympa/expl/music/include_admin_user.lock
List::is_update_param
List:sync_include_admin(music): 0 owner(s) updated
Release lock on /home/sympa/expl/music/include_admin_user.lock
List::get_first_admin_user(music,editor,domain,0,0)
SQL: SELECT user_admin AS email, comment_admin AS gecos, reception_admin AS 
reception, UNIX_TIMESTAMP(date_admin) AS date, UNIX_TIMESTAMP(update_admin) 
AS update_date, info_admin AS info, profile_admin AS profile, 
subscribed_admin AS subscribed, included_admin AS included, 
include_sources_admin AS id, REVERSE(SUBSTRING(user_admin FROM position('@' 
IN user_admin) FOR 50)) AS dom FROM admin_table WHERE (list_admin = 'music' 
AND robot_admin = 'announce.uchicago.edu' AND role_admin = 'editor' ) ORDER 
BY dom
List::_load_admin_users_include(editor) for list music
List::_load_admin_users_config(editor) for list music
Got lock for write on /home/sympa/expl/music/include_admin_user.lock
List:sync_include_admin(music): 0 editor(s) updated
Release lock on /home/sympa/expl/music/include_admin_user.lock
List::savestats
List::_save_stats_file(/home/sympa/expl/music/stats, 0, 0, 1148052089)
List::get_first_admin_user(music,owner,domain,0,0)
SQL: SELECT user_admin AS email, comment_admin AS gecos, reception_admin AS 
reception, UNIX_TIMESTAMP(date_admin) AS date, UNIX_TIMESTAMP(update_admin) 
AS update_date, info_admin AS info, profile_admin AS profile, 
subscribed_admin AS subscribed, included_admin AS included, 
include_sources_admin AS id, REVERSE(SUBSTRING(user_admin FROM position('@' 
IN user_admin) FOR 50)) AS dom FROM admin_table WHERE (list_admin = 'music' 
AND robot_admin = 'announce.uchicago.edu' AND role_admin = 'owner' ) ORDER BY 
dom
List::get_next_admin_user
List:sync_include_admin(nsit-system-ops)
List::get_first_admin_user(nsit-system-ops,owner,domain,0,0)
SQL: SELECT user_admin AS email, comment_admin AS gecos, reception_admin AS 
reception, UNIX_TIMESTAMP(date_admin) AS date, UNIX_TIMESTAMP(update_admin) 
AS update_date, info_admin AS info, profile_admin AS profile, 
subscribed_admin AS subscribed, included_admin AS included, 
include_sources_admin AS id, REVERSE(SUBSTRING(user_admin FROM position('@' 
IN user_admin) FOR 50)) AS dom FROM admin_table WHERE (list_admin = 
'nsit-system-ops' AND robot_admin = 'announce.uchicago.edu' AND role_admin = 
'owner' ) ORDER BY dom
List::get_next_admin_user
List::get_next_admin_user
List::_load_admin_users_include(owner) for list nsit-system-ops
List::_load_admin_users_config(owner) for list nsit-system-ops
Got lock for write on /home/sympa/expl/nsit-system-ops/include_admin_user.lock
List::is_update_param
List::is_update_param
List:sync_include_admin(nsit-system-ops): 0 owner(s) updated
Release lock on /home/sympa/expl/nsit-system-ops/include_admin_user.lock
List::get_first_admin_user(nsit-system-ops,editor,domain,0,0)
SQL: SELECT user_admin AS email, comment_admin AS gecos, reception_admin AS 
reception, UNIX_TIMESTAMP(date_admin) AS date, UNIX_TIMESTAMP(update_admin) 
AS update_date, info_admin AS info, profile_admin AS profile, 
subscribed_admin AS subscribed, included_admin AS included, 
include_sources_admin AS id, REVERSE(SUBSTRING(user_admin FROM position('@' 
IN user_admin) FOR 50)) AS dom FROM admin_table WHERE (list_admin = 
'nsit-system-ops' AND robot_admin = 'announce.uchicago.edu' AND role_admin = 
'editor' ) ORDER BY dom
List::_load_admin_users_include(editor) for list nsit-system-ops
List::_load_admin_users_config(editor) for list nsit-system-ops
Got lock for write on /home/sympa/expl/nsit-system-ops/include_admin_user.lock
List:sync_include_admin(nsit-system-ops): 0 editor(s) updated
Release lock on /home/sympa/expl/nsit-system-ops/include_admin_user.lock
List::savestats
List::_save_stats_file(/home/sympa/expl/nsit-system-ops/stats, 0, 0, 
1148052089)List::get_first_admin_user(nsit-system-ops,owner,domain,0,0)
SQL: SELECT user_admin AS email, comment_admin AS gecos, reception_admin AS 
reception, UNIX_TIMESTAMP(date_admin) AS date, UNIX_TIMESTAMP(update_admin) 
AS update_date, info_admin AS info, profile_admin AS profile, 
subscribed_admin AS subscribed, included_admin AS included, 
include_sources_admin AS id, REVERSE(SUBSTRING(user_admin FROM position('@' 
IN user_admin) FOR 50)) AS dom FROM admin_table WHERE (list_admin = 
'nsit-system-ops' AND robot_admin = 'announce.uchicago.edu' AND role_admin = 
'owner' ) ORDER BY dom
List::get_next_admin_user
List::get_next_admin_user
List:sync_include_admin(rdbtest)
List::get_first_admin_user(rdbtest,owner,domain,0,0)
SQL: SELECT user_admin AS email, comment_admin AS gecos, reception_admin AS 
reception, UNIX_TIMESTAMP(date_admin) AS date, UNIX_TIMESTAMP(update_admin) 
AS update_date, info_admin AS info, profile_admin AS profile, 
subscribed_admin AS subscribed, included_admin AS included, 
include_sources_admin AS id, REVERSE(SUBSTRING(user_admin FROM position('@' 
IN user_admin) FOR 50)) AS dom FROM admin_table WHERE (list_admin = 'rdbtest' 
AND robot_admin = 'announce.uchicago.edu' AND role_admin = 'owner' ) ORDER BY 
dom
List::get_next_admin_user
List::_load_admin_users_include(owner) for list rdbtest
List::_load_admin_users_config(owner) for list rdbtest
Got lock for write on /home/sympa/expl/rdbtest/include_admin_user.lock
List::is_update_param
List:sync_include_admin(rdbtest): 0 owner(s) updated
Release lock on /home/sympa/expl/rdbtest/include_admin_user.lock
List::get_first_admin_user(rdbtest,editor,domain,0,0)
SQL: SELECT user_admin AS email, comment_admin AS gecos, reception_admin AS 
reception, UNIX_TIMESTAMP(date_admin) AS date, UNIX_TIMESTAMP(update_admin) 
AS update_date, info_admin AS info, profile_admin AS profile, 
subscribed_admin AS subscribed, included_admin AS included, 
include_sources_admin AS id, REVERSE(SUBSTRING(user_admin FROM position('@' 
IN user_admin) FOR 50)) AS dom FROM admin_table WHERE (list_admin = 'rdbtest' 
AND robot_admin = 'announce.uchicago.edu' AND role_admin = 'editor' ) ORDER 
BY dom
List::_load_admin_users_include(editor) for list rdbtest
List::_load_admin_users_config(editor) for list rdbtest
Got lock for write on /home/sympa/expl/rdbtest/include_admin_user.lock
List:sync_include_admin(rdbtest): 0 editor(s) updated
Release lock on /home/sympa/expl/rdbtest/include_admin_user.lock
List::savestats
List::_save_stats_file(/home/sympa/expl/rdbtest/stats, 0, 0, 1148052089)
List::get_first_admin_user(rdbtest,owner,domain,0,0)
SQL: SELECT user_admin AS email, comment_admin AS gecos, reception_admin AS 
reception, UNIX_TIMESTAMP(date_admin) AS date, UNIX_TIMESTAMP(update_admin) 
AS update_date, info_admin AS info, profile_admin AS profile, 
subscribed_admin AS subscribed, included_admin AS included, 
include_sources_admin AS id, REVERSE(SUBSTRING(user_admin FROM position('@' 
IN user_admin) FOR 50)) AS dom FROM admin_table WHERE (list_admin = 'rdbtest' 
AND robot_admin = 'announce.uchicago.edu' AND role_admin = 'owner' ) ORDER BY 
dom
List::get_next_admin_user
List:sync_include_admin(test)
List::get_first_admin_user(test,owner,domain,0,0)
SQL: SELECT user_admin AS email, comment_admin AS gecos, reception_admin AS 
reception, UNIX_TIMESTAMP(date_admin) AS date, UNIX_TIMESTAMP(update_admin) 
AS update_date, info_admin AS info, profile_admin AS profile, 
subscribed_admin AS subscribed, included_admin AS included, 
include_sources_admin AS id, REVERSE(SUBSTRING(user_admin FROM position('@' 
IN user_admin) FOR 50)) AS dom FROM admin_table WHERE (list_admin = 'test' 
AND robot_admin = 'announce.uchicago.edu' AND role_admin = 'owner' ) ORDER BY 
dom
List::get_next_admin_user
List::_load_admin_users_include(owner) for list test
List::_load_admin_users_config(owner) for list test
Got lock for write on /home/sympa/expl/test/include_admin_user.lock
List::is_update_param
List:sync_include_admin(test): 0 owner(s) updated
Release lock on /home/sympa/expl/test/include_admin_user.lock
List::get_first_admin_user(test,editor,domain,0,0)
SQL: SELECT user_admin AS email, comment_admin AS gecos, reception_admin AS 
reception, UNIX_TIMESTAMP(date_admin) AS date, UNIX_TIMESTAMP(update_admin) 
AS update_date, info_admin AS info, profile_admin AS profile, 
subscribed_admin AS subscribed, included_admin AS included, 
include_sources_admin AS id, REVERSE(SUBSTRING(user_admin FROM position('@' 
IN user_admin) FOR 50)) AS dom FROM admin_table WHERE (list_admin = 'test' 
AND robot_admin = 'announce.uchicago.edu' AND role_admin = 'editor' ) ORDER 
BY dom
List::_load_admin_users_include(editor) for list test
List::_load_admin_users_config(editor) for list test
Got lock for write on /home/sympa/expl/test/include_admin_user.lock
List:sync_include_admin(test): 0 editor(s) updated
Release lock on /home/sympa/expl/test/include_admin_user.lock
List::savestats
List::_save_stats_file(/home/sympa/expl/test/stats, 0, 0, 1148052089)
List::get_first_admin_user(test,owner,domain,0,0)
SQL: SELECT user_admin AS email, comment_admin AS gecos, reception_admin AS 
reception, UNIX_TIMESTAMP(date_admin) AS date, UNIX_TIMESTAMP(update_admin) 
AS update_date, info_admin AS info, profile_admin AS profile, 
subscribed_admin AS subscribed, included_admin AS included, 
include_sources_admin AS id, REVERSE(SUBSTRING(user_admin FROM position('@' 
IN user_admin) FOR 50)) AS dom FROM admin_table WHERE (list_admin = 'test' 
AND robot_admin = 'announce.uchicago.edu' AND role_admin = 'owner' ) ORDER BY 
dom
List::get_next_admin_user
List:sync_include_admin(test2)
List::get_first_admin_user(test2,owner,domain,0,0)
SQL: SELECT user_admin AS email, comment_admin AS gecos, reception_admin AS 
reception, UNIX_TIMESTAMP(date_admin) AS date, UNIX_TIMESTAMP(update_admin) 
AS update_date, info_admin AS info, profile_admin AS profile, 
subscribed_admin AS subscribed, included_admin AS included, 
include_sources_admin AS id, REVERSE(SUBSTRING(user_admin FROM position('@' 
IN user_admin) FOR 50)) AS dom FROM admin_table WHERE (list_admin = 'test2' 
AND robot_admin = 'announce.uchicago.edu' AND role_admin = 'owner' ) ORDER BY 
dom
List::get_next_admin_user
List::_load_admin_users_include(owner) for list test2
List::_load_admin_users_config(owner) for list test2
Got lock for write on /home/sympa/expl/test2/include_admin_user.lock
List::is_update_param
List:sync_include_admin(test2): 0 owner(s) updated
Release lock on /home/sympa/expl/test2/include_admin_user.lock
List::get_first_admin_user(test2,editor,domain,0,0)
SQL: SELECT user_admin AS email, comment_admin AS gecos, reception_admin AS 
reception, UNIX_TIMESTAMP(date_admin) AS date, UNIX_TIMESTAMP(update_admin) 
AS update_date, info_admin AS info, profile_admin AS profile, 
subscribed_admin AS subscribed, included_admin AS included, 
include_sources_admin AS id, REVERSE(SUBSTRING(user_admin FROM position('@' 
IN user_admin) FOR 50)) AS dom FROM admin_table WHERE (list_admin = 'test2' 
AND robot_admin = 'announce.uchicago.edu' AND role_admin = 'editor' ) ORDER 
BY dom
List::_load_admin_users_include(editor) for list test2
List::_load_admin_users_config(editor) for list test2
Got lock for write on /home/sympa/expl/test2/include_admin_user.lock
List:sync_include_admin(test2): 0 editor(s) updated
Release lock on /home/sympa/expl/test2/include_admin_user.lock
List::savestats
List::_save_stats_file(/home/sympa/expl/test2/stats, 0, 0, 1148052089)
List::get_first_admin_user(test2,owner,domain,0,0)
SQL: SELECT user_admin AS email, comment_admin AS gecos, reception_admin AS 
reception, UNIX_TIMESTAMP(date_admin) AS date, UNIX_TIMESTAMP(update_admin) 
AS update_date, info_admin AS info, profile_admin AS profile, 
subscribed_admin AS subscribed, included_admin AS included, 
include_sources_admin AS id, REVERSE(SUBSTRING(user_admin FROM position('@' 
IN user_admin) FOR 50)) AS dom FROM admin_table WHERE (list_admin = 'test2' 
AND robot_admin = 'announce.uchicago.edu' AND role_admin = 'owner' ) ORDER BY 
dom
List::get_next_admin_user
List:sync_include_admin(testannouncements)
List::get_first_admin_user(testannouncements,owner,domain,0,0)
SQL: SELECT user_admin AS email, comment_admin AS gecos, reception_admin AS 
reception, UNIX_TIMESTAMP(date_admin) AS date, UNIX_TIMESTAMP(update_admin) 
AS update_date, info_admin AS info, profile_admin AS profile, 
subscribed_admin AS subscribed, included_admin AS included, 
include_sources_admin AS id, REVERSE(SUBSTRING(user_admin FROM position('@' 
IN user_admin) FOR 50)) AS dom FROM admin_table WHERE (list_admin = 
'testannouncements' AND robot_admin = 'announce.uchicago.edu' AND role_admin 
= 'owner' ) ORDER BY dom
List::get_next_admin_user
List::_load_admin_users_include(owner) for list testannouncements
List::_load_admin_users_config(owner) for list testannouncements
Got lock for write on 
/home/sympa/expl/testannouncements/include_admin_user.lockList::is_update_param
List:sync_include_admin(testannouncements): 0 owner(s) updated
Release lock on /home/sympa/expl/testannouncements/include_admin_user.lock
List::get_first_admin_user(testannouncements,editor,domain,0,0)
SQL: SELECT user_admin AS email, comment_admin AS gecos, reception_admin AS 
reception, UNIX_TIMESTAMP(date_admin) AS date, UNIX_TIMESTAMP(update_admin) 
AS update_date, info_admin AS info, profile_admin AS profile, 
subscribed_admin AS subscribed, included_admin AS included, 
include_sources_admin AS id, REVERSE(SUBSTRING(user_admin FROM position('@' 
IN user_admin) FOR 50)) AS dom FROM admin_table WHERE (list_admin = 
'testannouncements' AND robot_admin = 'announce.uchicago.edu' AND role_admin 
= 'editor' ) ORDER BY dom
List::get_next_admin_user
List::_load_admin_users_include(editor) for list testannouncements
List::_load_admin_users_config(editor) for list testannouncements
Got lock for write on 
/home/sympa/expl/testannouncements/include_admin_user.lockList::is_update_param
List:sync_include_admin(testannouncements): 0 editor(s) updated
Release lock on /home/sympa/expl/testannouncements/include_admin_user.lock
List::savestats
List::_save_stats_file(/home/sympa/expl/testannouncements/stats, 0, 0, 
1148052089)
List::get_first_admin_user(testannouncements,owner,domain,0,0)
SQL: SELECT user_admin AS email, comment_admin AS gecos, reception_admin AS 
reception, UNIX_TIMESTAMP(date_admin) AS date, UNIX_TIMESTAMP(update_admin) 
AS update_date, info_admin AS info, profile_admin AS profile, 
subscribed_admin AS subscribed, included_admin AS included, 
include_sources_admin AS id, REVERSE(SUBSTRING(user_admin FROM position('@' 
IN user_admin) FOR 50)) AS dom FROM admin_table WHERE (list_admin = 
'testannouncements' AND robot_admin = 'announce.uchicago.edu' AND role_admin 
= 'owner' ) ORDER BY dom
List::get_next_admin_user
List:sync_include_admin(therese-n-me)
List::get_first_admin_user(therese-n-me,owner,domain,0,0)
SQL: SELECT user_admin AS email, comment_admin AS gecos, reception_admin AS 
reception, UNIX_TIMESTAMP(date_admin) AS date, UNIX_TIMESTAMP(update_admin) 
AS update_date, info_admin AS info, profile_admin AS profile, 
subscribed_admin AS subscribed, included_admin AS included, 
include_sources_admin AS id, REVERSE(SUBSTRING(user_admin FROM position('@' 
IN user_admin) FOR 50)) AS dom FROM admin_table WHERE (list_admin = 
'therese-n-me' AND robot_admin = 'announce.uchicago.edu' AND role_admin = 
'owner' ) ORDER BY dom
List::get_next_admin_user
List::_load_admin_users_include(owner) for list therese-n-me
List::_load_admin_users_config(owner) for list therese-n-me
Got lock for write on /home/sympa/expl/therese-n-me/include_admin_user.lock
List::is_update_param
List:sync_include_admin(therese-n-me): 0 owner(s) updated
Release lock on /home/sympa/expl/therese-n-me/include_admin_user.lock
List::get_first_admin_user(therese-n-me,editor,domain,0,0)
SQL: SELECT user_admin AS email, comment_admin AS gecos, reception_admin AS 
reception, UNIX_TIMESTAMP(date_admin) AS date, UNIX_TIMESTAMP(update_admin) 
AS update_date, info_admin AS info, profile_admin AS profile, 
subscribed_admin AS subscribed, included_admin AS included, 
include_sources_admin AS id, REVERSE(SUBSTRING(user_admin FROM position('@' 
IN user_admin) FOR 50)) AS dom FROM admin_table WHERE (list_admin = 
'therese-n-me' AND robot_admin = 'announce.uchicago.edu' AND role_admin = 
'editor' ) ORDER BY dom
List::get_next_admin_user
List::_load_admin_users_include(editor) for list therese-n-me
List::_load_admin_users_config(editor) for list therese-n-me
Got lock for write on /home/sympa/expl/therese-n-me/include_admin_user.lock
List::is_update_param
List:sync_include_admin(therese-n-me): 0 editor(s) updated
Release lock on /home/sympa/expl/therese-n-me/include_admin_user.lock
List::savestats
List::_save_stats_file(/home/sympa/expl/therese-n-me/stats, 0, 0, 1148052089)
List::get_first_admin_user(therese-n-me,owner,domain,0,0)
SQL: SELECT user_admin AS email, comment_admin AS gecos, reception_admin AS 
reception, UNIX_TIMESTAMP(date_admin) AS date, UNIX_TIMESTAMP(update_admin) 
AS update_date, info_admin AS info, profile_admin AS profile, 
subscribed_admin AS subscribed, included_admin AS included, 
include_sources_admin AS id, REVERSE(SUBSTRING(user_admin FROM position('@' 
IN user_admin) FOR 50)) AS dom FROM admin_table WHERE (list_admin = 
'therese-n-me' AND robot_admin = 'announce.uchicago.edu' AND role_admin = 
'owner' ) ORDER BY dom
List::get_next_admin_user
Old web templates HTML structure is not compliant with latest ones.
Moving old-style web templates out of the include_path...
List::get_lists(*)
List::get_robots()
List::new(achtest, announce.uchicago.edu, )
List::load(achtest, announce.uchicago.edu, )
List::new(another_one, announce.uchicago.edu, )
List::load(another_one, announce.uchicago.edu, )
List::new(bobs, announce.uchicago.edu, )
List::load(bobs, announce.uchicago.edu, )
List::new(celine_dion, announce.uchicago.edu, )
List::load(celine_dion, announce.uchicago.edu, )
List::new(disneys_aladdin, announce.uchicago.edu, )
List::load(disneys_aladdin, announce.uchicago.edu, )
List::new(france, announce.uchicago.edu, )
List::load(france, announce.uchicago.edu, )
List::new(gj-test-private, announce.uchicago.edu, )
List::load(gj-test-private, announce.uchicago.edu, )
List::new(hey, announce.uchicago.edu, )
List::load(hey, announce.uchicago.edu, )
List::new(heyman, announce.uchicago.edu, )
List::load(heyman, announce.uchicago.edu, )
List::new(music, announce.uchicago.edu, )
List::load(music, announce.uchicago.edu, )
List::new(nsit-system-ops, announce.uchicago.edu, )
List::load(nsit-system-ops, announce.uchicago.edu, )
List::new(rdbtest, announce.uchicago.edu, )
List::load(rdbtest, announce.uchicago.edu, )
List::new(test, announce.uchicago.edu, )
List::load(test, announce.uchicago.edu, )
List::new(test2, announce.uchicago.edu, )
List::load(test2, announce.uchicago.edu, )
List::new(testannouncements, announce.uchicago.edu, )
List::load(testannouncements, announce.uchicago.edu, )
List::new(therese-n-me, announce.uchicago.edu, )
List::load(therese-n-me, announce.uchicago.edu, )
Cleaning buggy list config files...
List::get_lists(*)
List::get_robots()
List::new(achtest, announce.uchicago.edu, )
List::load(achtest, announce.uchicago.edu, )
List::new(another_one, announce.uchicago.edu, )
List::load(another_one, announce.uchicago.edu, )
List::new(bobs, announce.uchicago.edu, )
List::load(bobs, announce.uchicago.edu, )
List::new(celine_dion, announce.uchicago.edu, )
List::load(celine_dion, announce.uchicago.edu, )
List::new(disneys_aladdin, announce.uchicago.edu, )
List::load(disneys_aladdin, announce.uchicago.edu, )
List::new(france, announce.uchicago.edu, )
List::load(france, announce.uchicago.edu, )
List::new(gj-test-private, announce.uchicago.edu, )
List::load(gj-test-private, announce.uchicago.edu, )
List::new(hey, announce.uchicago.edu, )
List::load(hey, announce.uchicago.edu, )
List::new(heyman, announce.uchicago.edu, )
List::load(heyman, announce.uchicago.edu, )
List::new(music, announce.uchicago.edu, )
List::load(music, announce.uchicago.edu, )
List::new(nsit-system-ops, announce.uchicago.edu, )
List::load(nsit-system-ops, announce.uchicago.edu, )
List::new(rdbtest, announce.uchicago.edu, )
List::load(rdbtest, announce.uchicago.edu, )
List::new(test, announce.uchicago.edu, )
List::load(test, announce.uchicago.edu, )
List::new(test2, announce.uchicago.edu, )
List::load(test2, announce.uchicago.edu, )
List::new(testannouncements, announce.uchicago.edu, )
List::load(testannouncements, announce.uchicago.edu, )
List::new(therese-n-me, announce.uchicago.edu, )
List::load(therese-n-me, announce.uchicago.edu, )
Rename archives/log. files...
List::get_lists(*)
List::get_robots()
List::new(achtest, announce.uchicago.edu, )
List::load(achtest, announce.uchicago.edu, )
List::new(another_one, announce.uchicago.edu, )
List::load(another_one, announce.uchicago.edu, )
List::new(bobs, announce.uchicago.edu, )
List::load(bobs, announce.uchicago.edu, )
List::new(celine_dion, announce.uchicago.edu, )
List::load(celine_dion, announce.uchicago.edu, )
List::new(disneys_aladdin, announce.uchicago.edu, )
List::load(disneys_aladdin, announce.uchicago.edu, )
List::new(france, announce.uchicago.edu, )
List::load(france, announce.uchicago.edu, )
List::new(gj-test-private, announce.uchicago.edu, )
List::load(gj-test-private, announce.uchicago.edu, )
List::new(hey, announce.uchicago.edu, )
List::load(hey, announce.uchicago.edu, )
List::new(heyman, announce.uchicago.edu, )
List::load(heyman, announce.uchicago.edu, )
List::new(music, announce.uchicago.edu, )
List::load(music, announce.uchicago.edu, )
List::new(nsit-system-ops, announce.uchicago.edu, )
List::load(nsit-system-ops, announce.uchicago.edu, )
List::new(rdbtest, announce.uchicago.edu, )
List::load(rdbtest, announce.uchicago.edu, )
List::new(test, announce.uchicago.edu, )
List::load(test, announce.uchicago.edu, )
List::new(test2, announce.uchicago.edu, )
List::load(test2, announce.uchicago.edu, )
List::new(testannouncements, announce.uchicago.edu, )
List::load(testannouncements, announce.uchicago.edu, )
List::new(therese-n-me, announce.uchicago.edu, )
List::load(therese-n-me, announce.uchicago.edu, )
Updating the new robot_subscriber and robot_admin  Db fields...
List::get_lists(announce.uchicago.edu)
List::new(achtest, announce.uchicago.edu, skip_sync_admin)
List::load(achtest, announce.uchicago.edu, skip_sync_admin)
List::new(another_one, announce.uchicago.edu, skip_sync_admin)
List::load(another_one, announce.uchicago.edu, skip_sync_admin)
List::new(bobs, announce.uchicago.edu, skip_sync_admin)
List::load(bobs, announce.uchicago.edu, skip_sync_admin)
List::new(celine_dion, announce.uchicago.edu, skip_sync_admin)
List::load(celine_dion, announce.uchicago.edu, skip_sync_admin)
List::new(disneys_aladdin, announce.uchicago.edu, skip_sync_admin)
List::load(disneys_aladdin, announce.uchicago.edu, skip_sync_admin)
List::new(france, announce.uchicago.edu, skip_sync_admin)
List::load(france, announce.uchicago.edu, skip_sync_admin)
List::new(gj-test-private, announce.uchicago.edu, skip_sync_admin)
List::load(gj-test-private, announce.uchicago.edu, skip_sync_admin)
List::new(hey, announce.uchicago.edu, skip_sync_admin)
List::load(hey, announce.uchicago.edu, skip_sync_admin)
List::new(heyman, announce.uchicago.edu, skip_sync_admin)
List::load(heyman, announce.uchicago.edu, skip_sync_admin)
List::new(music, announce.uchicago.edu, skip_sync_admin)
List::load(music, announce.uchicago.edu, skip_sync_admin)
List::new(nsit-system-ops, announce.uchicago.edu, skip_sync_admin)
List::load(nsit-system-ops, announce.uchicago.edu, skip_sync_admin)
List::new(rdbtest, announce.uchicago.edu, skip_sync_admin)
List::load(rdbtest, announce.uchicago.edu, skip_sync_admin)
List::new(test, announce.uchicago.edu, skip_sync_admin)
List::load(test, announce.uchicago.edu, skip_sync_admin)
List::new(test2, announce.uchicago.edu, skip_sync_admin)
List::load(test2, announce.uchicago.edu, skip_sync_admin)
List::new(testannouncements, announce.uchicago.edu, skip_sync_admin)
List::load(testannouncements, announce.uchicago.edu, skip_sync_admin)
List::new(therese-n-me, announce.uchicago.edu, skip_sync_admin)
List::load(therese-n-me, announce.uchicago.edu, skip_sync_admin)
DBD::mysql::db do failed: Duplicate entry 
'address@concealed' for key 1 at 
/home/sympa/bin/List.pm line 11307.
Unable to execute SQL statement "UPDATE admin_table SET 
robot_admin='announce.uchicago.edu' WHERE (list_admin='achtest')" : Duplicate 
entry 'address@concealed' for key 1
Language::SetLang(en_US)
List::init_list_cache()
Reaper unwaited pids :
Open = 0

Language::SetLang(en_US)
List::init_list_cache()
Reaper unwaited pids :
Open = 0