Custom query module throws error

[mrenzmann@…]

I'm logged in as user with TRAC_ADMIN permission. When I go to "View Tickets ⇒ Custom Query" I get:

2008-10-28 08:23:32,873 Trac[main] ERROR: no such column: t.statis
Traceback (most recent call last):
  File "/usr/lib/python2.5/site-packages/Trac-0.11stable_r7613-py2.5.egg/trac/web/main.py", line 432, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.5/site-packages/Trac-0.11stable_r7613-py2.5.egg/trac/web/main.py", line 204, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.5/site-packages/Trac-0.11stable_r7613-py2.5.egg/trac/ticket/query.py", line 823, in process_request
    return self.display_html(req, query)
  File "/usr/lib/python2.5/site-packages/Trac-0.11stable_r7613-py2.5.egg/trac/ticket/query.py", line 876, in display_html
    tickets = query.execute(req, db)
  File "/usr/lib/python2.5/site-packages/Trac-0.11stable_r7613-py2.5.egg/trac/ticket/query.py", line 261, in execute
    self.num_items = self._count(sql, args, db)
  File "/usr/lib/python2.5/site-packages/Trac-0.11stable_r7613-py2.5.egg/trac/ticket/query.py", line 246, in _count
    cursor.execute(count_sql, args);
  File "/usr/lib/python2.5/site-packages/Trac-0.11stable_r7613-py2.5.egg/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.5/site-packages/Trac-0.11stable_r7613-py2.5.egg/trac/db/sqlite_backend.py", line 58, in execute
    args or [])
  File "/usr/lib/python2.5/site-packages/Trac-0.11stable_r7613-py2.5.egg/trac/db/sqlite_backend.py", line 50, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: no such column: t.statis

I verified that this is not caused by any of the plugins I have installed, by disabling all of them (with the only exception being the TracAccountManager plugin).

Version information as per the web-version of the traceback:

Trac:        0.11stable-r7613
Python:      2.5.2 (r252:60911, Sep 29 2008, 21:31:01) [GCC 4.3.2]
setuptools:  0.6c8
SQLite:      3.5.9
pysqlite:    2.4.1
Genshi:      0.5.1
Pygments:    0.10
Subversion:  1.5.1 (r32289)
jQuery:	     1.2.6

Trac is served by Apache 2.2 with mod_wsgi.

Not sure if the following matters at all, but anyway:

The environment was originally created with Trac 0.10.4. I have migrated it to a different server which uses Trac 0.11.1. Today I have installed a snapshot of 0.11-stable branch (r7613). Unfortunately I did not check the custom query functionality before installing the snapshot today - it might well be that the issue also existed before.

[Christian Boos]

Any idea where this "statis" comes from?

Could you grep the installed sources to locate it (it's not in the repo).

[Christian Boos]

Could it be a custom field mistaken for a standard field?

Can you post:

• your [ticket-custom] section from your trac.ini?
• the query url that you used for triggering the error?

[mrenzmann@…]

Replying to cboos:

Any idea where this "statis" comes from?

Nope, unfortunately not.

Could you grep the installed sources to locate it (it's not in the repo).

Did that, and couldn't find statis anywhere. Not in any of the sources of the various Trac versions I've been using with this environment, nor in the sources of any of the plugins that I've been or still am using.

[mrenzmann@…]

Replying to cboos:

Can you post:

• your [ticket-custom] section from your trac.ini?

There is no such section in the trac.ini for the environment in question.

• the query url that you used for triggering the error?

​http://crabl.org/query

[Christian Boos]

Replying to mrenzmann@…:

Replying to cboos:

Can you post:

• your [ticket-custom] section from your trac.ini?

There is no such section in the trac.ini for the environment in question.

Don't forget to look into the inheritance chain (i.e. look in your [inherit] file =... ini file, and if that one has an [inherit] section, repeat).

• the query url that you used for triggering the error?

​http://crabl.org/query

The default query seems misconfigured at the moment, but when creating a valid one it works. So again, what was the exact URL which triggered the problem?

[mrenzmann@…]

Replying to cboos:

Don't forget to look into the inheritance chain (i.e. look in your [inherit] file =... ini file, and if that one has an [inherit] section, repeat).

The inherit section looks like:

[inherit]
plugins_dir =
templates_dir =

No other entries.

​http://crabl.org/query

The default query seems misconfigured at the moment,

Doh! Indeed, you're right:

[query]
default_anonymous_query = status!=closed&&cc~=$USER
default_query = statis!=closed&owner=$USER
items_per_page = 100

default_query is where statis turns up. Obviously that's been a layer-8-issue. Sorry for the noise and the trouble I've caused. :-(