Context Navigation Oops Trac detected an internal error: OperationalError: near ",": syntax error This is probably a local installation issue. Found a bug in Trac? If you think this should work and you can reproduce the problem, you should consider creating a bug report. Note that the following plugins seem to be involved: trac.web.main, trac.ticket.batch, trac.ticket.model, Trac-jsGantt, trac.db.sqlite-backend Please report this issue to the plugin maintainer. Before you do that, though, please first try searching for similar issues, as it is quite likely that this problem has been reported before. For questions about installation and configuration of Trac or its plugins, please try the mailing list instead of creating a ticket. Otherwise, please ==== How to Reproduce ==== While doing a POST operation on `/batchmodify`, Trac issued an internal error. ''(please provide additional details here)'' Request parameters: {{{ {'__FORM_TOKEN': u'f5fd4f9b924fafae0740dffd', 'action': u'reassign', 'action_reassign_reassign_owner': u'stoklosa', 'action_resolve_resolve_resolution': u'fixed', 'batchmod_submit': u'Change tickets', 'batchmod_value_comment': u'', 'query_href': u'/dspace/query?owner=!~jacek&status=accepted&status=assigned&status=new&status=reopened&col=id&col=summary&col=status&col=type&col=priority&col=milestone&col=version&order=priority', 'selected_tickets': u'7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23'} }}} User agent: `#USER_AGENT#` ==== System Information ==== || '''`Trac`''' || `1.0.1` || || '''`Babel`''' || `0.9.5` || || '''`CustomFieldAdmin`''' || `0.2.5` || || '''`Genshi`''' || `0.6 (without speedups)` || || '''`Pygments`''' || `1.6` || || '''`pysqlite`''' || `2.6.0` || || '''`Python`''' || `2.6.7 (r267:88850, Jan 1 2012, 22:41:05) ` [[br]] `[GCC 4.5.3 20110515 (release)]` || || '''`RPC`''' || `1.1.2-r12168` || || '''`setuptools`''' || `0.6c11` || || '''`SQLite`''' || `3.7.6.3` || || '''`jQuery`''' || `#JQUERY#` || ==== Enabled Plugins ==== || '''`AutocompleteUsers`''' || `0.4.2` || || '''`ComponentsListMacro`''' || `r8457 ` || || '''`DuplicateTicketSearch`''' || `1.0.1` || || '''`ScreenshotPaste`''' || `0.1.2` || || '''`TicketImport`''' || `0.8` || || '''`TicketMoverPlugin`''' || `0.1.1` || || '''`TicketSidebarProvider`''' || `0.0` || || '''`Trac-jsGantt`''' || `0.10-r12998` || || '''`trac.about`''' || `N/A` || || '''`trac.admin.api`''' || `N/A` || || '''`trac.admin.console`''' || `N/A` || || '''`trac.admin.web-ui`''' || `N/A` || || '''`trac.attachment`''' || `N/A` || || '''`trac.cache`''' || `N/A` || || '''`trac.config`''' || `N/A` || || '''`trac.db.api`''' || `N/A` || || '''`trac.db.mysql-backend`''' || `N/A` || || '''`trac.db.postgres-backend`''' || `N/A` || || '''`trac.db.sqlite-backend`''' || `N/A` || || '''`trac.env`''' || `N/A` || || '''`trac.mimeview.api`''' || `N/A` || || '''`trac.mimeview.patch`''' || `N/A` || || '''`trac.mimeview.pygments`''' || `N/A` || || '''`trac.notification`''' || `N/A` || || '''`trac.perm`''' || `N/A` || || '''`trac.prefs.web-ui`''' || `N/A` || || '''`trac.resource`''' || `N/A` || || '''`trac.search.web-ui`''' || `N/A` || || '''`trac.ticket.admin`''' || `N/A` || || '''`trac.ticket.api`''' || `N/A` || || '''`trac.ticket.batch`''' || `N/A` || || '''`trac.ticket.default-workflow`''' || `N/A` || || '''`trac.ticket.model`''' || `N/A` || || '''`trac.ticket.notification`''' || `N/A` || || '''`trac.ticket.query`''' || `N/A` || || '''`trac.ticket.report`''' || `N/A` || || '''`trac.ticket.roadmap`''' || `N/A` || || '''`trac.ticket.web-ui`''' || `N/A` || || '''`trac.timeline.web-ui`''' || `N/A` || || '''`trac.versioncontrol.admin`''' || `N/A` || || '''`trac.versioncontrol.api`''' || `N/A` || || '''`trac.versioncontrol.svn-authz`''' || `N/A` || || '''`trac.versioncontrol.web-ui.browser`''' || `N/A` || || '''`trac.versioncontrol.web-ui.changeset`''' || `N/A` || || '''`trac.versioncontrol.web-ui.log`''' || `N/A` || || '''`trac.versioncontrol.web-ui.main`''' || `N/A` || || '''`trac.web.auth`''' || `N/A` || || '''`trac.web.chrome`''' || `N/A` || || '''`trac.web.main`''' || `N/A` || || '''`trac.web.session`''' || `N/A` || || '''`trac.wiki.admin`''' || `N/A` || || '''`trac.wiki.api`''' || `N/A` || || '''`trac.wiki.intertrac`''' || `N/A` || || '''`trac.wiki.interwiki`''' || `N/A` || || '''`trac.wiki.macros`''' || `N/A` || || '''`trac.wiki.parser`''' || `N/A` || || '''`trac.wiki.web-api`''' || `N/A` || || '''`trac.wiki.web-ui`''' || `N/A` || || '''`Tracchildtickets`''' || `2.4.0-BETA` || || '''`TracCustomFieldAdmin`''' || `0.2.5` || || '''`TracDiscussion`''' || `0.8-r9877` || || '''`TracHackergotchi`''' || `1.1` || || '''`TracMasterTickets`''' || `3.0.2` || || '''`tracsearchall`''' || `0.8` || || '''`TracXMLRPC`''' || `1.1.2-r12168` || ==== Python Traceback ==== {{{ Traceback (most recent call last): File "/usr/share/python2.6/site-packages/trac/web/main.py", line 497, in _dispatch_request dispatcher.dispatch(req) File "/usr/share/python2.6/site-packages/trac/web/main.py", line 214, in dispatch resp = chosen_handler.process_request(req) File "/usr/share/python2.6/site-packages/trac/ticket/batch.py", line 62, in process_request new_values, comment, action) File "/usr/share/python2.6/site-packages/trac/ticket/batch.py", line 167, in _save_ticket_changes t.save_changes(req.authname, comment, when=when) File "/usr/share/python2.6/site-packages/trac/ticket/model.py", line 365, in save_changes listener.ticket_changed(self, comment, author, old_values) File "build/bdist.linux-i686/egg/tracjsgantt/tracpm.py", line 2950, in ticket_changed self.rescheduleTickets(ticket, old_values) File "build/bdist.linux-i686/egg/tracjsgantt/tracpm.py", line 2910, in rescheduleTickets values) File "/usr/share/python2.6/site-packages/trac/db/util.py", line 65, in execute return self.cursor.execute(sql_escape_percent(sql), args) File "/usr/share/python2.6/site-packages/trac/db/sqlite_backend.py", line 78, in execute result = PyFormatCursor.execute(self, *args) File "/usr/share/python2.6/site-packages/trac/db/sqlite_backend.py", line 56, in execute args or []) File "/usr/share/python2.6/site-packages/trac/db/sqlite_backend.py", line 48, in _rollback_on_error return function(self, *args, **kwargs) OperationalError: near ",": syntax error }}} a new bug report describing the problem and explain how to reproduce it. Python Traceback Most recent call last: File "/usr/share/python2.6/site-packages/trac/web/main.py", line 497, in _dispatch_request dispatcher.dispatch(req) File "/usr/share/python2.6/site-packages/trac/web/main.py", line 214, in dispatch resp = chosen_handler.process_request(req) File "/usr/share/python2.6/site-packages/trac/ticket/batch.py", line 62, in process_request new_values, comment, action) File "/usr/share/python2.6/site-packages/trac/ticket/batch.py", line 167, in _save_ticket_changes t.save_changes(req.authname, comment, when=when) File "/usr/share/python2.6/site-packages/trac/ticket/model.py", line 365, in save_changes listener.ticket_changed(self, comment, author, old_values) File "build/bdist.linux-i686/egg/tracjsgantt/tracpm.py", line 2950, in ticket_changed self.rescheduleTickets(ticket, old_values) File "build/bdist.linux-i686/egg/tracjsgantt/tracpm.py", line 2910, in rescheduleTickets values) File "/usr/share/python2.6/site-packages/trac/db/util.py", line 65, in execute return self.cursor.execute(sql_escape_percent(sql), args) File "/usr/share/python2.6/site-packages/trac/db/sqlite_backend.py", line 78, in execute result = PyFormatCursor.execute(self, *args) File "/usr/share/python2.6/site-packages/trac/db/sqlite_backend.py", line 56, in execute args or []) File "/usr/share/python2.6/site-packages/trac/db/sqlite_backend.py", line 48, in _rollback_on_error return function(self, *args, **kwargs) System Information: Trac 1.0.1 Babel 0.9.5 CustomFieldAdmin 0.2.5 Genshi 0.6 (without speedups) Pygments 1.6 pysqlite 2.6.0 Python 2.6.7 (r267:88850, Jan 1 2012, 22:41:05) [GCC 4.5.3 20110515 (release)] RPC 1.1.2-r12168 setuptools 0.6c11 SQLite 3.7.6.3 Enabled Plugins: AutocompleteUsers 0.4.2 /usr/share/python2.6/site-packages/AutocompleteUsers-0.4.2-py2.6.egg ComponentsListMacro r8457 /usr/share/trac/plugins/ComponentsListMacro.pyc DuplicateTicketSearch 1.0.1 /usr/share/python2.6/site-packages/DuplicateTicketSearch-1.0.1-py2.6.egg ScreenshotPaste 0.1.2 /usr/share/trac/plugins/ScreenshotPaste-0.1.2-py2.6.egg TicketImport 0.8 /usr/share/python2.6/site-packages/TicketImport-0.8-py2.6.egg TicketMoverPlugin 0.1.1 /usr/share/python2.6/site-packages/TicketMoverPlugin-0.1.1-py2.6.egg TicketSidebarProvider 0.0 /usr/share/python2.6/site-packages/TicketSidebarProvider-0.0-py2.6.egg Trac-jsGantt 0.10-r12998 /usr/share/python2.6/site-packages/Trac_jsGantt-0.10_r12998-py2.6.egg trac.about N/A /usr/share/python2.6/site-packages/trac/about.pyc trac.admin.api N/A /usr/share/python2.6/site-packages/trac/admin/api.pyc trac.admin.console N/A /usr/share/python2.6/site-packages/trac/admin/console.pyc trac.admin.web-ui N/A /usr/share/python2.6/site-packages/trac/admin/web_ui.pyc trac.attachment N/A /usr/share/python2.6/site-packages/trac/attachment.pyc trac.cache N/A /usr/share/python2.6/site-packages/trac/cache.pyc trac.config N/A /usr/share/python2.6/site-packages/trac/config.pyc trac.db.api N/A /usr/share/python2.6/site-packages/trac/db/api.pyc trac.db.mysql-backend N/A /usr/share/python2.6/site-packages/trac/db/mysql_backend.pyc trac.db.postgres-backend N/A /usr/share/python2.6/site-packages/trac/db/postgres_backend.pyc trac.db.sqlite-backend N/A /usr/share/python2.6/site-packages/trac/db/sqlite_backend.pyc trac.env N/A /usr/share/python2.6/site-packages/trac/env.pyc trac.mimeview.api N/A /usr/share/python2.6/site-packages/trac/mimeview/api.pyc trac.mimeview.patch N/A /usr/share/python2.6/site-packages/trac/mimeview/patch.pyc trac.mimeview.pygments N/A /usr/share/python2.6/site-packages/trac/mimeview/pygments.pyc trac.notification N/A /usr/share/python2.6/site-packages/trac/notification.pyc trac.perm N/A /usr/share/python2.6/site-packages/trac/perm.pyc trac.prefs.web-ui N/A /usr/share/python2.6/site-packages/trac/prefs/web_ui.pyc trac.resource N/A /usr/share/python2.6/site-packages/trac/resource.pyc trac.search.web-ui N/A /usr/share/python2.6/site-packages/trac/search/web_ui.pyc trac.ticket.admin N/A /usr/share/python2.6/site-packages/trac/ticket/admin.pyc trac.ticket.api N/A /usr/share/python2.6/site-packages/trac/ticket/api.pyc trac.ticket.batch N/A /usr/share/python2.6/site-packages/trac/ticket/batch.pyc trac.ticket.default-workflow N/A /usr/share/python2.6/site-packages/trac/ticket/default_workflow.pyc trac.ticket.model N/A /usr/share/python2.6/site-packages/trac/ticket/model.pyc trac.ticket.notification N/A /usr/share/python2.6/site-packages/trac/ticket/notification.pyc trac.ticket.query N/A /usr/share/python2.6/site-packages/trac/ticket/query.pyc trac.ticket.report N/A /usr/share/python2.6/site-packages/trac/ticket/report.pyc trac.ticket.roadmap N/A /usr/share/python2.6/site-packages/trac/ticket/roadmap.pyc trac.ticket.web-ui N/A /usr/share/python2.6/site-packages/trac/ticket/web_ui.pyc trac.timeline.web-ui N/A /usr/share/python2.6/site-packages/trac/timeline/web_ui.pyc trac.versioncontrol.admin N/A /usr/share/python2.6/site-packages/trac/versioncontrol/admin.pyc trac.versioncontrol.api N/A /usr/share/python2.6/site-packages/trac/versioncontrol/api.pyc trac.versioncontrol.svn-authz N/A /usr/share/python2.6/site-packages/trac/versioncontrol/svn_authz.pyc trac.versioncontrol.web-ui.browser N/A /usr/share/python2.6/site-packages/trac/versioncontrol/web_ui/browser.pyc trac.versioncontrol.web-ui.changeset N/A /usr/share/python2.6/site-packages/trac/versioncontrol/web_ui/changeset.pyc trac.versioncontrol.web-ui.log N/A /usr/share/python2.6/site-packages/trac/versioncontrol/web_ui/log.pyc trac.versioncontrol.web-ui.main N/A /usr/share/python2.6/site-packages/trac/versioncontrol/web_ui/main.pyc trac.web.auth N/A /usr/share/python2.6/site-packages/trac/web/auth.pyc trac.web.chrome N/A /usr/share/python2.6/site-packages/trac/web/chrome.pyc trac.web.main N/A /usr/share/python2.6/site-packages/trac/web/main.pyc trac.web.session N/A /usr/share/python2.6/site-packages/trac/web/session.pyc trac.wiki.admin N/A /usr/share/python2.6/site-packages/trac/wiki/admin.pyc trac.wiki.api N/A /usr/share/python2.6/site-packages/trac/wiki/api.pyc trac.wiki.intertrac N/A /usr/share/python2.6/site-packages/trac/wiki/intertrac.pyc trac.wiki.interwiki N/A /usr/share/python2.6/site-packages/trac/wiki/interwiki.pyc trac.wiki.macros N/A /usr/share/python2.6/site-packages/trac/wiki/macros.pyc trac.wiki.parser N/A /usr/share/python2.6/site-packages/trac/wiki/parser.pyc trac.wiki.web-api N/A /usr/share/python2.6/site-packages/trac/wiki/web_api.pyc trac.wiki.web-ui N/A /usr/share/python2.6/site-packages/trac/wiki/web_ui.pyc Tracchildtickets 2.4.0-BETA /usr/share/python2.6/site-packages/Tracchildtickets-2.4.0_BETA-py2.6.egg TracCustomFieldAdmin 0.2.5 /usr/share/python2.6/site-packages/TracCustomFieldAdmin-0.2.5-py2.6.egg TracDiscussion 0.8-r9877 /usr/share/trac/plugins/TracDiscussion-0.8_r9877-py2.6.egg TracHackergotchi 1.1 /usr/share/python2.6/site-packages/TracHackergotchi-1.1-py2.6.egg TracMasterTickets 3.0.2 /usr/share/trac/plugins/TracMasterTickets-3.0.2-py2.6.egg tracsearchall 0.8 /usr/share/python2.6/site-packages/tracsearchall-0.8-py2.6.egg TracXMLRPC 1.1.2-r12168 /usr/share/python2.6/site-packages/TracXMLRPC-1.1.2_r12168-py2.6.egg