Number of closed / active / total tickets shows as float in roadmap page

[anonymous]

After upgrading from 0.10.3 to 0.11.5, the number of closed / active / total tickets is shown as float, not integer, in the roadmap and milestone views. In the milestone view, this affects the "Closed tickets: …" line below the progress bar, but NOT the "Ticket status by …" summary box in the right hand side of the page.

e.g.:

Closed tickets: 14.0 Active tickets: 5.0 / Total tickets: 19.0

is shown instead of:

Closed tickets: 14 Active tickets: 5 / Total tickets: 19

This did not happen before upgrading from 0.10.3.

Sysinfo:

Trac:  	0.11.5
Python: 	2.4.3 (#2, Oct 6 2006, 08:04:11) [GCC 4.0.3 (Ubuntu 4.0.3-1ubuntu5)]
setuptools: 	0.6c5
SQLite: 	2.8.17
pysqlite: 	1.0.1
Genshi: 	0.5.1
mod_python: 	< 3.2
Subversion: 	1.3.1 (r19032)
jQuery:	1.2.6

[Christian Boos]

Replying to anonymous:

> SQLite: 	2.8.17
> pysqlite: 	1.0.1

Not 100% sure, but I guess that might be the root of the problem. As anyway this version of SQLite is going to be deprecated soon in 0.11.x and support for it will be removed in 0.12.x, you should upgrade (see PySqlite#UpgradingSQLitefrom2.xto3.x).

[anonymous]

I have upgraded SQLite (to 3.2.8) and pysqlite (to 2.0.5), upgraded the database as described in PySqlite, and restarted apache, and the problem is now fixed. Thanks!

[Remy Blank]

Thanks for the feedback.