Hi all, I try to add severities with the following command:
python trac-admin D:\Server\Trac\Projects severity add Dangerous no matter what I try as severity, I always get the following error: Command 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 'int)),0),'severity','Dangerous' FROM enum WHERE type='severity'' at line 1") When I step through trac-admin with a Python debugger, I find that the full SQL command is INSERT INTO enum(value,type,name) SELECT 1+COALESCE(max(CAST(value AS int)),0),'severity','Dangerous' FROM enum WHERE type='severity' Setup: + Win XP SP2 plus all patches + Trac 0.10b1 + Apache 2.0.59 + Python 2.4.3 + mod_python 3.2.8 + MySQL 5.0.24a I am aware that MySQL support is experimental and apparently, Trac is supposed to be using SQLAlchemy in the near future, so interest in getting this to work might be limited, but maybe someone knows a work-around for the time being ? 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 -~----------~----~----~----~------~----~------~--~---
