The mailing list for listmasters using Sympa

["Stefan Hornburg (Racke)" <address@concealed>]

On 10/26/2016 05:31 AM, Amos (via sympa-users Mailing List) wrote:
> 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.
> 

Hello Amos,

please check out the thread "list_data configuration changes not active". 
This (faulty) behaviour was apparently
introduced in 6.2.

I posted a patch in this thread, which seems to fix the database update 
problems.
There are other problems caused by caching the admin users.

Regards
          Racke

> 
> On Thu, Sep 29, 2016 at 6:17 PM, Amos <address@concealed 
> <mailto: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 
> <mailto: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 
> <mailto: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 
> <mailto: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
>     <mailto:address@concealed> to table admin_table for list Sympa::List 
> <address@concealed
>     <mailto: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
>     <mailto: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 
> <mailto: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
>     <mailto:address@concealed> to table admin_table for list Sympa::List 
> <address@concealed
>     <mailto: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
>     <mailto: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.....
> 
> 


-- 
Ecommerce and Linux consulting + Perl and web application programming.
Debian and Sympa administration.