The swish-e indexer module fails each time it is called by cron with the "Data too long for column" error in the log. Viewing the entry shows a very large block of text which appears to be part of the document swish is trying to index and chunks of sql.

Comments

dinis’s picture

Ok, done some more digging and it's failing on a fairly large word document (51 pages, 550kb), is this a limitiation of the system, or is there a php/mysql setting I can change somewhere to allow swish to parse larger documents?

populist’s picture

Status: Active » Closed (works as designed)

I believe this is a problem with MySQL and how many characters it will support with the "text" field. Here is some more information about it: http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html