Opened 8 years ago

Closed 8 years ago

#4762 closed defect (fixed)

Error on a page containing an apostrophe in the URL

Reported by: Jirka Vejrazka Owned by: Martin Scharrer
Priority: low Component: WatchlistPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.11


If a page contains an apostrophe in its URL, Watchlist plugin causes Trac to fail (when this plugin is disabled, page displays properly). I know it's a dumb idea to have an apostrophe there, but hey - Trac can handle it :)

Here are relevant lines from the traceback (the URL ended with HOWTO's):

OperationalError: near "s": syntax error
2009-03-10 11:47:00,348 Trac[main] ERROR: near "s": syntax error

    if not self.is_watching(realm, resid, user):
  File "build/bdist.linux-i686/egg/tracwatchlist/", line 253, in is_watching

The installed plugin is revision 5234.

Attachments (0)

Change History (3)

comment:1 Changed 8 years ago by Martin Scharrer

Status: newassigned

This error happened because of the way I wrote the SQL command in python ("I was young (in python) and did not know it better!"). Check out revision [5349] which should fix this.

Please tell me if the error is gone. I will test it on my trac installation ASAP.

comment:2 Changed 8 years ago by Martin Scharrer

Update: Use the revision [5353] or later. The above quoted one introduced some small errors which I had to fix.

comment:3 Changed 8 years ago by Jirka Vejrazka

Resolution: fixed
Status: assignedclosed

Upgraded to latest revision, problem fixed - thanks for the speedy response!

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain Martin Scharrer.
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.