Edgewall Software
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

Duplicate of #5543.

View

Add a comment

Modify Ticket

Change Properties
<Author field>
Action
as closed
The resolution will be deleted. Next status will be 'reopened'
to The owner will be changed from jonas. Next status will be 'closed'
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.