On Thu, 2006-03-16 at 17:25 -0600, Ryan Wilcox wrote:
> i have seen a few of the other report problems recently, couldn't find a
> solution to my problem.
>
> we have a report with the following:
>
> strftime("%m/%d/%Y - %H:%M:%S", t.changetime, 'unixepoch') AS
> ChangedTime
>
> throws the following Trac error:
>
> Report execution failed: not enough arguments for format string
>
> it seems as though 'strftime' is causing a problem. i used this query
> directly via sqlite on the command line and it returns the correct
> result.
>
> any ideas what in trac would be causing this problem?
Yes, this is a problem with the "%" character and parameter substitution
with the Python APIs. For now add a second "%" to escape each "%" in
your query. I added one possible fix for this in the trunk. After
discussion I think it will be modified slightly, but this should be
fixed in 0.9.5.
--
Matthew Good <[EMAIL PROTECTED]>
_______________________________________________
Trac mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac
