Hi everyone, I fixed my trouble described below : the root cause was that the query strings (configured in the trac.ini) were embrassed with double quote instead of single quote. Single quote works well.
Now, I expected to have a "add" button to add a new "task" from the TaskList front end, but I've got nothing such. Any idea ? thanks gabriel [EMAIL PROTECTED] a écrit : > Hi everyone, > > I'm trying to install the TaskList plugin > http://trac-hacks.org/wiki/TaskListPlugin > but I get the following error message while clicking on the "Ticket" > in the nav bar: > > 2008-04-17 22:31:50,108 Trac[query] DEBUG: Query SQL: SELECT t.id AS > id,t.summary AS summary,t.priority AS priority,t.time AS > time,t.changetime AS changetime,t.amp;owner AS amp;owner,t."status AS > "status,priority.value AS priority_value,action_item.value AS > action_item > FROM ticket AS t > LEFT OUTER JOIN ticket_custom AS action_item ON > (id=action_item.ticket AND action_item.name='action_item') > LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND > priority.name=priority) > WHERE COALESCE(t.amp;owner,'')=u'toto"' AND COALESCE(t."status,'')! > =u'closed' > ORDER BY COALESCE(t.priority,'')='',priority.value,t.id > 2008-04-17 22:31:50,108 Trac[main] ERROR: no such column: t.id > Traceback (most recent call last): > File "c:\python25\lib\site-packages\Trac-0.11dev_r6814-py2.5.egg\trac > \web\main.py", line 417, in _dispatch_request > dispatcher.dispatch(req) > File "c:\python25\lib\site-packages\Trac-0.11dev_r6814-py2.5.egg\trac > \web\main.py", line 197, in dispatch > resp = chosen_handler.process_request(req) > File "build\bdist.win32\egg\tasklist\main.py", line 159, in > process_request > template, data, mime_type = self.display_html(req, query) > File "c:\python25\lib\site-packages\Trac-0.11dev_r6814-py2.5.egg\trac > \ticket\query.py", line 715, in display_html > tickets = query.execute(req, db) > File "c:\python25\lib\site-packages\Trac-0.11dev_r6814-py2.5.egg\trac > \ticket\query.py", line 199, in execute > cursor.execute(sql, args) > File "c:\python25\lib\site-packages\Trac-0.11dev_r6814-py2.5.egg\trac > \db\util.py", line 50, in execute > return self.cursor.execute(sql_escape_percent(sql), args) > File "c:\python25\lib\site-packages\Trac-0.11dev_r6814-py2.5.egg\trac > \db\sqlite_backend.py", line 58, in execute > args or []) > File "c:\python25\lib\site-packages\Trac-0.11dev_r6814-py2.5.egg\trac > \db\sqlite_backend.py", line 50, in _rollback_on_error > return function(self, *args, **kwargs) > OperationalError: no such column: t.id > > > Can someone (pacopablo I guess) help me to fix that ? > I'm using the trac0.11 (from trunk), genshi0.5 trunk and no other > plugin. May be I miss one. > > thanks in advance > > gabriel > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~----------~----~----~----~------~----~------~--~---
