Opened 10 years ago

Last modified 10 years ago

#11634 reopened defect

Create a NEW ticket -> rescheduleTickets OperationalError: near ",": syntax error — at Version 2

Reported by: jc Owned by: Chris Nelson
Priority: normal Component: TracJsGanttPlugin
Severity: normal Keywords:
Cc: Trac Release: 1.0

Description (last modified by Ryan J Ollos)

I get this error when creating a new ticket (with empty Dates etc.)

tracjsgantt.tracpm.ticketrescheduler = enabled   

This error has been reported is some ways in the past:

But I can't see a solution to the Problem beyond:

tracjsgantt.tracpm.ticketrescheduler = disabled   

My question is, is there a solution to this Problem and what exactly am I losing by disabling tracjsgantt.tracpm.ticketrescheduler

The error report:

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 Trac-jsGantt plugin seems to be involved. 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 a new bug report describing the problem and explain how to reproduce it. Python traceback Most recent call last:

    File "/usr/local/lib/python2.7/dist-packages/Trac-1.0.1-py2.7.egg/trac/web/main.py", line 497, in _dispatch_request
    File "/usr/local/lib/python2.7/dist-packages/Trac-1.0.1-py2.7.egg/trac/web/main.py", line 214, in dispatch
    File "/usr/local/lib/python2.7/dist-packages/Trac-1.0.1-py2.7.egg/trac/ticket/web_ui.py", line 180, in process_request
    File "/usr/local/lib/python2.7/dist-packages/Trac-1.0.1-py2.7.egg/trac/ticket/web_ui.py", line 465, in _process_newticket_request
    File "/usr/local/lib/python2.7/dist-packages/Trac-1.0.1-py2.7.egg/trac/ticket/web_ui.py", line 1289, in _do_create
    File "/usr/local/lib/python2.7/dist-packages/Trac-1.0.1-py2.7.egg/trac/ticket/model.py", line 256, in insert
    File "/usr/local/lib/python2.7/dist-packages/Trac_jsGantt-0.10_r13705-py2.7.egg/tracjsgantt/tracpm.py", line 2950, in ticket_created
    File "/usr/local/lib/python2.7/dist-packages/Trac_jsGantt-0.10_r13705-py2.7.egg/tracjsgantt/tracpm.py", line 2917, in rescheduleTickets
    File "/usr/local/lib/python2.7/dist-packages/Trac-1.0.1-py2.7.egg/trac/db/util.py", line 65, in execute
    File "/usr/local/lib/python2.7/dist-packages/Trac-1.0.1-py2.7.egg/trac/db/sqlite_backend.py", line 78, in execute
    File "/usr/local/lib/python2.7/dist-packages/Trac-1.0.1-py2.7.egg/trac/db/sqlite_backend.py", line 56, in execute
    File "/usr/local/lib/python2.7/dist-packages/Trac-1.0.1-py2.7.egg/trac/db/sqlite_backend.py", line 48, in _rollback_on_error

System information:

User Agent: Mozilla/5.0 (Windows NT 6.2; WOW64; rv:27.0) Gecko/20100101 Firefox/27.0
Trac 	1.0.1
Babel 	0.9.6
Docutils 	0.8.1
Genshi 	0.6 (with speedups)
mod_wsgi 	3.3 (WSGIProcessGroup WSGIApplicationGroup %{GLOBAL})
Pygments 	1.4
pysqlite 	2.6.0
Python 	2.7.3 (default, Feb 27 2014, 20:09:21) [GCC 4.6.3]
pytz 	2011k
setuptools 	3.2
SQLite 	3.7.9
Subversion 	1.6.17 (r1128011)
jQuery	1.7.2
Enabled plugins:
timingandestimationplugin 	1.3.7b 	/usr/local/lib/python2.7/dist-packages/timingandestimationplugin-1.3.7b-py2.7.egg
Trac-jsGantt 	0.10-r13705 	/usr/local/lib/python2.7/dist-packages/Trac_jsGantt-0.10_r13705-py2.7.egg
TracDateField 	3.0.0dev-r12118 	/usr/local/lib/python2.7/dist-packages/TracDateField-3.0.0dev_r12118-py2.7.egg
TracMasterTickets 	3.0.5dev-r13684 	/usr/local/lib/python2.7/dist-packages/TracMasterTickets-3.0.5dev_r13684-py2.7.egg
TracSubTicketsPlugin 	0.2.0.dev-20140315 	/usr/local/lib/python2.7/dist-packages/TracSubTicketsPlugin-0.2.0.dev_20140315-py2.7.egg

Change History (2)

comment:1 Changed 10 years ago by jc

Should read: I get this error when creating a new ticket (with empty Dates etc.) AND

tracjsgantt.tracpm.ticketrescheduler = enabled
Last edited 10 years ago by Ryan J Ollos (previous) (diff)

comment:2 Changed 10 years ago by Ryan J Ollos

Description: modified (diff)
Note: See TracTickets for help on using tickets.