Matthew Good skrev:
> In DB version 17 the columns "kind" and "change" in the table
> "node_change" were renamed to "node_type" and "change_type"
> respectively. You will need to change them back so the queries used in
> 0.9.5 will work.
Seems like I am missing another column "sql", as shown by the trace
quoted below.
Digging through the code I have found that the report table has a definition
CREATE TABLE report (
id integer PRIMARY KEY,
author text,
title text,
query text,
description text
);
Judging from the source code the "query" column really should be "sql"
instead.
My first guess was that I have missed a db upgrade script somewhere
along the way but looking through the available scripts (using "grep -i
report") I cannot find something that seems relevant.
Of course I can change this by creating my own upgrade script but I
don't understand how trac ended up in this state since the tracs checks
the database_version at runtime. (Maybe this is a new feature?)
Looking through the db_default.py and trac-admin it seems like the there
has never been a column called query...
Does anybody know what's going on?
Sincerely,
Christoffer Soop
Traceback (most recent call last):
File
"/usr/lib/python2.3/site-packages/trac/web/modpython_frontend.py", line
206, in handler
dispatch_request(mpr.path_info, mpr, env)
File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 139, in
dispatch_request
dispatcher.dispatch(req)
File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 107, in
dispatch
resp = chosen_handler.process_request(req)
File "/usr/lib/python2.3/site-packages/trac/ticket/report.py", line
113, in process_request
resp = self._render_view(req, db, id)
File "/usr/lib/python2.3/site-packages/trac/ticket/report.py", line
253, in _render_view
title, description, sql = self.get_info(db, id, args)
File "/usr/lib/python2.3/site-packages/trac/ticket/report.py", line
427, in get_info
"WHERE id=%s", (id,))
File "/usr/lib/python2.3/site-packages/trac/db.py", line 219, in execute
args or [])
File "/usr/lib/python2.3/site-packages/trac/db.py", line 211, in
_rollback_on_error
return function(self, *args, **kwargs)
OperationalError: no such column: sql
_______________________________________________
Trac mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac
