The mailing list for listmasters using Sympa

[Amos <address@concealed>]

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

On Wed, Sep 28, 2016 at 7:03 PM, Amos <address@concealed> wrote:

I don't seem to find anything on this yet.

For a while (before upgrading to 6.2.16), we had some lists that had the following in their config file:

owner_include

source owner_or_moderator_sympa_list

reception mail

profile privileged

visibility conceal

source_parameters helpdesk

And the template file (owner_or_moderator_sympa_list.incl) was just this:

include_list [% param.0 %]

Is this still valid?  I ask because I'm seeing SQL errors that seem to be related to these because when I delete such an entry for a list, those errors disappear.  When I then add such an entry back to the list, adding a regular address as an owner or moderator throws an internal server error.

Thanks.

Amos