Context Navigation

Modify ↓

#4400 closed defect (duplicate)

View "My Tickets" causes SQL syntax error - Report execution failed

Reported by:	Martin Burger <mburger@…>	Owned by:	Matthew Good
Priority:	normal	Milestone:
Component:	report system	Version:	0.10.3
Severity:	normal	Keywords:	mysql tickets reports
Cc:		Branch:
Release Notes:
API Changes:
Internal Changes:

Description

When I run the report "My Tickets" I will get an SQL syntax error:

Report execution failed: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 'mburger', ')'\n ORDER BY (status = 'assigned') DESC, p.value, ")

Attachments (0)

Change History (2)

comment:1 by Martin Burger <mburger@…>, 19 years ago

Component:	ticket system → report system
Owner:	changed from Jonas Borgström to Matthew Good

comment:2 by Christian Boos, 19 years ago

Resolution:	→ duplicate
Status:	new → closed

Duplicate of #4387 that happened to have been fixed today ;)

Modify Ticket

Change Properties

Summary:
Description:	When I run the report "My Tickets" I will get an SQL syntax error: {{{ Report execution failed: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 'mburger', ')'\n ORDER BY (status = 'assigned') DESC, p.value, ") }}} You may use WikiFormatting here.
Type:		Priority:
Milestone:		Component:
Version:		Severity:
Keywords:		Cc:	Set your email in Preferences
Branch:
Release Notes:
API Changes:
Internal Changes:

Action

leave as closed The owner will remain Matthew Good.

reopen The resolution will be deleted. Next status will be 'reopened'.

change ownership to The owner will be changed from Matthew Good to the specified user.

Add Comment

Your email or username:

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

You may use WikiFormatting here.

Attachments ↑ Description ↑

Note: See TracTickets for help on using tickets.

Download in other formats: