Modify

Opened 6 years ago

Closed 6 years ago

#4099 closed defect (fixed)

syntax error near user after click on watch link

Reported by: olistudent Owned by: martin_s
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 6 years ago by martin_s

  • Status changed from new to assigned

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 6 years ago by martin_s

Sorry,

Did you then create the DB manually?

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

comment:3 Changed 6 years ago by martin_s

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

comment:4 Changed 6 years ago by martin_s

  • Resolution set to fixed
  • Status changed from assigned to closed

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

Add Comment

Modify Ticket

Action
as closed The owner will remain martin_s.
The resolution will be deleted. Next status will be 'reopened'.
Author


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

 
Note: See TracTickets for help on using tickets.