Context Navigation

Modify ↓

#8449 closed defect (invalid)

InterfaceError: Error binding parameter 0 - probably unsupported type.

Reported by:	boooch	Owned by:
Priority:	normal	Milestone:
Component:	general	Version:	0.11.1
Severity:	normal	Keywords:	UserManagerPlugin
Cc:		Branch:
Release Notes:
API Changes:
Internal Changes:

Description

How to Reproduce

I have just install UserManagerPlugin.When I want click to Users I have an error:

While doing a GET operation on /admin/accounts/users, Trac issued an internal error.

(please provide additional details here)

Request parameters:

{'cat_id': u'accounts', 'panel_id': u'users', 'path_info': None}

User Agent was: Opera/9.63 (Windows NT 5.1; U; ru) Presto/2.1.1

System Information

Trac	`0.11.1`
Python	`2.5.2 (r252:60911, Aug 8 2008, 09:22:44)` `[GCC 4.3.1]`
setuptools	`0.6c9`
SQLite	`3.5.9`
pysqlite	`2.4.1`
Genshi	`0.5`
Pygments	`0.10`
Subversion	`1.5.1 (r32289)`
jQuery:	`1.2.6`

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.5/site-packages/trac/web/main.py", line 423, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.5/site-packages/trac/web/main.py", line 219, in dispatch
    data, content_type)
  File "/usr/lib/python2.5/site-packages/trac/web/chrome.py", line 715, in render_template
    return stream.render(method, doctype=doctype)
  File "/var/lib/python-support/python2.5/genshi/core.py", line 179, in render
    return encode(generator, method=method, encoding=encoding, out=out)
  File "/var/lib/python-support/python2.5/genshi/output.py", line 60, in encode
    return _encode(u''.join(list(iterator)))
  File "/var/lib/python-support/python2.5/genshi/output.py", line 311, in __call__
    for kind, data, pos in stream:
  File "/var/lib/python-support/python2.5/genshi/output.py", line 753, in __call__
    for kind, data, pos in stream:
  File "/var/lib/python-support/python2.5/genshi/output.py", line 592, in __call__
    for kind, data, pos in stream:
  File "/var/lib/python-support/python2.5/genshi/output.py", line 698, in __call__
    for kind, data, pos in chain(stream, [(None, None, None)]):
  File "/var/lib/python-support/python2.5/genshi/output.py", line 532, in __call__
    for ev in stream:
  File "/var/lib/python-support/python2.5/genshi/core.py", line 283, in _ensure
    for event in stream:
  File "/var/lib/python-support/python2.5/genshi/core.py", line 283, in _ensure
    for event in stream:
  File "/usr/lib/python2.5/site-packages/trac/web/chrome.py", line 767, in _strip_accesskeys
    for kind, data, pos in stream:
  File "/var/lib/python-support/python2.5/genshi/core.py", line 283, in _ensure
    for event in stream:
  File "/usr/lib/python2.5/site-packages/trac/web/chrome.py", line 756, in _generate
    for kind, data, pos in stream:
  File "/var/lib/python-support/python2.5/genshi/core.py", line 283, in _ensure
    for event in stream:
  File "/var/lib/python-support/python2.5/genshi/core.py", line 283, in _ensure
    for event in stream:
  File "/var/lib/python-support/python2.5/genshi/filters/transform.py", line 686, in _unmark
    for mark, event in stream:
  File "build/bdist.linux-i686/egg/timingandestimationplugin/tande_filters.py", line 60, in __call__
    for mark, event in stream:
  File "/var/lib/python-support/python2.5/genshi/filters/transform.py", line 713, in __call__
    for mark, event in stream:
  File "/var/lib/python-support/python2.5/genshi/filters/transform.py", line 682, in _mark
    for event in stream:
  File "/var/lib/python-support/python2.5/genshi/core.py", line 283, in _ensure
    for event in stream:
  File "/var/lib/python-support/python2.5/genshi/filters/transform.py", line 686, in _unmark
    for mark, event in stream:
  File "build/bdist.linux-i686/egg/timingandestimationplugin/tande_filters.py", line 60, in __call__
    for mark, event in stream:
  File "/var/lib/python-support/python2.5/genshi/filters/transform.py", line 713, in __call__
    for mark, event in stream:
  File "/var/lib/python-support/python2.5/genshi/filters/transform.py", line 682, in _mark
    for event in stream:
  File "/var/lib/python-support/python2.5/genshi/template/base.py", line 569, in _include
    for event in stream:
  File "/var/lib/python-support/python2.5/genshi/template/markup.py", line 299, in _match
    ctxt, match_templates[idx + 1:], **vars):
  File "/var/lib/python-support/python2.5/genshi/template/markup.py", line 299, in _match
    ctxt, match_templates[idx + 1:], **vars):
  File "/var/lib/python-support/python2.5/genshi/template/markup.py", line 299, in _match
    ctxt, match_templates[idx + 1:], **vars):
  File "/var/lib/python-support/python2.5/genshi/template/markup.py", line 246, in _match
    for event in stream:
  File "/var/lib/python-support/python2.5/genshi/template/base.py", line 543, in _exec
    for event in stream:
  File "/var/lib/python-support/python2.5/genshi/template/base.py", line 533, in _eval
    for event in substream:
  File "/var/lib/python-support/python2.5/genshi/template/base.py", line 496, in _eval
    for kind, data, pos in stream:
  File "/var/lib/python-support/python2.5/genshi/template/base.py", line 551, in _flatten
    for event in stream:
  File "/var/lib/python-support/python2.5/genshi/core.py", line 283, in _ensure
    for event in stream:
  File "/var/lib/python-support/python2.5/genshi/path.py", line 141, in _generate
    subevent = stream.next()
  File "/var/lib/python-support/python2.5/genshi/template/base.py", line 569, in _include
    for event in stream:
  File "/var/lib/python-support/python2.5/genshi/template/markup.py", line 235, in _strip
    event = stream.next()
  File "/var/lib/python-support/python2.5/genshi/template/base.py", line 543, in _exec
    for event in stream:
  File "/var/lib/python-support/python2.5/genshi/template/base.py", line 533, in _eval
    for event in substream:
  File "/var/lib/python-support/python2.5/genshi/template/base.py", line 496, in _eval
    for kind, data, pos in stream:
  File "/var/lib/python-support/python2.5/genshi/template/base.py", line 551, in _flatten
    for event in stream:
  File "/var/lib/python-support/python2.5/genshi/core.py", line 283, in _ensure
    for event in stream:
  File "/var/lib/python-support/python2.5/genshi/path.py", line 141, in _generate
    subevent = stream.next()
  File "/var/lib/python-support/python2.5/genshi/template/base.py", line 569, in _include
    for event in stream:
  File "/var/lib/python-support/python2.5/genshi/template/markup.py", line 246, in _match
    for event in stream:
  File "/var/lib/python-support/python2.5/genshi/template/markup.py", line 235, in _strip
    event = stream.next()
  File "/var/lib/python-support/python2.5/genshi/template/base.py", line 543, in _exec
    for event in stream:
  File "/var/lib/python-support/python2.5/genshi/template/base.py", line 533, in _eval
    for event in substream:
  File "/var/lib/python-support/python2.5/genshi/template/base.py", line 496, in _eval
    for kind, data, pos in stream:
  File "/var/lib/python-support/python2.5/genshi/template/base.py", line 551, in _flatten
    for event in stream:
  File "/var/lib/python-support/python2.5/genshi/core.py", line 283, in _ensure
    for event in stream:
  File "/var/lib/python-support/python2.5/genshi/path.py", line 141, in _generate
    subevent = stream.next()
  File "/var/lib/python-support/python2.5/genshi/template/base.py", line 569, in _include
    for event in stream:
  File "/var/lib/python-support/python2.5/genshi/template/markup.py", line 235, in _strip
    event = stream.next()
  File "/var/lib/python-support/python2.5/genshi/template/base.py", line 543, in _exec
    for event in stream:
  File "/var/lib/python-support/python2.5/genshi/template/base.py", line 496, in _eval
    for kind, data, pos in stream:
  File "/var/lib/python-support/python2.5/genshi/template/base.py", line 558, in _flatten
    for event in self._flatten(substream, ctxt, **vars):
  File "/var/lib/python-support/python2.5/genshi/template/base.py", line 551, in _flatten
    for event in stream:
  File "/var/lib/python-support/python2.5/genshi/template/directives.py", line 377, in __call__
    for item in iterable:
  File "/usr/lib/python2.5/site-packages/trac/util/compat.py", line 81, in next
    self.currkey = self.keyfunc(self.currvalue)
  File "<string>", line 1, in <lambda.20>
  File "build/bdist.linux-i686/egg/acct_mgr/api.py", line 114, in has_user
    if store.has_user(user):
  File "build/bdist.linux-i686/egg/acct_mgr/db.py", line 39, in has_user
    "AND sid=%s", (user,))
  File "/usr/lib/python2.5/site-packages/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.5/site-packages/trac/db/sqlite_backend.py", line 58, in execute
    args or [])
  File "/usr/lib/python2.5/site-packages/trac/db/sqlite_backend.py", line 50, in _rollback_on_error
    return function(self, *args, **kwargs)
