id	summary	reporter	owner	description	type	status	priority	component	severity	resolution	keywords	cc	release
6180	Downloader: SQL errors when accessing stats pages (and stats admin pages)	muenchen@…	Petr Škoda	"When accessing the time stats, file stats, release stats or category stats pages in Downloader, OR when accessing the stats admin page of the Downloader, an sql error occurs. I manually checked in my sqlite db file, the tables are there.

The example shows when accessing Admin -> Downloader -> stats admin:
{{{
OperationalError: no such column: c.id

File ""usr/pkg/lib/python2.5/site-packages/trac/web/main.py"", line 423, in _dispatch_request
  dispatcher.dispatch(req)
File ""usr/pkg/lib/python2.5/site-packages/trac/web/main.py"", line 197, in dispatch
  resp = chosen_handler.process_request(req)
File ""usr/pkg/lib/python2.5/site-packages/trac/admin/web_ui.py"", line 114, in process_request
  path_info)
File ""build/bdist.netbsd-5.0.1_PATCH-amd64/egg/tracdownloader/admin.py"", line 137, in process_admin_requestFile ""build/bdist.netbsd-5.0.1_PATCH-amd64/egg/tracdownloader/admin.py"", line 229, in _serve_stats_adminFile ""build/bdist.netbsd-5.0.1_PATCH-amd64/egg/tracdownloader/admin.py"", line 383, in _render_stats_tableFile ""build/bdist.netbsd-5.0.1_PATCH-amd64/egg/tracdownloader/model.py"", line 987, in fetch_downloads_listFile ""usr/pkg/lib/python2.5/site-packages/trac/db/util.py"", line 50, in execute
  return self.cursor.execute(sql_escape_percent(sql), args)
File ""usr/pkg/lib/python2.5/site-packages/trac/db/sqlite_backend.py"", line 58, in execute
  args or [])
File ""usr/pkg/lib/python2.5/site-packages/trac/db/sqlite_backend.py"", line 50, in _rollback_on_error
  return function(self, *args, **kwargs)
}}}

{{{
System Information:

User Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.22pre) Gecko/20090327 Ubuntu/8.04 (hardy) Firefox/2.0.0.22pre
Trac: 	0.11
Python: 	2.5.4 (r254:67916, Aug 11 2009, 15:28:54) [GCC 4.1.3 20080704 prerelease (NetBSD nb2 20081120)]
setuptools: 	0.6c9
SQLite: 	3.6.16
pysqlite: 	2.5.5
Genshi: 	0.5.1
mod_python: 	3.3.1
Pygments: 	1.0
Subversion: 	1.6.5 (r38866)
jQuery:	1.2.3
}}}"	defect	new	normal	TracDownloaderPlugin	major		stats		0.11