Custom Query (894 matches)

Is there something wrong?

...
dpkg-gencontrol: warning: package bcfg2: unused substitution variable ${python:Versions}
dpkg-gencontrol: warning: package bcfg2-server: unused substitution variable ${python:Versions}
dpkg-gencontrol: warning: Depends field of package bcfg2-web: unknown substitution variable ${python:Depends}
   dh_md5sums
   dh_builddeb
dpkg-deb: warning: 'debian/bcfg2/DEBIAN/control' contains user-defined field 'Python-Version'
dpkg-deb: building package `bcfg2' in `../bcfg2_1.2.0rc1-0.0_all.deb'.
dpkg-deb: warning: ignoring 1 warning about the control file(s)
...

bcfg2-server -C bcfg2.conf works fine.

But, bcfg2-server -C bcfg2.conf -D pid immediately silently exits without actually running server or printing anything to the log file (if given) or on the console. Debug option doesn't change anything.

Checked on 042c1e10bdf66e6c9b54c88a49200d4f2dbff683

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