The mailing list for listmasters using Sympa

[IKEDA Soji <address@concealed>]

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 = '

--
株式会社 コンバージョン
ITソリューション部 システムソリューション1グループ 池田荘児
e-mail address@concealed
https://www.conversion.co.jp/