error in all ticket views

[villalvilla@…]

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

[Vlad Glagolev]

no.

you just need to edit all default reports (but first of all you need to add the permission to REPORT_MODIFY) and replace 'int' with 'signed'.

MySQL of course has CAST function...

[anonymous]

Hi Vlad,

I'm having this exact same error after using the script. I'm not quite sure how to perform the fix you described. If you could please elaborate a bit, it would be appreciated.

Thanks

[anonymous]

Figured it out. In the actual Web Interface, there's an, Edit Page button, because it's like a wiki. Click that, and then you will see the sql query, just edit it and your done.