SQL query truncated in reports

[Sancho]

Like it

Up

0

Down

Drop it

::

Thanks for the fix, we’ll add for next version !

Hi,
I just came across a problem with reporting using custom SQL queries.
It happens to be that SQL queries are truncated to 255 chars, which is quite unfortunate when you’re trying to select, join and group data with a single query.

Didn’t take long to find the problem though. It’s only a column in the treport_content table that’s set to tinytext.

run this query from the DB interface to expand it to something a lot bigger:
   alter table treport_content modify external_source longtext ;

Cheers,
Jasper