Modify ↓
Ticket #6846 (closed defect: duplicate)
Opened 4 years ago
Last modified 4 years ago
DB Error when seeing tickets by milestone with Postgresql
| Reported by: | Martin <martin@…> | Owned by: | jonas |
|---|---|---|---|
| Priority: | normal | Milestone: | |
| Component: | ticket system | Version: | 0.10.4 |
| Severity: | normal | Keywords: | |
| Cc: | |||
| Release Notes: | |||
| API Changes: | |||
Description (last modified by cboos) (diff)
When trying to see tickets by milestone I get:
Report execution failed: no existe la columna «modified» LINE 16: (CASE status WHEN 'closed' THEN modified ELSE (-1)*p…
Checking postgresql logs I see this:
LOG: sentencia:
SELECT p.value AS __color__,
t.milestone AS __group__,
(CASE status
WHEN 'closed' THEN 'color: #777; background: #ddd; border-color: #ccc;'
ELSE
(CASE owner WHEN 'martin' THEN 'font-weight: bold' END)
END) AS __style__,
id AS ticket, summary, component, status,
resolution,version, t.type AS type, priority, owner,
changetime AS modified,
time AS _time,reporter AS _reporter
FROM ticket t
LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
ORDER BY (milestone IS NULL), milestone DESC, (status = 'closed'),
(CASE status WHEN 'closed' THEN modified ELSE (-1)*p.value END) DESC
ERROR: no existe la columna «modified» en carácter 614
Attachments
Change History
comment:1 Changed 4 years ago by cboos
- Description modified (diff)
- Resolution set to duplicate
- Status changed from new to closed
Note: See
TracTickets for help on using
tickets.



Duplicate of #5543.