On 12/14/20 9:46 AM, Morris Jones wrote:

I ran into this error attempting to add a user to a mailing list:

(pymysql.err.DataError) (1406, "Data too long for column 'data' at row 1") [SQL: INSERT INTO workflowstate (token, step, data) VALUES (%(token)s, %(step)s, %(data)s)] [parameters: {'token': '7394fbf654b3faffc6a65eb95e0616eea6651b9e', 'step': 'do_confirm_verify', 'data': '{"pre_approved": false, "pre_confirmed": false, "pre_verified": false, "invitation": false, "address_key": "dorothyxxxxxxxx@gmail.com", "subscriber_key": 1, "user_key": "00201c01dcc443c3a0d8f6d1ea42e230", "token_owner_key": 1, "send_welcome_message": null}'}]

In MySQL I see that column 'data' in workflowstate is VARCHAR(255), and the data in the query is 259 characters.

If I have a moment I'll write a bug or patch ... but I'm not really current on schema migrations.

This is <https://gitlab.com/mailman/mailman/-/issues/793> fixed by <https://gitlab.com/mailman/mailman/-/merge_requests/730>

You may be able to apply the fix from the merge request, but that depends on your install's latest Alembic Revision ID being 9735f5e5dbdb.

Alternatively, I think it may be sufficient to just

ALTER TABLE workflowstate MODIFY data VARCHAR(510);

-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan