Bug Tracker

Modify

Ticket #3136 (closed bug: fixed)

Opened 5 years ago

Last modified 4 years ago

Unable to perform a custom query in bug tracker

Reported by: genezys Owned by: john
Priority: major Milestone: 1.3
Component: web Version: 1.2.6
Keywords: Cc:
Blocking: Blocked by:

Description

How to Reproduce

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

I clicked the Custom Query link in the View Tickets tab while logged in.

System Information

Trac 0.11dev-r5354
Python 2.3.4 (#1, Oct 11 2006, 06:18:43)
[GCC 3.4.6 20060404 (Red Hat 3.4.6-3)]
setuptools 0.6c5
MySQL server: "5.0.27-log", client: "5.0.27", thread-safe: 0
MySQLdb 1.2.2
Genshi 0.4
Subversion 1.4.3 (r23084)

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.3/site-packages/Trac-0.11dev_r5354-py2.3.egg/trac/web/main.py", line 429, in dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.3/site-packages/Trac-0.11dev_r5354-py2.3.egg/trac/web/main.py", line 234, in dispatch
    req.session.save()
  File "/usr/lib/python2.3/site-packages/Trac-0.11dev_r5354-py2.3.egg/trac/web/session.py", line 184, in save
    "VALUES(%s,%s,%s,%s)", attrs)
  File "/usr/lib/python2.3/site-packages/Trac-0.11dev_r5354-py2.3.egg/trac/db/util.py", line 57, in executemany
    return self.cursor.executemany(sql_escape_percent(sql), args)
  File "/usr/lib/python2.3/site-packages/Trac-0.11dev_r5354-py2.3.egg/trac/db/util.py", line 57, in executemany
    return self.cursor.executemany(sql_escape_percent(sql), args)
  File "build/bdist.linux-i686/egg/MySQLdb/cursors.py", line 218, in executemany
  File "build/bdist.linux-i686/egg/MySQLdb/cursors.py", line 312, in _query
  File "build/bdist.linux-i686/egg/MySQLdb/cursors.py", line 276, in _do_query
IntegrityError: (1062, "Duplicate entry 'genezys-1-query_constrain' for key 1")

Change History

comment:1 Changed 5 years ago by flesler

  • Owner changed from joern to john

comment:2 Changed 4 years ago by john

  • Status changed from new to closed
  • Resolution set to fixed

This should be fixed now.

Please follow the  bug reporting guidlines and use  jsFiddle when providing test cases and demonstrations instead of pasting the code in the ticket.

View

Add a comment

Modify Ticket

Action
as closed
Author


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

 
Note: See TracTickets for help on using tickets.