id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release
4730,MySQL error when using Stratistics plugin for first time,anonymous,dagomez,I have just downloaded and compiled the Stratistics plugin to an egg file. I have then installed it_ given myself STRATISTICS_VIEW permission and then clicked on the new Stratistics button.\r\n\r\nI then get the following error:\r\n\r\n Trac detected an internal error:\r\n{{{\r\n\r\nFile "E:\\Python25\\lib\\site-packages\\trac-0.11.1-py2.5.egg\\trac\\web\\main.py"_ line 423_ in _dispatch_request\r\n  dispatcher.dispatch(req)\r\nFile "E:\\Python25\\lib\\site-packages\\trac-0.11.1-py2.5.egg\\trac\\web\\main.py"_ line 197_ in dispatch\r\n  resp = chosen_handler.process_request(req)\r\nFile "build\\bdist.win32\\egg\\stractistics\\web_ui.py"_ line 123_ in process_requestFile "build\\bdist.win32\\egg\\stractistics\\global_reports.py"_ line 31_ in global_reportsFile "build\\bdist.win32\\egg\\stractistics\\global_reports.py"_ line 64_ in _repository_activityFile "build\\bdist.win32\\egg\\stractistics\\global_reports.py"_ line 113_ in _most_active_repository_authorsFile "build\\bdist.win32\\egg\\stractistics\\util.py"_ line 117_ in execute_sql_expressionFile "E:\\Python25\\lib\\site-packages\\trac-0.11.1-py2.5.egg\\trac\\db\\util.py"_ line 51_ in execute\r\n  return self.cursor.execute(sql)\r\nFile "E:\\Python25\\lib\\site-packages\\mysql_python-1.2.2-py2.5-win32.egg\\MySQLdb\\cursors.py"_ line 166_ in executeFile "E:\\Python25\\lib\\site-packages\\mysql_python-1.2.2-py2.5-win32.egg\\MySQLdb\\connections.py"_ line 35_ in defaulterrorhandler\r\n\r\n\r\n\r\nProgrammingError: (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\n\r\nMy system info is as follows:\r\n\r\n{{{\r\nTrac:  	        0.11.1\r\nPython: 	2.5.2 (r252:60911_ Feb 21 2008_ 13:11:45) [MSC v.1310 32 bit (Intel)]\r\nsetuptools: 	0.6c9\r\nMySQL: 	server: "5.0.67-community-nt"_ client: "5.0.27"_ thread-safe: 1\r\nMySQLdb: 	1.2.2\r\nGenshi: 	0.5.1\r\nmod_python: 	3.3.1\r\njQuery:	        1.2.6\r\n}}}\r\n\r\n\r\n,defect,closed,highest,StractisticsPlugin,blocker,duplicate,MySQL Error,,0.11