The mailing list for listmasters using Sympa

[Michael Howe <address@concealed>]

Hello,

Has anyone else seen problems with having too many owners/moderators on
a list to fit in the list_table table with a recent 6.1 version of
sympa?  Both the owners_list and editors_list field default to
varchar(100), and while adding an owner I've just seen in my logs:

2014-07-22T16:25:42+01:00 irregular-apocalypse.it.ox.ac.uk local1.err
wwsympa[6146]: err List::_update_list_db() Unable to execute SQL
statement "UPDATE list_table SET status_list =
'open', name_list = 'worc2070test3', robot_list =
'dev2.maillist.ox.ac.uk', subject_list =
'Test list', web_archive_list = 1, topics_list = '', owners_list =
'address@concealed,address@concealed,address@concealed',
editors_list = 'address@concealed' WHERE robot_list =
'dev2.maillist.ox.ac.uk' AND name_list = 'worc2070test3'" : ERROR:
value too long for type character varying(100)


Has anyone else seen this sort of thing?  Does it actually cause a
problem?  (As far as I can tell the list_table is only used to cache
data, but I'm not sure when sympa prefers it to the on-disk data.)  Does
anyone have a work-around?

I've not found a bug report at
<https://sourcesup.renater.fr/tracker/?func=browse&group_id=23&atid=167>
about it, and am about to file one, but I wanted to get a feel for how
much of a problem it actually is.

(The hacky solution is to just increase the field size; the better
solution would be to normalize the data, but I don't know if that's a
bit drastic for 6.1.)

Many thanks,

Michael

(FWIW, I'm using Sympa 6.1.17.)

-- 
Michael Howe, Systems Development and Support Section
IT Services, University of Oxford