syntax error near user after click on watch link

[Oliver Metz]

database-backend: postgresql

trac.log:

2008-11-16 03:40:39,901 Trac[main] ERROR: ERROR:  Syntaxerror near »user«
LINE 1: INSERT INTO watchlist (user, realm, id) VALUES ('oliver','wi...
                               ^
Traceback (most recent call last):
  File "/usr/lib/python2.5/site-packages/Trac-0.11stable_r7667-py2.5.egg/trac/web/main.py", line 432, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.5/site-packages/Trac-0.11stable_r7667-py2.5.egg/trac/web/main.py", line 204, in dispatch
    resp = chosen_handler.process_request(req)
  File "build/bdist.linux-i686/egg/tracwatchlist/plugin.py", line 106, in process_request
    "VALUES ('%s','%s','%s');" % lst )
  File "/usr/lib/python2.5/site-packages/Trac-0.11stable_r7667-py2.5.egg/trac/db/util.py", line 51, in execute
    return self.cursor.execute(sql)
  File "/usr/lib/python2.5/site-packages/Trac-0.11stable_r7667-py2.5.egg/trac/db/util.py", line 51, in execute
    return self.cursor.execute(sql)
ProgrammingError: ERROR:  Syntaxerror near »user«
LINE 1: INSERT INTO watchlist (user, realm, id) VALUES ('oliver','wi...

browser:

Traceback (most recent call last):
  File "/usr/lib/python2.5/site-packages/Trac-0.11stable_r7667-py2.5.egg/trac/web/api.py", line 367, in send_error
    'text/html')
  File "/usr/lib/python2.5/site-packages/Trac-0.11stable_r7667-py2.5.egg/trac/web/chrome.py", line 719, in render_template
    return stream.render(method, doctype=doctype)
  File "/usr/lib/python2.5/site-packages/Genshi-0.5.2dev_r947-py2.5-linux-i686.egg/genshi/core.py", line 179, in render
    return encode(generator, method=method, encoding=encoding, out=out)
  File "/usr/lib/python2.5/site-packages/Genshi-0.5.2dev_r947-py2.5-linux-i686.egg/genshi/output.py", line 60, in encode
    return _encode(u''.join(list(iterator)))
  File "/usr/lib/python2.5/site-packages/Genshi-0.5.2dev_r947-py2.5-linux-i686.egg/genshi/output.py", line 311, in __call__
    for kind, data, pos in stream:
  File "/usr/lib/python2.5/site-packages/Genshi-0.5.2dev_r947-py2.5-linux-i686.egg/genshi/output.py", line 753, in __call__
    for kind, data, pos in stream:
  File "/usr/lib/python2.5/site-packages/Genshi-0.5.2dev_r947-py2.5-linux-i686.egg/genshi/output.py", line 592, in __call__
    for kind, data, pos in stream:
  File "/usr/lib/python2.5/site-packages/Genshi-0.5.2dev_r947-py2.5-linux-i686.egg/genshi/output.py", line 707, in __call__
    text = mjoin(textbuf, escape_quotes=False)
UnicodeDecodeError: 'ascii' codec can't decode byte 0xc2 in position 815: ordinal not in range(128)

[Martin Scharrer]

Could be that there is something wrong with your watchlist table.

You had problems setting up the watchlist table for postgressql (#4097). Did you then create the DB manually?

Does your user name includes non-ASCII characters?

I now ([4825]) enforced unicode encoding for the user name, could you please test this revision.

Thanks, Martin

[Martin Scharrer]

Sorry,

Did you then create the DB manually?

should be "Did you then create the table manually?"

[Martin Scharrer]

The latest version should fix this. Could you please verify this. Thanks!

[Martin Scharrer]

No response after three month. I'm closing this ticket now. Please reopen if fix didn't work.