[Trac] TracTags 0.3.1 +postgres -> needs ticket? [going OT]

Tim Diggins Tue, 18 Apr 2006 03:04:16 -0700

Hi -

I seem to have a similar issue... did this patch resolve it?

Should this issue have a ticket somewhere - onhttp://muness.textdriven.com/trac/? (is that the right place fortrac-tags tickets? what component etc. to use?)


thanks

Tim


Alec Thomas wrote:

Well, I answered my own question by installing Postgres. The boys on
#postgresql educated me to the fact that you can not refer to a column
alias in the WHERE clause. Annoying, but there you have it. It appears
it is just a lack of strictness on SQLite's part that allows it to work.

Please try this patch:

    Index: tractags/ticket.py
    ===================================================================
    --- tractags/ticket.py  (revision 230)
    +++ tractags/ticket.py  (working copy)
    @@ -29,7 +29,7 @@
             tags = set(tags)
             names = set(names)
             args = []
    -        sql = "SELECT id, %s, %s AS allfields FROM ticket" % 
(','.join(self.fields),
    +        sql = "SELECT * FROM (SELECT id, %s, %s AS allfields FROM ticket) 
s" % (','.join(self.fields),
                 '||'.join(["COALESCE(%s, '')" % f for f in self.fields]))
             constraints = []
             if names:

If anybody is running the MySQL patches, I'd be interested to know
whether this works, specifically under 4.1.12 (the lowest supported
version).

On Tue, Apr 11, 2006 at 12:24:57PM +1000, Alec Thomas wrote:

James,

Are you using Postgres?

Also, try adding this line:

  self.env.log.debug(sql % tuple(args))

just before

  cursor.execute(sql, args)

in ticket.py. Then reply with the log message.

Alec

On Tue, 11 Apr 2006 03:29:49 +0200 (SAST), "James B. Byrne" <[EMAIL PROTECTED]> 
wrote:

I checked the file sizes and discovered that the TracTags egg was
supiciously small.  Apparently using curl to fetch the tags egg using the
link provided just fetches another html page.  One must actually traverse
the link first in a browser and then use the alternate file url to
retrieve the actual egg using curl.

So, I fixed that, adjusted the trac.ini file, ran trac-admin tracenv
update --no-backup, and finally restarted the httpd server. Now tags are
partially working.  There are two problems that I have encountered so far.
 One is when folowing the tag index link from the wiki page header and
then following a tag index entry url I see this:


Oops...
Trac detected an internal error:

column "allfields" does not exist

If you think this really should work and you can reproduce it. Then you
should consider to report this problem to the Trac team.

Go to http://trac.edgewall.com/ and create a new ticket where you describe
the problem, how to reproduce it. Don't forget to include the python
traceback found below.

TracGuide — The Trac User and Administration Guide
Python traceback

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 "build\bdist.win32\egg\tractags\web_ui.py", line 176, in
process_request
  File "build\bdist.win32\egg\tractags\macros.py", line 203, in
render_listtagged
  File "build\bdist.win32\egg\tractags\api.py", line 330, in
get_tagged_names
  File "build\bdist.win32\egg\tractags\api.py", line 280, in
walk_tagged_names
  File "build\bdist.win32\egg\tractags\ticket.py", line 44, in
walk_tagged_names
ProgrammingError: column "allfields" does not exist


The other problem is when following the (view all tags) link from ta wiki
edit page I see this:


Error

No handler matched request to //tags

TracGuide — The Trac User and Administration Guide

Trac.log:
21:22:01 Trac[main] ERROR: column "allfields" does not exist
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 "build\bdist.win32\egg\tractags\web_ui.py", line 176, in
process_request
  File "build\bdist.win32\egg\tractags\macros.py", line 203, in
render_listtagged
  File "build\bdist.win32\egg\tractags\api.py", line 330, in
get_tagged_names
  File "build\bdist.win32\egg\tractags\api.py", line 280, in
walk_tagged_names
  File "build\bdist.win32\egg\tractags\ticket.py", line 44, in
walk_tagged_names
ProgrammingError: column "allfields" does not exist

21:23:18 Trac[main] ERROR: No handler matched request to //tags
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 104, in
dispatch
    raise TracError, 'No handler matched request to %s' % req.path_info
TracError: No handler matched request to //tags



Geting closer to success I think.

Regards,
Jim

_______________________________________________
Trac mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac


_______________________________________________
Trac mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac

[Trac] TracTags 0.3.1 +postgres -> needs ticket? [going OT]

Reply via email to