OperationalError: no such column: businessvalue

[jan]

How to Reproduce

While doing a POST operation on /ticket/49, Trac issued an internal error.

(i changed the task from query to task and reassigned to yulia and got the bug )

Request parameters:

{'__FORM_TOKEN': u'b2f71090e8d0372b411f6393',
 'action': u'reassign',
 'action_reassign_reassign_owner': u'yulia',
 'cnum': u'3',
 'comment': u'Yulia -\r\n\r\nAll of the artwork for the first 40 episodic pages of the scrapbooks have been delivered to decode. The after effect files have been delivered from Hackett films to Martin at DeCode.  Please have your team  begin constructing the pages for dig it all as they are to be exact replicas of the broadcast art.\r\nwe will be providing example pages with the tabs and arrows as well as the tabs and arrows as assets in the next day or so. we are also currently working on the design for each of the unique icons, but you can use a stand in for now - \r\nWe will also be providing an example of how the still frame of dirtgirl should appear within the photo frames on the page. (you can reference the gallery for now to see most of the art).\r\nIt would be great if you could also provide us with several examples of the how the photo will transition to full screen and back again.\r\nWe will also be providing you a list of activities per episode - and we have been brainstorming thru those - you can see the result on a google doc posted on http://docs.google.com/Doc?id=dfvnggmx_3ft3rjrcr\r\nplease do NOT share this with Jean Guy- as these are ideas and not final - we would love it if you and your team would also send us some brainstorming ideas for activities per epsiode.\r\n',
 'field_businessvalue': u'',
 'field_cc': u'',
 'field_component': u'component1',
 'field_description': u"Scrapbook:\r\n\r\nCan you please provide details on whether the Media Player will exist inside the Scrapbook or as an independent module? \r\nPlease refer to the revised flow chart (page 2) and confirm that it more accurately reflects the brief and the scope of work. \r\n\r\nPlease confirm that you will be providing us with the 1 minute videos.\r\nPlease let us know when we will be receiving the 1st video.\r\nPlease let us know what format would the videos be delivered in.\r\n\r\n\r\nPlease confirm that you would like to produce all the of the following:\r\n\r\n52 - one minute with dirtgirl' videos \r\n52 - unique home pages \r\n52 activities pages \r\n\r\nTotal of 156 web \u201cpages\u201d?\r\n\r\n\r\n\u201cLeft hand tab - upper - index of all home pages \r\nLeft hand tab - lower - (when needed) displays the home page icon \r\nRight hand tab - upper - home page activity page \r\nRight hand tab - lower - index of all UGC from dig it all... \r\nLower left arrow - turns scrapbook back one page - to previous home page, or if on activity page turns back to home page \r\nLower right arrow - turns page to activity page - if on activity page then NO arrow appears. This implies you can only access activity page thru the home page. or do we have the arrow and move onto the UGC page?\u201d\r\nPlease confirm the action each of these elements would perform.\r\nCan you please provide a diagram of what this would look like to ensure we clearly understand your vision?\r\nNeed to consider:\r\na) is this too much information for the age group?\r\nb) navigational tool \u2013 how do you leave with/without compass?\r\n",
 'field_drp_resources': u'',
 'field_i_links': u'',
 'field_keywords': u'',
 'field_milestone': u'',
 'field_o_links': u'',
 'field_priority': u'should have',
 'field_rd_points': u'',
 'field_remaining_time': u'',
 'field_reporter': u'jan',
 'field_sprint': u'',
 'field_story_priority': u'',
 'field_summary': u'Question 6: Scrapbook',
 'field_type': u'task',
 'field_version': u'',
 'id': u'49',
 'pane': u'edit',
 'replyto': u'',
 'submit': u'Submit changes',
 'ts': u'2009-05-26 22:10:38+00:00'}

User Agent was: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.4; en-US; rv:1.9.0.10) Gecko/2009042315 Firefox/3.0.10

System Information

Trac	0.11.4
Python	2.4.4 (#1, Apr 15 2008, 23:37:53) [GCC 4.1.2 20061115 (prerelease) (Debian 4.1.1-21)]
setuptools	0.6c9
SQLite	3.3.8
pysqlite	2.3.2
Genshi	0.5.1
Agilo	0.7.3.3-r1417-20090313
Subversion	1.4.2 (r22196)
jQuery:	1.2.6

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/web/main.py", line 435, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/web/main.py", line 205, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/ticket/web_ui.py", line 182, in process_request
    return self._process_ticket_request(req)
  File "/usr/lib/python2.4/site-packages/agilo-0.7.3.3_r1417_20090313-py2.4.egg/agilo/ticket/web_ui.py", line 202, in _process_ticket_request
    template, data, content_type = super(AgiloTicketModule, self)._process_ticket_request(req)
  File "/usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/ticket/web_ui.py", line 508, in _process_ticket_request
    self._do_save(req, ticket, action)
  File "/usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/ticket/web_ui.py", line 1014, in _do_save
    cnum=internal_cnum):
  File "/usr/lib/python2.4/site-packages/agilo-0.7.3.3_r1417_20090313-py2.4.egg/agilo/ticket/model.py", line 645, in save_changes
    res = super(AgiloTicket, self).save_changes(author, comment, when, db, cnum)
  File "/usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/ticket/model.py", line 273, in save_changes
    (self[name], self.id))
  File "/usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/db/sqlite_backend.py", line 58, in execute
    args or [])
  File "/usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/db/sqlite_backend.py", line 50, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: no such column: businessvalue

[Remy Blank]

PluginIssue (agilo), please report it to the plugin maintainer.

OT: Would it be possible to train the SpamFilter to reject all tickets whose description contain the word "agilo"? Those are the most frequent invalid tickets these days…

[Christian Boos]

Replying to rblank:

OT: Would it be possible to train the SpamFilter to reject all tickets whose description contain the word "agilo"?

The SpamFilter is not really appropriate for this: imagine the frustration of someone trying to create a ticket and see his (otherwise valid) report rejected as spam…

I think my MostFrequentDuplicatesPlugin idea is more appropriate.

[Remy Blank]

Replying to cboos:

The SpamFilter is not really appropriate for this: imagine the frustration of someone trying to create a ticket and see his (otherwise valid) report rejected as spam…

Sure, I was just thinking in terms of "highest added value for least effort" :-)