On 3/7/21 3:42 AM, David Partain via Mailman-users wrote:
Most of it's going fine, as best I can see. However, I get exceptions on some lists that look like this:
Traceback (most recent call last):
...
pymysql.err.DataError: (1406, "Data too long for column 'info' at row 1")
My assumption is that what's in the "Info" field on the old mailman2 config is simply too long. Is that correct?
Yes. For MySQL and MariaDB the info column is VARCHAR(255). It probably should be defined as a type that allows a longer value, but for now with those DB engines, it is limited to 255 bytes.
In that case, I suppose the right thing is to (1) edit each one, reducing the size, which'll create a new config.pck, (2) pull it over to the new machine, and (3) run the import again.
Seem reasonable?
Yes, that's the workaround. Or you could start over with postgresql as the DB which doesn't have that limitation.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan