id summary reporter owner description type status priority component severity resolution keywords cc release 3239 Get database error when using CAST( .. AS ..) syntax nicolasm@… Emilien Klein "I get this error after installing this plugin: {{{ 11:08:47 Trac[__init__] ERROR: near ""as"": syntax error Traceback (most recent call last): File ""/usr/lib/python2.4/site-packages/Trac-0.11-py2.4.egg/trac/web/main.py"", line 423, in _dispatch_request dispatcher.dispatch(req) File ""/usr/lib/python2.4/site-packages/Trac-0.11-py2.4.egg/trac/web/main.py"", line 219, in dispatch data, content_type) File ""/usr/lib/python2.4/site-packages/Trac-0.11-py2.4.egg/trac/web/chrome.py"", line 690, in render_template stream |= self._filter_stream(req, method, filename, stream, data) File ""/usr/lib/python2.4/site-packages/Genshi-0.5-py2.4-linux-i686.egg/genshi/core.py"", line 128, in __or__ File ""/usr/lib/python2.4/site-packages/Trac-0.11-py2.4.egg/trac/web/chrome.py"", line 789, in inner data) File ""build/bdist.linux-i686/egg/ticketmodifiedfiles/ticketmodifiedfiles.py"", line 78, in filter_stream File ""build/bdist.linux-i686/egg/ticketmodifiedfiles/ticketmodifiedfiles.py"", line 137, in __process_ticket_request File ""/usr/lib/python2.4/site-packages/Trac-0.11-py2.4.egg/trac/db/util.py"", line 51, in execute return self.cursor.execute(sql) File ""/usr/lib/python2.4/site-packages/sqlite/main.py"", line 244, in execute self.rs = self.con.db.execute(SQL) DatabaseError: near ""as"": syntax error }}} I have fixed it temporarily with: {{{ Line 137: - cursor.execute(""SELECT change_type FROM node_change WHERE path='"" + file + ""' ORDER BY CAST(rev as integer) DESC LIMIT 1"") + cursor.execute(""SELECT change_type FROM node_change WHERE path='"" + file + ""' ORDER BY 1*rev DESC LIMIT 1"") }}} I think I have new enough sqlite installed, but who knows..." defect closed normal TicketModifiedFilesPlugin normal fixed 0.11