Crash when browsing a ticket

[ntmlod]

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.

[Ryan J Ollos]

In 16955:

TracVote 0.7.0dev: Fix ProgrammingError with PostgreSQL

Fixes #13324.

[Ryan J Ollos]

In 16956:

TracVote 0.7.0dev: Use list literal

Refs #13324.