Project

General

Profile

Actions

Defect #3241

closed

Doc update for install on PostgreSQL (datestyle)

Added by Herve Boulouis about 16 years ago. Updated about 16 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Documentation
Target version:
-
Start date:
2009-04-26
Due date:
% Done:

0%

Estimated time:
Resolution:
Fixed
Affected version:

Description

On my recent installation of Redmine I got bitten by multiple ActionView::TemplateError (undefined method `-' for nil:NilClass) in many places all refering to date fields.

As already reported in the redmine forums, I traced the crashes to my PgSQL default datestyle to 'SQL, European'. Switching to ISO,MDY fixed the problem, so I think adding a note about that in the installation documentation is necessary.

You can alter the datestyle for the redmine db permanently with the sql request :

ALTER DATABASE redmine SET datestyle TO 'ISO, MDY';

My setup : FreeBSD 6.2 / ruby 1.8.7 / rails 2.2.2 / trunk from 23/04/2009

Note: 0.8.3 also affected

Actions #1

Updated by Jean-Philippe Lang about 16 years ago

  • Status changed from New to Closed
  • Resolution set to Fixed

This was already discussed in Redmine 0.8.0 - PostgreSQL 8.1 - datestyle.
Added to the installation guide.

Actions

Also available in: Atom PDF