Modify

Opened 5 years ago

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

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

comment:4 Changed 5 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 .
as The resolution will be set. Next status will be 'closed'.
to The owner will be changed from martin_s. Next status will be 'closed'.
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.