Actions
Defect #3241
closed
Doc update for install on PostgreSQL (datestyle)
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
Updated by
Actions