The mailing list for listmasters using Sympa

["antonelli@cnaf" <address@concealed>]

Hi Soji

> Perhaps removing the index named list_admin_2 would solve the problem.
> Please issue the following SQL statements then try adding owner again.
>
> USE my_sympa_db;
> DROP INDEX list_admin_2 ON admin_table;

yes; I dropped the index, tested adding the owner and it worked;

thank you
regards Stefano

Il 16/06/23 10:21, IKEDA Soji ha scritto:
> Hi Stefano,
>
> On 2023/06/16 16:55, antonelli@cnaf wrote:
> > Hi Soji
> >
> > thank you for your answer; I'm using mariadb 10.0.38
> >
> > this is the output of the select query (SELECT TABLE_NAME, INDEX_NAME, 
> > COLUMN_NAME FROM INFORMATION_SCHEMA.STATISTICS WHERE TABLE_SCHEMA = 
> > 'my_sympa_db') (I attach the file too)
>
> Perhaps removing the index named list_admin_2 would solve the problem. 
> Please issue the following SQL statements then try adding owner again.
>
> USE my_sympa_db;
> DROP INDEX list_admin_2 ON admin_table;
>
> This index was probably added in a very old version (maybe before 5.3)
> and has not been deleted even though it is no longer needed.
>
>
> Regards,
> -- Soji
>
>
> > thank you
> > regards Stefano
> >
> > +-----------------------+-----------------------+------------------------+ 
> >
> > | TABLE_NAME            | INDEX_NAME            | 
> > COLUMN_NAME            |
> > +-----------------------+-----------------------+------------------------+ 
> >
> > | admin_table           | PRIMARY               | 
> > list_admin             |
> > | admin_table           | PRIMARY               | 
> > user_admin             |
> > | admin_table           | PRIMARY               | 
> > robot_admin            |
> > | admin_table           | PRIMARY               | 
> > role_admin             |
> > | admin_table           | list_admin_2          | 
> > list_admin             |
> > | admin_table           | list_admin_2          | 
> > user_admin             |
> > | admin_table           | admin_user_index      | 
> > user_admin             |
> > | bulkmailer_table      | PRIMARY               | 
> > messagekey_bulkmailer  |
> > | bulkmailer_table      | PRIMARY               | 
> > packetid_bulkmailer    |
> > | bulkspool_table       | PRIMARY               | 
> > messagekey_bulkspool   |
> > | conf_table            | PRIMARY               | 
> > robot_conf             |
> > | conf_table            | PRIMARY               | 
> > label_conf             |
> > | exclusion_table       | PRIMARY               | 
> > user_exclusion         |
> > | exclusion_table       | PRIMARY               | 
> > robot_exclusion        |
> > | exclusion_table       | PRIMARY               | 
> > family_exclusion       |
> > | exclusion_table       | PRIMARY               | 
> > list_exclusion         |
> > | inclusion_table       | PRIMARY               | 
> > source_inclusion       |
> > | inclusion_table       | PRIMARY               | 
> > role_inclusion         |
> > | inclusion_table       | PRIMARY               | 
> > target_inclusion       |
> > | list_table            | PRIMARY               | 
> > name_list              |
> > | list_table            | PRIMARY               | 
> > robot_list             |
> > | netidmap_table        | PRIMARY               | 
> > netid_netidmap         |
> > | netidmap_table        | PRIMARY               | 
> > serviceid_netidmap     |
> > | netidmap_table        | PRIMARY               | 
> > robot_netidmap         |
> > | notification_table    | PRIMARY               | 
> > pk_notification        |
> > | one_time_ticket_table | PRIMARY               | 
> > ticket_one_time_ticket |
> > | session_table         | PRIMARY               | 
> > id_session             |
> > | session_table         | session_prev_id_index | 
> > prev_id_session        |
> > | stat_table            | stats_user_index      | 
> > email_stat             |
> > | subscriber_table      | PRIMARY               | 
> > list_subscriber        |
> > | subscriber_table      | PRIMARY               | 
> > user_subscriber        |
> > | subscriber_table      | PRIMARY               | 
> > robot_subscriber       |
> > | subscriber_table      | subscriber_user_index | 
> > user_subscriber        |
> > | user_table            | PRIMARY               | 
> > email_user             |
> > +-----------------------+-----------------------+------------------------+ 
> >
> >
> >
> >
> > Il 16/06/23 07:50, IKEDA Soji ha scritto:
> > > WHERE TABLE_SCHEMA = '