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
>
--
Evolution: Taking care of those too stupid to take care of themselves.
_______________________________________________
Trac mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac
