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

[anonymous]

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

tracmercurial

1.0.0.9dev

Interface Customization

shared-htdocs
shared-templates
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
    dispatcher.dispatch(req)
  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
    (cls.type,)):
  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.

[anonymous]

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

[Jun Omae]

Unable to reproduce it, however too weird.

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

[Ryan J Ollos]

Closing since there was no follow-up.