DatabaseError in bcfg2 dynamic reporting

[https://www.google.com/accounts/o8/id?id=AItOawndHbt6oQD5o4llC_tsXLYSWsFqERWT0_Q]

Hi,

I use the DBStats plugin for reporting. It started working fine, but now I get a database error if I click on a bad element:

DatabaseError? at /elements/bad/3574939

too many SQL variables

Request Method: GET Request URL: ​https://bcfg2.uni-paderborn.de/bcfg2/elements/bad/3574939 Django Version: 1.2.3 Exception Type: DatabaseError? Exception Value:

too many SQL variables

Exception Location: /usr/lib/pymodules/python2.6/django/db/backends/sqlite3/base.py in execute, line 200 Python Executable: /usr/bin/python Python Version: 2.6.6 Python Path: ['/usr/lib/python2.6', '/usr/lib/python2.6/plat-linux2', '/usr/lib/python2.6/lib-tk', '/usr/lib/python2.6/lib-old', '/usr/lib/python2.6/lib-dynload', '/usr/local/lib/python2.6/dist-packages', '/usr/lib/python2.6/dist-packages', '/usr/lib/pymodules/python2.6'] Server time: Thu, 29 Mar 2012 17:06:33 +0200

Traceback:

Environment:

Request Method: GET Request URL: ​https://bcfg2.uni-paderborn.de/bcfg2/elements/bad/3574939 Django Version: 1.2.3 Python Version: 2.6.6 Installed Applications: ['django.contrib.auth',

'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.sites', 'django.contrib.admin', 'Bcfg2.Server.Reports.reports']

Installed Middleware: ('django.middleware.common.CommonMiddleware?',

'django.contrib.sessions.middleware.SessionMiddleware?', 'django.contrib.auth.middleware.AuthenticationMiddleware?', 'django.middleware.doc.XViewMiddleware')

Traceback: File "/usr/lib/pymodules/python2.6/django/core/handlers/base.py" in get_response

100. response = callback(request, *callback_args, callback_kwargs)

File "/usr/lib/python2.6/dist-packages/Bcfg2/Server/Reports/reports/views.py" in config_item

111. for x in shared_entries.values('interaction')])\

File "/usr/lib/pymodules/python2.6/django/db/models/query.py" in _result_iter

106. self._fill_cache()

File "/usr/lib/pymodules/python2.6/django/db/models/query.py" in _fill_cache

760. self._result_cache.append(self._iter.next())

File "/usr/lib/pymodules/python2.6/django/db/models/query.py" in iterator

829. for row in self.query.get_compiler(self.db).results_iter():

File "/usr/lib/pymodules/python2.6/django/db/models/sql/compiler.py" in results_iter

672. for rows in self.execute_sql(MULTI):

File "/usr/lib/pymodules/python2.6/django/db/models/sql/compiler.py" in execute_sql

727. cursor.execute(sql, params)

File "/usr/lib/pymodules/python2.6/django/db/backends/util.py" in execute

15. return self.cursor.execute(sql, params)

File "/usr/lib/pymodules/python2.6/django/db/backends/sqlite3/base.py" in execute

200. return Database.Cursor.execute(self, query, params)

Exception Type: DatabaseError? at /elements/bad/3574939 Exception Value: too many SQL variables

Client and server version is 1.2.2 with very few unrelated patches.

Any ideas?

Thanks,

Christopher

[solj]

I cannot reproduce this with the latest stable release (and we require a more recent version of django). Please reopen if this is still an issue.