Need help with strange MySQL error 1406: Data too long for column

💬 General Discussion
1

For some reason my scheduler got stuck after cron job started processing ‘Process Workflow Tasks’. It goes into running state for eternity.
In log I found a strange error:

[FATAL] Error updating table: job_queue: Query Failed: UPDATE job_queue
…
target=‘function::processAOW_Workflow’.
…
MySQL error 1406: Data too long for column ‘message’ at row 1

And the message it self is actually very long 1179954 characters in total.
So it is not fitting into TEXT field with utf8 characters.
It should fit into MEDIUM TEXT but I am not sure why do I have such a long text there.

The text it self is full of warnings like those (repeating the same warnings numerous times):
Warning [2]: copy(upload//c62b64c3-77e7-b7a0-0613-4d6b6f7e6e9b_photo): failed to open stream: No such file or directory in C:\Apache24\htdocs\sugarcrm2test\modules\AOS_PDF_Templates\templateParser.php on line 82\r\nWarning [2]: implode(): Invalid arguments passed in C:\Apache24\htdocs\sugarcrm2test\modules\AOW_Actions\actions\actionSendEmail.php on line 417\r\n

Suite is v.7.9.7 on apache on windows, php7.1 and mysql server 5.1…

2

It seems you need to get a MySQL version that is compatible with your version of SuiteCRM:

https://suitecrm.com/wiki/index.php/Compatibility_Matrix

3

Well it looks like i am about to face mysql server upgrade…was skipping this for some time for a number of reasons (other non suitecrm databases) but it sims that i cannot continue any further with 5.1…
Thank you. Will post here if I found something interesting during this upgrade…

BTW, never find a time to congratulate you on your new role with salesagility. You deserved it and I believe I am speaking for the whole community when I say thank you and keep up the good work as you always did.

1 Like