Modify

Opened 15 years ago

Closed 14 years ago

Last modified 14 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

Description

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

Attachments (0)

Change History (3)

comment:1 Changed 14 years ago by Vlad Glagolev

Resolution: worksforme
Status: newclosed

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

comment:2 Changed 14 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.

Thanks

comment:3 Changed 14 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
Action
as closed The owner will remain takayama.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment


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

 
Note: See TracTickets for help on using tickets.