id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release 11484,Fresh install - SQL Error in Project Admin Page,JR,falkb,"Good morning, Fresh install of trac and Simple Multi Project Plugin First time checking out the plugin via !admin -> ""Manage Projects"" -> ""Projects"" I get the following: '''Trac detected an internal error:''' ''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 'restrict\n FROM\n smp_project' at line 2"")'' '''System Information:''' SimpleMultiProject 0.0.4dev /PATHtoPlugin/SimpleMultiProject-0.0.4dev-py2.7.egg User Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.63 Safari/537.36 Trac 0.12.5 Babel 0.9.6 Docutils 0.11 Genshi 0.6 (with speedups) GIT 1.8.3.2 mod_python 3.3.1 MySQL server: ""5.5.34-0ubuntu0.13.10.1"", client: ""5.5.34"", thread-safe: 1 MySQLdb 1.2.3 Pygments 1.6 Python 2.7.5+ (default, Sep 19 2013, 13:52:09) [GCC 4.8.1] pytz 2012c setuptools 0.6 Subversion 1.7.9 (!r1462340) jQuery 1.7.2 '''Most recent calls:''' {{{#!pycon File ""/usr/lib/python2.7/dist-packages/trac/web/main.py"", line 522, in _dispatch_request dispatcher.dispatch(req) File ""/usr/lib/python2.7/dist-packages/trac/web/main.py"", line 243, in dispatch resp = chosen_handler.process_request(req) File ""/usr/lib/python2.7/dist-packages/trac/admin/web_ui.py"", line 117, in process_request path_info) File ""build/bdist.linux-x86_64/egg/simplemultiproject/admin.py"", line 79, in render_admin_panel projects_rows = self.__SmpModel.get_all_projects() File ""build/bdist.linux-x86_64/egg/simplemultiproject/model.py"", line 88, in get_all_projects cursor.execute(query) File ""/usr/lib/python2.7/dist-packages/trac/db/util.py"", line 66, in execute return self.cursor.execute(sql) File ""/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py"", line 174, in execute self.errorhandler(self, exc, value) File ""/usr/lib/python2.7/dist-packages/MySQLdb/connections.py"", line 36, in defaulterrorhandler raise errorclass, errorvalue }}} Please let me know if you need any further information, Thanks JR",defect,closed,normal,SimpleMultiProjectPlugin,blocker,fixed,,,