search

keiffster / program-y

Python 3.x based AIML 2.0 Chatbot interpreter, framework, related programs and knowledge files
https://keiffster.github.io/program-y/
Other
348 stars 138 forks source link

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

Open SunilGudivada opened 4 years ago

SunilGudivada commented 4 years ago

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.

keiffster commented 3 years ago

Do you know how long the text is, the field is fixed value