Cannot batch modify tickets

[wrobel.przemyslaw@…]

When this plugin is enabled I cannot batch modify tickets because of error. Details attached.

[wrobel.przemyslaw@…]

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.

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) [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

[Ryan J Ollos]

All of the line ending were stripped out of the content. Could you try reposting?

[wrobel.przemyslaw@…]

error details

[Chris Nelson]

I have had no problem with batch modify and the Trac-jsGantt plugin. Can you provide more details of what you were trying to change when this happened? Does it occur if you use batch modify to add a comment to multiple tickets?

Also, do you have the background ticket rescheduler enabled? If so, try it with that disabled.