Modify

Opened 7 years ago

Closed 7 years ago

Last modified 3 years ago

#13324 closed defect (fixed)

Crash when browsing a ticket

Reported by: ntmlod Owned by: Ryan J Ollos
Priority: normal Component: VotePlugin
Severity: normal Keywords:
Cc: Steffen Hoffmann Trac Release: 1.0

Description

2017-11-03 20:38:10,935 Trac[main] ERROR: Internal Server Error:
Traceback (most recent call last):
  File "/usr/lib/python2.7/site-packages/trac/web/main.py", line 497, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.7/site-packages/trac/web/main.py", line 224, in dispatch
    self._post_process_request(req, *resp)
  File "/usr/lib/python2.7/site-packages/trac/web/main.py", line 338, in _post_process_request
    resp = f.post_process_request(req, *resp)
  File "build/bdist.linux-x86_64/egg/tracvote/__init__.py", line 355, in post_process_request
    self.render_voter(req, context.resource)
  File "build/bdist.linux-x86_64/egg/tracvote/__init__.py", line 551, in render_voter
    body, title = self.format_votes(resource)
  File "build/bdist.linux-x86_64/egg/tracvote/__init__.py", line 562, in format_votes
    self.get_vote_counts(resource) if resource else (0, 0, 0)
  File "build/bdist.linux-x86_64/egg/tracvote/__init__.py", line 133, in get_vote_counts
    """, (resource.realm, resource.id)):
  File "/usr/lib/python2.7/site-packages/trac/db/util.py", line 121, in execute
    cursor.execute(query, params)
  File "/usr/lib/python2.7/site-packages/trac/db/util.py", line 65, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
ProgrammingError: operator does not exist: text = integer
LINE 5:                        AND resource_id=1858
                                              ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
ProgrammingError: operator does not exist: text = integer
LINE 5:                        AND resource_id=1858
                                              ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

Attachments (0)

Change History (3)

comment:1 Changed 7 years ago by Ryan J Ollos

Status: newaccepted

comment:2 Changed 7 years ago by Ryan J Ollos

Resolution: fixed
Status: acceptedclosed

In 16955:

TracVote 0.7.0dev: Fix ProgrammingError with PostgreSQL

Fixes #13324.

comment:3 Changed 7 years ago by Ryan J Ollos

In 16956:

TracVote 0.7.0dev: Use list literal

Refs #13324.

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain Ryan J Ollos.
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.