Modify

Opened 6 years ago

Closed 5 years ago

Last modified 5 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 5 years ago by Vlad Glagolev

  • Resolution set to worksforme
  • Status changed from new to closed

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

Add Comment

Modify Ticket

Action
as closed .
The resolution will be deleted. Next status will be 'reopened'.
Author


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

 
Note: See TracTickets for help on using tickets.