#601: ProgrammingError: column "product" specified more than onceLINE 1:
...tus,product,severity,keywords,cc,time,changetime, product) V...
^
-----------------------+--------------------
Reporter: ogaerick | Owner: nobody
Type: defect | Status: new
Priority: blocker | Milestone:
Component: dashboard | Version:
Keywords: |
-----------------------+--------------------
==== How to Reproduce ====
While doing a POST operation on `/newticket`, Trac issued an internal
error.
''(please provide additional details here)''
Request parameters:
{{{
{'__FORM_TOKEN': u'c0b60abc8107497945866914',
'comment': u'',
'field_cc': u'',
'field_description': u'',
'field_keywords': u'',
'field_reporter': u'lok',
'field_severity': u'none',
'field_summary': u'aaaaaaaa',
'start_time': u'0',
'submit': u'Create ticket',
'view_time': u'0'}
}}}
User agent: `Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_4)
AppleWebKit/537.36 (KHTML, like Gecko) Chrome/28.0.1500.71 Safari/537.36`
==== System Information ====
|| '''`Trac`''' || `1.0.1` [[br]] `` ||
|| '''`Babel`''' || `0.9.6` ||
|| '''`Bloodhound Trac`''' || `1.0.1` ||
|| '''`Genshi`''' || `0.7 (without speedups)` ||
|| '''`mod_wsgi`''' || `3.3 (WSGIProcessGroup bloodhound_tracker
WSGIApplicationGroup %{GLOBAL})` ||
|| '''`psycopg2`''' || `2.4.5` ||
|| '''`Pygments`''' || `1.6` ||
|| '''`Python`''' || `2.7.3 (default, Apr 10 2013, 06:31:07) ` [[br]]
`[GCC 4.6.3]` ||
|| '''`pytz`''' || `2013b` ||
|| '''`setuptools`''' || `0.6` ||
|| '''`jQuery`''' || `1.7.2` ||
==== Enabled Plugins ====
|| '''`bhrelations.widgets.relations`''' || `N/A` ||
|| '''`BloodhoundDashboardPlugin`''' || `0.6.0` ||
|| '''`BloodhoundMultiProduct`''' || `0.6.0` ||
|| '''`BloodhoundRelationsPlugin`''' || `0.6.0` ||
|| '''`BloodhoundSearchPlugin`''' || `0.6.0` ||
|| '''`BloodhoundTheme`''' || `0.6.0` ||
|| '''`TracAccountManager`''' || `0.4.3` ||
|| '''`TracPermRedirect`''' || `3.0` ||
|| '''`TracThemeEngine`''' || `2.2.0` ||
==== Python Traceback ====
{{{
Traceback (most recent call last):
File "/opt/apache-bloodhound-0.6/trac/trac/web/main.py", line 477, in
_dispatch_request
dispatcher.dispatch(req)
File "/opt/apache-bloodhound-0.6/trac/trac/web/main.py", line 214, in
dispatch
resp = chosen_handler.process_request(req)
File "/opt/apache-bloodhound-0.6/trac/trac/ticket/web_ui.py", line 180,
in process_request
return self._process_newticket_request(req)
File "/opt/apache-bloodhound-0.6/trac/trac/ticket/web_ui.py", line 465,
in _process_newticket_request
self._do_create(req, ticket) # (redirected if successful)
File "/opt/apache-bloodhound-0.6/trac/trac/ticket/web_ui.py", line 1289,
in _do_create
ticket.insert()
File "/opt/apache-bloodhound-0.6/trac/trac/ticket/model.py", line 241,
in insert
[values[name] for name in std_fields])
File "/opt/apache-
bloodhound-0.6/bloodhound_multiproduct/multiproduct/dbcursor.py", line
143, in execute
return self.cursor.execute(sql, args=args)
File "/opt/apache-
bloodhound-0.6/bloodhound_multiproduct/multiproduct/dbcursor.py", line 83,
in execute
return super(BloodhoundIterableCursor,
self).execute(translate_sql(self.env, sql), args=args)
File "/opt/apache-bloodhound-0.6/trac/trac/db/util.py", line 65, in
execute
return self.cursor.execute(sql_escape_percent(sql), args)
ProgrammingError: column "product" specified more than once
LINE 1: ...tus,product,severity,keywords,cc,time,changetime, product) V...
^
}}}
--
Ticket URL: <https://issues.apache.org/bloodhound/ticket/601>
Apache Bloodhound <https://issues.apache.org/bloodhound/>
The Apache Bloodhound issue tracker