Modify ↓
      
Opened 17 years ago
Closed 17 years ago
#7908 closed defect (invalid)
OperationalError: near ",": syntax error
| Reported by: | Owned by: | ||
|---|---|---|---|
| Priority: | normal | Milestone: | |
| Component: | general | Version: | 0.11.1 | 
| Severity: | normal | Keywords: | teamcalendar | 
| Cc: | Branch: | ||
| Release Notes: | |||
| API Changes: | |||
| Internal Changes: | |||
Description
How to Reproduce
While doing a POST operation on /teamcalendar, Trac issued an internal error.
I tried to save one or more entries.
Request parameters:
{'2008-12-23.eldn': u'1',
 '__FORM_TOKEN': u'ecf35174cbc56575139b58c9',
 'from_date': u'2008-12-15',
 'orig_from_date': u'2008-12-15',
 'orig_to_date': u'2009-01-18',
 'to_date': u'2009-01-18',
 'update_calendar': u'Apply changes'}
User Agent was: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.0.3) Gecko/2008092816 Iceweasel/3.0.3 (Debian-3.0.3-3)
System Information
| Trac |  0.11.1 
 | 
| Python |  2.5.2 (r252:60911, Nov 14 2008, 19:46:32)  [GCC 4.3.2] 
 | 
| setuptools |  0.6c8 
 | 
| SQLite |  3.5.9 
 | 
| pysqlite |  2.4.1 
 | 
| Genshi |  0.5.1 
 | 
| Pygments |  0.10 
 | 
| Subversion |  1.5.1 (r32289) 
 | 
| jQuery: |  1.2.6 
 | 
Python Traceback
Traceback (most recent call last):
  File "/usr/lib/python2.5/site-packages/trac/web/main.py", line 423, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.5/site-packages/trac/web/main.py", line 197, in dispatch
    resp = chosen_handler.process_request(req)
  File "build/bdist.linux-i686/egg/teamcalendar/calendar.py", line 148, in process_request
    self.update_timetable(tuples)
  File "build/bdist.linux-i686/egg/teamcalendar/calendar.py", line 83, in update_timetable
    ", ".join(["('%s', '%s', %d)" % (t[0], t[1], t[2] and 1 or 0,) for t in tuples])))
  File "/usr/lib/python2.5/site-packages/trac/db/util.py", line 51, in execute
    return self.cursor.execute(sql)
  File "/usr/lib/python2.5/site-packages/trac/db/sqlite_backend.py", line 58, in execute
    args or [])
  File "/usr/lib/python2.5/site-packages/trac/db/sqlite_backend.py", line 50, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: near ",": syntax error
Attachments (0)
  Note:
 See   TracTickets
 for help on using tickets.
    


  
/teamcalendaris not part of Trac core: this error comes from a plugin, and as such should be reported to the plugin maintainer.