Edgewall Software
Modify

Opened 15 years ago

Closed 15 years ago

#9200 closed defect (worksforme)

Putting a single quote into a milestone name when using SQLite results in page load errors (DatabaseError: near X: syntax error)

Reported by: devon.g.mackay@… Owned by:
Priority: normal Milestone:
Component: general Version: 0.11.4
Severity: normal Keywords: single quote, milestone, database error, sqlite
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:

Description (last modified by Christian Boos)

After creating a new milestone with a single quote in the title, the "roadmap" page no longer functioned and the new milestone did not appear on the list of milestones.

In this case, the new milestone was "Slushy stuff for X's initiation". Trying to load the roadmap page resulted in an error box containing 'DatabaseError: near "s": syntax error'.

Once I used sqlite3 to manually delete the milestone record from the table, everything was back to normal.

Attachments (0)

Change History (1)

comment:1 by Christian Boos, 15 years ago

Description: modified (diff)
Resolution: worksforme
Status: newclosed

This must have been fixed at some point, please upgrade to 0.11.7.

See demo-0.11:milestone:"Slushy stuff for X's initiation" (the [demo-0.11:] instance also uses sqlite as a backend).

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The ticket will remain with no owner.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from (none) to the specified user.

Add Comment


E-mail address and name can be saved in the Preferences .
 
Note: See TracTickets for help on using tickets.