Opened 4 years ago

#12879 new defect

RecentChanges Macro

Reported by: anonymous Owned by:
Priority: normal Component: MsSqlBackendPlugin
Severity: normal Keywords:
Cc: Trac Release:


It looks like the RecentChanges macro isn't correctly converted from regular SQL to MSSQL as it's still trying to use the 'LIMIT' clause:

Error: Macro RecentChanges(Trac,3) failed
('42000', "[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'LIMIT'. (102) (SQLExecDirectW); [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (8180)")

An example of this can be found on the default install of Trac under the following page: WikiFormatting#Macros when the MSSQL plugin is used.

Attachments (0)

Change History (0)

Modify Ticket

Change Properties
Set your email in Preferences
as new The ticket will remain with no owner.

Add Comment

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

Note: See TracTickets for help on using tickets.