Hi all,
I am using Trac with the MySQL backend. The default ticket report
queries used to work fine on a Win XP test system, but they now fail on
the FreeBSD production system.
I get the following error messages in trac.log:
{6} All Tickets By Milestone (Including closed)
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 ' '<my user name>', ')' THEN 'font-weight:
bold' END)\n END) AS __style__,\n' at line 6")
{7} My Tickets
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 ' '<my user name>', ')'\n ORDER BY (status =
'assigned') DESC, p.value, miles' at line 9")
{8} Active Tickets, Mine first
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 ' '<my user name>', ')' THEN 'My Tickets' \n
ELSE 'Active Tickets' \n EN' at line 3")
AFAICT, these 3 reports uses dynamic variables, but I seem to lack the
SQL skills to diagnose the actual root cause myself. It further puzzles
me that these reports used to work on Win XP.
Can someone help me ?
TIA,
CU z00m1n
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Trac Users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---
