Modify ↓
      
#2979 closed defect (duplicate)
Custom query fails when using custom ticket field has same name as existing ticket field
| Reported by: | Owned by: | Jonas Borgström | |
|---|---|---|---|
| Priority: | normal | Milestone: | |
| Component: | ticket system | Version: | 0.9.4 | 
| Severity: | normal | Keywords: | custom fields | 
| Cc: | Branch: | ||
| Release Notes: | |||
| API Changes: | |||
| Internal Changes: | |||
Description (last modified by )
Traceback (most recent call last):
  File "/usr/local/lib/python2.4/site-packages/trac/web/cgi_frontend.py", line 130, in run
    dispatch_request(req.path_info, req, env)
  File "/usr/local/lib/python2.4/site-packages/trac/web/main.py", line 139, in dispatch_request
    dispatcher.dispatch(req)
  File "/usr/local/lib/python2.4/site-packages/trac/web/main.py", line 107, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/local/lib/python2.4/site-packages/trac/ticket/query.py", line 414, in process_request
    self.display_html(req, query)
  File "/usr/local/lib/python2.4/site-packages/trac/ticket/query.py", line 522, in display_html
    tickets = query.execute(db)
  File "/usr/local/lib/python2.4/site-packages/trac/ticket/query.py", line 157, in execute
    val = int(val)
ValueError: invalid literal for int(): 15m
probably has somethign to do with my custom field.
time = select time.label=Time time.options=|15|30|45|60|75|90|1h45m|2h|2h15m|2h30m|3h time.value=0
the options were 15m|30m|45m, etc but I changed them in hopes the error would go away, but it hasn't.
Attachments (0)
Change History (3)
comment:1 by , 20 years ago
| Component: | general → ticket system | 
|---|---|
| Description: | modified (diff) | 
| Keywords: | custom fields added | 
| Priority: | normal → low | 
| Severity: | normal → minor | 
comment:2 by , 19 years ago
| Priority: | low → normal | 
|---|---|
| Resolution: | → duplicate | 
| Severity: | minor → normal | 
| Status: | new → closed | 
This is a duplicate of #1449.
comment:3 by , 19 years ago
| Summary: | unable to custom query → Custom query fails when using custom ticket field has same name as existing ticket field | 
|---|
  Note:
 See   TracTickets
 for help on using tickets.
    


  
This has to do with the name of your custom field, which conflicts with one of the default field name for the tickets.
For now, as a workaround, simply choose another name for your custom field.
In order to close this issue, this limitation should either be documented or lifted…