Edgewall Software
Modify

Opened 17 years ago

Closed 17 years ago

Last modified 16 years ago

#6857 closed defect (worksforme)

trac internal error

Reported by: leandro@… Owned by: Jonas Borgström
Priority: normal Milestone:
Component: general Version:
Severity: normal Keywords:
Cc: erlingwl@… Branch:
Release Notes:
API Changes:
Internal Changes:

Description (last modified by Emmanuel Blot)

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.

Attachments (0)

Change History (2)

comment:1 by Emmanuel Blot, 17 years ago

Description: modified (diff)
Resolution: worksforme
Status: newclosed

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.

comment:2 by erlingwl@…, 16 years ago

Cc: erlingwl@… added

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

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain Jonas Borgström.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from Jonas Borgström to the specified user.

Add Comment


E-mail address and name can be saved in the Preferences .
 
Note: See TracTickets for help on using tickets.