InterfaceError: Error binding parameter 0 - probably unsupported type.

Attachments (0)

Change History (1)

comment:1 by Remy Blank, 15 years ago

Resolution:	→ invalid
Status:	new → closed

PluginIssue, please report it to the plugin maintainer on http://trac-hacks.org.

Modify Ticket

Change Properties

Summary:
Description:	==== How to Reproduce ==== I have just install UserManagerPlugin.When I want click to Users I have an error: While doing a GET operation on `/admin/accounts/users`, Trac issued an internal error. ''(please provide additional details here)'' Request parameters: {{{ {'cat_id': u'accounts', 'panel_id': u'users', 'path_info': None} }}} User Agent was: `Opera/9.63 (Windows NT 5.1; U; ru) Presto/2.1.1` ==== System Information ==== \|\| '''Trac''' \|\| `0.11.1` \|\| \|\| '''Python''' \|\| `2.5.2 (r252:60911, Aug 8 2008, 09:22:44) ` [[br]] `[GCC 4.3.1]` \|\| \|\| '''setuptools''' \|\| `0.6c9` \|\| \|\| '''SQLite''' \|\| `3.5.9` \|\| \|\| '''pysqlite''' \|\| `2.4.1` \|\| \|\| '''Genshi''' \|\| `0.5` \|\| \|\| '''Pygments''' \|\| `0.10` \|\| \|\| '''Subversion''' \|\| `1.5.1 (r32289)` \|\| \|\| '''jQuery:''' \|\| `1.2.6` \|\| ==== Python Traceback ==== {{{ Traceback (most recent call last): File "/usr/lib/python2.5/site-packages/trac/web/main.py", line 423, in _dispatch_request dispatcher.dispatch(req) File "/usr/lib/python2.5/site-packages/trac/web/main.py", line 219, in dispatch data, content_type) File "/usr/lib/python2.5/site-packages/trac/web/chrome.py", line 715, in render_template return stream.render(method, doctype=doctype) File "/var/lib/python-support/python2.5/genshi/core.py", line 179, in render return encode(generator, method=method, encoding=encoding, out=out) File "/var/lib/python-support/python2.5/genshi/output.py", line 60, in encode return _encode(u''.join(list(iterator))) File "/var/lib/python-support/python2.5/genshi/output.py", line 311, in __call__ for kind, data, pos in stream: File "/var/lib/python-support/python2.5/genshi/output.py", line 753, in __call__ for kind, data, pos in stream: File "/var/lib/python-support/python2.5/genshi/output.py", line 592, in __call__ for kind, data, pos in stream: File "/var/lib/python-support/python2.5/genshi/output.py", line 698, in __call__ for kind, data, pos in chain(stream, [(None, None, None)]): File "/var/lib/python-support/python2.5/genshi/output.py", line 532, in __call__ for ev in stream: File "/var/lib/python-support/python2.5/genshi/core.py", line 283, in _ensure for event in stream: File "/var/lib/python-support/python2.5/genshi/core.py", line 283, in _ensure for event in stream: File "/usr/lib/python2.5/site-packages/trac/web/chrome.py", line 767, in _strip_accesskeys for kind, data, pos in stream: File "/var/lib/python-support/python2.5/genshi/core.py", line 283, in _ensure for event in stream: File "/usr/lib/python2.5/site-packages/trac/web/chrome.py", line 756, in _generate for kind, data, pos in stream: File "/var/lib/python-support/python2.5/genshi/core.py", line 283, in _ensure for event in stream: File "/var/lib/python-support/python2.5/genshi/core.py", line 283, in _ensure for event in stream: File "/var/lib/python-support/python2.5/genshi/filters/transform.py", line 686, in _unmark for mark, event in stream: File "build/bdist.linux-i686/egg/timingandestimationplugin/tande_filters.py", line 60, in __call__ for mark, event in stream: File "/var/lib/python-support/python2.5/genshi/filters/transform.py", line 713, in __call__ for mark, event in stream: File "/var/lib/python-support/python2.5/genshi/filters/transform.py", line 682, in _mark for event in stream: File "/var/lib/python-support/python2.5/genshi/core.py", line 283, in _ensure for event in stream: File "/var/lib/python-support/python2.5/genshi/filters/transform.py", line 686, in _unmark for mark, event in stream: File "build/bdist.linux-i686/egg/timingandestimationplugin/tande_filters.py", line 60, in __call__ for mark, event in stream: File "/var/lib/python-support/python2.5/genshi/filters/transform.py", line 713, in __call__ for mark, event in stream: File "/var/lib/python-support/python2.5/genshi/filters/transform.py", line 682, in _mark for event in stream: File "/var/lib/python-support/python2.5/genshi/template/base.py", line 569, in _include for event in stream: File "/var/lib/python-support/python2.5/genshi/template/markup.py", line 299, in _match ctxt, match_templates[idx + 1:], vars): File "/var/lib/python-support/python2.5/genshi/template/markup.py", line 299, in _match ctxt, match_templates[idx + 1:], vars): File "/var/lib/python-support/python2.5/genshi/template/markup.py", line 299, in _match ctxt, match_templates[idx + 1:], vars): File "/var/lib/python-support/python2.5/genshi/template/markup.py", line 246, in _match for event in stream: File "/var/lib/python-support/python2.5/genshi/template/base.py", line 543, in _exec for event in stream: File "/var/lib/python-support/python2.5/genshi/template/base.py", line 533, in _eval for event in substream: File "/var/lib/python-support/python2.5/genshi/template/base.py", line 496, in _eval for kind, data, pos in stream: File "/var/lib/python-support/python2.5/genshi/template/base.py", line 551, in _flatten for event in stream: File "/var/lib/python-support/python2.5/genshi/core.py", line 283, in _ensure for event in stream: File "/var/lib/python-support/python2.5/genshi/path.py", line 141, in _generate subevent = stream.next() File "/var/lib/python-support/python2.5/genshi/template/base.py", line 569, in _include for event in stream: File "/var/lib/python-support/python2.5/genshi/template/markup.py", line 235, in _strip event = stream.next() File "/var/lib/python-support/python2.5/genshi/template/base.py", line 543, in _exec for event in stream: File "/var/lib/python-support/python2.5/genshi/template/base.py", line 533, in _eval for event in substream: File "/var/lib/python-support/python2.5/genshi/template/base.py", line 496, in _eval for kind, data, pos in stream: File "/var/lib/python-support/python2.5/genshi/template/base.py", line 551, in _flatten for event in stream: File "/var/lib/python-support/python2.5/genshi/core.py", line 283, in _ensure for event in stream: File "/var/lib/python-support/python2.5/genshi/path.py", line 141, in _generate subevent = stream.next() File "/var/lib/python-support/python2.5/genshi/template/base.py", line 569, in _include for event in stream: File "/var/lib/python-support/python2.5/genshi/template/markup.py", line 246, in _match for event in stream: File "/var/lib/python-support/python2.5/genshi/template/markup.py", line 235, in _strip event = stream.next() File "/var/lib/python-support/python2.5/genshi/template/base.py", line 543, in _exec for event in stream: File "/var/lib/python-support/python2.5/genshi/template/base.py", line 533, in _eval for event in substream: File "/var/lib/python-support/python2.5/genshi/template/base.py", line 496, in _eval for kind, data, pos in stream: File "/var/lib/python-support/python2.5/genshi/template/base.py", line 551, in _flatten for event in stream: File "/var/lib/python-support/python2.5/genshi/core.py", line 283, in _ensure for event in stream: File "/var/lib/python-support/python2.5/genshi/path.py", line 141, in _generate subevent = stream.next() File "/var/lib/python-support/python2.5/genshi/template/base.py", line 569, in _include for event in stream: File "/var/lib/python-support/python2.5/genshi/template/markup.py", line 235, in _strip event = stream.next() File "/var/lib/python-support/python2.5/genshi/template/base.py", line 543, in _exec for event in stream: File "/var/lib/python-support/python2.5/genshi/template/base.py", line 496, in _eval for kind, data, pos in stream: File "/var/lib/python-support/python2.5/genshi/template/base.py", line 558, in _flatten for event in self._flatten(substream, ctxt, vars): File "/var/lib/python-support/python2.5/genshi/template/base.py", line 551, in _flatten for event in stream: File "/var/lib/python-support/python2.5/genshi/template/directives.py", line 377, in __call__ for item in iterable: File "/usr/lib/python2.5/site-packages/trac/util/compat.py", line 81, in next self.currkey = self.keyfunc(self.currvalue) File "<string>", line 1, in <lambda.20> File "build/bdist.linux-i686/egg/acct_mgr/api.py", line 114, in has_user if store.has_user(user): File "build/bdist.linux-i686/egg/acct_mgr/db.py", line 39, in has_user "AND sid=%s", (user,)) File "/usr/lib/python2.5/site-packages/trac/db/util.py", line 50, in execute return self.cursor.execute(sql_escape_percent(sql), args) File "/usr/lib/python2.5/site-packages/trac/db/sqlite_backend.py", line 58, in execute args or []) File "/usr/lib/python2.5/site-packages/trac/db/sqlite_backend.py", line 50, in _rollback_on_error return function(self, args, *kwargs) InterfaceError: Error binding parameter 0 - probably unsupported type. }}} You may use WikiFormatting here.
Type:		Priority:
Milestone:		Component:
Version:		Severity:
Keywords:		Cc:	Set your email in Preferences
Branch:
Release Notes:
API Changes:
Internal Changes:

Action

leave as closed The ticket will remain with no owner.

reopen The resolution will be deleted. Next status will be 'reopened'.

change ownership to The owner will be changed from (none) to the specified user.

Add Comment

Your email or username:

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

You may use WikiFormatting here.

Attachments ↑ Description ↑

Note: See TracTickets for help on using tickets.

Download in other formats: