Opened 7 years ago

Last modified 20 months ago

#6792 new defect

Error: Macro TicketCountQuery

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


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


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 AS id,t.owner AS owner,t.status AS status,t.priority AS prio' at line 1

Attachments (0)

Change History (1)

comment:1 Changed 20 months ago by rjollos

  • Owner coderanger deleted

Add Comment

Modify Ticket

as new The ticket will remain with no owner.

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

Note: See TracTickets for help on using tickets.