The mailing list for listmasters using Sympa

[Jean Charles Delepine <address@concealed>]

Hello,

Ugrade from 5.1.2-cvs.20060224 gives this message : 
SYMPA <address@concealed> écrivait (wrote) :

> Sympa encountered the following error while running upgrade procedures : 
>      Duplicate entry 
> 'address@concealed' for 
> key 1
> 
> Check log file for further details.

In log file for admin_table :

Dec 19 15:55:34 oban sympa[28853]: Field 'included_admin'  (table 
'admin_table' ; database 'sympa') does NOT have awaited type (int(1)). 
Attempting to change it... 
Dec 19 15:55:34 oban sympa[28853]: ALTER TABLE admin_table CHANGE 
included_admin included_admin int(1)  
Dec 19 15:55:36 oban sympa[28853]: Field included_admin in table admin_table, 
structur updated 
Dec 19 15:55:37 oban sympa[28853]: Field 'robot_admin' (table 'admin_table' ; 
database 'sympa') was NOT found. Attempting to add it... 
Dec 19 15:55:39 oban sympa[28853]: Field robot_admin added to table 
admin_table 
Dec 19 15:55:40 oban sympa[28853]: Field 'subscribed_admin'  (table 
'admin_table' ; database 'sympa') does NOT have awaited type (int(1)). 
Attempting to change it... 
Dec 19 15:55:41 oban sympa[28853]: ALTER TABLE admin_table CHANGE 
subscribed_admin subscribed_admin int(1)  
Dec 19 15:55:42 oban sympa[28853]: Field subscribed_admin in table 
admin_table, structur updated 
Dec 19 15:55:42 oban sympa[28853]: Table admin_table, PRIMARY KEY dropped 
Dec 19 15:55:43 oban sympa[28853]: Table admin_table, PRIMARY KEY set on 
list_admin,robot_admin,user_admin,role_admin 
Dec 19 15:55:43 oban sympa[28853]: Table admin_table, INDEX dropped 
Dec 19 15:55:43 oban sympa[28853]: Table admin_table, INDEX set on 
list_admin,robot_admin,user_admin,role_admin 
Dec 19 15:56:20 oban sympa[29182]: Unable to execute SQL statement "UPDATE 
admin_table SET robot_admin='listes.u-picardie.fr' WHERE 
(list_admin='ac-enseignants')" : Duplicate entry 
'address@concealed' for 
key 1 

The table admin_table contains for the list ac-enseignants (also attached) :

NULL;"2006-02-25 
16:14:16";NULL;"1";NULL;"ac-enseignants";"privileged";"nomail";"owner";"2";"2006-02-25
 16:14:17";"address@concealed";
NULL;"2006-02-25 
16:14:16";NULL;"1";NULL;"ac-enseignants";NULL;"nomail";"editor";"2";"2006-02-25
 16:14:17";"address@concealed";
NULL;"2006-02-25 
16:14:16";NULL;"1";NULL;"ac-enseignants";"privileged";"mail";"owner";"2";"2006-02-25
 16:14:17";"address@concealed";
NULL;"2006-02-25 
16:14:16";NULL;"1";NULL;"ac-enseignants";NULL;"mail";"editor";"2";"2006-02-25 
16:14:17";"address@concealed";
NULL;"2006-12-19 
15:56:14";NULL;"0";NULL;"ac-enseignants";"privileged";"nomail";"owner";"1";"2006-12-19
 15:56:14";"address@concealed";"listes.u-picardie.fr"
NULL;"2006-12-19 
15:56:14";NULL;"0";NULL;"ac-enseignants";NULL;"nomail";"editor";"1";"2006-12-19
 15:56:14";"address@concealed";"listes.u-picardie.fr"
NULL;"2006-12-19 
15:56:14";NULL;"0";NULL;"ac-enseignants";"privileged";"mail";"owner";"1";"2006-12-19
 15:56:14";"address@concealed";"listes.u-picardie.fr"
NULL;"2006-12-19 
15:56:14";NULL;"0";NULL;"ac-enseignants";NULL;"mail";"editor";"1";"2006-12-19 
15:56:14";"address@concealed";"listes.u-picardie.fr"

The admin_table table contains double entries, with and without 
robot_admin feild.

Some search gives
http://sourcesup.cru.fr/tracker/index.php?func=detail&aid=709&group_id=23&atid=167

which recommands :

mysql> UPDATE admin_table SET robot_admin='listes.u-picardie.fr' WHERE
(list_admin='ac-enseignants');
ERROR 1062: Duplicate entry
'address@concealed'
for key 1

later...

sympa is back online. admin_table as been manually corrected and
sympa.pl --upgrade --from=5.1.2 --to=5.2.3 has finished the job.

It seems from
http://sourcesup.cru.fr/tracker/index.php?func=detail&aid=709&group_id=23&atid=167
that for such on old version wwsympa must be turned out before upgrade. 
Right ?

-- 
> R : Tu vois !            || Jean Charles Delépine - Université de Picardie
> > Q : Tu crois ?          
> > > R : Ça casse l'ordre chronologique de l'échange.
> > > > Q : En quoi répondre au dessus est-il gênant ?
NULL;"2006-02-25 16:14:16";NULL;"1";NULL;"ac-enseignants";"privileged";"nomail";"owner";"2";"2006-02-25 16:14:17";"address@concealed";
NULL;"2006-02-25 16:14:16";NULL;"1";NULL;"ac-enseignants";NULL;"nomail";"editor";"2";"2006-02-25 16:14:17";"address@concealed";
NULL;"2006-02-25 16:14:16";NULL;"1";NULL;"ac-enseignants";"privileged";"mail";"owner";"2";"2006-02-25 16:14:17";"address@concealed";
NULL;"2006-02-25 16:14:16";NULL;"1";NULL;"ac-enseignants";NULL;"mail";"editor";"2";"2006-02-25 16:14:17";"address@concealed";
NULL;"2006-12-19 15:56:14";NULL;"0";NULL;"ac-enseignants";"privileged";"nomail";"owner";"1";"2006-12-19 15:56:14";"address@concealed";"listes.u-picardie.fr"
NULL;"2006-12-19 15:56:14";NULL;"0";NULL;"ac-enseignants";NULL;"nomail";"editor";"1";"2006-12-19 15:56:14";"address@concealed";"listes.u-picardie.fr"
NULL;"2006-12-19 15:56:14";NULL;"0";NULL;"ac-enseignants";"privileged";"mail";"owner";"1";"2006-12-19 15:56:14";"address@concealed";"listes.u-picardie.fr"
NULL;"2006-12-19 15:56:14";NULL;"0";NULL;"ac-enseignants";NULL;"mail";"editor";"1";"2006-12-19 15:56:14";"address@concealed";"listes.u-picardie.fr"