Opened 8 years ago

Last modified 6 years ago

#12711 new defect

SQL query problem — at Version 1

Reported by: gbarrelet Owned by: Franz
Priority: normal Component: MailPlugin
Severity: blocker Keywords:
Cc: Trac Release: 1.2

Description (last modified by Ryan J Ollos)

Hello,

Using Trac 1.1.6 with mailplugin 0.4.3 Plugin has been enabled in trac.ini After several tries, trying to create a new simple report with only field "Reporter" and a where clause for Milestone (tried without any clause and getting the same error):

Illegal Arguments:
Illegal value for field 'whereClause'.

Further Informations:
(u'select id,reporter from ticket where milestone="Unknown"', ProgrammingError(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 'interval,active) VALUES ('test','username',1460908800000000,null,'reporter','mi' at line 1"))

Trying the same request in mysql works (select id,reporter from ticket where milestone="Unknown"). I also tried select id,reporter from ticket where milestone LIKE 'Unknown':

Illegal Arguments:
Illegal value for field 'whereClause'.

Further Informations:
(u"select id,reporter from ticket where milestone LIKE 'Unknown'", ProgrammingError(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 'interval,active) VALUES ('test','username',1460908800000000,null,'reporter','mi' at line 1"))

The VALUES seems incomplete, I don't know if it is the request or just the debug. "'interval,active" are always in the debug message. Something is different compared to the picture in the wiki, I have an "a" letter near the date. Picture attached to this ticket.

Any idea / tests to do ?

Change History (2)

Changed 8 years ago by gbarrelet

Attachment: typo.png added

comment:1 Changed 8 years ago by Ryan J Ollos

Description: modified (diff)
Note: See TracTickets for help on using tickets.