Objet : Pour les administrateurs de serveurs de listes utilisant le logiciel Sympa
Archives de la liste
[sympa-fr] problème upgrade base mysql sympa
- From: Anne-Marie Philippon <adresse@cachée>
- To: adresse@cachée
- Subject: [sympa-fr] problème upgrade base mysql sympa
- Date: Fri, 28 Oct 2011 15:44:43 +0200
Bonjour Je viens d'installer un nouveau serveur sympa en version 6.1.5 Après avoir récupéré la base sympa installée sur une version 5.2.4, je n'arrive pas à upgrader ma base: Voici ce que j'obtiens: /usr/sbin/sympa.pl --upgrade --from=5.2.4 --to=6.1.5 info Configuration file read, default log level 0 notice Upgrade::probe_db() Table conf_table created in database sympa notice Upgrade::probe_db() Table logs_table created in database sympa notice Upgrade::probe_db() Table exclusion_table created in database sympa notice Upgrade::probe_db() Table session_table created in database sympa notice Upgrade::probe_db() Table bulkspool_table created in database sympa notice Upgrade::probe_db() Table one_time_ticket_table created in database sympa notice Upgrade::probe_db() Table bulkmailer_table created in database sympa info Upgrade::probe_db() Field 'label_conf' (table 'conf_table' ; database 'sympa') was NOT found. Attempting to add it... info Upgrade::probe_db() Field label_conf added to table conf_table info Upgrade::probe_db() Field 'robot_conf' (table 'conf_table' ; database 'sympa') was NOT found. Attempting to add it... info Upgrade::probe_db() Field robot_conf added to table conf_table info Upgrade::probe_db() Field 'value_conf' (table 'conf_table' ; database 'sympa') was NOT found. Attempting to add it... info Upgrade::probe_db() Field value_conf added to table conf_table info Upgrade::probe_db() Missing expected primary key : robot_conf info Upgrade::probe_db() Missing expected primary key : label_conf info Upgrade::probe_db() Table conf_table, PRIMARY KEY set on robot_conf,label_conf info Upgrade::probe_db() Field 'action_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it... info Upgrade::probe_db() Field action_logs added to table logs_table info Upgrade::probe_db() Field 'client_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it... info Upgrade::probe_db() Field client_logs added to table logs_table info Upgrade::probe_db() Field 'daemon_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it... info Upgrade::probe_db() Field daemon_logs added to table logs_table info Upgrade::probe_db() Field 'date_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it... info Upgrade::probe_db() Field date_logs added to table logs_table info Upgrade::probe_db() Field 'error_type_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it... info Upgrade::probe_db() Field error_type_logs added to table logs_table info Upgrade::probe_db() Field 'id_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it... info Upgrade::probe_db() Field id_logs added to table logs_table info Upgrade::probe_db() Field 'list_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it... info Upgrade::probe_db() Field list_logs added to table logs_table info Upgrade::probe_db() Field 'msg_id_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it... info Upgrade::probe_db() Field msg_id_logs added to table logs_table info Upgrade::probe_db() Field 'parameters_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it... info Upgrade::probe_db() Field parameters_logs added to table logs_table info Upgrade::probe_db() Field 'robot_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it... info Upgrade::probe_db() Field robot_logs added to table logs_table info Upgrade::probe_db() Field 'status_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it... info Upgrade::probe_db() Field status_logs added to table logs_table info Upgrade::probe_db() Field 'target_email_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it... info Upgrade::probe_db() Field target_email_logs added to table logs_table info Upgrade::probe_db() Field 'user_email_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it... info Upgrade::probe_db() Field user_email_logs added to table logs_table info Upgrade::probe_db() Missing expected primary key : id_logs info Upgrade::probe_db() Table logs_table, PRIMARY KEY set on id_logs info Upgrade::probe_db() Field 'data_user' (table 'user_table' ; database 'sympa') was NOT found. Attempting to add it... info Upgrade::probe_db() Field data_user added to table user_table info Upgrade::probe_db() Field 'last_login_date_user' (table 'user_table' ; database 'sympa') was NOT found. Attempting to add it... info Upgrade::probe_db() Field last_login_date_user added to table user_table info Upgrade::probe_db() Field 'last_login_host_user' (table 'user_table' ; database 'sympa') was NOT found. Attempting to add it... info Upgrade::probe_db() Field last_login_host_user added to table user_table info Upgrade::probe_db() Field 'wrong_login_count_user' (table 'user_table' ; database 'sympa') was NOT found. Attempting to add it... info Upgrade::probe_db() Field wrong_login_count_user added to table user_table info Upgrade::probe_db() Missing expected primary key : email_user DBD::mysql::db do failed: Duplicate entry 'adresse@cachée' for key 1 at /usr/share/sympa/lib/Upgrade.pm line 1309. err Upgrade::probe_db() Could not set field 'email_user' as PRIMARY KEY, table'user_table'. Database sympa defined in sympa.conf has not the right structure or is unreachable. verify db_xxx parameters in sympa.conf Comment s'en sortir? Les paramètres db_... de sympa.conf sont identiques à ceux de la version 5.2.4 Si je supprime une des 2 entrées adresse@cachée, je tombe sur la suivante, etc Merci de m'aider Anne-Marie Philippon |
-
[sympa-fr] problème upgrade base mysql sympa,
Anne-Marie Philippon, 28/10/2011
- RE: [sympa-fr] problème upgrade base mysql sympa, Jérôme Zittoun, 28/10/2011
Archives gérées par MHonArc 2.6.19+.