OperationalError: ORDER BY terms must not be non-integer constants

[jishinsalim@…]

How to Reproduce

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

(please provide additional details here)

User Agent was: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/525.13 (KHTML, like Gecko) Chrome/0.2.149.27 Safari/525.13

System Information

Trac	0.11.3
Python	2.5.4 (r254:67916, Dec 23 2008, 15:10:54) [MSC v.1310 32 bit (Intel)]
setuptools	0.6c8
SQLite	3.3.4
pysqlite	2.3.2
Genshi	0.5.1
mod_python	3.3.1
jQuery:	1.2.6

Python Traceback

Traceback (most recent call last):
  File "D:\Program Files\VisualSVN Server\trac\python\lib\site-packages\trac-0.11.3-py2.5.egg\trac\web\main.py", line 435, in _dispatch_request
    dispatcher.dispatch(req)
  File "D:\Program Files\VisualSVN Server\trac\python\lib\site-packages\trac-0.11.3-py2.5.egg\trac\web\main.py", line 205, in dispatch
    resp = chosen_handler.process_request(req)
  File "D:\Program Files\VisualSVN Server\trac\python\lib\site-packages\trac-0.11.3-py2.5.egg\trac\ticket\roadmap.py", line 752, in process_request
    'owner')
  File "D:\Program Files\VisualSVN Server\trac\python\lib\site-packages\trac-0.11.3-py2.5.egg\trac\ticket\roadmap.py", line 307, in get_tickets_for_milestone
    "ORDER BY %s", (milestone,field))
  File "D:\Program Files\VisualSVN Server\trac\python\lib\site-packages\trac-0.11.3-py2.5.egg\trac\db\util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "D:\Program Files\VisualSVN Server\trac\python\lib\site-packages\trac-0.11.3-py2.5.egg\trac\db\sqlite_backend.py", line 58, in execute
    args or [])
  File "D:\Program Files\VisualSVN Server\trac\python\lib\site-packages\trac-0.11.3-py2.5.egg\trac\db\sqlite_backend.py", line 50, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: ORDER BY terms must not be non-integer constants

[Tim Hatch]

Known issue with SQLite < 3.3.6. See ​http://docs.djangoproject.com/en/1.0/ref/databases/#versions-prior-to-3-3-6

Versions of SQLite 3.3.5 and older contain a bug when handling ORDER BY parameters. This can cause problems when you use the select parameter for the extra() QuerySet method. The bug can be identified by the error message OperationalError: ORDER BY terms must not be non-integer constants. The problem can be solved updating SQLite to version 3.3.6 or newer, possibly also updating the pysqlite2 Python module in the process.

[jishinsalim@…]

Thanks. It worked.
Jishin

Replying to thatch:

Known issue with SQLite < 3.3.6. See ​http://docs.djangoproject.com/en/1.0/ref/databases/#versions-prior-to-3-3-6

Versions of SQLite 3.3.5 and older contain a bug when handling ORDER BY parameters. This can cause problems when you use the select parameter for the extra() QuerySet method. The bug can be identified by the error message OperationalError: ORDER BY terms must not be non-integer constants. The problem can be solved updating SQLite to version 3.3.6 or newer, possibly also updating the pysqlite2 Python module in the process.