When adding a severity, I get an SQL syntax error

[anonymous]

The command and error looks like:

trac-admin /path/to/project/ severity add annoying 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','annoying' FROM enum WHERE type='severity at line 1")

[mgood]

Have you upgraded Trac from the trunk? I believe this may be the same issue as #3669 with the recently introduced use of CAST.

[trac@…]

After updating past r3690, trac doesn't work with mysql anymore. The problem is that

select cast(1 as int);

doesn't work in mysql.

The following patch works for me

trac/db/mysql_backend.py

@@ -145 +147 @@
         ConnectionWrapper.__init__(self, cnx)
 
     def cast(self, column, type):
+       if type == 'int':
+           type = 'signed'
         return 'CAST(%s AS %s)' % (column, type)
 
     def like(self):

[mgood]

Replying to trac@erre.user.lysator.liu.se:

After updating past r3690, trac doesn't work with mysql anymore. The problem is that

select cast(1 as int);

doesn't work in mysql.

Hmm, there was an existing cast before r3690, so I don't know why this just popped up, but the patch looks ok.

[mgood]

Ok, patch applied in r3716.