#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: multiproduct | Version: 0.6.0
Resolution: | Keywords:
---------------------------+--------------------
Comment (by rjollos):
When I create a ticket using the quick ticket form, the following SQL is
executed (`[trac] debug_sql = true`):
{{{
04:32:59 AM Trac[dbcursor] DEBUG: SQL: INSERT INTO ticket
(summary,reporter,owner,description,type,status,priority,product,milestone,component,version,resolution,time,changetime,
product) VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,'prod1')
04:32:59 AM Trac[util] DEBUG: SQL: INSERT INTO ticket
(summary,reporter,owner,description,type,status,priority,product,milestone,component,version,resolution,time,changetime,
product) VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,'prod1')
}}}
The duplication of the `product` field, caused by the addition of the
`product` select in #569, doesn't seem to cause a problem with SQLite, but
I'll attempt to reproduce with PostgreSQL.
I'm not seeing a duplication of the `product` field for tickets created
from the `/newticket` URL (i.e. the full new ticket form):
{{{
03:46:38 AM Trac[dbcursor] DEBUG: Original SQl: INSERT INTO ticket
(summary,reporter,owner,descriobserving this
issueption,type,status,priority,milestone,component,version,keywords,cc,time,changetime)
VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)
03:46:38 AM Trac[dbcursor] DEBUG: SQL: INSERT INTO ticket
(summary,reporter,owner,description,type,status,priority,milestone,component,version,keywords,cc,time,changetime,
product) VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,'@')
}}}
The latter finding isn't too surprising since there shouldn't be a product
select field within the `#inplace-propertyform` form. The product select
should only exist on the breadcrumb. Do you see a product select field in
the new ticket form when on the `/newticket` page?
--
Ticket URL: <https://issues.apache.org/bloodhound/ticket/601#comment:5>
Apache Bloodhound <https://issues.apache.org/bloodhound/>
The Apache Bloodhound issue tracker
