trac internal error

[leandro@…]

I'm running in a Postgresql 8.3.0 and when I tried to insert a ticket:

Python Traceback

Traceback (most recent call last):
  File "/var/lib/python-support/python2.5/trac/web/main.py", line 406, in dispatch_request
    dispatcher.dispatch(req)
  File "/var/lib/python-support/python2.5/trac/web/main.py", line 237, in dispatch
    resp = chosen_handler.process_request(req)
  File "/var/lib/python-support/python2.5/trac/ticket/web_ui.py", line 313, in process_request
    get_reporter_id(req, 'author'))
  File "/var/lib/python-support/python2.5/trac/ticket/web_ui.py", line 630, in _insert_ticket_data
    for change in self.grouped_changelog_entries(ticket, db):
  File "/var/lib/python-support/python2.5/trac/ticket/web_ui.py", line 677, in grouped_changelog_entries
    changelog = ticket.get_changelog(when=when, db=db)
  File "/var/lib/python-support/python2.5/trac/ticket/model.py", line 296, in get_changelog
    "ORDER BY time", (self.id,  str(self.id), self.id))
  File "/var/lib/python-support/python2.5/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/var/lib/python-support/python2.5/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.5/site-packages/pyPgSQL/PgSQL.py", line 3111, in execute
    raise OperationalError, msg
OperationalError: ERROR:  operator does not exist: text = integer at character 241
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

[Emmanuel Blot]

As you forgot to report an essential piece of information: the version of Trac you use, I assume you're not using the last version of Trac and have not read TracInstall#ForPostgreSQL yet, especially the warning about Postgresql 8.3.

Feel free to re-open the ticket if I'm wrong and you can provide useful details about your installation.

[erlingwl@…]

See: ​http://doc.nuxeo.org/xwiki/bin/view/FAQ/UsingPostgreSQL83

It says:

"To make Jena work with PostgreSQL 8.3, you can execute the following commands in your PostgreSQL console:

CREATE FUNCTION pg_catalog.text(integer) RETURNS text STRICT IMMUTABLE LANGUAGE SQL AS 'SELECT textin(int4out($1));'; CREATE CAST (integer AS text) WITH FUNCTION pg_catalog.text(integer) AS IMPLICIT;"

This worked on my Trac installation too :D