Project

General

Profile

Actions

Defect #5696

closed

Redmine + PostgreSQL 8.4.4 fails on _dir_list_content.rhtml

Added by Anonymous almost 14 years ago. Updated over 13 years ago.

Status:
Closed
Priority:
Low
Assignee:
Category:
Database
Target version:
Start date:
2010-06-16
Due date:
% Done:

0%

Estimated time:
Resolution:
Cant reproduce
Affected version:

Description

This bug is very similar to #3942.

When requesting directory contents, postgresql fails with an error like:

PGError: ERROR: operator does not exist: character varying = integer

The solution is about the same.
I changed in _dir_list_content.rhtml
< % changeset = @project.repository.changesets.find_by_revision(entry.lastrev.identifier) if entry.lastrev && entry.lastrev.identifier % >
to
< % changeset = @project.repository.changesets.find_by_revision(entry.lastrev.identifier.to_s) if entry.lastrev && entry.lastrev.identifier % >
and it worked.

About:
  • Ubuntu server 10.04
  • Redmine 0.9.3
  • PostgreSQL 8.4.4
  • Ruby version 1.8.7 (i486-linux)
  • RubyGems version 1.3.5
  • Rails version 2.2.3
  • Active Record version 2.2.3
  • Action Pack version 2.2.3
  • Active Resource version 2.2.3
  • Action Mailer version 2.2.3
  • Active Support version 2.2.3
  • Edge Rails revision unknown
  • Application root /usr/share/redmine
  • Environment production
  • Database adapter postgresql
  • Database schema version 20100221100219

Related issues

Related to Redmine - Defect #3942: Redmine + PostgreSQL 8.3: ActiveRecord::StatementInvalid in RepositoriesController#revisionClosed2009-09-29

Actions
Actions

Also available in: Atom PDF