Two errors after a fresh new installation: wrong date and xml output
Added by LdP Matic over 13 years ago
Hello all !
I've just installed (under linux) ruby 1.8.7, rubygems 1.3.7, and redmine 1.0.4 (for this one I followed the installation guide).
I have the following problems:
1) Some pages related to projects outputs xml data instead of normal html&co: for instance if I open the browser at the page http://redmine/projects I get the following output:
<?xml version="1.0" encoding="UTF-8"?> <projects type="array"> <project> <id>1</id> <name>MyPrj</name> <identifier>myprj</identifier> <description>MyPrj description</description> <created_on>Thu Dec 30 08:00:15 +0100 2010</created_on> <updated_on>Wed Dec 29 19:57:18 +0100 2010</updated_on> </project> </projects>
2) The date has absurd value: If I go to http://redmine/settings it lets me choose among these date formats (today it's 22 Dec 2010):
2118-01-33336 33336/01/2118 33336.01.2118 33336-01-2118 01/33336/2118 33336 Dec 2118 33336 December 2118 Dec 33336, 2118 December 33336, 2118
As result, many pages fail in composing the sql query concerning dates. For example under http://redmine/projects/myprj/activity I get this error:
PGError: ERROR: date/time field value out of range: "2118-01-33307"
LINE 1: ...cker_id WHERE (1=1 AND (issues.created_on BETWEEN '2118-01-3...
SELECT "issues"."id" AS t0_r0, "issues"."tracker_id" AS t0_r1, "issues"."project_id" AS t0_r2, "issues"."subject" AS t0_r3, "issues"."description" AS t0_r4, "issues"."due_date" AS t0_r5, "issues"."category_id" AS t0_r6, "issues"."status_id" AS t0_r7, "issues"."assigned_to_id" AS t0_r8, "issues"."priority_id" AS t0_r9, "issues"."fixed_version_id" AS t0_r10, "issues"."author_id" AS t0_r11, "issues"."lock_version" AS t0_r12, "issues"."created_on" AS t0_r13, "issues"."updated_on" AS t0_r14, "issues"."start_date" AS t0_r15, "issues"."done_ratio" AS t0_r16, "issues"."estimated_hours" AS t0_r17, "issues"."parent_id" AS t0_r18, "issues"."root_id" AS t0_r19, "issues"."lft" AS t0_r20, "issues"."rgt" AS t0_r21, "projects"."id" AS t1_r0, "projects"."name" AS t1_r1, "projects"."description" AS t1_r2, "projects"."homepage" AS t1_r3, "projects"."is_public" AS t1_r4, "projects"."parent_id" AS t1_r5, "projects"."created_on" AS t1_r6, "projects"."updated_on" AS t1_r7, "projects"."identifier" AS t1_r8, "projects"."status" AS t1_r9, "projects"."lft" AS t1_r10, "projects"."rgt" AS t1_r11, "users"."id" AS t2_r0, "users"."login" AS t2_r1, "users"."hashed_password" AS t2_r2, "users"."firstname" AS t2_r3, "users"."lastname" AS t2_r4, "users"."mail" AS t2_r5, "users"."mail_notification" AS t2_r6, "users"."admin" AS t2_r7, "users"."status" AS t2_r8, "users"."last_login_on" AS t2_r9, "users"."language" AS t2_r10, "users"."auth_source_id" AS t2_r11, "users"."created_on" AS t2_r12, "users"."updated_on" AS t2_r13, "users"."type" AS t2_r14, "users"."identity_url" AS t2_r15, "trackers"."id" AS t3_r0, "trackers"."name" AS t3_r1, "trackers"."is_in_chlog" AS t3_r2, "trackers"."position" AS t3_r3, "trackers"."is_in_roadmap" AS t3_r4 FROM "issues" LEFT OUTER JOIN "projects" ON "projects".id = "issues".project_id LEFT OUTER JOIN "users" ON "users".id = "issues".author_id AND ("users"."type" = 'User' OR "users"."type" = 'AnonymousUser' ) LEFT OUTER JOIN "trackers" ON "trackers".id = "issues".tracker_id WHERE (1=1 AND (issues.created_on BETWEEN '2118-01-33307' AND '2118-01-33337') AND ((projects.id = 1 OR (projects.lft > 1 AND projects.rgt < 2)) AND (projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking'))))
The production log doesn't help much. What am I doing wrong?
Thank you
Replies (1)
[SOLVED] Two errors after a fresh new installation: wrong date and xml output
-
Added by LdP Matic over 13 years ago
This was my problem:
[gaxcom@tmp]$ ruby -v ruby 1.8.7 (2008-05-31 patchlevel 0) [x86_64-linux]
Now everything is ok:
[gaxcom@tmp]$ ruby -v ruby 1.8.7 (2010-12-23 patchlevel 330) [x86_64-linux]