Edgewall Software

Opened 3 years ago

Closed 3 years ago

#13204 closed defect (cantfix)

ProgrammingError: Incorrect number of bindings supplied. The current statement uses 0, and there are 1 supplied.

Reported by: anonymous Owned by:
Priority: normal Milestone:
Component: general Version:
Severity: normal Keywords: needinfo
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:


How to Reproduce

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

Immediately before that I had enabled Ticket Deleter component, deleted a comment in that ticket, disabled Ticket Deleter component again, then tried to refresh the tab of that ticket. I got this error twice. Then it worked again.

Request parameters:

{'id': u'4313'}

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

System Information

Trac 1.5.1dev
Jinja2 2.9.6
Mercurial 4.6
Pygments 2.0.2
pysqlite 2.6.0
Python 2.7.9
setuptools 7.0
SQLite 3.6.21
jQuery 1.12.4
jQuery UI 1.12.1
jQuery Timepicker 1.6.3

Enabled Plugins


Interface Customization

site-htdocs common, site, site.css
site-templates site_head.html

Python Traceback

Traceback (most recent call last):
  File "build\bdist.win32\egg\trac\web\main.py", line 611, in dispatch_request
  File "build\bdist.win32\egg\trac\web\main.py", line 250, in dispatch
    resp = chosen_handler.process_request(req)
  File "build\bdist.win32\egg\trac\ticket\web_ui.py", line 161, in process_request
    return self._process_ticket_request(req)
  File "build\bdist.win32\egg\trac\ticket\web_ui.py", line 694, in _process_ticket_request
    get_reporter_id(req, 'author'), field_changes)
  File "build\bdist.win32\egg\trac\ticket\web_ui.py", line 1687, in _insert_ticket_data
    self._get_action_controls(req, ticket)
  File "build\bdist.win32\egg\trac\ticket\web_ui.py", line 436, in _get_action_controls
    req, ticket, action)
  File "build\bdist.win32\egg\trac\ticket\default_workflow.py", line 325, in render_ticket_action_control
    resolutions = [r.name for r in Resolution.select(self.env)]
  File "build\bdist.win32\egg\trac\ticket\model.py", line 878, in select
  File "build\bdist.win32\egg\trac\db\util.py", line 129, in execute
    cursor.execute(query, params if params is not None else [])
  File "build\bdist.win32\egg\trac\db\util.py", line 73, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "build\bdist.win32\egg\trac\db\sqlite_backend.py", line 87, in execute
    result = PyFormatCursor.execute(self, *args)
  File "build\bdist.win32\egg\trac\db\sqlite_backend.py", line 63, in execute
    args or [])
  File "build\bdist.win32\egg\trac\db\sqlite_backend.py", line 54, in _rollback_on_error
    return function(self, *args, **kwargs)
ProgrammingError: Incorrect number of bindings supplied. The current statement uses 0, and there are 1 supplied.

Attachments (1)

trac.log (21.1 KB ) - added by Ryan J Ollos 3 years ago.

Download all attachments as: .zip

Change History (4)

comment:1 by anonymous, 3 years ago

The log file contained more similar errors: trac.log. But none since I restarted the web server.

Last edited 3 years ago by Ryan J Ollos (previous) (diff)

by Ryan J Ollos, 3 years ago

Attachment: trac.log added

comment:2 by Jun Omae, 3 years ago

Keywords: needinfo added

Unable to reproduce it, however too weird.

Please try to upgrade to TracMercurial== via PyPI, e.g. pip install -U TracMercurial== If not fixed, please post trac.log with DEBUG level.

comment:3 by Ryan J Ollos, 3 years ago

Resolution: cantfix
Status: newclosed

Closing since there was no follow-up.

Modify Ticket

Change Properties
Set your email in Preferences
as closed The ticket will remain with no owner.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from (none) to the specified user.

Add Comment

E-mail address and name can be saved in the Preferences .
Note: See TracTickets for help on using tickets.