[sympa-fr] Data too long for column 'include_sources_subscriber'

["DESMOULINS Charles ROSI/DPS" <adresse@cachée>]

Bonjour,

J'ai un serveur Sympa en version 5.2.1 & une base MySQL 5.0.

J'ai constaté un problème suivant lorsque j'importe des abonnées à partir 
d'une source LDAP ou d'un fichier.

Si une même adresse mail revient plusieurs fois, j'obtiens l'erreur suivante 
: 

Jan 15 15:10:50 XXXXXXXX wwsympa[14147]: Unable to execute SQL statement 
"INSERT INTO subscriber_table (user_subscriber, comment_subscriber, 
list_subscriber, robot_subscriber, date_subscriber, update_subscriber, 
reception_subscriber, topics_subscriber, 
visibility_subscriber,subscribed_subscriber,included_subscriber,include_sources_subscriber)
 VALUES ('adresse@cachée', NULL, 'xxx.xxxxxxxxxxxx', 
'list.yyyyyy-zzzzzzz.com', FROM_UNIXTIME(1200406170), 
FROM_UNIXTIME(1200406170), 'mail', NULL, 'noconceal', 0, 1, 
'd4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08')"
 : Data too long for column 'include_sources_subscriber' at row 1

Jan 15 15:10:50 XXXXXXXX wwsympa[14147]: Unable to execute SQL statement 
"INSERT INTO subscriber_table (user_subscriber, comment_subscriber, 
list_subscriber, robot_subscriber, date_subscriber, update_subscriber, 
reception_subscriber, topics_subscriber, 
visibility_subscriber,subscribed_subscriber,included_subscriber,include_sources_subscriber)
 VALUES ('adresse@cachée', NULL, 'xxx.xxxxxxxxxxxx', 
'list.yyyyyy-zzzzzzz.com', FROM_UNIXTIME(1200406171), 
FROM_UNIXTIME(1200406171), 'mail', NULL, 'noconceal', 0, 1, 
'd4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d4795d08,d47


Il semble que Sympa ajoute l'ID de la source dans la colonne 
"include_sources_subscriber" au tant de fois que l'adresse mail est trouvée. 
Il ne "voit pas" que c'est la même source et il ne vérifie pas si la taille 
max de cette colonne est atteinte.

J'aimerais savoir ce qu'on faire pour résoudre/contourner ce problème.

Merci,
Charles


*********************************
This message and any attachments (the "message") are confidential and 
intended solely for the addressees. 
Any unauthorised use or dissemination is prohibited.
Messages are susceptible to alteration. 
France Telecom Group shall not be liable for the message if altered, changed 
or falsified.
If you are not the intended addressee of this message, please cancel it 
immediately and inform the sender.
********************************