#642: Internal server error creating ticket
------------------------+---------------------------
Reporter: rimas | Owner: rimas
Type: defect | Status: needinfo(new)
Priority: major | Milestone:
Component: trac core | Version: 0.6.0
Resolution: | Keywords: db
------------------------+---------------------------
Changes (by olemis):
* keywords: => db
Old description:
> Using version 0.6.0, I clicked on the blue Create Ticket button, filled
> in a summary and description, selected a product, clicked on the blue
> Create button, but then I got the following error: Could not create
> ticket. Error: Internal Server Error. Here is what I see in
> C:\apache\bloodhound\installer\bloodhound\environments\main\log
> \bloodhound-error.log:
>
> 2013-08-22 08:08:29,111 Trac[theme] ERROR: BH: Quick create ticket failed
> column "product" specified more than once
> LINE 1: ...atus,priority,product,resolution,time,changetime, product)
> V...
> ^
> Traceback (most recent call last):
> File "C:\apache\bloodhound\installer\bloodhound\lib\site-
> packages\bhtheme\theme.py", line 519, in process_request
> product, tid = self.create(req, summary, desc, attrs, True)
> File "C:\apache\bloodhound\installer\bloodhound\lib\site-
> packages\bhtheme\theme.py", line 552, in create
> t.insert()
> File "C:\apache\bloodhound\installer\bloodhound\lib\site-
> packages\trac\ticket\model.py", line 241, in insert
> [values[name] for name in std_fields])
> File "C:\apache\bloodhound\installer\bloodhound\lib\site-
> packages\multiproduct\dbcursor.py", line 143, in execute
> return self.cursor.execute(sql, args=args)
> File "C:\apache\bloodhound\installer\bloodhound\lib\site-
> packages\multiproduct\dbcursor.py", line 83, in execute
> return super(BloodhoundIterableCursor,
> self).execute(translate_sql(self.env, sql), args=args)
> File "C:\apache\bloodhound\installer\bloodhound\lib\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: ...atus,priority,product,resolution,time,changetime, product)
> V...
> ^
New description:
Using version 0.6.0, I clicked on the blue Create Ticket button, filled in
a summary and description, selected a product, clicked on the blue Create
button, but then I got the following error: Could not create ticket.
Error: Internal Server Error. Here is what I see in
C:\apache\bloodhound\installer\bloodhound\environments\main\log
\bloodhound-error.log:
{{{
2013-08-22 08:08:29,111 Trac[theme] ERROR: BH: Quick create ticket failed
column "product" specified more than once
LINE 1: ...atus,priority,product,resolution,time,changetime, product) V...
^
Traceback (most recent call last):
File "C:\apache\bloodhound\installer\bloodhound\lib\site-
packages\bhtheme\theme.py", line 519, in process_request
product, tid = self.create(req, summary, desc, attrs, True)
File "C:\apache\bloodhound\installer\bloodhound\lib\site-
packages\bhtheme\theme.py", line 552, in create
t.insert()
File "C:\apache\bloodhound\installer\bloodhound\lib\site-
packages\trac\ticket\model.py", line 241, in insert
[values[name] for name in std_fields])
File "C:\apache\bloodhound\installer\bloodhound\lib\site-
packages\multiproduct\dbcursor.py", line 143, in execute
return self.cursor.execute(sql, args=args)
File "C:\apache\bloodhound\installer\bloodhound\lib\site-
packages\multiproduct\dbcursor.py", line 83, in execute
return super(BloodhoundIterableCursor,
self).execute(translate_sql(self.env, sql), args=args)
File "C:\apache\bloodhound\installer\bloodhound\lib\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: ...atus,priority,product,resolution,time,changetime, product) V...
^
}}}
--
--
Ticket URL: <https://issues.apache.org/bloodhound/ticket/642#comment:2>
Apache Bloodhound <https://issues.apache.org/bloodhound/>
The Apache Bloodhound issue tracker
