Modify

Opened 8 years ago

Closed 8 years ago

#4099 closed defect (fixed)

syntax error near user after click on watch link

Reported by: Oliver Metz Owned by: Martin Scharrer
Priority: normal Component: WatchlistPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.11

Description

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)

Attachments (0)

Change History (4)

comment:1 Changed 8 years ago by Martin Scharrer

Status: newassigned

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

comment:2 Changed 8 years ago by Martin Scharrer

Sorry,

Did you then create the DB manually?

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

comment:3 Changed 8 years ago by Martin Scharrer

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

comment:4 Changed 8 years ago by Martin Scharrer

Resolution: fixed
Status: assignedclosed

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

Modify Ticket

Change Properties
Set your email in Preferences
Action
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.