OperationalError: too many SQL variables

[dl@…]

How to Reproduce

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

(please provide additional details here)

User Agent was: Mozilla/5.0 (Windows; U; Windows NT 5.1; ru; rv:1.9.0.5) Gecko/2008120122 Firefox/3.0.5

System Information

Trac	0.11.2
Python	2.5.2 (r252:60911, Dec 19 2008, 16:42:11) [GCC 3.4.6 [FreeBSD] 20060305]
setuptools	0.6c9
SQLite	3.4.1
pysqlite	2.3.2
Genshi	0.5.1
Pygments	0.8.1
Subversion	1.5.4 (r33841)
jQuery:	1.2.6

Python Traceback

Traceback (most recent call last):
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.2-py2.5.egg/trac/web/main.py", line 432, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.2-py2.5.egg/trac/web/main.py", line 204, in dispatch
    resp = chosen_handler.process_request(req)
  File "build/bdist.freebsd-6.2-RELEASE-i386/egg/tractags/web_ui.py", line 99, in process_request
    data['tag_body'] =  macro.expand_macro(formatter, None, query)
  File "build/bdist.freebsd-6.2-RELEASE-i386/egg/tractags/macros.py", line 59, in expand_macro
    for resource, tags in query_result:
  File "build/bdist.freebsd-6.2-RELEASE-i386/egg/tractags/api.py", line 196, in query
    for resource, tags in provider.get_tagged_resources(req, query_tags):
  File "build/bdist.freebsd-6.2-RELEASE-i386/egg/tractags/api.py", line 107, in get_tagged_resources
    cursor.execute(sql, args)
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.2-py2.5.egg/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.2-py2.5.egg/trac/db/sqlite_backend.py", line 58, in execute
    args or [])
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.2-py2.5.egg/trac/db/sqlite_backend.py", line 50, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: too many SQL variables

[Remy Blank]

Duplicate of #8009. Seems to be the same Trac installation, too. Please report the issue to your Trac admin, as well as to the ​th:TagsPlugin plugin maintainer.