The mailing list for listmasters using Sympa

[Amos <address@concealed>]

Is anybody else using a Sympa list for either the owners and/or editors of another Sympa list?  These errors appear to have an impact on updating either the owners or editors of such a configured list.

On Thu, Sep 29, 2016 at 6:17 PM, Amos <address@concealed> wrote:

OK, so I realized that include_list changed with 6.2.16, so changed template like so:

include_sympa_list

name owner_or_moderator_sympa_list

listname [% param.0 %]

The first time this is associated with a list, it's fine and the members of the specified local sympa list are added to the admin_table as either owner/editor, depending on what section this data source was applied.

However, any subsequent updates to the list owners/editors throws an error.  The logs show something like this:

Sep 29 17:49:12 sympa01 wwsympa[92245]: info Sympa::List::_include_users_list() 6 included users from list Sympa::List <address@concealed>

Sep 29 17:49:12 sympa01 wwsympa[92245]: info Sympa::List::_include_users_list() 6 included users from list Sympa::List <address@concealed>

Sep 29 17:49:12 sympa01 wwsympa[92245]: err main::#1662 > main::do_edit_list#12463 > Sympa::List::sync_include_admin#7488 > Sympa::List::add_list_admin#4128 > Sympa::Database::do_prepared_query#379 Unable to execute SQL statement "INSERT INTO admin_table (user_admin, comment_admin, list_admin, robot_admin, date_admin, update_admin, reception_admin, visibility_admin, subscribed_admin, included_admin, include_sources_admin, role_admin, info_admin, profile_admin) VALUES (?, ?, ?, ?, FROM_UNIXTIME(1475189352), FROM_UNIXTIME(1475189352), ?, ?, ?, ?, ?, ?, ?, ?)": (23000) Duplicate entry 'address@concealed' for key 'PRIMARY'

Sep 29 17:49:12 sympa01 wwsympa[92245]: err main::#1662 > main::do_edit_list#12463 > Sympa::List::sync_include_admin#7488 > Sympa::List::add_list_admin#4159 Unable to add admin address@concealed to table admin_table for list Sympa::List <address@concealed>:

Sep 29 17:49:12 sympa01 wwsympa[92245]: err main::#1662 > main::do_edit_list#12463 > Sympa::List::sync_include_admin#7490 Failed to add new owner(s) to list Sympa::List <address@concealed>

Sep 29 17:49:12 sympa01 wwsympa[92245]: err main::#1662 > main::do_edit_list#12463 > Sympa::List::sync_include_admin#7488 > Sympa::List::add_list_admin#4128 > Sympa::Database::do_prepared_query#379 Unable to execute SQL statement "INSERT INTO admin_table (user_admin, comment_admin, list_admin, robot_admin, date_admin, update_admin, reception_admin, visibility_admin, subscribed_admin, included_admin, include_sources_admin, role_admin, info_admin, profile_admin) VALUES (?, ?, ?, ?, FROM_UNIXTIME(1475189352), FROM_UNIXTIME(1475189352), ?, ?, ?, ?, ?, ?, ?, ?)": (23000) Duplicate entry 'address@concealed' for key 'PRIMARY'

Sep 29 17:49:12 sympa01 wwsympa[92245]: err main::#1662 > main::do_edit_list#12463 > Sympa::List::sync_include_admin#7488 > Sympa::List::add_list_admin#4159 Unable to add admin address@concealed to table admin_table for list Sympa::List <address@concealed>:

Sep 29 17:49:12 sympa01 wwsympa[92245]: err main::#1662 > main::do_edit_list#12463 > Sympa::List::sync_include_admin#7490 Failed to add new owner(s) to list Sympa::List <address@concealed>

If I look at the admin_table, the user is already there, hence the error.  So for some reason it's falsely thinking that it needs to add that entry.  It's as if it's not first checking to see if that address is already in the admin_table.....