Invalid Request error - if the matched string length is more - SQL #58

New issue

Open

opened 2025-10-14 17:31:03 -06:00 by navan · 0 comments

navan commented

2025-10-14 17:31:03 -06:00

Owner

Originally created by @SunilGudivada on 6/26/2020

I am using the telegram client, while sending the reply it is giving the below error.

My text is combination of the html tags like ,.......

sqlalchemy.exc.InvalidRequestError: This Session's transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (pymysql.err.DataError) (1406, "Data too long for column 'matchstr' at row 1")
[SQL: INSERT INTO matchednodes (matchid, matchcount, matchtype, matchnode, matchstr, wildcard, multiword) VALUES (%(matchid)s, %(matchcount)s, %(matchtype)s, %(matchnode)s, %(matchstr)s, %(wildcard)s, %(multiword)s)]

After this error i am unable to send any message or getting back the reply.

*Originally created by @SunilGudivada on 6/26/2020* I am using the telegram client, while sending the reply it is giving the below error. My text is combination of the html tags like <b></b>,....... ``` sqlalchemy.exc.InvalidRequestError: This Session's transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (pymysql.err.DataError) (1406, "Data too long for column 'matchstr' at row 1") [SQL: INSERT INTO matchednodes (matchid, matchcount, matchtype, matchnode, matchstr, wildcard, multiword) VALUES (%(matchid)s, %(matchcount)s, %(matchtype)s, %(matchnode)s, %(matchstr)s, %(wildcard)s, %(multiword)s)] ``` After this error i am unable to send any message or getting back the reply.

No milestone

No project

No assignees

1 participant

Notifications

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: github/program-y#58

No description provided.

Rows
Columns