Opened 2 years ago

Last modified 21 months ago

defect #122 (new)

Error: no such column: priority

Test Complete Size: undefined Test Complete Date:
Documentation Complete Size: undefined Documentation Complete Date:
Acceptance Complete Size: undefined Acceptance Complete Date:
Reported by: Jens Owned by: ja11sop
Milestone: Undecided Component: agiletracplugin
Version: Plugin 0.1.7 Keywords: sqlite priority column install
Cc: Blocked By:
Patch SVN Revision: Patch Trac Version: not_applicable
Blocking:
In Iterations: None

Description

Installed agile-trac and replaced trac site-package with the one on agile-trac svn repo. But I get the following error when trying to view pages like tickets, roadmap and iterations. 

Trac detected an internal error:
   OperationalError: no such column: priority

Python Traceback

Most recent call last:
File "/usr/lib/python2.5/site-packages/Trac-0.11.5-py2.5.egg/trac/web/main.py", line 444, in _dispatch_request
File "/usr/lib/python2.5/site-packages/Trac-0.11.5-py2.5.egg/trac/web/main.py", line 205, in dispatch
File "/usr/lib/python2.5/site-packages/Trac-0.11.5-py2.5.egg/trac/ticket/roadmap.py", line 388, in process_request
File "/usr/lib/python2.5/site-packages/Trac-0.11.5-py2.5.egg/trac/ticket/api.py", line 206, in get_ticket_fields
File "/usr/lib/python2.5/site-packages/Trac-0.11.5-py2.5.egg/trac/ticket/api.py", line 253, in _get_ticket_fields
File "/usr/lib/python2.5/site-packages/Trac-0.11.5-py2.5.egg/trac/ticket/model.py", line 943, in select
File "/usr/lib/python2.5/site-packages/Trac-0.11.5-py2.5.egg/trac/db/util.py", line 60, in execute
File "/usr/lib/python2.5/site-packages/Trac-0.11.5-py2.5.egg/trac/db/sqlite_backend.py", line 58, in execute
File "/usr/lib/python2.5/site-packages/Trac-0.11.5-py2.5.egg/trac/db/sqlite_backend.py", line 50, in _rollback_on_error

The problem occurs in both 0.2.0 and 0.3.0, both in a new trac project, and upgraded. 

System Information:

User Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_6_1; en-us) AppleWebKit/531.9 (KHTML, like Gecko) Version/4.0.3 Safari/531.9

Trac:	0.11.5
Python:	2.5.2 (r252:60911, Jul 22 2009, 15:50:42) [GCC 4.2.4 (Ubuntu 4.2.4-1ubuntu3)]
setuptools:	0.6c9
SQLite:	3.4.2
pysqlite:	2.4.0
Genshi:	0.6dev-r1064
mod_python:	3.3.1
Pygments:	1.0
RPC:	1.0.6
GIT:	1.5.4.3
jQuery:	1.2.6

Change History

Have a look at the list of modified files related to this ticket.

Changed 2 years ago by Jens

Error seems to originate from conflicting plugins or invalid trac.ini.

Changed 2 years ago by ja11sop

Thanks for raising this issue. Due to the 'patch' nature of Agile-Trac I'd suggest trying the install instructions on a clean trac without other plugins (though we run it fine with a number of plugins). If you enable logging in trac and can provide that it might also help. Make sure the installation order is followed also as simply patching is not enough.

Changed 21 months ago by SD

Hi, I'm experiencing the same problem ("no such column: priority").

I'm attempting to install Agile "plugin" to an existing Trac 0.11.6 instance. As per instructions, replaced "/usr/lib/python2.4/site-packages/Trac-0.11.6-py2.4.egg/trac" with SVN r329 of Agile-ified Trac 0.11.6 codebase, modified my trac.ini as per instructions, and ran "trac-admin /path/to/project upgrade" with output: 

Database is up to date, no upgrade necessary.

When restarting Apache (serving Trac using mod_python and not Trac's own server) and going into Trac instance, I see the "iterations" tab has been added. However, instead of "view work" and "new work", those tabs are still named "view tickets" and "new ticket".

When accessing those areas, the "no such column: priority" error is given.

Plugins that were already installed:
- PrivateWikis 1.0.0
- TracMercurial 0.11.0.8
- TracPermRedirect 2.0

Any help / advice besides installation into a clean Trac instance would be appreciated (I can verify that installing into a new Trac instance works fine - but I have an existing Trac instance with many existing tickets and wiki entries and I don't wish to export / import those into a new instance unless absolutely necessary).

Cheers

System info: 

Trac:  	0.11.6
Python: 	2.4.3 (#1, Sep 3 2009, 15:37:12) [GCC 4.1.2 20080704 (Red Hat 4.1.2-46)]
setuptools: 	0.6c5
SQLite: 	3.3.6
pysqlite: 	2.3.3
Genshi: 	0.5.1
mod_python: 	3.2.8
Mercurial: 	1.3.1
jQuery:	1.2.6
Note: See TracTickets for help on using tickets.