Opened 9 years ago

Closed 9 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 9 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 9 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 9 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.

Add Comment

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

Note: See TracTickets for help on using tickets.