#635: ProgrammingError: column "product" specified more than onceLINE 1:
...ne,component,version,keywords,cc,time,changetime, product) V...
^
--------------------------+--------------------
Reporter: jav | Owner: nobody
Type: defect | Status: new
Priority: blocker | Milestone:
Component: multiproduct | Version: 0.6.0
Keywords: |
--------------------------+--------------------
= Create Ticket results in DB error =
Creating a ticket results in a database error:
{{{
2013-08-12 14:13:30 CEST bloodhound bloodhound ERROR: column "product"
specified more than once at character 142
2013-08-12 14:13:30 CEST bloodhound bloodhound STATEMENT: INSERT INTO
ticket
(summary,reporter,owner,description,type,status,priority,product,milestone,component,version,keywords,cc,time,changetime,
product) VALUES
('test','admin','somebody','','defect','new','major','Root','','component1','','','',1376309610703945,1376309610703945,'@')
}}}
==== How to Reproduce ====
While doing a POST operation on `/newticket`, Trac issued an internal
error.
Click ''Create Ticket'' button -> ''More Fields'' -> enter ''Ticket
Summary'' -> click ''Create Ticket'' button
Request parameters:
{{{
{'__FORM_TOKEN': u'6bc262035d3c5bd1685a62f1',
'comment': u'',
'field_cc': u'',
'field_component': u'component1',
'field_description': u'',
'field_keywords': u'',
'field_milestone': u'',
'field_priority': u'major',
'field_reporter': u'admin',
'field_summary': u'test',
'field_type': u'defect',
'field_version': u'',
'start_time': u'0',
'submit': u'Create ticket',
'view_time': u'0'}
}}}
User agent: `Mozilla/5.0 (X11; Linux x86_64; rv:23.0) Gecko/20100101
Firefox/23.0`
==== 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 bh_tracker
WSGIApplicationGroup %{GLOBAL})` ||
|| '''`psycopg2`''' || `2.4.5` ||
|| '''`Pygments`''' || `1.6` ||
|| '''`Python`''' || `2.7.3 (default, Apr 14 2012, 08:58:41) [GCC]` ||
|| '''`pytz`''' || `2013b` ||
|| '''`setuptools`''' || `0.9.8` ||
|| '''`jQuery`''' || `1.7.2` ||
==== Enabled Plugins ====
|| '''`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/installer/bloodhound/lib/python2.7
/site-packages/trac/web/main.py", line 477, in _dispatch_request
dispatcher.dispatch(req)
File "/opt/apache-bloodhound-0.6/installer/bloodhound/lib/python2.7
/site-packages/trac/web/main.py", line 214, in dispatch
resp = chosen_handler.process_request(req)
File "/opt/apache-bloodhound-0.6/installer/bloodhound/lib/python2.7
/site-packages/multiproduct/ticket/web_ui.py", line 66, in process_request
return self._process_newticket_request(req)
File "/opt/apache-bloodhound-0.6/installer/bloodhound/lib/python2.7
/site-packages/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/installer/bloodhound/lib/python2.7
/site-packages/trac/ticket/web_ui.py", line 1289, in _do_create
ticket.insert()
File "/opt/apache-bloodhound-0.6/installer/bloodhound/lib/python2.7
/site-packages/trac/ticket/model.py", line 241, in insert
[values[name] for name in std_fields])
File "/opt/apache-bloodhound-0.6/installer/bloodhound/lib/python2.7
/site-packages/multiproduct/dbcursor.py", line 143, in execute
return self.cursor.execute(sql, args=args)
File "/opt/apache-bloodhound-0.6/installer/bloodhound/lib/python2.7
/site-packages/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/installer/bloodhound/lib/python2.7
/site-packages/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: ...ne,component,version,keywords,cc,time,changetime, product) V...
^
}}}
--
Ticket URL: <https://issues.apache.org/bloodhound/ticket/635>
Apache Bloodhound <https://issues.apache.org/bloodhound/>
The Apache Bloodhound issue tracker
