#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

Reply via email to