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. I then get the following error: Trac detected an internal error: {{{ File ""E:\Python25\lib\site-packages\trac-0.11.1-py2.5.egg\trac\web\main.py"", line 423, in _dispatch_request dispatcher.dispatch(req) File ""E:\Python25\lib\site-packages\trac-0.11.1-py2.5.egg\trac\web\main.py"", line 197, in dispatch resp = chosen_handler.process_request(req) File ""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 return self.cursor.execute(sql) File ""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 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"") }}} My system info is as follows: {{{ Trac: 0.11.1 Python: 2.5.2 (r252:60911, Feb 21 2008, 13:11:45) [MSC v.1310 32 bit (Intel)] setuptools: 0.6c9 MySQL: server: ""5.0.67-community-nt"", client: ""5.0.27"", thread-safe: 1 MySQLdb: 1.2.2 Genshi: 0.5.1 mod_python: 3.3.1 jQuery: 1.2.6 }}} " defect closed highest StractisticsPlugin blocker duplicate MySQL Error 0.11