Edgewall Software
Modify

Opened 15 years ago

Closed 15 years ago

#8805 closed defect (invalid)

Report execution failed: Incorrect number of bindings supplied. The current statement uses 1, and there are 2 supplied.

Reported by: trac@… Owned by:
Priority: normal Milestone:
Component: report system Version: 0.11.5
Severity: major Keywords:
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:

Description

Removing the version; component; and milestone fields from the My Tickets report results in the following error:

Report execution failed: Incorrect number of bindings supplied. The current statement uses 1, and there are 2 supplied.

The error results from the following SQL:

SELECT p.value AS __color__,
   (CASE status WHEN 'accepted' THEN 'Accepted' ELSE 'Owned' END) AS __group__,
   id AS ticket, summary,
   t.type AS type, priority, time AS created,
   changetime AS _changetime, description AS _description,
   reporter AS _reporter
  FROM ticket t
  LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
  WHERE t.status <> 'closed' AND owner = 'robert.morris'
  ORDER BY (status = 'accepted') DESC, CAST(p.value AS int), t.type, time

Trac is running on Python 2.6.4 on Windows 2003.

Attachments (0)

Change History (1)

comment:1 by trac@…, 15 years ago

Resolution: invalid
Status: newclosed

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The ticket will remain with no owner.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from (none) to the specified user.

Add Comment


E-mail address and name can be saved in the Preferences .
 
Note: See TracTickets for help on using tickets.