Opened 3 years ago

Last modified 3 years ago

defect #96 (closed: duplicate)

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

Test Complete Size: 0 Test Complete Date:
Documentation Complete Size: 0 Documentation Complete Date:
Acceptance Complete Size: 0 Acceptance Complete Date:
Reported by: jishin Owned by: ja11sop
Milestone: Undecided Component: agiletracplugin
Version: Keywords:
Cc: jishinsalim@… Blocked By:
Patch SVN Revision: Patch Trac Version: 0.11.3
Blocking:
In Iterations: 20

Description

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

Change History

Have a look at the list of modified files related to this ticket.

Changed 3 years ago by ja11sop

  • test_complete_size changed from undefined to 0
  • doc_complete_size changed from undefined to 0
  • acceptance_complete_size changed from undefined to 0

This looks like a duplicate of #57 and #62. Please have a look at those issues and see if that helps resolve your issue. Marking this as a duplicate for now.

Note: See TracTickets for help on using tickets.