id	summary	reporter	owner	description	type	status	priority	component	severity	resolution	keywords	cc	release
6745	Error when navigating to CodeReview tab on Trac 0.11 and 0.12	rjollos	rjollos	I see the following error when navigating to the CodeReview tab on Trac0.12dev-r9314:\r\n{{{\r\nTrac detected an internal error:\r\n\r\nOperationalError: unrecognized token: ":"\r\n}}}\r\n\r\n{{{\r\n    *    File "/home/rjollos/Workspace/tracdev/trac-trunk/trac/web/main.py", line 499, in  _dispatch_request\r\n      Code fragment:\r\n      Line_\r\n      494_try:\r\n      495_if not env and env_error:\r\n      496_raise HTTPInternalError(env_error)\r\n      497_try:\r\n      498_dispatcher = RequestDispatcher(env)\r\n      499_dispatcher.dispatch(req)\r\n      500_except RequestDone:\r\n      501_pass\r\n      502_resp = req._response or []\r\n      503_ \r\n      504_except HTTPException, e:\r\n      Local variables:\r\n      Name_Value\r\n      dispatcher _<trac.web.main.RequestDispatcher object at 0x1e471d0>\r\n      e _OperationalError('unrecognized token: ":"',)\r\n      env _<trac.env.Environment object at 0x1c25ad0>\r\n      env_error _None\r\n      exc_info _(<class 'sqlite3.OperationalError'>, OperationalError('unrecognized token: ...\r\n      faulty_plugins _[]\r\n      frames _[]\r\n      has_admin _True\r\n      message _u'OperationalError: unrecognized token: ":"'\r\n      plugins _[]\r\n      req _<Request "GET u'/CodeReview'">\r\n      resp _[]\r\n      th _'http://trac-hacks.org'\r\n      traceback _u'Traceback (most recent call last):\\n File ...\r\n      tracker _'http://trac.edgewall.org'\r\n    * File "/home/rjollos/Workspace/tracdev/trac-trunk/trac/web/main.py", line 231, in dispatch\r\n      Code fragment:\r\n      Line_\r\n      226_msg = _('Do you have cookies enabled?')\r\n      227_raise HTTPBadRequest(_('Missing or invalid form token.'\r\n      228_' %(msg)s', msg=msg))\r\n      229_ \r\n      230_# Process the request and render the template\r\n      231_resp = chosen_handler.process_request(req)\r\n      232_if resp:\r\n      233_if len(resp) == 2: # Clearsilver\r\n      234_chrome.populate_hdf(req)\r\n      235_template, content_type = \\\r\n      236_self._post_process_request(req, *resp)\r\n      Local variables:\r\n      Name_Value\r\n      chosen_handler _<codereview.web_ui.CodeReviewMain object at 0x1e4d4d0>\r\n      chrome _<trac.web.chrome.Chrome object at 0x1e47610>\r\n      err _(<class 'sqlite3.OperationalError'>, OperationalError('unrecognized token: ...\r\n      handler _<codereview.web_ui.CodeReviewMain object at 0x1e4d4d0>\r\n      req _<Request "GET u'/CodeReview'">\r\n      self _<trac.web.main.RequestDispatcher object at 0x1e471d0>\r\n    * File "build/bdist.linux-x86_64/egg/codereview/web_ui.py", line 358, in process_request\r\n      Local variables:\r\n      Name_Value\r\n      req _<Request "GET u'/CodeReview'">\r\n      self _<codereview.web_ui.CodeReviewMain object at 0x1e4d4d0>\r\n    * File "build/bdist.linux-x86_64/egg/codereview/web_ui.py", line 264, in _display_html\r\n      Local variables:\r\n      Name_Value\r\n      action _''\r\n      base_href _'/tracdev'\r\n      crp _<codereview.model.CodeReviewPool object at 0x204f7d0>\r\n      db _<trac.db.pool.PooledConnection object at 0x221a4b0>\r\n      is_completed _''\r\n      keywords _{}\r\n      not_shown _{'msg': [], 'prefix': []}\r\n      req _<Request "GET u'/CodeReview'">\r\n      req_author _''\r\n      req_date _None\r\n      self _<codereview.web_ui.CodeReviewMain object at 0x1e4d4d0>\r\n      start_rev _0\r\n      undergoing_items _[]\r\n    * File "build/bdist.linux-x86_64/egg/codereview/model.py", line 104, in get_codereviews_by_key\r\n      Local variables:\r\n      Name_Value\r\n      codereviews_items _[]\r\n      id_cs _[1]\r\n      key _{}\r\n      not_shown _{'msg': [], 'prefix': []}\r\n      self _<codereview.model.CodeReviewPool object at 0x204f7d0>\r\n      start_rev _0\r\n      status _'Awaiting'\r\n    * File "build/bdist.linux-x86_64/egg/codereview/model.py", line 81, in get_codereviews_by_revisions\r\n      Local variables:\r\n      Name_Value\r\n      key _{}\r\n      not_shown _{'msg': [], 'prefix': []}\r\n      revisions _[1]\r\n      self _<codereview.model.CodeReviewPool object at 0x204f7d0>\r\n    * File "build/bdist.linux-x86_64/egg/codereview/model.py", line 167, in changeset_info\r\n      Local variables:\r\n      Name_Value\r\n      author _u'rjollos'\r\n      common_path _None\r\n      ctime _1267431625587431L\r\n      message _u'Adding code review plugin to repos'\r\n      r _u'0000000001'\r\n      result _[(u'0000000001', u'rjollos', u'Adding code review plugin to repos', None, ...\r\n      ret _[]\r\n      revisions _[1]\r\n      self _<codereview.model.CodeReviewPool object at 0x204f7d0>\r\n    * File "build/bdist.linux-x86_64/egg/codereview/model.py", line 329, in get_path\r\n      Local variables:\r\n      Name_Value\r\n      rev _1\r\n      self _<codereview.model.CommitPath object at 0x2310d90>\r\n    * File "/home/rjollos/Workspace/tracdev/trac-trunk/trac/db/util.py", line 90, in execute\r\n      Code fragment:\r\n      Line_\r\n      85_return r\r\n      86_except Exception, e:\r\n      87_self.log.debug('execute exception: %r', e)\r\n      88_raise\r\n      89_if args:\r\n      90_return self.cursor.execute(sql_escape_percent(sql), args)\r\n      91_return self.cursor.execute(sql)\r\n      92_ \r\n      93_def executemany(self, sql, args=None):\r\n      94_if self.log:\r\n      95_self.log.debug('SQL: %r', sql)\r\n      Local variables:\r\n      Name_Value\r\n      args _(1,)\r\n      self _<trac.db.util.IterableCursor object at 0x23106d0>\r\n      sql _'SELECT path FROM rev_path WHERE rev=%s::int'\r\n    * File "/home/rjollos/Workspace/tracdev/trac-trunk/trac/db/sqlite_backend.py", line 77, in execute\r\n      Code fragment:\r\n      Line_\r\n      72_PyFormatCursor.__init__(self, con)\r\n      73_self.rows = []\r\n      74_self.pos = 0\r\n      75_ \r\n      76_def execute(self, *args):\r\n      77_result = PyFormatCursor.execute(self, *args)\r\n      78_self.rows = PyFormatCursor.fetchall(self)\r\n      79_self.pos = 0\r\n      80_return result\r\n      81_ \r\n      82_def fetchone(self):\r\n      Local variables:\r\n      Name_Value\r\n      args _('SELECT path FROM rev_path WHERE rev=%s::int', (1,))\r\n      self _<trac.db.sqlite_backend.EagerCursor object at 0x1fc1408>\r\n    * File "/home/rjollos/Workspace/tracdev/trac-trunk/trac/db/sqlite_backend.py", line 56, in execute\r\n      Code fragment:\r\n      Line_\r\n      51_raise\r\n      52_def execute(self, sql, args=None):\r\n      53_if args:\r\n      54_sql = sql % (('?',) * len(args))\r\n      55_return self._rollback_on_error(sqlite.Cursor.execute, sql,\r\n      56_args or [])\r\n      57_def executemany(self, sql, args=None):\r\n      58_if args:\r\n      59_sql = sql % (('?',) * len(args[0]))\r\n      60_return self._rollback_on_error(sqlite.Cursor.executemany, sql,\r\n      61_args or [])\r\n      Local variables:\r\n      Name_Value\r\n      args _(1,)\r\n      self _<trac.db.sqlite_backend.EagerCursor object at 0x1fc1408>\r\n      sql _'SELECT path FROM rev_path WHERE rev=?::int'\r\n    * File "/home/rjollos/Workspace/tracdev/trac-trunk/trac/db/sqlite_backend.py", line 48, in _rollback_on_error\r\n      Code fragment:\r\n      Line_\r\n      43_sqlite_version_string = sqlite.sqlite_version\r\n      44_ \r\n      45_class PyFormatCursor(sqlite.Cursor):\r\n      46_def _rollback_on_error(self, function, *args, **kwargs):\r\n      47_try:\r\n      48_return function(self, *args, **kwargs)\r\n      49_except sqlite.DatabaseError:\r\n      50_self.cnx.rollback()\r\n      51_raise\r\n      52_def execute(self, sql, args=None):\r\n      53_if args:\r\n      Local variables:\r\n      Name_Value\r\n      args _('SELECT path FROM rev_path WHERE rev=?::int', (1,))\r\n      function _<method 'execute' of 'sqlite3.Cursor' objects>\r\n      kwargs _{}\r\n      self _<trac.db.sqlite_backend.EagerCursor object at 0x1fc1408>\r\n\r\nFile "/home/rjollos/Workspace/tracdev/trac-trunk/trac/web/main.py", line 499, in _dispatch_request\r\n  dispatcher.dispatch(req)\r\nFile "/home/rjollos/Workspace/tracdev/trac-trunk/trac/web/main.py", line 231, in dispatch\r\n  resp = chosen_handler.process_request(req)\r\nFile "build/bdist.linux-x86_64/egg/codereview/web_ui.py", line 358, in process_requestFile "build/bdist.linux-x86_64/egg/codereview/web_ui.py", line 264, in _display_htmlFile "build/bdist.linux-x86_64/egg/codereview/model.py", line 104, in get_codereviews_by_keyFile "build/bdist.linux-x86_64/egg/codereview/model.py", line 81, in get_codereviews_by_revisionsFile "build/bdist.linux-x86_64/egg/codereview/model.py", line 167, in changeset_infoFile "build/bdist.linux-x86_64/egg/codereview/model.py", line 329, in get_pathFile "/home/rjollos/Workspace/tracdev/trac-trunk/trac/db/util.py", line 90, in execute\r\n  return self.cursor.execute(sql_escape_percent(sql), args)\r\nFile "/home/rjollos/Workspace/tracdev/trac-trunk/trac/db/sqlite_backend.py", line 77, in execute\r\n  result = PyFormatCursor.execute(self, *args)\r\nFile "/home/rjollos/Workspace/tracdev/trac-trunk/trac/db/sqlite_backend.py", line 56, in execute\r\n  args or [])\r\nFile "/home/rjollos/Workspace/tracdev/trac-trunk/trac/db/sqlite_backend.py", line 48, in _rollback_on_error\r\n  return function(self, *args, **kwargs)\r\n}}}	defect	closed	normal	ExoWebCodeReviewPlugin	normal	fixed			0.11