#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