Milestone - DB Error

167
Defect
Mythos
Jack
2.0
0.4
Roadmap
Fixed
High
Major
11 years ago
7 years ago
0

Description

When you click on a milestone (Open tickets), you\'ll get this error:

@#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 \')AND status in (2,7,1) ORDER BY priority DESC\' at line [email protected]

Attachments

Ticket History

11 years ago by Jack

Can you be more clear on how to reproduce this? I get no errors when viewing milestones or their tickets.

11 years ago by Mythos

http://lordsofwarcraft.ath.cx/bugs/index.php/frostmore/roadmap

Please click on Milestone 3.3.3a and you\'ll see it ;-)

11 years ago by Mythos

Btw: after you\'ve checked this, please delete the link to my website

11 years ago by Jack

I've tested this with the latest revision and the revision running on this website and cannot reproduce the error.

11 years ago by Mythos

I only get an error with the ticket #1. Ticket #2 works. Also #3 does.

I attached a screenshot of the table.

11 years ago by Mythos

I found the problem:

Renamed 3.3.3a to 333a and it works because: http://lordsofwarcraft.ath.cx/bugs/index.php/frostmore/tickets?milestone=333a&status=open -- Works http://lordsofwarcraft.ath.cx/bugs/index.php/frostmore/tickets?milestone=3.3.3a&status=open -- Doesn't work

11 years ago by Mythos

This means it doesn't use the slug, it uses the name, please change this.

10 years and 12 months ago by Mythos

Push ;)

10 years and 11 months ago by Jack

  • Closed ticket as Fixed