Opened 5 years ago

Closed 5 years ago

#13528 closed defect (cantfix)

OperationalError: (1052, "Column 'id' in where clause is ambiguous")

Reported by: hambardzum Owned by: bphinz
Priority: high Component: TicketFieldsPlugin
Severity: major Keywords:
Cc: Trac Release: 1.2


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'order': u'due_date',
 u'owner': u'hayk_h',
 u'status': [u'accepted', u'assigned', u'new', u'reopened']}

User agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 Safari/537.36

System Information

Trac 1.2.3
Babel 0.9.6
Genshi 0.7 (with speedups)
mod_wsgi 3.4 (WSGIProcessGroup WSGIApplicationGroup trac-new.instigate.local|/instigate)
MySQL server: "5.6.43", client: "5.6.43", thread-safe: 1
MySQLdb 1.2.5
Python 2.7.5 (default, Oct 30 2018, 23:45:53)
[GCC 4.8.5 20150623 (Red Hat 4.8.5-36)]
setuptools 0.9.8
Subversion 1.7.14 (r1542130)
jQuery 1.11.3
jQuery UI 1.11.4
jQuery Timepicker 1.5.5

Enabled Plugins

AllAttachmentsMacro 0.2
AttachmentPolicyPlugin 0.1.0
BreadCrumbsNav 0.3
DefaultCc 0.4dev
mail2trac 1.0
TicketReminderPlugin 0.2.1
TicketValidator 0.2dev
TracAccountManager 0.4.4
TracAutocompleteUsersPlugin 0.4.4dev
TracAwesomeAttachments 0.4dev
TracCustomFieldAdmin 0.2.13
TracEstimationTools 0.5.0dev
TracIniAdmin 0.4
TracStats 0.6.1
TracSubTicketsPlugin 0.5.4dev
TracTicketTemplate 1.0dev

Interface Customization

site-htdocs fetchmail, ins.png, instigate.png, instigatedesign.png, old_instigatedesign.png, site.js, style.css, theme.css
site-templates site.html

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.7/site-packages/Trac-1.2.3-py2.7.egg/trac/web/", line 647, in _dispatch_request
  File "/usr/lib/python2.7/site-packages/Trac-1.2.3-py2.7.egg/trac/web/", line 248, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.7/site-packages/Trac-1.2.3-py2.7.egg/trac/ticket/", line 1016, in process_request
    return self.display_html(req, query)
  File "/usr/lib/python2.7/site-packages/Trac-1.2.3-py2.7.egg/trac/ticket/", line 1122, in display_html
    tickets = query.execute(req, cached_ids=orig_list)
  File "/usr/lib/python2.7/site-packages/Trac-1.2.3-py2.7.egg/trac/ticket/", line 303, in execute
    self.num_items = self._count(sql, args)
  File "/usr/lib/python2.7/site-packages/Trac-1.2.3-py2.7.egg/trac/ticket/", line 284, in _count
    % sql, args)[0][0]
  File "/usr/lib/python2.7/site-packages/Trac-1.2.3-py2.7.egg/trac/db/", line 122, in execute
    return db.execute(query, params)
  File "/usr/lib/python2.7/site-packages/Trac-1.2.3-py2.7.egg/trac/db/", line 128, in execute
    cursor.execute(query, params if params is not None else [])
  File "/usr/lib/python2.7/site-packages/Trac-1.2.3-py2.7.egg/trac/db/", line 72, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib64/python2.7/site-packages/MySQLdb/", line 205, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib64/python2.7/site-packages/MySQLdb/", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
OperationalError: (1052, "Column 'id' in where clause is ambiguous")

Attachments (0)

Change History (1)

comment:1 Changed 5 years ago by Jun Omae

Resolution: cantfix
Status: newclosed

The issue is a Trac issue, trac:#13068. Please try Trac 1.2.2 or 1.2-stable.

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain bphinz.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment

E-mail address and name can be saved in the Preferences.

Note: See TracTickets for help on using tickets.