Milestone - DB Error

167
Defect
Mythos
Jack
2.0
0.4
Roadmap
Fixed
High
Major
7 years ago
3 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

7 years and 4 months ago by Jack

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

7 years and 4 months ago by Mythos

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

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

7 years and 4 months ago by Mythos

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

7 years and 4 months ago by Jack

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

7 years and 4 months 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.

7 years and 4 months 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

7 years and 4 months ago by Mythos

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

7 years and 4 months ago by Mythos

Push ;)

7 years and 4 months ago by Jack

  • Closed ticket as Fixed