The mailing list for listmasters using Sympa

[Adam Bernstein <address@concealed>]

> the error I get is duplicate key in mysql table as list_admin entry...
> a list_admin email address cannot be also a moderator.

Huh, that's weird.  Reaching the limit of my knowledge here -- hopefully 
you can get help from the Sympa team.

> I have to say my mysql DB of sympa is hinerited since early versions 5.x
> and I have updated it during sympa software update procedure when
> a newer sympa version was avaliable up to hte latest version.

We've done more or less the same thing, but on the other hand we've also 
switched to new servers once or twice, so in fact we've started with a 
fresh database at least once.  So this may be relevant, although I would 
think the sympa upgrade process would have taken care of everything.

The only thing I can suggest is to see if you have the same index/key 
defined that I see in my admin_table.  The key that's listed as Primary 
is an index of these columns:
     list_admin
     robot_admin
     user_admin
     role_admin

Maybe that hasn't been created on your database for some reason?  I'm 
looking at mine via PhpMyAdmin, looking at the Structure of this table 
and then Details.  There's other ways, I just don't know 'em.

Good luck!
        adam