Skip to Content.
Sympa Menu

en - [en@sympa] Duplicate entry error adding list owner (Sympa multi domain/robot)

Subject: The mailing list for listmasters using Sympa

List archive

Chronological Thread  
  • From: "antonelli@cnaf" <address@concealed>
  • To: address@concealed
  • Subject: [en@sympa] Duplicate entry error adding list owner (Sympa multi domain/robot)
  • Date: Thu, 15 Jun 2023 15:49:56 +0200

Dear Sympa,

I have a multi domain/robot Sympa 6.2.70 on CentOS 7.9.2009 and I'm facing this error:

I have two lists same-name@domain1 and same-name@domain2 and when I try to add the (yet) owner address@concealed of same-name@domain1 as owner of same-name@domain2 I get an error from database. I attach the output at the end.

Am I doing anything wrong (like configuration?) or how can I bypass this (provided that we authenticate only via an IdP/CAS and each user has one email)?

Thank you
cheers Stefano

###

This is the query showing the existence of address@concealed as owner of same-name@domain1

MariaDB [sympa]> select list_admin,user_admin,robot_admin,role_admin from admin_table where user_admin like '%address@concealed%';

| same-name | address@concealed | domain1 | owner |

and this is the error from wwsympa.log

2023-06-15T15:17:49.054246+02:00 **** wwsympa[3678]: err main::#1557 > main::do_review#4494 > main::_review_user#4632 > Sympa::Spindle::spin#95 > Sympa::Request::Handler::add
::_twist#87 > Sympa::List::add_list_admin#3313 > Sympa::List::_add_list_admin#3432 > Sympa::Database::do_prepared_query#382 Unable to execute SQL statement "INSERT INTO admin_
table (date_epoch_admin, comment_admin, inclusion_admin, inclusion_ext_admin, inclusion_label_admin, info_admin, profile_admin, reception_admin, subscribed_admin, update_epoch
_admin, visibility_admin, role_admin, user_admin, list_admin, robot_admin) SELECT ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? FROM dual WHERE NOT EXISTS ( SELECT 1 FROM admin_
table WHERE role_admin = ? AND user_admin = ? AND list_admin = ? AND robot_admin = ? )": (23000) Duplicate entry 'address@concealed' for key 'list_admin_2'
2023-06-15T15:17:49.054355+02:00 lists wwsympa[3678]: err main::#1557 > main::do_review#4494 > main::_review_user#4632 > Sympa::Spindle::spin#95 > Sympa::Request::Handler::add
::_twist#87 > Sympa::List::add_list_admin#3313 > Sympa::List::_add_list_admin#3461 Unable to add owner address@concealed to the list Sympa::List <same-name@domain2>



Archive powered by MHonArc 2.6.19+.

Top of Page