fails when used with report containing LIKE operator

[anonymous]

Reports which contain something like the following work in the reports page, but fail with the TicketBox macro:

SELECT id AS ticket, summary FROM ticket

WHERE status IN ('new', 'assigned', 'reopened')

AND (owner='$USER' OR cc LIKE '%$USER%')

I guess that the problem is with the use of the % symbols in the LIKE string?

[Shun-ichi Goto]

(In [3423]) Fix to use ReportModule.sql_sub_vars() for the issue #2810. Old code is not good for query like "... LIKE '%$USER%'" on 0.10.x or 0.11 on replacing variables. Close #2810.

And also drop supporting for trac 0.8 or before.

[Shun-ichi Goto]

I'd reproduced your issue and fix it in r3423. Try it please.