OperationalError: ambiguous column name: id

[admin]

Upgraded from 1.0 to 1.2.3. Now, most of the time custom queries works Ok, but at random interval custom queryies give below error.

How to Reproduce

While doing a GET operation on /query, Trac issued an internal error.

(please provide additional details here)

Request parameters:

{u'col': [u'id',
          u'summary',
          u'owner',
          u'status',
          u'doc_title',
          u'doc_revision',
          u'doc_revdate',
          u'doc_tag',
          u'doc_author',
          u'doc_reviewer',
          u'doc_approver'],
 u'group': u'status',
 u'order': u'priority',
 u'report': u'12',
 u'type': u'Document'}

User agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:62.0) Gecko/20100101 Firefox/62.0

System Information

Trac	1.2.3
Babel	1.3
Docutils	0.12
Genshi	0.7 (with speedups)
Pygments	2.0.1
pysqlite	2.6.0
Python	2.7.9 (default, Apr 2 2015, 15:33:21) [GCC 4.9.2]
pytz	2014.10
setuptools	18.0.1
SQLite	3.8.7.4
Subversion	1.8.10 (r1615264)
jQuery	1.11.3
jQuery UI	1.11.4
jQuery Timepicker	1.5.5

Enabled Plugins

graphviz	0.7.7dev-r0
KeepInterfaceSimple2Plugin	2.5
MultipleWorkflowPlugin	1.4.1
OdtExportPlugin	0.7.dev0
parameterizedincludemacro	N/A
TicketImport	0.9.0
TracCustomFieldAdmin	0.2.12
TracMasterTickets	4.0.2
TracMathJax	0.4
TracMultiSelectField	1.0.1.post0
TracSQL	0.3
TracWysiwyg	0.12.0.5.post0
Wikinfo	0.2dev-r0
WikiTableMacro	0.3.dev0

Interface Customization

shared-htdocs
shared-templates
site-htdocs	logo.png
site-templates	site.html

Python Traceback

Traceback (most recent call last):
  File "build/bdist.linux-x86_64/egg/trac/web/main.py", line 647, in _dispatch_request
    dispatcher.dispatch(req)
  File "build/bdist.linux-x86_64/egg/trac/web/main.py", line 248, in dispatch
    resp = chosen_handler.process_request(req)
  File "build/bdist.linux-x86_64/egg/trac/ticket/query.py", line 1016, in process_request
    return self.display_html(req, query)
  File "build/bdist.linux-x86_64/egg/trac/ticket/query.py", line 1122, in display_html
    tickets = query.execute(req, cached_ids=orig_list)
  File "build/bdist.linux-x86_64/egg/trac/ticket/query.py", line 303, in execute
    self.num_items = self._count(sql, args)
  File "build/bdist.linux-x86_64/egg/trac/ticket/query.py", line 284, in _count
    % sql, args)[0][0]
  File "build/bdist.linux-x86_64/egg/trac/db/api.py", line 122, in execute
    return db.execute(query, params)
  File "build/bdist.linux-x86_64/egg/trac/db/util.py", line 128, in execute
    cursor.execute(query, params if params is not None else [])
  File "build/bdist.linux-x86_64/egg/trac/db/util.py", line 72, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "build/bdist.linux-x86_64/egg/trac/db/sqlite_backend.py", line 88, in execute
    result = PyFormatCursor.execute(self, *args)
  File "build/bdist.linux-x86_64/egg/trac/db/sqlite_backend.py", line 64, in execute
    args or [])
  File "build/bdist.linux-x86_64/egg/trac/db/sqlite_backend.py", line 55, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: ambiguous column name: id

[Jun Omae]

A duplicate of #13068.