Modify ↓

Opened 15 years ago

Closed 8 years ago

Last modified 8 years ago

#6792 closed defect (wontfix)

Error: Macro TicketCountQuery

Reported by: vbner1234 Owned by:
Priority: normal Component: MacroPostPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.11

Description (last modified by Ryan J Ollos)

I have a problem when I use Macro TicketCountQuery. Here is the code that works fine when use the sqlite database, but after change the database to mysql, it shows the error messages, Does someone know how to fix it? thanks

command: 

[[TicketCountQuery(query=created=today;, groupby=owner, title=Tickets Created Today)]]

error messages: 

Error: Macro TicketCountQuery(query=created=today;, groupby=owner, title=Tickets Created Today) failed

1064You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') FROM (SELECT t.id AS id,t.owner AS owner,t.status AS status,t.priority AS prio' at line 1

Attachments (0)

Change History (3)

comment:1 Changed 10 years ago by Ryan J Ollos

Owner: Noah Kantrowitz deleted

comment:2 Changed 8 years ago by Ryan J Ollos

Description: modified (diff)
Resolution: → wontfix
Status: new → closed

See TicketQuery instead.

comment:3 Changed 8 years ago by Ryan J Ollos

Also, it appears the ticket is incorrectly reported against the MacroPostPlugin.

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'.

Add Comment

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

Attachments ↑ Description ↑
 
Note: See TracTickets for help on using tickets.