Modify ↓
#6857 closed defect (worksforme)
trac internal error
Reported by: | 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 )
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 , 17 years ago
Description: | modified (diff) |
---|---|
Resolution: | → worksforme |
Status: | new → closed |
comment:2 by , 16 years ago
Cc: | 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
Note:
See TracTickets
for help on using tickets.
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.