Error on a page containing an apostrophe in the URL

[Jirka Vejrazka]

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.

[Martin Scharrer]

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.

[Martin Scharrer]

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

[Jirka Vejrazka]

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