id summary reporter owner description type status priority component severity resolution keywords cc release 4851 error in all ticket views villalvilla@… takayama "Hello! Your script is cool! But I found an SQL syntax error that affects all default ticket views. This mysql error appears: {{{ 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 'int), t.type, time\n) AS tab' at line 12"") }}} The solution is patch all the view tickets' selects and clean the part that says ""CAST(p.value AS int)"" with ""p.value"", because mysql doesn't have the cast function. It could be integrated in your script and it would be the coolest on trackhacks ;-) regards" defect closed highest SqliteToMySqlScript blocker worksforme 0.11