id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release
3088,Error in MySQL Query Syntax,abidoon@gmail.com,rjollos,Trac detected an internal error:\r\n\r\n!ProgrammingError: (1064_ "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\\n     GROUP BY r.author \\n     ORDER BY commits DESC \\n     LIMIT 5' at line 3")\r\n\r\nMost recent call last:\r\n{{{\r\n    * File "/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/web/main.py"_ line 417_ in _dispatch_request\r\n      Code fragment:\r\n       412. try:\r\n       413. if not env and env_error:\r\n       414. raise HTTPInternalError(env_error)\r\n       415. try:\r\n       416. dispatcher = RequestDispatcher(env)\r\n       417. dispatcher.dispatch(req)\r\n       418. except RequestDone:\r\n       419. pass\r\n       420. resp = req._response or []\r\n       421.  \r\n       422. except HTTPException_ e:\r\n      Local variables:\r\n      Name	Value\r\n      after 	[u' except RequestDone:'_ u' pass'_ u' resp = ...\r\n      before 	[u' try:'_ u' if not env and env_error:'_ u' raise ...\r\n      dispatcher 	<trac.web.main.RequestDispatcher object at 0x2aaad0d9ab10>\r\n      e 	<_mysql_exceptions.ProgrammingError instance at 0x2aaad0d82518>\r\n      env 	<trac.env.Environment object at 0x2aaaccfc4ad0>\r\n      env_error 	None\r\n      exc_info 	(<class _mysql_exceptions.ProgrammingError at 0x2aaace3e24d0>_ ...\r\n      filename 	'/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/web/main.py'\r\n      frames 	[{'function': '_dispatch_request'_ 'lines_before': [u' try:'_ u' ...\r\n      has_admin 	True\r\n      line 	u' dispatcher.dispatch(req)'\r\n      lineno 	416\r\n      message 	u'ProgrammingError: (1064_ "You have an error in your SQL syntax; check ...\r\n      req 	<Request "GET u'/stractistics'">\r\n      resp 	[]\r\n      tb 	<traceback object at 0x2aaad0d82c68>\r\n      tb_hide 	None\r\n      traceback 	'Traceback (most recent call last):\\n File ...\r\n    * File "/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/web/main.py"_ line 197_ in dispatch\r\n      Code fragment:\r\n       192. req.args.get('__FORM_TOKEN') != req.form_token:\r\n       193. raise HTTPBadRequest('Missing or invalid form token. '\r\n       194. 'Do you have cookies enabled?')\r\n       195.  \r\n       196. # Process the request and render the template\r\n       197. resp = chosen_handler.process_request(req)\r\n       198. if resp:\r\n       199. if len(resp) == 2: # Clearsilver\r\n       200. chrome.populate_hdf(req)\r\n       201. template_ content_type = \\\r\n       202. self._post_process_request(req_ *resp)\r\n      Local variables:\r\n      Name	Value\r\n      chosen_handler 	<stractistics.web_ui.StractisticsModule object at 0x2aaad0d80cd0>\r\n      chrome 	<trac.web.chrome.Chrome object at 0x2aaad0d9a790>\r\n      err 	(<class _mysql_exceptions.ProgrammingError at 0x2aaace3e24d0>_ ...\r\n      handler 	<stractistics.web_ui.StractisticsModule object at 0x2aaad0d80cd0>\r\n      req 	<Request "GET u'/stractistics'">\r\n      self 	<trac.web.main.RequestDispatcher object at 0x2aaad0d9ab10>\r\n    * File "build/bdist.linux-x86_64/egg/stractistics/web_ui.py"_ line 116_ in process_request\r\n      Local variables:\r\n      Name	Value\r\n      config 	{'wiki_ignored_authors': []_ 'repository_ignored_authors': []_ ...\r\n      db 	<trac.db.pool.PooledConnection object at 0x2aaad0d82440>\r\n      elem 	('User reports'_ 'user_reports')\r\n      links 	[('Project reports'_ '/stractistics/project_reports')_ ('User reports'_ ...\r\n      module 	None\r\n      req 	<Request "GET u'/stractistics'">\r\n      self 	<stractistics.web_ui.StractisticsModule object at 0x2aaad0d80cd0>\r\n      strac_ref 	'/stractistics'\r\n    * File "build/bdist.linux-x86_64/egg/stractistics/global_reports.py"_ line 31_ in global_reports\r\n      Local variables:\r\n      Name	Value\r\n      config 	{'wiki_ignored_authors': []_ 'repository_ignored_authors': []_ ...\r\n      db 	<trac.db.pool.PooledConnection object at 0x2aaad0d82440>\r\n      end_date 	datetime.datetime(2008_ 5_ 28_ 11_ 9_ 29_ 652479)\r\n      req 	<Request "GET u'/stractistics'">\r\n      start_date 	datetime.datetime(2008_ 3_ 5_ 11_ 9_ 29_ 652479)\r\n      weeks_back 	12\r\n    * File "build/bdist.linux-x86_64/egg/stractistics/global_reports.py"_ line 64_ in _repository_activity\r\n      Local variables:\r\n      Name	Value\r\n      AUTHORS_LIMIT 	5\r\n      WEEKS_NUMBER 	12\r\n      config 	{'wiki_ignored_authors': []_ 'repository_ignored_authors': []_ ...\r\n      db 	<trac.db.pool.PooledConnection object at 0x2aaad0d82440>\r\n      end_date 	datetime.datetime(2008_ 5_ 28_ 11_ 9_ 29_ 652479)\r\n      ignored_authors 	''\r\n      req 	<Request "GET u'/stractistics'">\r\n      start_date 	datetime.datetime(2008_ 3_ 5_ 11_ 9_ 29_ 652479)\r\n      weeks_back 	12\r\n    * File "build/bdist.linux-x86_64/egg/stractistics/global_reports.py"_ line 113_ in _most_active_repository_authors\r\n      Local variables:\r\n      Name	Value\r\n      AUTHORS_LIMIT 	5\r\n      authors 	[]\r\n      db 	<trac.db.pool.PooledConnection object at 0x2aaad0d82440>\r\n      end_date 	datetime.datetime(2008_ 5_ 28_ 11_ 9_ 29_ 652479)\r\n      ignored_authors 	''\r\n      map_rows 	<function map_rows at 0x2aaad0d855f0>\r\n      sql_expr 	'\\n SELECT r.author AS author_ COUNT( r.author ) AS commits \\n FROM ...\r\n      start_date 	datetime.datetime(2008_ 3_ 5_ 11_ 9_ 29_ 652479)\r\n    * File "build/bdist.linux-x86_64/egg/stractistics/util.py"_ line 117_ in execute_sql_expression\r\n      Local variables:\r\n      Name	Value\r\n      cursor 	<trac.db.util.IterableCursor object at 0x2aaad0d9e6a8>\r\n      db 	<trac.db.pool.PooledConnection object at 0x2aaad0d82440>\r\n      map_rows 	<function map_rows at 0x2aaad0d855f0>\r\n      sql_expr 	'\\n SELECT r.author AS author_ COUNT( r.author ) AS commits \\n FROM ...\r\n    * File "/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/db/util.py"_ line 51_ in execute\r\n      Code fragment:\r\n        46. # -- In case of SQL errors_ uncomment the following 'print' statements\r\n        47. # print 'execute'_ repr(sql)\r\n        48. if args:\r\n        49. # print repr(args)\r\n        50. return self.cursor.execute(sql_escape_percent(sql)_ args)\r\n        51. return self.cursor.execute(sql)\r\n        52.  \r\n        53. def executemany(self_ sql_ args=None):\r\n        54. # print 'executemany'_ repr(sql)\r\n        55. if args:\r\n        56. # print repr(args)\r\n      Local variables:\r\n      Name	Value\r\n      args 	None\r\n      self 	<trac.db.util.IterableCursor object at 0x2aaad0d9e6a8>\r\n      sql 	'\\n SELECT r.author AS author_ COUNT( r.author ) AS commits \\n FROM ...\r\n    * File "/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/db/util.py"_ line 51_ in execute\r\n      Code fragment:\r\n        46. # -- In case of SQL errors_ uncomment the following 'print' statements\r\n        47. # print 'execute'_ repr(sql)\r\n        48. if args:\r\n        49. # print repr(args)\r\n        50. return self.cursor.execute(sql_escape_percent(sql)_ args)\r\n        51. return self.cursor.execute(sql)\r\n        52.  \r\n        53. def executemany(self_ sql_ args=None):\r\n        54. # print 'executemany'_ repr(sql)\r\n        55. if args:\r\n        56. # print repr(args)\r\n      Local variables:\r\n      Name	Value\r\n      args 	None\r\n      self 	<trac.db.util.IterableCursor object at 0x2aaad0d9ea28>\r\n      sql 	'\\n SELECT r.author AS author_ COUNT( r.author ) AS commits \\n FROM ...\r\n    * File "/usr/lib64/python2.4/site-packages/MySQLdb/cursors.py"_ line 163_ in execute\r\n      Code fragment:\r\n       158. self.errorhandler(self_ TypeError_ m)\r\n       159. except:\r\n       160. exc_ value_ tb = exc_info()\r\n       161. del tb\r\n       162. self.messages.append((exc_ value))\r\n       163. self.errorhandler(self_ exc_ value)\r\n       164. self._executed = query\r\n       165. self._warning_check()\r\n       166. return r\r\n       167.  \r\n       168. def executemany(self_ query_ args):\r\n      Local variables:\r\n      Name	Value\r\n      ListType 	<type 'list'>\r\n      TupleType 	<type 'tuple'>\r\n      args 	None\r\n      charset 	'utf8'\r\n      db 	<weakproxy at 0x2aaace3f8d08 to Connection at 0x2aaabcc7dfe0>\r\n      exc 	<class _mysql_exceptions.ProgrammingError at 0x2aaace3e24d0>\r\n      exc_info 	<built-in function exc_info>\r\n      query 	'\\n SELECT r.author AS author_ COUNT( r.author ) AS commits \\n FROM ...\r\n      self 	<MySQLdb.cursors.Cursor object at 0x2aaad0d9b190>\r\n      value 	<_mysql_exceptions.ProgrammingError instance at 0x2aaad0d82518>\r\n    * File "/usr/lib64/python2.4/site-packages/MySQLdb/connections.py"_ line 35_ in defaulterrorhandler\r\n      Code fragment:\r\n        30. cursor.messages.append(error)\r\n        31. else:\r\n        32. connection.messages.append(error)\r\n        33. del cursor\r\n        34. del connection\r\n        35. raise errorclass_ errorvalue\r\n        36.  \r\n        37.  \r\n        38. class Connection(_mysql.connection):\r\n        39.  \r\n        40. """MySQL Database Connection Object"""\r\n      Local variables:\r\n      Name	Value\r\n      error 	(<class _mysql_exceptions.ProgrammingError at 0x2aaace3e24d0>_ ...\r\n      errorclass 	<class _mysql_exceptions.ProgrammingError at 0x2aaace3e24d0>\r\n      errorvalue 	<_mysql_exceptions.ProgrammingError instance at 0x2aaad0d82518>\r\n\r\nFile "/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/web/main.py"_ line 417_ in _dispatch_request\r\n  dispatcher.dispatch(req)\r\nFile "/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/web/main.py"_ line 197_ in dispatch\r\n  resp = chosen_handler.process_request(req)\r\nFile "build/bdist.linux-x86_64/egg/stractistics/web_ui.py"_ line 116_ in process_requestFile "build/bdist.linux-x86_64/egg/stractistics/global_reports.py"_ line 31_ in global_reportsFile "build/bdist.linux-x86_64/egg/stractistics/global_reports.py"_ line 64_ in _repository_activityFile "build/bdist.linux-x86_64/egg/stractistics/global_reports.py"_ line 113_ in _most_active_repository_authorsFile "build/bdist.linux-x86_64/egg/stractistics/util.py"_ line 117_ in execute_sql_expressionFile "/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/db/util.py"_ line 51_ in execute\r\n  return self.cursor.execute(sql)\r\nFile "/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/db/util.py"_ line 51_ in execute\r\n  return self.cursor.execute(sql)\r\nFile "/usr/lib64/python2.4/site-packages/MySQLdb/cursors.py"_ line 163_ in execute\r\n  self.errorhandler(self_ exc_ value)\r\nFile "/usr/lib64/python2.4/site-packages/MySQLdb/connections.py"_ line 35_ in defaulterrorhandler\r\n  raise errorclass_ errorvalue\r\n}}}\r\n\r\n{{{\r\nSystem Information:\r\n\r\nUser Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.14) Gecko/20080404 Firefox/2.0.0.14\r\nTrac: 	0.11rc1\r\nPython: 	2.4.3 (#1_ Mar 14 2007_ 19:01:42) [GCC 4.1.1 20070105 (Red Hat 4.1.1-52)]\r\nsetuptools: 	0.6c8\r\nMySQL: 	server: "5.1.22-rc-log"_ client: "5.0.22"_ thread-safe: 0\r\nMySQLdb: 	1.2.1\r\nGenshi: 	0.5dev-r852\r\nmod_python: 	3.2.8\r\nSubversion: 	1.4.2 (r22196)\r\njQuery:	1.2.3\r\n}}},defect,new,highest,StractisticsPlugin,blocker,,,dagomez@gmv.com_ mjrecena@gmv.com,0.11