Opened 9 years ago

Closed 8 years ago

Last modified 8 years ago

#4851 closed defect (worksforme)

error in all ticket views

Reported by: villalvilla@… Owned by: takayama
Priority: highest Component: SqliteToMySqlScript
Severity: blocker Keywords:
Cc: Trac Release: 0.11


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 ;-)


Attachments (0)

Change History (3)

comment:1 Changed 8 years ago by Vlad Glagolev

Resolution: worksforme
Status: newclosed


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...

comment:2 Changed 8 years ago by 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.


comment:3 Changed 8 years ago by 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.

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain takayama.
The resolution will be deleted.

Add Comment

E-mail address and name can be saved in the Preferences.

Note: See TracTickets for help on using tickets.