Page MenuHomePhabricator

Internal server error (with ugly html tags) when changing Autoresponse postings text
Closed, ResolvedPublic

Description

Steps to reproduce:

  1. Go to https://lists.wikimedia.org/postorius/lists/daily-image-l.lists.wikimedia.org/settings/automatic_responses
  2. Change Autoresponse postings text (e.g. add a letter)
  3. Click Save changes

Expected result: it changes the value and shows a success message

Actual: result:

Internal error.png (258×1 px, 29 KB)

Event Timeline

Legoktm subscribed.
sqlalchemy.exc.DataError: (pymysql.err.DataError) (1406, "Data too long for column 'autoresponse_postings_text' at row 1") [SQL: 'UPDATE mailinglist SET autoresponse_postings_text=%(autoresponse_postings_text)s WHERE mailinglist.id = %(mailinglist_id)s'] [parameters: {'autoresponse_postings_text': 'Sorry, this is an announcement-only list. To comment on a posting, please leave a message at http://commons.wikimedia.org/wiki/Commons_talk:Daily-image-l\r\n\r\nTo unsubscribe, use the "Unsubscribe or edit options" at the bottom of http://lists.wikimedia.org/o', 'mailinglist_id': 499}] (Background on this error at: http://sqlalche.me/e/9h9h)

And for reference:

autoresponse_postings_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,

Can ask upstream to make it bigger