The mailing list for listmasters using Sympa

[Olivier Salaün - CRU <address@concealed>]

Hi,

This problem happens while upgrading to 5.2.x versions of Sympa because this version adds the full virtual hosting support. This leads to DB changes : new 'robot' field added to both subscriber_table and admin_table.

If you forget to stop all Sympa processes during the upgrade process (including wwsympa and the SOAP server ; which require that Apache is stopped), you might end up with such "duplicate entries problems".

To fix the problem :

1. remove all entries from the admin_table
   
2. run sympa.pl  --reload_list_config ; it will recreate entries in the admin_table
   

Jean Charles Delepine wrote:

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: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 admin_table table contains double entries, with and without robot_admin feild.
[...]
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 ?