I just tried with my trac and got the same problem. CAST(value as INT) should be CAST(value as SIGNED)
This is corrected in mysql_backend.py on lines 148, 149 in revision 3716. I just updated to latest version in trunk and tested, and it works for me now. --Jim Nanney On 9/25/06, z00m1n <[EMAIL PROTECTED]> wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
