Opened 9 years ago

Closed 9 years ago

# Error on a page containing an apostrophe in the URL

Reported by: Owned by: Jirka Vejrazka Martin Scharrer low WatchlistPlugin normal 0.11

### Description

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/plugin.py", line 253, in is_watching


The installed plugin is revision 5234.

### comment:1 Changed 9 years ago by Martin Scharrer

Status: new → assigned

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 assigned → closed

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

### Modify Ticket

Change Properties