Using Flowise with MYSQL only supports uploading very small files

[RicardoFernandez-UY]

Hi,
I'm using Flowise with MYSQL.
My flow loads a docx document and it allows QA over the document.
For small documents, for example 16k it works fine.
When I try to upload a slightly bigger document, say a couple of Mb, it fails.
After working for a while on the problem I arrived at this error:

2024-03-25 01:46:23 [ERROR]: unhandledRejection:  ER_DATA_TOO_LONG: Data too long for column 'flowData' at row 1
QueryFailedError: ER_DATA_TOO_LONG: Data too long for column 'flowData' at row 1
    at Query.<anonymous> (/usr/local/lib/node_modules/flowise/node_modules/typeorm/driver/mysql/MysqlQueryRunner.js:165:37)
    at Query.<anonymous> (/usr/local/lib/node_modules/flowise/node_modules/mysql/lib/Connection.js:526:10)
    at Query._callback (/usr/local/lib/node_modules/flowise/node_modules/mysql/lib/Connection.js:488:16)
    at Sequence.end (/usr/local/lib/node_modules/flowise/node_modules/mysql/lib/protocol/sequences/Sequence.js:83:24)
    at Query.ErrorPacket (/usr/local/lib/node_modules/flowise/node_modules/mysql/lib/protocol/sequences/Query.js:92:8)
    at Protocol._parsePacket (/usr/local/lib/node_modules/flowise/node_modules/mysql/lib/protocol/Protocol.js:291:23)
    at Parser._parsePacket (/usr/local/lib/node_modules/flowise/node_modules/mysql/lib/protocol/Parser.js:433:10)
    at Parser.write (/usr/local/lib/node_modules/flowise/node_modules/mysql/lib/protocol/Parser.js:43:10)
    at Protocol.write (/usr/local/lib/node_modules/flowise/node_modules/mysql/lib/protocol/Protocol.js:38:16)
    at Socket.<anonymous> (/usr/local/lib/node_modules/flowise/node_modules/mysql/lib/Connection.js:88:28)
    at Socket.<anonymous> (/usr/local/lib/node_modules/flowise/node_modules/mysql/lib/Connection.js:526:10)
    at Socket.emit (node:events:517:28)
    at addChunk (node:internal/streams/readable:368:12)
    at readableAddChunk (node:internal/streams/readable:341:9)
    at Readable.push (node:internal/streams/readable:278:10)
    at TCP.onStreamRead (node:internal/stream_base_commons:190:23)

It seems that Flowise is trying to save the flow (including the uploaded file to the mysql database to a field called flowData which is of type Text, and from what I've researched it allows a maximum of 64Kb)

This is a major limitation, or I've done something wrong.
Whichever it is, I will greatly appreciate your guidance to overcome this limitation, as any docx file is bigger than this.

Thank you very much!!

[amansoniamazatic]

Hi @RicardoFernandez-UY , I faced a similar situation before. Sometimes, Flowise, may cause an error due to data being too long for the 'flowdata' column. In that case, users have to first connect to their MySQL database using CMD and GUI and then ALter the column length of 'flowdata' from 'text' to 'longtext'. This should fix the error.

[RicardoFernandez-UY]

Hi @amansoniamazatic
I did what you suggested (I thought about it but I was a bit afraid of modifying what was created by the installation scripts), and it worked fine!
Thank you!!

[amansoniamazatic]

You're welcome

[vinodkiran]

we are working on this and have an active PR to address the issue of MYSQL column length.

[RicardoFernandez-UY]

Hi @vinodkiran
Great to hear that!
Thank you!