Project

General

Profile

Actions
Copy link

Defect #5397

closed

Internal Error Thrown, no logging information provided, but everything 'works'.

Added by Jon Lumpkin over 14 years ago. Updated over 13 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Issues
Target version:
-
Start date:
2010-04-28
Due date:
% Done:

0%

Estimated time:
Resolution:
Invalid
Affected version:
0.9.3

Description

We are having an issue (with .93) that includes the following:
  • IE 7 on Windows XP (with integrated auth enabled or not, this is the only thing that has changed in the last few days we know of).
  • Cache has been cleared
  • machine restarted

When the user does any sort of insert/update, they get the (Redmine Error 500) Internal Error, please report to redMine administrator. If the user clicks to go back, it says that the update/insert was ok (and it was).

This page does not show any stack trace.

I then went into the environment.rb, and enabled debug logging. At the time this error is thrown, nothing is added to the log stating the problem.

Finally, when the user tries this in Google Chrome, it works correctly. So it appears to be an IE related issue.

Our biggest problem right now is how to track down what is going wrong with out any logs, and the bug report would be to log these general exceptions.

Actions
Copy link
 #1

Updated by Holger Just over 14 years ago

might be related to #5401

Actions
Copy link
 #2

Updated by Jon Lumpkin over 14 years ago

Not sure, it works in all other browsers. and that other issue looks like its having problems showing any page. Ours only seems to have problems after doing some type of update/insert.

Finally - I have another user now having this issue as well, also using IE7 on Windows XP.

It works fine in all other browsers.

Actions
Copy link
 #3

Updated by Jon Lumpkin over 14 years ago

  1. Logfile created on Thu May 06 14:35:12 -0400 2010 [4;35;1mSQL (0.0ms)[0m [0mSET SQL_AUTO_IS_NULL=0[0m

Processing WelcomeController#index (for 10.29.96.8 at 2010-05-06 14:35:25) [GET]
Parameters: {"action"=>"index", "controller"=>"welcome"}
[4;36;1mSetting Columns (46.0ms)[0m [0;1mSHOW FIELDS FROM `settings`[0m
[4;35;1mSQL (0.0ms)[0m [0mSELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` [0m
[4;36;1mUser Columns (31.0ms)[0m [0;1mSHOW FIELDS FROM `users`[0m
[4;35;1mUser Load (0.0ms)[0m [0mSELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) [0m
[4;36;1mNews Columns (47.0ms)[0m [0;1mSHOW FIELDS FROM `news`[0m
[4;35;1mProject Columns (46.0ms)[0m [0mSHOW FIELDS FROM `projects`[0m
[4;36;1mNews Load Including Associations (141.0ms)[0m [0;1mSELECT `news`.`id` AS t0_r0, `news`.`project_id` AS t0_r1, `news`.`title` AS t0_r2, `news`.`summary` AS t0_r3, `news`.`description` AS t0_r4, `news`.`author_id` AS t0_r5, `news`.`created_on` AS t0_r6, `news`.`comments_count` AS t0_r7, `users`.`id` AS t1_r0, `users`.`login` AS t1_r1, `users`.`hashed_password` AS t1_r2, `users`.`firstname` AS t1_r3, `users`.`lastname` AS t1_r4, `users`.`mail` AS t1_r5, `users`.`mail_notification` AS t1_r6, `users`.`admin` AS t1_r7, `users`.`status` AS t1_r8, `users`.`last_login_on` AS t1_r9, `users`.`language` AS t1_r10, `users`.`auth_source_id` AS t1_r11, `users`.`created_on` AS t1_r12, `users`.`updated_on` AS t1_r13, `users`.`type` AS t1_r14, `users`.`identity_url` AS t1_r15, `projects`.`id` AS t2_r0, `projects`.`name` AS t2_r1, `projects`.`description` AS t2_r2, `projects`.`homepage` AS t2_r3, `projects`.`is_public` AS t2_r4, `projects`.`parent_id` AS t2_r5, `projects`.`created_on` AS t2_r6, `projects`.`updated_on` AS t2_r7, `projects`.`identifier` AS t2_r8, `projects`.`status` AS t2_r9, `projects`.`lft` AS t2_r10, `projects`.`rgt` AS t2_r11 FROM `news` LEFT OUTER JOIN `users` ON `users`.id = `news`.author_id AND (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) LEFT OUTER JOIN `projects` ON `projects`.id = `news`.project_id WHERE (projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='news')) ORDER BY news.created_on DESC LIMIT 5[0m
[4;35;1mProject Load (16.0ms)[0m [0mSELECT * FROM `projects` WHERE (projects.status=1) ORDER BY created_on DESC LIMIT 5[0m
Rendering template within layouts/base
Rendering welcome/index
[4;36;1mSetting Load (0.0ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'welcome_text') LIMIT 1[0m
[4;35;1mSetting Load (0.0ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'user_format') LIMIT 1[0m
[4;36;1mUserPreference Load (0.0ms)[0m [0;1mSELECT * FROM `user_preferences` WHERE (`user_preferences`.user_id = 3) LIMIT 1[0m
[4;35;1mUserPreference Columns (16.0ms)[0m [0mSHOW FIELDS FROM `user_preferences`[0m
[4;36;1mSetting Load (0.0ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'time_format') LIMIT 1[0m
Rendered news/_news (906.0ms)
Rendered news/_news (0.0ms)
Rendered news/_news (16.0ms)
Rendered news/_news (0.0ms)
Rendered news/_news (0.0ms)
[4;35;1mSetting Load (0.0ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'text_formatting') LIMIT 1[0m
[4;36;1mToken Load (47.0ms)[0m [0;1mSELECT * FROM `tokens` WHERE (`tokens`.user_id = 3 AND (action='feeds')) LIMIT 1[0m
[4;35;1mToken Columns (16.0ms)[0m [0mSHOW FIELDS FROM `tokens`[0m
[4;36;1mSetting Load (0.0ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'app_title') LIMIT 1[0m
[4;35;1mSetting Load (15.0ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'ui_theme') LIMIT 1[0m
[4;36;1mProject Load (125.0ms)[0m [0;1mSELECT `projects`.* FROM `projects` INNER JOIN `members` ON `projects`.id = `members`.project_id WHERE ((`members`.user_id = 3) AND ((projects.status=1))) [0m
Completed in 1750ms (View: 1078, DB: 546) | 200 OK [http://wit390/redmine/]
[4;35;1mSQL (0.0ms)[0m [0mSET SQL_AUTO_IS_NULL=0[0m

Processing IssuesController#edit (for 10.8.96.47 at 2010-05-06 14:37:02) [POST]
Parameters: {"time_entry"=>{"comments"=>"", "activity_id"=>"", "hours"=>""}, "commit"=>"Submit", "notes"=>"", "action"=>"edit", "authenticity_token"=>"yee7SiOU8KdoOG+moDsoV4biHKFAt1SLqxCFkz2cCN8=", "id"=>"813", "issue"=>{"start_date"=>"", "custom_field_values"=>{"25"=>"", "26"=>"", "27"=>"", "28"=>"1.0.0.18"}, "estimated_hours"=>"", "priority_id"=>"4", "lock_version"=>"0", "fixed_version_id"=>"", "done_ratio"=>"0", "assigned_to_id"=>"", "subject"=>"ICR 100408078 did not show up in review queue", "tracker_id"=>"1", "due_date"=>"", "status_id"=>"1", "description"=>"REMOVING OUR STACK TRACE"}, "controller"=>"issues", "attachments"=>{"1"=>{"description"=>""}}}
[4;36;1mSetting Columns (16.0ms)[0m [0;1mSHOW FIELDS FROM `settings`[0m
[4;35;1mSQL (0.0ms)[0m [0mSELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` [0m
[4;36;1mUser Columns (0.0ms)[0m [0;1mSHOW FIELDS FROM `users`[0m
[4;35;1mUser Load (0.0ms)[0m [0mSELECT * FROM `users` WHERE (`users`.`id` = 10) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) [0m
[4;36;1mIssue Columns (219.0ms)[0m [0;1mSHOW FIELDS FROM `issues`[0m
[4;35;1mIssue Load (47.0ms)[0m [0mSELECT * FROM `issues` WHERE (`issues`.`id` = 813) [0m
[4;36;1mProject Columns (47.0ms)[0m [0;1mSHOW FIELDS FROM `projects`[0m
[4;35;1mProject Load (0.0ms)[0m [0mSELECT * FROM `projects` WHERE (`projects`.`id` = 2) [0m
[4;36;1mTracker Columns (47.0ms)[0m [0;1mSHOW FIELDS FROM `trackers`[0m
[4;35;1mTracker Load (15.0ms)[0m [0mSELECT * FROM `trackers` WHERE (`trackers`.`id` = 1) [0m
[4;36;1mIssueStatus Columns (94.0ms)[0m [0;1mSHOW FIELDS FROM `issue_statuses`[0m
[4;35;1mIssueStatus Load (0.0ms)[0m [0mSELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` = 1) [0m
[4;36;1mUser Load (0.0ms)[0m [0;1mSELECT * FROM `users` WHERE (`users`.`id` = 69) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) [0m
[4;35;1mIssuePriority Columns (47.0ms)[0m [0mSHOW FIELDS FROM `enumerations`[0m
[4;36;1mIssuePriority Load (0.0ms)[0m [0;1mSELECT * FROM `enumerations` WHERE (`enumerations`.`id` = 4) AND ( (`enumerations`.`type` = 'IssuePriority' ) ) [0m
[4;35;1mEnabledModule Load (0.0ms)[0m [0mSELECT * FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 2) [0m
[4;36;1mEnabledModule Columns (0.0ms)[0m [0;1mSHOW FIELDS FROM `enabled_modules`[0m
[4;35;1mMember Columns (0.0ms)[0m [0mSHOW FIELDS FROM `members`[0m
[4;36;1mRole Columns (31.0ms)[0m [0;1mSHOW FIELDS FROM `roles`[0m
[4;35;1mMember Load Including Associations (203.0ms)[0m [0mSELECT `members`.`id` AS t0_r0, `members`.`user_id` AS t0_r1, `members`.`project_id` AS t0_r2, `members`.`created_on` AS t0_r3, `members`.`mail_notification` AS t0_r4, `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, `roles`.`id` AS t2_r0, `roles`.`name` AS t2_r1, `roles`.`position` AS t2_r2, `roles`.`assignable` AS t2_r3, `roles`.`builtin` AS t2_r4, `roles`.`permissions` AS t2_r5 FROM `members` LEFT OUTER JOIN `projects` ON `projects`.id = `members`.project_id LEFT OUTER JOIN `member_roles` ON (`members`.`id` = `member_roles`.`member_id`) LEFT OUTER JOIN `roles` ON (`roles`.`id` = `member_roles`.`role_id`) WHERE (`members`.user_id = 10 AND (projects.status=1)) ORDER BY projects.name[0m
[4;36;1mWorkflow Load (187.0ms)[0m [0;1mSELECT * FROM `workflows` WHERE (`workflows`.old_status_id = 1 AND (`workflows`.`tracker_id` = 1 AND `workflows`.`role_id` IN (4))) [0m
[4;35;1mWorkflow Columns (16.0ms)[0m [0mSHOW FIELDS FROM `workflows`[0m
[4;36;1mIssueStatus Load (0.0ms)[0m [0;1mSELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` IN (6,7,8,9,1,2,3,4,5)) [0m
[4;35;1mIssueRelation Load (47.0ms)[0m [0mSELECT * FROM `issue_relations` WHERE (`issue_relations`.issue_to_id = 813) [0m
[4;36;1mIssuePriority Load (0.0ms)[0m [0;1mSELECT * FROM `enumerations` WHERE ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC[0m
[4;35;1mTimeEntry Columns (62.0ms)[0m [0mSHOW FIELDS FROM `time_entries`[0m
[4;36;1mTimeEntryActivity Columns (15.0ms)[0m [0;1mSHOW FIELDS FROM `enumerations`[0m
[4;35;1mTimeEntryActivity Load (0.0ms)[0m [0mSELECT * FROM `enumerations` WHERE (`enumerations`.`is_default` = 1) AND ( (`enumerations`.`type` = 'TimeEntryActivity' ) ) ORDER BY enumerations.position ASC LIMIT 1[0m
[4;36;1mJournal Columns (313.0ms)[0m [0;1mSHOW FIELDS FROM `journals`[0m
[4;35;1mIssueStatus Load (0.0ms)[0m [0mSELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` = 0) [0m
[4;36;1mIssueStatus Load (0.0ms)[0m [0;1mSELECT * FROM `issue_statuses` WHERE (is_default=1) LIMIT 1[0m
[4;35;1mIssuePriority Load (0.0ms)[0m [0mSELECT * FROM `enumerations` WHERE (`enumerations`.`id` = 0) AND ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC[0m
[4;36;1mIssuePriority Load (0.0ms)[0m [0;1mSELECT * FROM `enumerations` WHERE (`enumerations`.`is_default` = 1) AND ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC LIMIT 1[0m
[4;35;1mCustomValue Columns (375.0ms)[0m [0mSHOW FIELDS FROM `custom_values`[0m
[4;36;1mCustomField Columns (109.0ms)[0m [0;1mSHOW FIELDS FROM `custom_fields`[0m
[4;35;1mCustomValue Load Including Associations (16.0ms)[0m [0mSELECT `custom_values`.`id` AS t0_r0, `custom_values`.`customized_type` AS t0_r1, `custom_values`.`customized_id` AS t0_r2, `custom_values`.`custom_field_id` AS t0_r3, `custom_values`.`value` AS t0_r4, `custom_fields`.`id` AS t1_r0, `custom_fields`.`type` AS t1_r1, `custom_fields`.`name` AS t1_r2, `custom_fields`.`field_format` AS t1_r3, `custom_fields`.`possible_values` AS t1_r4, `custom_fields`.`regexp` AS t1_r5, `custom_fields`.`min_length` AS t1_r6, `custom_fields`.`max_length` AS t1_r7, `custom_fields`.`is_required` AS t1_r8, `custom_fields`.`is_for_all` AS t1_r9, `custom_fields`.`is_filter` AS t1_r10, `custom_fields`.`position` AS t1_r11, `custom_fields`.`searchable` AS t1_r12, `custom_fields`.`default_value` AS t1_r13, `custom_fields`.`editable` AS t1_r14 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.id = `custom_values`.custom_field_id WHERE (`custom_values`.customized_id = 813 AND `custom_values`.customized_type = 'Issue') ORDER BY custom_fields.position[0m
[4;36;1mCACHE (0.0ms)[0m [0;1mSELECT * FROM `trackers` WHERE (`trackers`.`id` = 1) [0m
[4;35;1mIssueCustomField Columns (15.0ms)[0m [0mSHOW FIELDS FROM `custom_fields`[0m
[4;36;1mIssueCustomField Load (0.0ms)[0m [0;1mSELECT * FROM `custom_fields` WHERE (is_for_all=1) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY position[0m
[4;35;1mcustom_fields_projects Columns (47.0ms)[0m [0mSHOW FIELDS FROM `custom_fields_projects`[0m
[4;36;1mIssueCustomField Load (16.0ms)[0m [0;1mSELECT * FROM `custom_fields` INNER JOIN `custom_fields_projects` ON `custom_fields`.id = `custom_fields_projects`.custom_field_id WHERE (`custom_fields_projects`.project_id = 2 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY custom_fields.position[0m
[4;35;1mIssueCustomField Load (0.0ms)[0m [0mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 13) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
[4;36;1mIssueCustomField Load (0.0ms)[0m [0;1mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 14) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
[4;35;1mIssueCustomField Load (0.0ms)[0m [0mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 15) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
[4;36;1mIssueCustomField Load (0.0ms)[0m [0;1mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 20) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
[4;35;1mIssueCustomField Load (0.0ms)[0m [0mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 21) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
[4;36;1mIssueCustomField Load (0.0ms)[0m [0;1mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 22) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
[4;35;1mIssueCustomField Load (0.0ms)[0m [0mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 23) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
[4;36;1mIssueCustomField Load (0.0ms)[0m [0;1mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 25) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
[4;35;1mIssueCustomField Load (0.0ms)[0m [0mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 26) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
[4;36;1mIssueCustomField Load (0.0ms)[0m [0;1mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 27) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
[4;35;1mIssueCustomField Load (0.0ms)[0m [0mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 28) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
[4;36;1mCACHE (0.0ms)[0m [0;1mSELECT * FROM `enumerations` WHERE (`enumerations`.`is_default` = 1) AND ( (`enumerations`.`type` = 'TimeEntryActivity' ) ) ORDER BY enumerations.position ASC LIMIT 1[0m
[4;35;1mIssuePriority Load (0.0ms)[0m [0mSELECT * FROM `enumerations` WHERE (`enumerations`.`id` = 4) AND ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC[0m
[4;36;1mCACHE (0.0ms)[0m [0;1mSELECT * FROM `trackers` WHERE (`trackers`.`id` = 1) [0m
[4;35;1mSetting Load (0.0ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'issue_done_ratio') LIMIT 1[0m
[4;36;1mSQL (0.0ms)[0m [0;1mBEGIN[0m
[4;35;1mIssue Update with optimistic locking (0.0ms)[0m [0m UPDATE `issues`
SET `subject` = 'ICR 100408078 did not show up in review queue', `description` = 'REMOVING OUR STACK TRACE', `lock_version` = 1, `updated_on` = '2010-05-06 14:37:05'
WHERE id = 813
AND `lock_version` = 0
[0m
[4;36;1mIssueCustomField Load (0.0ms)[0m [0;1mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 13) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
[4;35;1mIssueCustomField Load (0.0ms)[0m [0mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 14) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
[4;36;1mIssueCustomField Load (0.0ms)[0m [0;1mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 15) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
[4;35;1mIssueCustomField Load (0.0ms)[0m [0mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 20) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
[4;36;1mIssueCustomField Load (0.0ms)[0m [0;1mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 21) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
[4;35;1mIssueCustomField Load (0.0ms)[0m [0mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 22) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
[4;36;1mIssueCustomField Load (0.0ms)[0m [0;1mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 23) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
[4;35;1mIssueCustomField Load (0.0ms)[0m [0mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 25) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
[4;36;1mIssueCustomField Load (0.0ms)[0m [0;1mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 26) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
[4;35;1mIssueCustomField Load (0.0ms)[0m [0mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 27) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
[4;36;1mIssueCustomField Load (0.0ms)[0m [0;1mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 28) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
[4;35;1mJournalDetail Columns (391.0ms)[0m [0mSHOW FIELDS FROM `journal_details`[0m
[4;36;1mJournal Create (31.0ms)[0m [0;1mINSERT INTO `journals` (`created_on`, `notes`, `user_id`, `journalized_type`, `journalized_id`) VALUES[0m
[4;35;1mJournalDetail Create (0.0ms)[0m [0mINSERT INTO `journal_details` (`property`, `prop_key`, `old_value`, `value`, `journal_id`) VALUES', 'ICR 100408078 did not show up in review queue', 1659)[0m
[4;36;1mSetting Load (0.0ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'notified_events') LIMIT 1[0m
[4;35;1mSetting Load (0.0ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'default_language') LIMIT 1[0m
[4;36;1mSetting Load (0.0ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'mail_from') LIMIT 1[0m
[4;35;1mSetting Load (0.0ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'host_name') LIMIT 1[0m
[4;36;1mSetting Load (0.0ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'app_title') LIMIT 1[0m
[4;35;1mIssue Load (0.0ms)[0m [0mSELECT * FROM `issues` WHERE (`issues`.`id` = 813) [0m
[4;36;1mProject Load (0.0ms)[0m [0;1mSELECT * FROM `projects` WHERE (`projects`.`id` = 2) [0m
[4;35;1mUser Load (0.0ms)[0m [0mSELECT * FROM `users` WHERE (`users`.`id` = 69) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) [0m
[4;36;1mMember Load Including Associations (0.0ms)[0m [0;1mSELECT `members`.`id` AS t0_r0, `members`.`user_id` AS t0_r1, `members`.`project_id` AS t0_r2, `members`.`created_on` AS t0_r3, `members`.`mail_notification` AS t0_r4, `users`.`id` AS t1_r0, `users`.`login` AS t1_r1, `users`.`hashed_password` AS t1_r2, `users`.`firstname` AS t1_r3, `users`.`lastname` AS t1_r4, `users`.`mail` AS t1_r5, `users`.`mail_notification` AS t1_r6, `users`.`admin` AS t1_r7, `users`.`status` AS t1_r8, `users`.`last_login_on` AS t1_r9, `users`.`language` AS t1_r10, `users`.`auth_source_id` AS t1_r11, `users`.`created_on` AS t1_r12, `users`.`updated_on` AS t1_r13, `users`.`type` AS t1_r14, `users`.`identity_url` AS t1_r15, `roles`.`id` AS t2_r0, `roles`.`name` AS t2_r1, `roles`.`position` AS t2_r2, `roles`.`assignable` AS t2_r3, `roles`.`builtin` AS t2_r4, `roles`.`permissions` AS t2_r5 FROM `members` LEFT OUTER JOIN `users` ON `users`.id = `members`.user_id AND (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) LEFT OUTER JOIN `member_roles` ON (`members`.`id` = `member_roles`.`member_id`) LEFT OUTER JOIN `roles` ON (`roles`.`id` = `member_roles`.`role_id`) WHERE (`members`.project_id = 2 AND (users.type='User' AND users.status=1)) [0m
[4;35;1mEnabledModule Load (0.0ms)[0m [0mSELECT * FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 2) [0m
[4;36;1mMember Load Including Associations (31.0ms)[0m [0;1mSELECT `members`.`id` AS t0_r0, `members`.`user_id` AS t0_r1, `members`.`project_id` AS t0_r2, `members`.`created_on` AS t0_r3, `members`.`mail_notification` AS t0_r4, `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, `roles`.`id` AS t2_r0, `roles`.`name` AS t2_r1, `roles`.`position` AS t2_r2, `roles`.`assignable` AS t2_r3, `roles`.`builtin` AS t2_r4, `roles`.`permissions` AS t2_r5 FROM `members` LEFT OUTER JOIN `projects` ON `projects`.id = `members`.project_id LEFT OUTER JOIN `member_roles` ON (`members`.`id` = `member_roles`.`member_id`) LEFT OUTER JOIN `roles` ON (`roles`.`id` = `member_roles`.`role_id`) WHERE (`members`.user_id = 69 AND (projects.status=1)) ORDER BY projects.name[0m
[4;35;1mWatcher Load (109.0ms)[0m [0mSELECT * FROM `watchers` WHERE (`watchers`.watchable_id = 813 AND `watchers`.watchable_type = 'Issue') [0m
[4;36;1mWatcher Columns (16.0ms)[0m [0;1mSHOW FIELDS FROM `watchers`[0m
[4;35;1mCACHE (0.0ms)[0m [0mSELECT * FROM `users` WHERE (`users`.`id` = 69) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) [0m
[4;36;1mCACHE (0.0ms)[0m [0;1mSELECT `members`.`id` AS t0_r0, `members`.`user_id` AS t0_r1, `members`.`project_id` AS t0_r2, `members`.`created_on` AS t0_r3, `members`.`mail_notification` AS t0_r4, `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, `roles`.`id` AS t2_r0, `roles`.`name` AS t2_r1, `roles`.`position` AS t2_r2, `roles`.`assignable` AS t2_r3, `roles`.`builtin` AS t2_r4, `roles`.`permissions` AS t2_r5 FROM `members` LEFT OUTER JOIN `projects` ON `projects`.id = `members`.project_id LEFT OUTER JOIN `member_roles` ON (`members`.`id` = `member_roles`.`member_id`) LEFT OUTER JOIN `roles` ON (`roles`.`id` = `member_roles`.`role_id`) WHERE (`members`.user_id = 69 AND (projects.status=1)) ORDER BY projects.name[0m
[4;35;1mTracker Load (0.0ms)[0m [0mSELECT * FROM `trackers` WHERE (`trackers`.`id` = 1) [0m
[4;36;1mSetting Load (0.0ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'protocol') LIMIT 1[0m
[4;35;1mSetting Load (0.0ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'plain_text_mail') LIMIT 1[0m
[4;36;1mSetting Load (0.0ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'user_format') LIMIT 1[0m
[4;35;1mIssueStatus Load (0.0ms)[0m [0mSELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` = 1) [0m
[4;36;1mIssuePriority Load (0.0ms)[0m [0;1mSELECT * FROM `enumerations` WHERE (`enumerations`.`id` = 4) AND ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC[0m
[4;35;1mCustomValue Load Including Associations (16.0ms)[0m [0mSELECT `custom_values`.`id` AS t0_r0, `custom_values`.`customized_type` AS t0_r1, `custom_values`.`customized_id` AS t0_r2, `custom_values`.`custom_field_id` AS t0_r3, `custom_values`.`value` AS t0_r4, `custom_fields`.`id` AS t1_r0, `custom_fields`.`type` AS t1_r1, `custom_fields`.`name` AS t1_r2, `custom_fields`.`field_format` AS t1_r3, `custom_fields`.`possible_values` AS t1_r4, `custom_fields`.`regexp` AS t1_r5, `custom_fields`.`min_length` AS t1_r6, `custom_fields`.`max_length` AS t1_r7, `custom_fields`.`is_required` AS t1_r8, `custom_fields`.`is_for_all` AS t1_r9, `custom_fields`.`is_filter` AS t1_r10, `custom_fields`.`position` AS t1_r11, `custom_fields`.`searchable` AS t1_r12, `custom_fields`.`default_value` AS t1_r13, `custom_fields`.`editable` AS t1_r14 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.id = `custom_values`.custom_field_id WHERE (`custom_values`.customized_id = 813 AND `custom_values`.customized_type = 'Issue') ORDER BY custom_fields.position[0m
Rendered mailer/_issue_text_plain (32.0ms)
[4;36;1mSetting Load (0.0ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'emails_footer') LIMIT 1[0m
[4;35;1mAttachment Load (297.0ms)[0m [0mSELECT * FROM `attachments` WHERE (`attachments`.container_id = 813 AND `attachments`.container_type = 'Issue') ORDER BY attachments.created_on[0m
[4;36;1mSetting Load (15.0ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'text_formatting') LIMIT 1[0m
Rendered mailer/_issue_text_html (3109.0ms)
[4;35;1mUserPreference Load (0.0ms)[0m [0mSELECT * FROM `user_preferences` WHERE (`user_preferences`.user_id = 10) LIMIT 1[0m
[4;36;1mUserPreference Columns (0.0ms)[0m [0;1mSHOW FIELDS FROM `user_preferences`[0m
[4;35;1mSetting Load (0.0ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'bcc_recipients') LIMIT 1[0m
[4;36;1mCACHE (0.0ms)[0m [0;1mSELECT * FROM `issues` WHERE (`issues`.`id` = 813) [0m
[4;35;1mIssueRelation Load (0.0ms)[0m [0mSELECT * FROM `issue_relations` WHERE (`issue_relations`.issue_from_id = 813) [0m
[4;36;1mCACHE (0.0ms)[0m [0;1mSELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` = 1) [0m
[4;35;1mSQL (0.0ms)[0m [0mCOMMIT[0m
[4;36;1mSQL (0.0ms)[0m [0;1mBEGIN[0m
[4;35;1mCustomField Load (0.0ms)[0m [0mSELECT * FROM `custom_fields` WHERE (type = 'TimeEntryCustomField') ORDER BY position[0m
[4;36;1mCACHE (0.0ms)[0m [0;1mSELECT * FROM `projects` WHERE (`projects`.`id` = 2) [0m
[4;35;1mSQL (0.0ms)[0m [0mROLLBACK[0m
Redirected to http://wit390:8080/redmine/issues/813
Completed in 7188ms (DB: 2890) | 302 Found [http://wit390/redmine/issues/813/edit]

Processing IssuesController#index (for 10.8.96.47 at 2010-05-06 14:37:32) [GET]
Parameters: {"project_id"=>"prime", "set_filter"=>"1", "action"=>"index", "controller"=>"issues"}
[4;36;1mSQL (0.0ms)[0m [0;1mSELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` [0m
[4;35;1mUser Load (0.0ms)[0m [0mSELECT * FROM `users` WHERE (`users`.`id` = 10) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) [0m
[4;36;1mProject Load (0.0ms)[0m [0;1mSELECT * FROM `projects` WHERE (`projects`.`identifier` = 'prime') LIMIT 1[0m
[4;35;1mEnabledModule Load (0.0ms)[0m [0mSELECT * FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 2) [0m
[4;36;1mMember Load Including Associations (16.0ms)[0m [0;1mSELECT `members`.`id` AS t0_r0, `members`.`user_id` AS t0_r1, `members`.`project_id` AS t0_r2, `members`.`created_on` AS t0_r3, `members`.`mail_notification` AS t0_r4, `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, `roles`.`id` AS t2_r0, `roles`.`name` AS t2_r1, `roles`.`position` AS t2_r2, `roles`.`assignable` AS t2_r3, `roles`.`builtin` AS t2_r4, `roles`.`permissions` AS t2_r5 FROM `members` LEFT OUTER JOIN `projects` ON `projects`.id = `members`.project_id LEFT OUTER JOIN `member_roles` ON (`members`.`id` = `member_roles`.`member_id`) LEFT OUTER JOIN `roles` ON (`roles`.`id` = `member_roles`.`role_id`) WHERE (`members`.user_id = 10 AND (projects.status=1)) ORDER BY projects.name[0m
[4;35;1mQuery Columns (31.0ms)[0m [0mSHOW FIELDS FROM `queries`[0m
[4;36;1mTracker Load Including Associations (62.0ms)[0m [0;1mSELECT `trackers`.`id` AS t0_r0, `trackers`.`name` AS t0_r1, `trackers`.`is_in_chlog` AS t0_r2, `trackers`.`position` AS t0_r3, `trackers`.`is_in_roadmap` AS t0_r4, `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 FROM `trackers` LEFT OUTER JOIN `projects_trackers` ON `projects_trackers`.tracker_id = `trackers`.id LEFT OUTER JOIN `projects` ON `projects`.id = `projects_trackers`.project_id WHERE (projects.lft >= 293 AND projects.rgt <= 294 AND projects.status = 1) ORDER BY trackers.position[0m
[4;35;1mIssueStatus Load (0.0ms)[0m [0mSELECT * FROM `issue_statuses` ORDER BY position[0m
[4;36;1mIssuePriority Load (0.0ms)[0m [0;1mSELECT * FROM `enumerations` WHERE ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC[0m
[4;35;1mUser Load (0.0ms)[0m [0mSELECT `users`.* FROM `users` INNER JOIN `members` ON `users`.id = `members`.user_id WHERE ((`members`.project_id = 2) AND ((users.type='User' AND users.status=1))) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) [0m
[4;36;1mIssueCategory Columns (47.0ms)[0m [0;1mSHOW FIELDS FROM `issue_categories`[0m
[4;35;1mSQL (15.0ms)[0m [0mSELECT count() AS count_all FROM `issue_categories` WHERE (`issue_categories`.project_id = 2) [0m
[4;36;1mProject Load (0.0ms)[0m [0;1mSELECT * FROM `projects` WHERE (projects.`lft` <= 293 AND projects.`rgt` >= 294) ORDER BY `lft` LIMIT 1[0m
[4;35;1mCACHE (0.0ms)[0m [0mSELECT * FROM `projects` WHERE (projects.`lft` <= 293 AND projects.`rgt` >= 294) ORDER BY `lft` LIMIT 1[0m
[4;36;1mVersion Columns (79.0ms)[0m [0;1mSHOW FIELDS FROM `versions`[0m
[4;35;1mSQL (0.0ms)[0m [0mSELECT count(DISTINCT `versions`.id) AS count_all FROM `versions` LEFT OUTER JOIN `projects` ON `projects`.id = `versions`.project_id WHERE (projects.id = 2 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 1 AND projects.rgt <= 308 AND versions.sharing = 'tree') OR (projects.lft < 293 AND projects.rgt > 294 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 293 AND projects.rgt < 294 AND versions.sharing = 'hierarchy')))) [0m
[4;36;1mVersion Load Including Associations (15.0ms)[0m [0;1mSELECT `versions`.`id` AS t0_r0, `versions`.`project_id` AS t0_r1, `versions`.`name` AS t0_r2, `versions`.`description` AS t0_r3, `versions`.`effective_date` AS t0_r4, `versions`.`created_on` AS t0_r5, `versions`.`updated_on` AS t0_r6, `versions`.`wiki_page_title` AS t0_r7, `versions`.`status` AS t0_r8, `versions`.`sharing` AS t0_r9, `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 FROM `versions` LEFT OUTER JOIN `projects` ON `projects`.id = `versions`.project_id WHERE (projects.id = 2 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 1 AND projects.rgt <= 308 AND versions.sharing = 'tree') OR (projects.lft < 293 AND projects.rgt > 294 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 293 AND projects.rgt < 294 AND versions.sharing = 'hierarchy')))) [0m
[4;35;1mSQL (0.0ms)[0m [0mSELECT count() AS count_all FROM `projects` WHERE (((projects.status = 1) AND (projects.id != 2)) AND (projects.`lft` >= 293 AND projects.`rgt` <= 294)) [0m
[4;36;1mIssueCustomField Load (0.0ms)[0m [0;1mSELECT * FROM `custom_fields` WHERE (is_for_all=1) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY position[0m
[4;35;1mIssueCustomField Load (16.0ms)[0m [0mSELECT * FROM `custom_fields` INNER JOIN `custom_fields_projects` ON `custom_fields`.id = `custom_fields_projects`.custom_field_id WHERE (`custom_fields_projects`.project_id = 2 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY custom_fields.position[0m
[4;36;1mSetting Load (0.0ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'per_page_options') LIMIT 1[0m
[4;35;1mCACHE (0.0ms)[0m [0mSELECT count() AS count_all FROM `projects` WHERE (((projects.status = 1) AND (projects.id != 2)) AND (projects.`lft` >= 293 AND projects.`rgt` <= 294)) [0m
[4;36;1mRole Load (0.0ms)[0m [0;1mSELECT * FROM `roles` WHERE (`roles`.`builtin` = 1) LIMIT 1[0m
[4;35;1mSQL (172.0ms)[0m [0mSELECT count(DISTINCT `issues`.id) AS count_all FROM `issues` LEFT OUTER JOIN `issue_statuses` ON `issue_statuses`.id = `issues`.status_id LEFT OUTER JOIN `projects` ON `projects`.id = `issues`.project_id WHERE ((issue_statuses.is_closed=0) AND projects.id = 2 AND ((projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) AND (1=0 OR projects.is_public = 1 OR projects.id IN (150,144,116,132,134,135,127,137,115,139,177,66,1,4,2,178,67,5,114,136)))) [0m
[4;36;1mCACHE (0.0ms)[0m [0;1mSELECT count() AS count_all FROM `projects` WHERE (((projects.status = 1) AND (projects.id != 2)) AND (projects.`lft` >= 293 AND projects.`rgt` <= 294)) [0m
[4;35;1mCACHE (0.0ms)[0m [0mSELECT * FROM `roles` WHERE (`roles`.`builtin` = 1) LIMIT 1[0m
[4;36;1mIssue Load Including Associations (16.0ms)[0m [0;1mSELECT `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, `issue_statuses`.`id` AS t1_r0, `issue_statuses`.`name` AS t1_r1, `issue_statuses`.`is_closed` AS t1_r2, `issue_statuses`.`is_default` AS t1_r3, `issue_statuses`.`position` AS t1_r4, `issue_statuses`.`default_done_ratio` AS t1_r5, `projects`.`id` AS t2_r0, `projects`.`name` AS t2_r1, `projects`.`description` AS t2_r2, `projects`.`homepage` AS t2_r3, `projects`.`is_public` AS t2_r4, `projects`.`parent_id` AS t2_r5, `projects`.`created_on` AS t2_r6, `projects`.`updated_on` AS t2_r7, `projects`.`identifier` AS t2_r8, `projects`.`status` AS t2_r9, `projects`.`lft` AS t2_r10, `projects`.`rgt` AS t2_r11, `users`.`id` AS t3_r0, `users`.`login` AS t3_r1, `users`.`hashed_password` AS t3_r2, `users`.`firstname` AS t3_r3, `users`.`lastname` AS t3_r4, `users`.`mail` AS t3_r5, `users`.`mail_notification` AS t3_r6, `users`.`admin` AS t3_r7, `users`.`status` AS t3_r8, `users`.`last_login_on` AS t3_r9, `users`.`language` AS t3_r10, `users`.`auth_source_id` AS t3_r11, `users`.`created_on` AS t3_r12, `users`.`updated_on` AS t3_r13, `users`.`type` AS t3_r14, `users`.`identity_url` AS t3_r15, `trackers`.`id` AS t4_r0, `trackers`.`name` AS t4_r1, `trackers`.`is_in_chlog` AS t4_r2, `trackers`.`position` AS t4_r3, `trackers`.`is_in_roadmap` AS t4_r4, `enumerations`.`id` AS t5_r0, `enumerations`.`name` AS t5_r1, `enumerations`.`position` AS t5_r2, `enumerations`.`is_default` AS t5_r3, `enumerations`.`type` AS t5_r4, `enumerations`.`active` AS t5_r5, `enumerations`.`project_id` AS t5_r6, `enumerations`.`parent_id` AS t5_r7, `issue_categories`.`id` AS t6_r0, `issue_categories`.`project_id` AS t6_r1, `issue_categories`.`name` AS t6_r2, `issue_categories`.`assigned_to_id` AS t6_r3, `versions`.`id` AS t7_r0, `versions`.`project_id` AS t7_r1, `versions`.`name` AS t7_r2, `versions`.`description` AS t7_r3, `versions`.`effective_date` AS t7_r4, `versions`.`created_on` AS t7_r5, `versions`.`updated_on` AS t7_r6, `versions`.`wiki_page_title` AS t7_r7, `versions`.`status` AS t7_r8, `versions`.`sharing` AS t7_r9 FROM `issues` LEFT OUTER JOIN `issue_statuses` ON `issue_statuses`.id = `issues`.status_id LEFT OUTER JOIN `projects` ON `projects`.id = `issues`.project_id LEFT OUTER JOIN `users` ON `users`.id = `issues`.assigned_to_id AND (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) LEFT OUTER JOIN `trackers` ON `trackers`.id = `issues`.tracker_id LEFT OUTER JOIN `enumerations` ON `enumerations`.id = `issues`.priority_id AND (`enumerations`.`type` = 'IssuePriority' ) LEFT OUTER JOIN `issue_categories` ON `issue_categories`.id = `issues`.category_id LEFT OUTER JOIN `versions` ON `versions`.id = `issues`.fixed_version_id WHERE (((issue_statuses.is_closed=0) AND projects.id = 2 AND ((projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) AND (1=0 OR projects.is_public = 1 OR projects.id IN (150,144,116,132,134,135,127,137,115,139,177,66,1,4,2,178,67,5,114,136))))) ORDER BY issues.id DESC LIMIT 0, 25[0m
Rendering template within layouts/base
Rendering issues/index.rhtml
Rendered queries/_filters (78.0ms)
[4;35;1mSetting Load (0.0ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'issue_list_default_columns') LIMIT 1[0m
Rendered queries/_columns (0.0ms)
[4;36;1mUserPreference Load (0.0ms)[0m [0;1mSELECT * FROM `user_preferences` WHERE (`user_preferences`.user_id = 10) LIMIT 1[0m
[4;35;1mSetting Load (0.0ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'time_format') LIMIT 1[0m
Rendered issues/_list (594.0ms)
[4;36;1mToken Load (0.0ms)[0m [0;1mSELECT * FROM `tokens` WHERE (`tokens`.user_id = 10 AND (action='feeds')) LIMIT 1[0m
[4;35;1mToken Columns (0.0ms)[0m [0mSHOW FIELDS FROM `tokens`[0m
[4;36;1mQuery Load (0.0ms)[0m [0;1mSELECT id, name FROM `queries` WHERE (1=1 AND (is_public = 1 OR user_id = 10) AND (project_id IS NULL OR project_id = 2)) ORDER BY name ASC[0m
Rendered issues/_sidebar (32.0ms)
[4;35;1mSetting Load (15.0ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'ui_theme') LIMIT 1[0m
[4;36;1mProject Load (0.0ms)[0m [0;1mSELECT `projects`.* FROM `projects` INNER JOIN `members` ON `projects`.id = `members`.project_id WHERE ((`members`.user_id = 10) AND ((projects.status=1))) [0m
[4;35;1mSQL (0.0ms)[0m [0mSELECT count() AS count_all FROM `projects` WHERE (((projects.status=1 AND (projects.is_public = 1 or projects.id IN (150,144,116,132,134,135,127,137,115,139,177,66,1,4,2,178,67,5,114,136))) AND (projects.id != 2)) AND (projects.`lft` <= 293 AND projects.`rgt` >= 294)) [0m
[4;36;1mProject Load (0.0ms)[0m [0;1mSELECT * FROM `projects` WHERE (((projects.status=1 AND (projects.is_public = 1 or projects.id IN (150,144,116,132,134,135,127,137,115,139,177,66,1,4,2,178,67,5,114,136))) AND (projects.id != 2)) AND (projects.`lft` <= 293 AND projects.`rgt` >= 294)) ORDER BY `lft`[0m
[4;35;1mWiki Load (47.0ms)[0m [0mSELECT * FROM `wikis` WHERE (`wikis`.project_id = 2) LIMIT 1[0m
[4;36;1mBoard Columns (94.0ms)[0m [0;1mSHOW FIELDS FROM `boards`[0m
[4;35;1mSQL (0.0ms)[0m [0mSELECT count() AS count_all FROM `boards` WHERE (`boards`.project_id = 2) [0m
[4;36;1mRepository Load (47.0ms)[0m [0;1mSELECT * FROM `repositories` WHERE (`repositories`.project_id = 2) LIMIT 1[0m
[4;35;1mRepository Columns (16.0ms)[0m [0mSHOW FIELDS FROM `repositories`[0m
Completed in 1672ms (View: 796, DB: 688) | 200 OK [http://wit390/redmine/projects/prime/issues?set_filter=1]

Processing IssuesController#show (for 10.8.96.47 at 2010-05-06 14:38:36) [GET]
Parameters: {"action"=>"show", "id"=>"813", "controller"=>"issues"}
[4;36;1mSQL (15.0ms)[0m [0;1mSELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` [0m
[4;35;1mUser Load (0.0ms)[0m [0mSELECT * FROM `users` WHERE (`users`.`id` = 10) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) [0m
[4;36;1mIssue Load (0.0ms)[0m [0;1mSELECT * FROM `issues` WHERE (`issues`.`id` = 813) [0m
[4;35;1mProject Load (0.0ms)[0m [0mSELECT * FROM `projects` WHERE (`projects`.`id` = 2) [0m
[4;36;1mTracker Load (0.0ms)[0m [0;1mSELECT * FROM `trackers` WHERE (`trackers`.`id` = 1) [0m
[4;35;1mIssueStatus Load (0.0ms)[0m [0mSELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` = 1) [0m
[4;36;1mUser Load (0.0ms)[0m [0;1mSELECT * FROM `users` WHERE (`users`.`id` = 69) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) [0m
[4;35;1mIssuePriority Load (0.0ms)[0m [0mSELECT * FROM `enumerations` WHERE (`enumerations`.`id` = 4) AND ( (`enumerations`.`type` = 'IssuePriority' ) ) [0m
[4;36;1mEnabledModule Load (0.0ms)[0m [0;1mSELECT * FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 2) [0m
[4;35;1mMember Load Including Associations (16.0ms)[0m [0mSELECT `members`.`id` AS t0_r0, `members`.`user_id` AS t0_r1, `members`.`project_id` AS t0_r2, `members`.`created_on` AS t0_r3, `members`.`mail_notification` AS t0_r4, `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, `roles`.`id` AS t2_r0, `roles`.`name` AS t2_r1, `roles`.`position` AS t2_r2, `roles`.`assignable` AS t2_r3, `roles`.`builtin` AS t2_r4, `roles`.`permissions` AS t2_r5 FROM `members` LEFT OUTER JOIN `projects` ON `projects`.id = `members`.project_id LEFT OUTER JOIN `member_roles` ON (`members`.`id` = `member_roles`.`member_id`) LEFT OUTER JOIN `roles` ON (`roles`.`id` = `member_roles`.`role_id`) WHERE (`members`.user_id = 10 AND (projects.status=1)) ORDER BY projects.name[0m
[4;36;1mJournal Load (0.0ms)[0m [0;1mSELECT * FROM `journals` WHERE (`journals`.journalized_id = 813 AND `journals`.journalized_type = 'Issue') ORDER BY journals.created_on ASC[0m
[4;35;1mUser Load (0.0ms)[0m [0mSELECT * FROM `users` WHERE (`users`.`id` = 10) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) [0m
[4;36;1mJournalDetail Load (0.0ms)[0m [0;1mSELECT `journal_details`.* FROM `journal_details` WHERE (`journal_details`.journal_id = 1659) [0m
[4;35;1mUserPreference Load (0.0ms)[0m [0mSELECT * FROM `user_preferences` WHERE (`user_preferences`.user_id = 10) LIMIT 1[0m
[4;36;1mRole Load (0.0ms)[0m [0;1mSELECT * FROM `roles` WHERE (`roles`.`builtin` = 1) LIMIT 1[0m
[4;35;1mChangeset Columns (172.0ms)[0m [0mSHOW FIELDS FROM `changesets`[0m
[4;36;1mChangeset Load Including Associations (47.0ms)[0m [0;1mSELECT `changesets`.`id` AS t0_r0, `changesets`.`repository_id` AS t0_r1, `changesets`.`revision` AS t0_r2, `changesets`.`committer` AS t0_r3, `changesets`.`committed_on` AS t0_r4, `changesets`.`comments` AS t0_r5, `changesets`.`commit_date` AS t0_r6, `changesets`.`scmid` AS t0_r7, `changesets`.`user_id` AS t0_r8, `repositories`.`id` AS t1_r0, `repositories`.`project_id` AS t1_r1, `repositories`.`url` AS t1_r2, `repositories`.`login` AS t1_r3, `repositories`.`password` AS t1_r4, `repositories`.`root_url` AS t1_r5, `repositories`.`type` AS t1_r6, `projects`.`id` AS t2_r0, `projects`.`name` AS t2_r1, `projects`.`description` AS t2_r2, `projects`.`homepage` AS t2_r3, `projects`.`is_public` AS t2_r4, `projects`.`parent_id` AS t2_r5, `projects`.`created_on` AS t2_r6, `projects`.`updated_on` AS t2_r7, `projects`.`identifier` AS t2_r8, `projects`.`status` AS t2_r9, `projects`.`lft` AS t2_r10, `projects`.`rgt` AS t2_r11 FROM `changesets` LEFT OUTER JOIN `repositories` ON `repositories`.id = `changesets`.repository_id LEFT OUTER JOIN `projects` ON `projects`.id = `repositories`.project_id INNER JOIN `changesets_issues` ON `changesets`.id = `changesets_issues`.changeset_id WHERE (((((projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='repository')) AND (1=0 OR projects.is_public = 1 OR projects.id IN (150,144,116,132,134,135,127,137,115,139,177,66,1,4,2,178,67,5,114,136)))) AND (`changesets_issues`.issue_id = 813 )) AND (`changesets_issues`.issue_id = 813 )) ORDER BY changesets.committed_on ASC, changesets.id ASC[0m
[4;35;1mWorkflow Load (0.0ms)[0m [0mSELECT * FROM `workflows` WHERE (`workflows`.old_status_id = 1 AND (`workflows`.`tracker_id` = 1 AND `workflows`.`role_id` IN (4))) [0m
[4;36;1mIssueStatus Load (0.0ms)[0m [0;1mSELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` IN (6,7,8,9,1,2,3,4,5)) [0m
[4;35;1mIssueRelation Load (0.0ms)[0m [0mSELECT * FROM `issue_relations` WHERE (`issue_relations`.issue_to_id = 813) [0m
[4;36;1mIssuePriority Load (0.0ms)[0m [0;1mSELECT * FROM `enumerations` WHERE ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC[0m
[4;35;1mTimeEntryActivity Load (0.0ms)[0m [0mSELECT * FROM `enumerations` WHERE (`enumerations`.`is_default` = 1) AND ( (`enumerations`.`type` = 'TimeEntryActivity' ) ) ORDER BY enumerations.position ASC LIMIT 1[0m
Rendering template within layouts/base
Rendering issues/show.rhtml
[4;36;1mWatcher Load (0.0ms)[0m [0;1mSELECT * FROM `watchers` WHERE (`watchers`.watchable_id = 813 AND `watchers`.watchable_type = 'Issue') [0m
Rendered issues/_action_menu (31.0ms)
[4;35;1mSetting Load (0.0ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'gravatar_enabled') LIMIT 1[0m
[4;36;1mSQL (0.0ms)[0m [0;1mSELECT sum(`time_entries`.hours) AS sum_hours FROM `time_entries` WHERE (`time_entries`.issue_id = 813) [0m
[4;35;1mIssueCustomField Load (0.0ms)[0m [0mSELECT * FROM `custom_fields` WHERE (is_for_all=1) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY position[0m
[4;36;1mIssueCustomField Load (0.0ms)[0m [0;1mSELECT * FROM `custom_fields` INNER JOIN `custom_fields_projects` ON `custom_fields`.id = `custom_fields_projects`.custom_field_id WHERE (`custom_fields_projects`.project_id = 2 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY custom_fields.position[0m
[4;35;1mIssueCustomField Load (0.0ms)[0m [0mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 13) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
[4;36;1mIssueCustomField Load (0.0ms)[0m [0;1mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 14) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
[4;35;1mIssueCustomField Load (0.0ms)[0m [0mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 15) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
[4;36;1mIssueCustomField Load (0.0ms)[0m [0;1mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 20) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
[4;35;1mIssueCustomField Load (0.0ms)[0m [0mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 21) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
[4;36;1mIssueCustomField Load (0.0ms)[0m [0;1mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 22) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
[4;35;1mIssueCustomField Load (0.0ms)[0m [0mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 23) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
[4;36;1mIssueCustomField Load (0.0ms)[0m [0;1mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 25) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
[4;35;1mIssueCustomField Load (0.0ms)[0m [0mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 26) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
[4;36;1mIssueCustomField Load (0.0ms)[0m [0;1mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 27) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
[4;35;1mIssueCustomField Load (0.0ms)[0m [0mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 28) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
[4;36;1mCustomValue Load Including Associations (15.0ms)[0m [0;1mSELECT `custom_values`.`id` AS t0_r0, `custom_values`.`customized_type` AS t0_r1, `custom_values`.`customized_id` AS t0_r2, `custom_values`.`custom_field_id` AS t0_r3, `custom_values`.`value` AS t0_r4, `custom_fields`.`id` AS t1_r0, `custom_fields`.`type` AS t1_r1, `custom_fields`.`name` AS t1_r2, `custom_fields`.`field_format` AS t1_r3, `custom_fields`.`possible_values` AS t1_r4, `custom_fields`.`regexp` AS t1_r5, `custom_fields`.`min_length` AS t1_r6, `custom_fields`.`max_length` AS t1_r7, `custom_fields`.`is_required` AS t1_r8, `custom_fields`.`is_for_all` AS t1_r9, `custom_fields`.`is_filter` AS t1_r10, `custom_fields`.`position` AS t1_r11, `custom_fields`.`searchable` AS t1_r12, `custom_fields`.`default_value` AS t1_r13, `custom_fields`.`editable` AS t1_r14 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.id = `custom_values`.custom_field_id WHERE (`custom_values`.customized_id = 813 AND `custom_values`.customized_type = 'Issue') ORDER BY custom_fields.position[0m
[4;35;1mAttachment Load (16.0ms)[0m [0mSELECT * FROM `attachments` WHERE (`attachments`.container_id = 813 AND `attachments`.container_type = 'Issue') ORDER BY attachments.created_on[0m
[4;36;1mIssueRelation Load (0.0ms)[0m [0;1mSELECT * FROM `issue_relations` WHERE (`issue_relations`.issue_from_id = 813) [0m
Rendered issue_relations/_form (0.0ms)
Rendered issues/_relations (0.0ms)
[4;35;1mUser Load (0.0ms)[0m [0mSELECT `users`.* FROM `users` INNER JOIN `watchers` ON `users`.id = `watchers`.user_id WHERE ((`watchers`.watchable_id = 813) AND (`watchers`.watchable_type = 'Issue')) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) [0m
Rendered watchers/_watchers (16.0ms)
Rendered issues/_history (0.0ms)
Rendered issues/_action_menu (0.0ms)
[4;36;1mprojects_trackers Columns (0.0ms)[0m [0;1mSHOW FIELDS FROM `projects_trackers`[0m
[4;35;1mTracker Load (47.0ms)[0m [0mSELECT * FROM `trackers` INNER JOIN `projects_trackers` ON `trackers`.id = `projects_trackers`.tracker_id WHERE (`projects_trackers`.project_id = 2 ) ORDER BY trackers.position[0m
[4;36;1mMember Load Including Associations (0.0ms)[0m [0;1mSELECT `members`.`id` AS t0_r0, `members`.`user_id` AS t0_r1, `members`.`project_id` AS t0_r2, `members`.`created_on` AS t0_r3, `members`.`mail_notification` AS t0_r4, `users`.`id` AS t1_r0, `users`.`login` AS t1_r1, `users`.`hashed_password` AS t1_r2, `users`.`firstname` AS t1_r3, `users`.`lastname` AS t1_r4, `users`.`mail` AS t1_r5, `users`.`mail_notification` AS t1_r6, `users`.`admin` AS t1_r7, `users`.`status` AS t1_r8, `users`.`last_login_on` AS t1_r9, `users`.`language` AS t1_r10, `users`.`auth_source_id` AS t1_r11, `users`.`created_on` AS t1_r12, `users`.`updated_on` AS t1_r13, `users`.`type` AS t1_r14, `users`.`identity_url` AS t1_r15, `roles`.`id` AS t2_r0, `roles`.`name` AS t2_r1, `roles`.`position` AS t2_r2, `roles`.`assignable` AS t2_r3, `roles`.`builtin` AS t2_r4, `roles`.`permissions` AS t2_r5 FROM `members` LEFT OUTER JOIN `users` ON `users`.id = `members`.user_id AND (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) LEFT OUTER JOIN `member_roles` ON (`members`.`id` = `member_roles`.`member_id`) LEFT OUTER JOIN `roles` ON (`roles`.`id` = `member_roles`.`role_id`) WHERE (`members`.project_id = 2 AND (users.type='User' AND users.status=1)) [0m
[4;35;1mSQL (0.0ms)[0m [0mSELECT count() AS count_all FROM `issue_categories` WHERE (`issue_categories`.project_id = 2) [0m
[4;36;1mProject Load (0.0ms)[0m [0;1mSELECT * FROM `projects` WHERE (projects.`lft` <= 293 AND projects.`rgt` >= 294) ORDER BY `lft` LIMIT 1[0m
[4;35;1mCACHE (0.0ms)[0m [0mSELECT * FROM `projects` WHERE (projects.`lft` <= 293 AND projects.`rgt` >= 294) ORDER BY `lft` LIMIT 1[0m
[4;36;1mVersion Load (0.0ms)[0m [0;1mSELECT * FROM `versions` WHERE (`versions`.`id` IS NULL) LIMIT 1[0m
[4;35;1mVersion Load Including Associations (0.0ms)[0m [0mSELECT `versions`.`id` AS t0_r0, `versions`.`project_id` AS t0_r1, `versions`.`name` AS t0_r2, `versions`.`description` AS t0_r3, `versions`.`effective_date` AS t0_r4, `versions`.`created_on` AS t0_r5, `versions`.`updated_on` AS t0_r6, `versions`.`wiki_page_title` AS t0_r7, `versions`.`status` AS t0_r8, `versions`.`sharing` AS t0_r9, `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 FROM `versions` LEFT OUTER JOIN `projects` ON `projects`.id = `versions`.project_id WHERE ((`versions`.`status` = 'open') AND (projects.id = 2 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 1 AND projects.rgt <= 308 AND versions.sharing = 'tree') OR (projects.lft < 293 AND projects.rgt > 294 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 293 AND projects.rgt < 294 AND versions.sharing = 'hierarchy'))))) [0m
[4;36;1mSetting Load (0.0ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'start_of_week') LIMIT 1[0m
Rendered issues/_form_custom_fields (0.0ms)
Rendered issues/_attributes (31.0ms)
Rendered issues/_form (94.0ms)
[4;35;1mTimeEntryActivity Load (0.0ms)[0m [0mSELECT * FROM `enumerations` WHERE (`enumerations`.project_id = 2) AND ( (`enumerations`.`type` = 'TimeEntryActivity' ) ) ORDER BY enumerations.position ASC[0m
[4;36;1mTimeEntryActivity Load (0.0ms)[0m [0;1mSELECT * FROM `enumerations` WHERE ((`enumerations`.`project_id` IS NULL AND `enumerations`.`active` = 1)) AND ( (`enumerations`.`type` = 'TimeEntryActivity' ) ) ORDER BY enumerations.position ASC[0m
[4;35;1mCustomField Load (0.0ms)[0m [0mSELECT * FROM `custom_fields` WHERE (type = 'TimeEntryCustomField') ORDER BY position[0m
[4;36;1mSetting Load (0.0ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'attachment_max_size') LIMIT 1[0m
Rendered attachments/_form (0.0ms)
Rendered issues/_edit (171.0ms)
[4;35;1mToken Load (0.0ms)[0m [0mSELECT * FROM `tokens` WHERE (`tokens`.user_id = 10 AND (action='feeds')) LIMIT 1[0m
[4;36;1mQuery Load (0.0ms)[0m [0;1mSELECT id, name FROM `queries` WHERE (1=1 AND (is_public = 1 OR user_id = 10) AND (project_id IS NULL OR project_id = 2)) ORDER BY name ASC[0m
Rendered issues/_sidebar (0.0ms)
[4;35;1mProject Load (0.0ms)[0m [0mSELECT `projects`. FROM `projects` INNER JOIN `members` ON `projects`.id = `members`.project_id WHERE ((`members`.user_id = 10) AND ((projects.status=1))) [0m
[4;36;1mSQL (0.0ms)[0m [0;1mSELECT count() AS count_all FROM `projects` WHERE (((projects.status=1 AND (projects.is_public = 1 or projects.id IN (150,144,116,132,134,135,127,137,115,139,177,66,1,4,2,178,67,5,114,136))) AND (projects.id != 2)) AND (projects.`lft` <= 293 AND projects.`rgt` >= 294)) [0m
[4;35;1mProject Load (0.0ms)[0m [0mSELECT * FROM `projects` WHERE (((projects.status=1 AND (projects.is_public = 1 or projects.id IN (150,144,116,132,134,135,127,137,115,139,177,66,1,4,2,178,67,5,114,136))) AND (projects.id != 2)) AND (projects.`lft` <= 293 AND projects.`rgt` >= 294)) ORDER BY `lft`[0m
[4;36;1mSQL (0.0ms)[0m [0;1mSELECT count(DISTINCT `versions`.id) AS count_all FROM `versions` LEFT OUTER JOIN `projects` ON `projects`.id = `versions`.project_id WHERE (projects.id = 2 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 1 AND projects.rgt <= 308 AND versions.sharing = 'tree') OR (projects.lft < 293 AND projects.rgt > 294 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 293 AND projects.rgt < 294 AND versions.sharing = 'hierarchy')))) [0m
[4;35;1mWiki Load (0.0ms)[0m [0mSELECT * FROM `wikis` WHERE (`wikis`.project_id = 2) LIMIT 1[0m
[4;36;1mSQL (0.0ms)[0m [0;1mSELECT count() AS count_all FROM `boards` WHERE (`boards`.project_id = 2) [0m
[4;35;1mRepository Load (0.0ms)[0m [0mSELECT * FROM `repositories` WHERE (`repositories`.project_id = 2) LIMIT 1[0m
Completed in 3937ms (View: 3422, DB: 328) | 200 OK [http://wit390/redmine/issues/813]
[4;35;1mSQL (0.0ms)[0m [0mSET SQL_AUTO_IS_NULL=0[0m

Processing WelcomeController#index (for 10.29.96.8 at 2010-05-06 14:39:23) [GET]
Parameters: {"action"=>"index", "controller"=>"welcome"}
[4;36;1mSetting Columns (31.0ms)[0m [0;1mSHOW FIELDS FROM `settings`[0m
[4;35;1mSQL (0.0ms)[0m [0mSELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` [0m
[4;36;1mUser Columns (0.0ms)[0m [0;1mSHOW FIELDS FROM `users`[0m
[4;35;1mUser Load (0.0ms)[0m [0mSELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) [0m
[4;36;1mNews Columns (46.0ms)[0m [0;1mSHOW FIELDS FROM `news`[0m
[4;35;1mProject Columns (16.0ms)[0m [0mSHOW FIELDS FROM `projects`[0m
[4;36;1mNews Load Including Associations (15.0ms)[0m [0;1mSELECT `news`.`id` AS t0_r0, `news`.`project_id` AS t0_r1, `news`.`title` AS t0_r2, `news`.`summary` AS t0_r3, `news`.`description` AS t0_r4, `news`.`author_id` AS t0_r5, `news`.`created_on` AS t0_r6, `news`.`comments_count` AS t0_r7, `users`.`id` AS t1_r0, `users`.`login` AS t1_r1, `users`.`hashed_password` AS t1_r2, `users`.`firstname` AS t1_r3, `users`.`lastname` AS t1_r4, `users`.`mail` AS t1_r5, `users`.`mail_notification` AS t1_r6, `users`.`admin` AS t1_r7, `users`.`status` AS t1_r8, `users`.`last_login_on` AS t1_r9, `users`.`language` AS t1_r10, `users`.`auth_source_id` AS t1_r11, `users`.`created_on` AS t1_r12, `users`.`updated_on` AS t1_r13, `users`.`type` AS t1_r14, `users`.`identity_url` AS t1_r15, `projects`.`id` AS t2_r0, `projects`.`name` AS t2_r1, `projects`.`description` AS t2_r2, `projects`.`homepage` AS t2_r3, `projects`.`is_public` AS t2_r4, `projects`.`parent_id` AS t2_r5, `projects`.`created_on` AS t2_r6, `projects`.`updated_on` AS t2_r7, `projects`.`identifier` AS t2_r8, `projects`.`status` AS t2_r9, `projects`.`lft` AS t2_r10, `projects`.`rgt` AS t2_r11 FROM `news` LEFT OUTER JOIN `users` ON `users`.id = `news`.author_id AND (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) LEFT OUTER JOIN `projects` ON `projects`.id = `news`.project_id WHERE (projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='news')) ORDER BY news.created_on DESC LIMIT 5[0m
[4;35;1mProject Load (0.0ms)[0m [0mSELECT * FROM `projects` WHERE (projects.status=1) ORDER BY created_on DESC LIMIT 5[0m
Rendering template within layouts/base
Rendering welcome/index
[4;36;1mSetting Load (0.0ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'welcome_text') LIMIT 1[0m
[4;35;1mSetting Load (0.0ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'user_format') LIMIT 1[0m
[4;36;1mUserPreference Load (16.0ms)[0m [0;1mSELECT * FROM `user_preferences` WHERE (`user_preferences`.user_id = 3) LI

Actions
Copy link
 #4

Updated by Jon Lumpkin over 14 years ago

That didn't format right, here it is again with PRE


# Logfile created on Thu May 06 14:35:12 -0400 2010  [4;35;1mSQL (0.0ms)[0m   [0mSET SQL_AUTO_IS_NULL=0[0m

Processing WelcomeController#index (for 10.29.96.8 at 2010-05-06 14:35:25) [GET]
  Parameters: {"action"=>"index", "controller"=>"welcome"}
  [4;36;1mSetting Columns (46.0ms)[0m   [0;1mSHOW FIELDS FROM `settings`[0m
  [4;35;1mSQL (0.0ms)[0m   [0mSELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` [0m
  [4;36;1mUser Columns (31.0ms)[0m   [0;1mSHOW FIELDS FROM `users`[0m
  [4;35;1mUser Load (0.0ms)[0m   [0mSELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) [0m
  [4;36;1mNews Columns (47.0ms)[0m   [0;1mSHOW FIELDS FROM `news`[0m
  [4;35;1mProject Columns (46.0ms)[0m   [0mSHOW FIELDS FROM `projects`[0m
  [4;36;1mNews Load Including Associations (141.0ms)[0m   [0;1mSELECT `news`.`id` AS t0_r0, `news`.`project_id` AS t0_r1, `news`.`title` AS t0_r2, `news`.`summary` AS t0_r3, `news`.`description` AS t0_r4, `news`.`author_id` AS t0_r5, `news`.`created_on` AS t0_r6, `news`.`comments_count` AS t0_r7, `users`.`id` AS t1_r0, `users`.`login` AS t1_r1, `users`.`hashed_password` AS t1_r2, `users`.`firstname` AS t1_r3, `users`.`lastname` AS t1_r4, `users`.`mail` AS t1_r5, `users`.`mail_notification` AS t1_r6, `users`.`admin` AS t1_r7, `users`.`status` AS t1_r8, `users`.`last_login_on` AS t1_r9, `users`.`language` AS t1_r10, `users`.`auth_source_id` AS t1_r11, `users`.`created_on` AS t1_r12, `users`.`updated_on` AS t1_r13, `users`.`type` AS t1_r14, `users`.`identity_url` AS t1_r15, `projects`.`id` AS t2_r0, `projects`.`name` AS t2_r1, `projects`.`description` AS t2_r2, `projects`.`homepage` AS t2_r3, `projects`.`is_public` AS t2_r4, `projects`.`parent_id` AS t2_r5, `projects`.`created_on` AS t2_r6, `projects`.`updated_on` AS t2_r7, `projects`.`identifier` AS t2_r8, `projects`.`status` AS t2_r9, `projects`.`lft` AS t2_r10, `projects`.`rgt` AS t2_r11 FROM `news` LEFT OUTER JOIN `users` ON `users`.id = `news`.author_id AND (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) LEFT OUTER JOIN `projects` ON `projects`.id = `news`.project_id WHERE (projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='news')) ORDER BY news.created_on DESC LIMIT 5[0m
  [4;35;1mProject Load (16.0ms)[0m   [0mSELECT * FROM `projects` WHERE (projects.status=1) ORDER BY created_on DESC LIMIT 5[0m
Rendering template within layouts/base
Rendering welcome/index
  [4;36;1mSetting Load (0.0ms)[0m   [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'welcome_text') LIMIT 1[0m
  [4;35;1mSetting Load (0.0ms)[0m   [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'user_format') LIMIT 1[0m
  [4;36;1mUserPreference Load (0.0ms)[0m   [0;1mSELECT * FROM `user_preferences` WHERE (`user_preferences`.user_id = 3) LIMIT 1[0m
  [4;35;1mUserPreference Columns (16.0ms)[0m   [0mSHOW FIELDS FROM `user_preferences`[0m
  [4;36;1mSetting Load (0.0ms)[0m   [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'time_format') LIMIT 1[0m
Rendered news/_news (906.0ms)
Rendered news/_news (0.0ms)
Rendered news/_news (16.0ms)
Rendered news/_news (0.0ms)
Rendered news/_news (0.0ms)
  [4;35;1mSetting Load (0.0ms)[0m   [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'text_formatting') LIMIT 1[0m
  [4;36;1mToken Load (47.0ms)[0m   [0;1mSELECT * FROM `tokens` WHERE (`tokens`.user_id = 3 AND (action='feeds')) LIMIT 1[0m
  [4;35;1mToken Columns (16.0ms)[0m   [0mSHOW FIELDS FROM `tokens`[0m
  [4;36;1mSetting Load (0.0ms)[0m   [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'app_title') LIMIT 1[0m
  [4;35;1mSetting Load (15.0ms)[0m   [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'ui_theme') LIMIT 1[0m
  [4;36;1mProject Load (125.0ms)[0m   [0;1mSELECT `projects`.* FROM `projects` INNER JOIN `members` ON `projects`.id = `members`.project_id WHERE ((`members`.user_id = 3) AND ((projects.status=1))) [0m
Completed in 1750ms (View: 1078, DB: 546) | 200 OK [http://wit390/redmine/]
  [4;35;1mSQL (0.0ms)[0m   [0mSET SQL_AUTO_IS_NULL=0[0m

Processing IssuesController#edit (for 10.8.96.47 at 2010-05-06 14:37:02) [POST]
  Parameters: {"time_entry"=>{"comments"=>"", "activity_id"=>"", "hours"=>""}, "commit"=>"Submit", "notes"=>"", "action"=>"edit", "authenticity_token"=>"yee7SiOU8KdoOG+moDsoV4biHKFAt1SLqxCFkz2cCN8=", "id"=>"813", "issue"=>{"start_date"=>"", "custom_field_values"=>{"25"=>"", "26"=>"", "27"=>"", "28"=>"1.0.0.18"}, "estimated_hours"=>"", "priority_id"=>"4", "lock_version"=>"0", "fixed_version_id"=>"", "done_ratio"=>"0", "assigned_to_id"=>"", "subject"=>"ICR 100408078 did not show up in review queue", "tracker_id"=>"1", "due_date"=>"", "status_id"=>"1", "description"=>"REMOVED OUR STACK TRACE"}, "controller"=>"issues", "attachments"=>{"1"=>{"description"=>""}}}
  [4;36;1mSetting Columns (16.0ms)[0m   [0;1mSHOW FIELDS FROM `settings`[0m
  [4;35;1mSQL (0.0ms)[0m   [0mSELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` [0m
  [4;36;1mUser Columns (0.0ms)[0m   [0;1mSHOW FIELDS FROM `users`[0m
  [4;35;1mUser Load (0.0ms)[0m   [0mSELECT * FROM `users` WHERE (`users`.`id` = 10) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) [0m
  [4;36;1mIssue Columns (219.0ms)[0m   [0;1mSHOW FIELDS FROM `issues`[0m
  [4;35;1mIssue Load (47.0ms)[0m   [0mSELECT * FROM `issues` WHERE (`issues`.`id` = 813) [0m
  [4;36;1mProject Columns (47.0ms)[0m   [0;1mSHOW FIELDS FROM `projects`[0m
  [4;35;1mProject Load (0.0ms)[0m   [0mSELECT * FROM `projects` WHERE (`projects`.`id` = 2) [0m
  [4;36;1mTracker Columns (47.0ms)[0m   [0;1mSHOW FIELDS FROM `trackers`[0m
  [4;35;1mTracker Load (15.0ms)[0m   [0mSELECT * FROM `trackers` WHERE (`trackers`.`id` = 1) [0m
  [4;36;1mIssueStatus Columns (94.0ms)[0m   [0;1mSHOW FIELDS FROM `issue_statuses`[0m
  [4;35;1mIssueStatus Load (0.0ms)[0m   [0mSELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` = 1) [0m
  [4;36;1mUser Load (0.0ms)[0m   [0;1mSELECT * FROM `users` WHERE (`users`.`id` = 69) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) [0m
  [4;35;1mIssuePriority Columns (47.0ms)[0m   [0mSHOW FIELDS FROM `enumerations`[0m
  [4;36;1mIssuePriority Load (0.0ms)[0m   [0;1mSELECT * FROM `enumerations` WHERE (`enumerations`.`id` = 4) AND ( (`enumerations`.`type` = 'IssuePriority' ) ) [0m
  [4;35;1mEnabledModule Load (0.0ms)[0m   [0mSELECT * FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 2) [0m
  [4;36;1mEnabledModule Columns (0.0ms)[0m   [0;1mSHOW FIELDS FROM `enabled_modules`[0m
  [4;35;1mMember Columns (0.0ms)[0m   [0mSHOW FIELDS FROM `members`[0m
  [4;36;1mRole Columns (31.0ms)[0m   [0;1mSHOW FIELDS FROM `roles`[0m
  [4;35;1mMember Load Including Associations (203.0ms)[0m   [0mSELECT `members`.`id` AS t0_r0, `members`.`user_id` AS t0_r1, `members`.`project_id` AS t0_r2, `members`.`created_on` AS t0_r3, `members`.`mail_notification` AS t0_r4, `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, `roles`.`id` AS t2_r0, `roles`.`name` AS t2_r1, `roles`.`position` AS t2_r2, `roles`.`assignable` AS t2_r3, `roles`.`builtin` AS t2_r4, `roles`.`permissions` AS t2_r5 FROM `members` LEFT OUTER JOIN `projects` ON `projects`.id = `members`.project_id LEFT OUTER JOIN `member_roles` ON (`members`.`id` = `member_roles`.`member_id`) LEFT OUTER JOIN `roles` ON (`roles`.`id` = `member_roles`.`role_id`) WHERE (`members`.user_id = 10 AND (projects.status=1)) ORDER BY projects.name[0m
  [4;36;1mWorkflow Load (187.0ms)[0m   [0;1mSELECT * FROM `workflows` WHERE (`workflows`.old_status_id = 1 AND (`workflows`.`tracker_id` = 1 AND `workflows`.`role_id` IN (4))) [0m
  [4;35;1mWorkflow Columns (16.0ms)[0m   [0mSHOW FIELDS FROM `workflows`[0m
  [4;36;1mIssueStatus Load (0.0ms)[0m   [0;1mSELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` IN (6,7,8,9,1,2,3,4,5)) [0m
  [4;35;1mIssueRelation Load (47.0ms)[0m   [0mSELECT * FROM `issue_relations` WHERE (`issue_relations`.issue_to_id = 813) [0m
  [4;36;1mIssuePriority Load (0.0ms)[0m   [0;1mSELECT * FROM `enumerations` WHERE ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC[0m
  [4;35;1mTimeEntry Columns (62.0ms)[0m   [0mSHOW FIELDS FROM `time_entries`[0m
  [4;36;1mTimeEntryActivity Columns (15.0ms)[0m   [0;1mSHOW FIELDS FROM `enumerations`[0m
  [4;35;1mTimeEntryActivity Load (0.0ms)[0m   [0mSELECT * FROM `enumerations` WHERE (`enumerations`.`is_default` = 1) AND ( (`enumerations`.`type` = 'TimeEntryActivity' ) ) ORDER BY enumerations.position ASC LIMIT 1[0m
  [4;36;1mJournal Columns (313.0ms)[0m   [0;1mSHOW FIELDS FROM `journals`[0m
  [4;35;1mIssueStatus Load (0.0ms)[0m   [0mSELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` = 0) [0m
  [4;36;1mIssueStatus Load (0.0ms)[0m   [0;1mSELECT * FROM `issue_statuses` WHERE (is_default=1) LIMIT 1[0m
  [4;35;1mIssuePriority Load (0.0ms)[0m   [0mSELECT * FROM `enumerations` WHERE (`enumerations`.`id` = 0) AND ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC[0m
  [4;36;1mIssuePriority Load (0.0ms)[0m   [0;1mSELECT * FROM `enumerations` WHERE (`enumerations`.`is_default` = 1) AND ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC LIMIT 1[0m
  [4;35;1mCustomValue Columns (375.0ms)[0m   [0mSHOW FIELDS FROM `custom_values`[0m
  [4;36;1mCustomField Columns (109.0ms)[0m   [0;1mSHOW FIELDS FROM `custom_fields`[0m
  [4;35;1mCustomValue Load Including Associations (16.0ms)[0m   [0mSELECT `custom_values`.`id` AS t0_r0, `custom_values`.`customized_type` AS t0_r1, `custom_values`.`customized_id` AS t0_r2, `custom_values`.`custom_field_id` AS t0_r3, `custom_values`.`value` AS t0_r4, `custom_fields`.`id` AS t1_r0, `custom_fields`.`type` AS t1_r1, `custom_fields`.`name` AS t1_r2, `custom_fields`.`field_format` AS t1_r3, `custom_fields`.`possible_values` AS t1_r4, `custom_fields`.`regexp` AS t1_r5, `custom_fields`.`min_length` AS t1_r6, `custom_fields`.`max_length` AS t1_r7, `custom_fields`.`is_required` AS t1_r8, `custom_fields`.`is_for_all` AS t1_r9, `custom_fields`.`is_filter` AS t1_r10, `custom_fields`.`position` AS t1_r11, `custom_fields`.`searchable` AS t1_r12, `custom_fields`.`default_value` AS t1_r13, `custom_fields`.`editable` AS t1_r14 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.id = `custom_values`.custom_field_id WHERE (`custom_values`.customized_id = 813 AND `custom_values`.customized_type = 'Issue') ORDER BY custom_fields.position[0m
  [4;36;1mCACHE (0.0ms)[0m   [0;1mSELECT * FROM `trackers` WHERE (`trackers`.`id` = 1) [0m
  [4;35;1mIssueCustomField Columns (15.0ms)[0m   [0mSHOW FIELDS FROM `custom_fields`[0m
  [4;36;1mIssueCustomField Load (0.0ms)[0m   [0;1mSELECT * FROM `custom_fields` WHERE (is_for_all=1) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY position[0m
  [4;35;1mcustom_fields_projects Columns (47.0ms)[0m   [0mSHOW FIELDS FROM `custom_fields_projects`[0m
  [4;36;1mIssueCustomField Load (16.0ms)[0m   [0;1mSELECT * FROM `custom_fields` INNER JOIN `custom_fields_projects` ON `custom_fields`.id = `custom_fields_projects`.custom_field_id WHERE (`custom_fields_projects`.project_id = 2 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY custom_fields.position[0m
  [4;35;1mIssueCustomField Load (0.0ms)[0m   [0mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 13) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
  [4;36;1mIssueCustomField Load (0.0ms)[0m   [0;1mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 14) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
  [4;35;1mIssueCustomField Load (0.0ms)[0m   [0mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 15) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
  [4;36;1mIssueCustomField Load (0.0ms)[0m   [0;1mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 20) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
  [4;35;1mIssueCustomField Load (0.0ms)[0m   [0mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 21) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
  [4;36;1mIssueCustomField Load (0.0ms)[0m   [0;1mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 22) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
  [4;35;1mIssueCustomField Load (0.0ms)[0m   [0mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 23) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
  [4;36;1mIssueCustomField Load (0.0ms)[0m   [0;1mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 25) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
  [4;35;1mIssueCustomField Load (0.0ms)[0m   [0mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 26) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
  [4;36;1mIssueCustomField Load (0.0ms)[0m   [0;1mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 27) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
  [4;35;1mIssueCustomField Load (0.0ms)[0m   [0mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 28) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
  [4;36;1mCACHE (0.0ms)[0m   [0;1mSELECT * FROM `enumerations` WHERE (`enumerations`.`is_default` = 1) AND ( (`enumerations`.`type` = 'TimeEntryActivity' ) ) ORDER BY enumerations.position ASC LIMIT 1[0m
  [4;35;1mIssuePriority Load (0.0ms)[0m   [0mSELECT * FROM `enumerations` WHERE (`enumerations`.`id` = 4) AND ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC[0m
  [4;36;1mCACHE (0.0ms)[0m   [0;1mSELECT * FROM `trackers` WHERE (`trackers`.`id` = 1) [0m
  [4;35;1mSetting Load (0.0ms)[0m   [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'issue_done_ratio') LIMIT 1[0m
  [4;36;1mSQL (0.0ms)[0m   [0;1mBEGIN[0m
  [4;35;1mIssue Update with optimistic locking (0.0ms)[0m   [0m UPDATE `issues`
 SET `subject` = 'ICR 100408078 did not show up in review queue', `description` = 'REMOVED OUR STACK TRACE', `lock_version` = 1, `updated_on` = '2010-05-06 14:37:05'
 WHERE id = 813
 AND `lock_version` = 0
[0m
  [4;36;1mIssueCustomField Load (0.0ms)[0m   [0;1mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 13) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
  [4;35;1mIssueCustomField Load (0.0ms)[0m   [0mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 14) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
  [4;36;1mIssueCustomField Load (0.0ms)[0m   [0;1mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 15) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
  [4;35;1mIssueCustomField Load (0.0ms)[0m   [0mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 20) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
  [4;36;1mIssueCustomField Load (0.0ms)[0m   [0;1mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 21) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
  [4;35;1mIssueCustomField Load (0.0ms)[0m   [0mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 22) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
  [4;36;1mIssueCustomField Load (0.0ms)[0m   [0;1mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 23) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
  [4;35;1mIssueCustomField Load (0.0ms)[0m   [0mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 25) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
  [4;36;1mIssueCustomField Load (0.0ms)[0m   [0;1mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 26) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
  [4;35;1mIssueCustomField Load (0.0ms)[0m   [0mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 27) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
  [4;36;1mIssueCustomField Load (0.0ms)[0m   [0;1mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 28) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
  [4;35;1mJournalDetail Columns (391.0ms)[0m   [0mSHOW FIELDS FROM `journal_details`[0m
  [4;36;1mJournal Create (31.0ms)[0m   [0;1mINSERT INTO `journals` (`created_on`, `notes`, `user_id`, `journalized_type`, `journalized_id`) VALUES('2010-05-06 14:37:05', '', 10, 'Issue', 813)[0m
  [4;35;1mJournalDetail Create (0.0ms)[0m   [0mINSERT INTO `journal_details` (`property`, `prop_key`, `old_value`, `value`, `journal_id`) VALUES('attr', 'subject', 'Prime bug submission (Build: 1.0.0.18)', 'ICR 100408078 did not show up in review queue', 1659)[0m
  [4;36;1mSetting Load (0.0ms)[0m   [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'notified_events') LIMIT 1[0m
  [4;35;1mSetting Load (0.0ms)[0m   [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'default_language') LIMIT 1[0m
  [4;36;1mSetting Load (0.0ms)[0m   [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'mail_from') LIMIT 1[0m
  [4;35;1mSetting Load (0.0ms)[0m   [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'host_name') LIMIT 1[0m
  [4;36;1mSetting Load (0.0ms)[0m   [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'app_title') LIMIT 1[0m
  [4;35;1mIssue Load (0.0ms)[0m   [0mSELECT * FROM `issues` WHERE (`issues`.`id` = 813) [0m
  [4;36;1mProject Load (0.0ms)[0m   [0;1mSELECT * FROM `projects` WHERE (`projects`.`id` = 2) [0m
  [4;35;1mUser Load (0.0ms)[0m   [0mSELECT * FROM `users` WHERE (`users`.`id` = 69) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) [0m
  [4;36;1mMember Load Including Associations (0.0ms)[0m   [0;1mSELECT `members`.`id` AS t0_r0, `members`.`user_id` AS t0_r1, `members`.`project_id` AS t0_r2, `members`.`created_on` AS t0_r3, `members`.`mail_notification` AS t0_r4, `users`.`id` AS t1_r0, `users`.`login` AS t1_r1, `users`.`hashed_password` AS t1_r2, `users`.`firstname` AS t1_r3, `users`.`lastname` AS t1_r4, `users`.`mail` AS t1_r5, `users`.`mail_notification` AS t1_r6, `users`.`admin` AS t1_r7, `users`.`status` AS t1_r8, `users`.`last_login_on` AS t1_r9, `users`.`language` AS t1_r10, `users`.`auth_source_id` AS t1_r11, `users`.`created_on` AS t1_r12, `users`.`updated_on` AS t1_r13, `users`.`type` AS t1_r14, `users`.`identity_url` AS t1_r15, `roles`.`id` AS t2_r0, `roles`.`name` AS t2_r1, `roles`.`position` AS t2_r2, `roles`.`assignable` AS t2_r3, `roles`.`builtin` AS t2_r4, `roles`.`permissions` AS t2_r5 FROM `members` LEFT OUTER JOIN `users` ON `users`.id = `members`.user_id AND (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) LEFT OUTER JOIN `member_roles` ON (`members`.`id` = `member_roles`.`member_id`) LEFT OUTER JOIN `roles` ON (`roles`.`id` = `member_roles`.`role_id`) WHERE (`members`.project_id = 2 AND (users.type='User' AND users.status=1)) [0m
  [4;35;1mEnabledModule Load (0.0ms)[0m   [0mSELECT * FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 2) [0m
  [4;36;1mMember Load Including Associations (31.0ms)[0m   [0;1mSELECT `members`.`id` AS t0_r0, `members`.`user_id` AS t0_r1, `members`.`project_id` AS t0_r2, `members`.`created_on` AS t0_r3, `members`.`mail_notification` AS t0_r4, `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, `roles`.`id` AS t2_r0, `roles`.`name` AS t2_r1, `roles`.`position` AS t2_r2, `roles`.`assignable` AS t2_r3, `roles`.`builtin` AS t2_r4, `roles`.`permissions` AS t2_r5 FROM `members` LEFT OUTER JOIN `projects` ON `projects`.id = `members`.project_id LEFT OUTER JOIN `member_roles` ON (`members`.`id` = `member_roles`.`member_id`) LEFT OUTER JOIN `roles` ON (`roles`.`id` = `member_roles`.`role_id`) WHERE (`members`.user_id = 69 AND (projects.status=1)) ORDER BY projects.name[0m
  [4;35;1mWatcher Load (109.0ms)[0m   [0mSELECT * FROM `watchers` WHERE (`watchers`.watchable_id = 813 AND `watchers`.watchable_type = 'Issue') [0m
  [4;36;1mWatcher Columns (16.0ms)[0m   [0;1mSHOW FIELDS FROM `watchers`[0m
  [4;35;1mCACHE (0.0ms)[0m   [0mSELECT * FROM `users` WHERE (`users`.`id` = 69) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) [0m
  [4;36;1mCACHE (0.0ms)[0m   [0;1mSELECT `members`.`id` AS t0_r0, `members`.`user_id` AS t0_r1, `members`.`project_id` AS t0_r2, `members`.`created_on` AS t0_r3, `members`.`mail_notification` AS t0_r4, `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, `roles`.`id` AS t2_r0, `roles`.`name` AS t2_r1, `roles`.`position` AS t2_r2, `roles`.`assignable` AS t2_r3, `roles`.`builtin` AS t2_r4, `roles`.`permissions` AS t2_r5 FROM `members` LEFT OUTER JOIN `projects` ON `projects`.id = `members`.project_id LEFT OUTER JOIN `member_roles` ON (`members`.`id` = `member_roles`.`member_id`) LEFT OUTER JOIN `roles` ON (`roles`.`id` = `member_roles`.`role_id`) WHERE (`members`.user_id = 69 AND (projects.status=1)) ORDER BY projects.name[0m
  [4;35;1mTracker Load (0.0ms)[0m   [0mSELECT * FROM `trackers` WHERE (`trackers`.`id` = 1) [0m
  [4;36;1mSetting Load (0.0ms)[0m   [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'protocol') LIMIT 1[0m
  [4;35;1mSetting Load (0.0ms)[0m   [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'plain_text_mail') LIMIT 1[0m
  [4;36;1mSetting Load (0.0ms)[0m   [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'user_format') LIMIT 1[0m
  [4;35;1mIssueStatus Load (0.0ms)[0m   [0mSELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` = 1) [0m
  [4;36;1mIssuePriority Load (0.0ms)[0m   [0;1mSELECT * FROM `enumerations` WHERE (`enumerations`.`id` = 4) AND ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC[0m
  [4;35;1mCustomValue Load Including Associations (16.0ms)[0m   [0mSELECT `custom_values`.`id` AS t0_r0, `custom_values`.`customized_type` AS t0_r1, `custom_values`.`customized_id` AS t0_r2, `custom_values`.`custom_field_id` AS t0_r3, `custom_values`.`value` AS t0_r4, `custom_fields`.`id` AS t1_r0, `custom_fields`.`type` AS t1_r1, `custom_fields`.`name` AS t1_r2, `custom_fields`.`field_format` AS t1_r3, `custom_fields`.`possible_values` AS t1_r4, `custom_fields`.`regexp` AS t1_r5, `custom_fields`.`min_length` AS t1_r6, `custom_fields`.`max_length` AS t1_r7, `custom_fields`.`is_required` AS t1_r8, `custom_fields`.`is_for_all` AS t1_r9, `custom_fields`.`is_filter` AS t1_r10, `custom_fields`.`position` AS t1_r11, `custom_fields`.`searchable` AS t1_r12, `custom_fields`.`default_value` AS t1_r13, `custom_fields`.`editable` AS t1_r14 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.id = `custom_values`.custom_field_id WHERE (`custom_values`.customized_id = 813 AND `custom_values`.customized_type = 'Issue') ORDER BY custom_fields.position[0m
Rendered mailer/_issue_text_plain (32.0ms)
  [4;36;1mSetting Load (0.0ms)[0m   [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'emails_footer') LIMIT 1[0m
  [4;35;1mAttachment Load (297.0ms)[0m   [0mSELECT * FROM `attachments` WHERE (`attachments`.container_id = 813 AND `attachments`.container_type = 'Issue') ORDER BY attachments.created_on[0m
  [4;36;1mSetting Load (15.0ms)[0m   [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'text_formatting') LIMIT 1[0m
Rendered mailer/_issue_text_html (3109.0ms)
  [4;35;1mUserPreference Load (0.0ms)[0m   [0mSELECT * FROM `user_preferences` WHERE (`user_preferences`.user_id = 10) LIMIT 1[0m
  [4;36;1mUserPreference Columns (0.0ms)[0m   [0;1mSHOW FIELDS FROM `user_preferences`[0m
  [4;35;1mSetting Load (0.0ms)[0m   [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'bcc_recipients') LIMIT 1[0m
  [4;36;1mCACHE (0.0ms)[0m   [0;1mSELECT * FROM `issues` WHERE (`issues`.`id` = 813) [0m
  [4;35;1mIssueRelation Load (0.0ms)[0m   [0mSELECT * FROM `issue_relations` WHERE (`issue_relations`.issue_from_id = 813) [0m
  [4;36;1mCACHE (0.0ms)[0m   [0;1mSELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` = 1) [0m
  [4;35;1mSQL (0.0ms)[0m   [0mCOMMIT[0m
  [4;36;1mSQL (0.0ms)[0m   [0;1mBEGIN[0m
  [4;35;1mCustomField Load (0.0ms)[0m   [0mSELECT * FROM `custom_fields` WHERE (type = 'TimeEntryCustomField') ORDER BY position[0m
  [4;36;1mCACHE (0.0ms)[0m   [0;1mSELECT * FROM `projects` WHERE (`projects`.`id` = 2) [0m
  [4;35;1mSQL (0.0ms)[0m   [0mROLLBACK[0m
Redirected to http://wit390:8080/redmine/issues/813
Completed in 7188ms (DB: 2890) | 302 Found [http://wit390/redmine/issues/813/edit]

Processing IssuesController#index (for 10.8.96.47 at 2010-05-06 14:37:32) [GET]
  Parameters: {"project_id"=>"prime", "set_filter"=>"1", "action"=>"index", "controller"=>"issues"}
  [4;36;1mSQL (0.0ms)[0m   [0;1mSELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` [0m
  [4;35;1mUser Load (0.0ms)[0m   [0mSELECT * FROM `users` WHERE (`users`.`id` = 10) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) [0m
  [4;36;1mProject Load (0.0ms)[0m   [0;1mSELECT * FROM `projects` WHERE (`projects`.`identifier` = 'prime') LIMIT 1[0m
  [4;35;1mEnabledModule Load (0.0ms)[0m   [0mSELECT * FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 2) [0m
  [4;36;1mMember Load Including Associations (16.0ms)[0m   [0;1mSELECT `members`.`id` AS t0_r0, `members`.`user_id` AS t0_r1, `members`.`project_id` AS t0_r2, `members`.`created_on` AS t0_r3, `members`.`mail_notification` AS t0_r4, `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, `roles`.`id` AS t2_r0, `roles`.`name` AS t2_r1, `roles`.`position` AS t2_r2, `roles`.`assignable` AS t2_r3, `roles`.`builtin` AS t2_r4, `roles`.`permissions` AS t2_r5 FROM `members` LEFT OUTER JOIN `projects` ON `projects`.id = `members`.project_id LEFT OUTER JOIN `member_roles` ON (`members`.`id` = `member_roles`.`member_id`) LEFT OUTER JOIN `roles` ON (`roles`.`id` = `member_roles`.`role_id`) WHERE (`members`.user_id = 10 AND (projects.status=1)) ORDER BY projects.name[0m
  [4;35;1mQuery Columns (31.0ms)[0m   [0mSHOW FIELDS FROM `queries`[0m
  [4;36;1mTracker Load Including Associations (62.0ms)[0m   [0;1mSELECT `trackers`.`id` AS t0_r0, `trackers`.`name` AS t0_r1, `trackers`.`is_in_chlog` AS t0_r2, `trackers`.`position` AS t0_r3, `trackers`.`is_in_roadmap` AS t0_r4, `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 FROM `trackers` LEFT OUTER JOIN `projects_trackers` ON `projects_trackers`.tracker_id = `trackers`.id LEFT OUTER JOIN `projects` ON `projects`.id = `projects_trackers`.project_id WHERE (projects.lft >= 293 AND projects.rgt <= 294 AND projects.status = 1) ORDER BY trackers.position[0m
  [4;35;1mIssueStatus Load (0.0ms)[0m   [0mSELECT * FROM `issue_statuses` ORDER BY position[0m
  [4;36;1mIssuePriority Load (0.0ms)[0m   [0;1mSELECT * FROM `enumerations` WHERE ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC[0m
  [4;35;1mUser Load (0.0ms)[0m   [0mSELECT `users`.* FROM `users` INNER JOIN `members` ON `users`.id = `members`.user_id WHERE ((`members`.project_id = 2) AND ((users.type='User' AND users.status=1))) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) [0m
  [4;36;1mIssueCategory Columns (47.0ms)[0m   [0;1mSHOW FIELDS FROM `issue_categories`[0m
  [4;35;1mSQL (15.0ms)[0m   [0mSELECT count(*) AS count_all FROM `issue_categories` WHERE (`issue_categories`.project_id = 2) [0m
  [4;36;1mProject Load (0.0ms)[0m   [0;1mSELECT * FROM `projects` WHERE (projects.`lft` <= 293 AND projects.`rgt` >= 294) ORDER BY `lft` LIMIT 1[0m
  [4;35;1mCACHE (0.0ms)[0m   [0mSELECT * FROM `projects` WHERE (projects.`lft` <= 293 AND projects.`rgt` >= 294) ORDER BY `lft` LIMIT 1[0m
  [4;36;1mVersion Columns (79.0ms)[0m   [0;1mSHOW FIELDS FROM `versions`[0m
  [4;35;1mSQL (0.0ms)[0m   [0mSELECT count(DISTINCT `versions`.id) AS count_all FROM `versions` LEFT OUTER JOIN `projects` ON `projects`.id = `versions`.project_id WHERE (projects.id = 2 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 1 AND projects.rgt <= 308 AND versions.sharing = 'tree') OR (projects.lft < 293 AND projects.rgt > 294 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 293 AND projects.rgt < 294 AND versions.sharing = 'hierarchy')))) [0m
  [4;36;1mVersion Load Including Associations (15.0ms)[0m   [0;1mSELECT `versions`.`id` AS t0_r0, `versions`.`project_id` AS t0_r1, `versions`.`name` AS t0_r2, `versions`.`description` AS t0_r3, `versions`.`effective_date` AS t0_r4, `versions`.`created_on` AS t0_r5, `versions`.`updated_on` AS t0_r6, `versions`.`wiki_page_title` AS t0_r7, `versions`.`status` AS t0_r8, `versions`.`sharing` AS t0_r9, `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 FROM `versions` LEFT OUTER JOIN `projects` ON `projects`.id = `versions`.project_id WHERE (projects.id = 2 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 1 AND projects.rgt <= 308 AND versions.sharing = 'tree') OR (projects.lft < 293 AND projects.rgt > 294 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 293 AND projects.rgt < 294 AND versions.sharing = 'hierarchy')))) [0m
  [4;35;1mSQL (0.0ms)[0m   [0mSELECT count(*) AS count_all FROM `projects` WHERE (((projects.status = 1) AND (projects.id != 2)) AND (projects.`lft` >= 293 AND projects.`rgt` <= 294)) [0m
  [4;36;1mIssueCustomField Load (0.0ms)[0m   [0;1mSELECT * FROM `custom_fields` WHERE (is_for_all=1) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY position[0m
  [4;35;1mIssueCustomField Load (16.0ms)[0m   [0mSELECT * FROM `custom_fields` INNER JOIN `custom_fields_projects` ON `custom_fields`.id = `custom_fields_projects`.custom_field_id WHERE (`custom_fields_projects`.project_id = 2 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY custom_fields.position[0m
  [4;36;1mSetting Load (0.0ms)[0m   [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'per_page_options') LIMIT 1[0m
  [4;35;1mCACHE (0.0ms)[0m   [0mSELECT count(*) AS count_all FROM `projects` WHERE (((projects.status = 1) AND (projects.id != 2)) AND (projects.`lft` >= 293 AND projects.`rgt` <= 294)) [0m
  [4;36;1mRole Load (0.0ms)[0m   [0;1mSELECT * FROM `roles` WHERE (`roles`.`builtin` = 1) LIMIT 1[0m
  [4;35;1mSQL (172.0ms)[0m   [0mSELECT count(DISTINCT `issues`.id) AS count_all FROM `issues` LEFT OUTER JOIN `issue_statuses` ON `issue_statuses`.id = `issues`.status_id LEFT OUTER JOIN `projects` ON `projects`.id = `issues`.project_id WHERE ((issue_statuses.is_closed=0) AND projects.id = 2 AND ((projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) AND (1=0 OR projects.is_public = 1 OR projects.id IN (150,144,116,132,134,135,127,137,115,139,177,66,1,4,2,178,67,5,114,136)))) [0m
  [4;36;1mCACHE (0.0ms)[0m   [0;1mSELECT count(*) AS count_all FROM `projects` WHERE (((projects.status = 1) AND (projects.id != 2)) AND (projects.`lft` >= 293 AND projects.`rgt` <= 294)) [0m
  [4;35;1mCACHE (0.0ms)[0m   [0mSELECT * FROM `roles` WHERE (`roles`.`builtin` = 1) LIMIT 1[0m
  [4;36;1mIssue Load Including Associations (16.0ms)[0m   [0;1mSELECT `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, `issue_statuses`.`id` AS t1_r0, `issue_statuses`.`name` AS t1_r1, `issue_statuses`.`is_closed` AS t1_r2, `issue_statuses`.`is_default` AS t1_r3, `issue_statuses`.`position` AS t1_r4, `issue_statuses`.`default_done_ratio` AS t1_r5, `projects`.`id` AS t2_r0, `projects`.`name` AS t2_r1, `projects`.`description` AS t2_r2, `projects`.`homepage` AS t2_r3, `projects`.`is_public` AS t2_r4, `projects`.`parent_id` AS t2_r5, `projects`.`created_on` AS t2_r6, `projects`.`updated_on` AS t2_r7, `projects`.`identifier` AS t2_r8, `projects`.`status` AS t2_r9, `projects`.`lft` AS t2_r10, `projects`.`rgt` AS t2_r11, `users`.`id` AS t3_r0, `users`.`login` AS t3_r1, `users`.`hashed_password` AS t3_r2, `users`.`firstname` AS t3_r3, `users`.`lastname` AS t3_r4, `users`.`mail` AS t3_r5, `users`.`mail_notification` AS t3_r6, `users`.`admin` AS t3_r7, `users`.`status` AS t3_r8, `users`.`last_login_on` AS t3_r9, `users`.`language` AS t3_r10, `users`.`auth_source_id` AS t3_r11, `users`.`created_on` AS t3_r12, `users`.`updated_on` AS t3_r13, `users`.`type` AS t3_r14, `users`.`identity_url` AS t3_r15, `trackers`.`id` AS t4_r0, `trackers`.`name` AS t4_r1, `trackers`.`is_in_chlog` AS t4_r2, `trackers`.`position` AS t4_r3, `trackers`.`is_in_roadmap` AS t4_r4, `enumerations`.`id` AS t5_r0, `enumerations`.`name` AS t5_r1, `enumerations`.`position` AS t5_r2, `enumerations`.`is_default` AS t5_r3, `enumerations`.`type` AS t5_r4, `enumerations`.`active` AS t5_r5, `enumerations`.`project_id` AS t5_r6, `enumerations`.`parent_id` AS t5_r7, `issue_categories`.`id` AS t6_r0, `issue_categories`.`project_id` AS t6_r1, `issue_categories`.`name` AS t6_r2, `issue_categories`.`assigned_to_id` AS t6_r3, `versions`.`id` AS t7_r0, `versions`.`project_id` AS t7_r1, `versions`.`name` AS t7_r2, `versions`.`description` AS t7_r3, `versions`.`effective_date` AS t7_r4, `versions`.`created_on` AS t7_r5, `versions`.`updated_on` AS t7_r6, `versions`.`wiki_page_title` AS t7_r7, `versions`.`status` AS t7_r8, `versions`.`sharing` AS t7_r9 FROM `issues` LEFT OUTER JOIN `issue_statuses` ON `issue_statuses`.id = `issues`.status_id LEFT OUTER JOIN `projects` ON `projects`.id = `issues`.project_id LEFT OUTER JOIN `users` ON `users`.id = `issues`.assigned_to_id AND (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) LEFT OUTER JOIN `trackers` ON `trackers`.id = `issues`.tracker_id LEFT OUTER JOIN `enumerations` ON `enumerations`.id = `issues`.priority_id AND (`enumerations`.`type` = 'IssuePriority' ) LEFT OUTER JOIN `issue_categories` ON `issue_categories`.id = `issues`.category_id LEFT OUTER JOIN `versions` ON `versions`.id = `issues`.fixed_version_id WHERE (((issue_statuses.is_closed=0) AND projects.id = 2 AND ((projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) AND (1=0 OR projects.is_public = 1 OR projects.id IN (150,144,116,132,134,135,127,137,115,139,177,66,1,4,2,178,67,5,114,136))))) ORDER BY issues.id DESC LIMIT 0, 25[0m
Rendering template within layouts/base
Rendering issues/index.rhtml
Rendered queries/_filters (78.0ms)
  [4;35;1mSetting Load (0.0ms)[0m   [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'issue_list_default_columns') LIMIT 1[0m
Rendered queries/_columns (0.0ms)
  [4;36;1mUserPreference Load (0.0ms)[0m   [0;1mSELECT * FROM `user_preferences` WHERE (`user_preferences`.user_id = 10) LIMIT 1[0m
  [4;35;1mSetting Load (0.0ms)[0m   [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'time_format') LIMIT 1[0m
Rendered issues/_list (594.0ms)
  [4;36;1mToken Load (0.0ms)[0m   [0;1mSELECT * FROM `tokens` WHERE (`tokens`.user_id = 10 AND (action='feeds')) LIMIT 1[0m
  [4;35;1mToken Columns (0.0ms)[0m   [0mSHOW FIELDS FROM `tokens`[0m
  [4;36;1mQuery Load (0.0ms)[0m   [0;1mSELECT id, name FROM `queries` WHERE (1=1 AND (is_public = 1 OR user_id = 10) AND (project_id IS NULL OR project_id = 2)) ORDER BY name ASC[0m
Rendered issues/_sidebar (32.0ms)
  [4;35;1mSetting Load (15.0ms)[0m   [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'ui_theme') LIMIT 1[0m
  [4;36;1mProject Load (0.0ms)[0m   [0;1mSELECT `projects`.* FROM `projects` INNER JOIN `members` ON `projects`.id = `members`.project_id WHERE ((`members`.user_id = 10) AND ((projects.status=1))) [0m
  [4;35;1mSQL (0.0ms)[0m   [0mSELECT count(*) AS count_all FROM `projects` WHERE (((projects.status=1 AND (projects.is_public = 1 or projects.id IN (150,144,116,132,134,135,127,137,115,139,177,66,1,4,2,178,67,5,114,136))) AND (projects.id != 2)) AND (projects.`lft` <= 293 AND projects.`rgt` >= 294)) [0m
  [4;36;1mProject Load (0.0ms)[0m   [0;1mSELECT * FROM `projects` WHERE (((projects.status=1 AND (projects.is_public = 1 or projects.id IN (150,144,116,132,134,135,127,137,115,139,177,66,1,4,2,178,67,5,114,136))) AND (projects.id != 2)) AND (projects.`lft` <= 293 AND projects.`rgt` >= 294)) ORDER BY `lft`[0m
  [4;35;1mWiki Load (47.0ms)[0m   [0mSELECT * FROM `wikis` WHERE (`wikis`.project_id = 2) LIMIT 1[0m
  [4;36;1mBoard Columns (94.0ms)[0m   [0;1mSHOW FIELDS FROM `boards`[0m
  [4;35;1mSQL (0.0ms)[0m   [0mSELECT count(*) AS count_all FROM `boards` WHERE (`boards`.project_id = 2) [0m
  [4;36;1mRepository Load (47.0ms)[0m   [0;1mSELECT * FROM `repositories` WHERE (`repositories`.project_id = 2) LIMIT 1[0m
  [4;35;1mRepository Columns (16.0ms)[0m   [0mSHOW FIELDS FROM `repositories`[0m
Completed in 1672ms (View: 796, DB: 688) | 200 OK [http://wit390/redmine/projects/prime/issues?set_filter=1]

Processing IssuesController#show (for 10.8.96.47 at 2010-05-06 14:38:36) [GET]
  Parameters: {"action"=>"show", "id"=>"813", "controller"=>"issues"}
  [4;36;1mSQL (15.0ms)[0m   [0;1mSELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` [0m
  [4;35;1mUser Load (0.0ms)[0m   [0mSELECT * FROM `users` WHERE (`users`.`id` = 10) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) [0m
  [4;36;1mIssue Load (0.0ms)[0m   [0;1mSELECT * FROM `issues` WHERE (`issues`.`id` = 813) [0m
  [4;35;1mProject Load (0.0ms)[0m   [0mSELECT * FROM `projects` WHERE (`projects`.`id` = 2) [0m
  [4;36;1mTracker Load (0.0ms)[0m   [0;1mSELECT * FROM `trackers` WHERE (`trackers`.`id` = 1) [0m
  [4;35;1mIssueStatus Load (0.0ms)[0m   [0mSELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` = 1) [0m
  [4;36;1mUser Load (0.0ms)[0m   [0;1mSELECT * FROM `users` WHERE (`users`.`id` = 69) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) [0m
  [4;35;1mIssuePriority Load (0.0ms)[0m   [0mSELECT * FROM `enumerations` WHERE (`enumerations`.`id` = 4) AND ( (`enumerations`.`type` = 'IssuePriority' ) ) [0m
  [4;36;1mEnabledModule Load (0.0ms)[0m   [0;1mSELECT * FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 2) [0m
  [4;35;1mMember Load Including Associations (16.0ms)[0m   [0mSELECT `members`.`id` AS t0_r0, `members`.`user_id` AS t0_r1, `members`.`project_id` AS t0_r2, `members`.`created_on` AS t0_r3, `members`.`mail_notification` AS t0_r4, `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, `roles`.`id` AS t2_r0, `roles`.`name` AS t2_r1, `roles`.`position` AS t2_r2, `roles`.`assignable` AS t2_r3, `roles`.`builtin` AS t2_r4, `roles`.`permissions` AS t2_r5 FROM `members` LEFT OUTER JOIN `projects` ON `projects`.id = `members`.project_id LEFT OUTER JOIN `member_roles` ON (`members`.`id` = `member_roles`.`member_id`) LEFT OUTER JOIN `roles` ON (`roles`.`id` = `member_roles`.`role_id`) WHERE (`members`.user_id = 10 AND (projects.status=1)) ORDER BY projects.name[0m
  [4;36;1mJournal Load (0.0ms)[0m   [0;1mSELECT * FROM `journals` WHERE (`journals`.journalized_id = 813 AND `journals`.journalized_type = 'Issue') ORDER BY journals.created_on ASC[0m
  [4;35;1mUser Load (0.0ms)[0m   [0mSELECT * FROM `users` WHERE (`users`.`id` = 10) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) [0m
  [4;36;1mJournalDetail Load (0.0ms)[0m   [0;1mSELECT `journal_details`.* FROM `journal_details` WHERE (`journal_details`.journal_id = 1659) [0m
  [4;35;1mUserPreference Load (0.0ms)[0m   [0mSELECT * FROM `user_preferences` WHERE (`user_preferences`.user_id = 10) LIMIT 1[0m
  [4;36;1mRole Load (0.0ms)[0m   [0;1mSELECT * FROM `roles` WHERE (`roles`.`builtin` = 1) LIMIT 1[0m
  [4;35;1mChangeset Columns (172.0ms)[0m   [0mSHOW FIELDS FROM `changesets`[0m
  [4;36;1mChangeset Load Including Associations (47.0ms)[0m   [0;1mSELECT `changesets`.`id` AS t0_r0, `changesets`.`repository_id` AS t0_r1, `changesets`.`revision` AS t0_r2, `changesets`.`committer` AS t0_r3, `changesets`.`committed_on` AS t0_r4, `changesets`.`comments` AS t0_r5, `changesets`.`commit_date` AS t0_r6, `changesets`.`scmid` AS t0_r7, `changesets`.`user_id` AS t0_r8, `repositories`.`id` AS t1_r0, `repositories`.`project_id` AS t1_r1, `repositories`.`url` AS t1_r2, `repositories`.`login` AS t1_r3, `repositories`.`password` AS t1_r4, `repositories`.`root_url` AS t1_r5, `repositories`.`type` AS t1_r6, `projects`.`id` AS t2_r0, `projects`.`name` AS t2_r1, `projects`.`description` AS t2_r2, `projects`.`homepage` AS t2_r3, `projects`.`is_public` AS t2_r4, `projects`.`parent_id` AS t2_r5, `projects`.`created_on` AS t2_r6, `projects`.`updated_on` AS t2_r7, `projects`.`identifier` AS t2_r8, `projects`.`status` AS t2_r9, `projects`.`lft` AS t2_r10, `projects`.`rgt` AS t2_r11 FROM `changesets` LEFT OUTER JOIN `repositories` ON `repositories`.id = `changesets`.repository_id LEFT OUTER JOIN `projects` ON `projects`.id = `repositories`.project_id INNER JOIN `changesets_issues` ON `changesets`.id = `changesets_issues`.changeset_id WHERE (((((projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='repository')) AND (1=0 OR projects.is_public = 1 OR projects.id IN (150,144,116,132,134,135,127,137,115,139,177,66,1,4,2,178,67,5,114,136)))) AND (`changesets_issues`.issue_id = 813 )) AND (`changesets_issues`.issue_id = 813 )) ORDER BY changesets.committed_on ASC, changesets.id ASC[0m
  [4;35;1mWorkflow Load (0.0ms)[0m   [0mSELECT * FROM `workflows` WHERE (`workflows`.old_status_id = 1 AND (`workflows`.`tracker_id` = 1 AND `workflows`.`role_id` IN (4))) [0m
  [4;36;1mIssueStatus Load (0.0ms)[0m   [0;1mSELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` IN (6,7,8,9,1,2,3,4,5)) [0m
  [4;35;1mIssueRelation Load (0.0ms)[0m   [0mSELECT * FROM `issue_relations` WHERE (`issue_relations`.issue_to_id = 813) [0m
  [4;36;1mIssuePriority Load (0.0ms)[0m   [0;1mSELECT * FROM `enumerations` WHERE ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC[0m
  [4;35;1mTimeEntryActivity Load (0.0ms)[0m   [0mSELECT * FROM `enumerations` WHERE (`enumerations`.`is_default` = 1) AND ( (`enumerations`.`type` = 'TimeEntryActivity' ) ) ORDER BY enumerations.position ASC LIMIT 1[0m
Rendering template within layouts/base
Rendering issues/show.rhtml
  [4;36;1mWatcher Load (0.0ms)[0m   [0;1mSELECT * FROM `watchers` WHERE (`watchers`.watchable_id = 813 AND `watchers`.watchable_type = 'Issue') [0m
Rendered issues/_action_menu (31.0ms)
  [4;35;1mSetting Load (0.0ms)[0m   [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'gravatar_enabled') LIMIT 1[0m
  [4;36;1mSQL (0.0ms)[0m   [0;1mSELECT sum(`time_entries`.hours) AS sum_hours FROM `time_entries` WHERE (`time_entries`.issue_id = 813) [0m
  [4;35;1mIssueCustomField Load (0.0ms)[0m   [0mSELECT * FROM `custom_fields` WHERE (is_for_all=1) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY position[0m
  [4;36;1mIssueCustomField Load (0.0ms)[0m   [0;1mSELECT * FROM `custom_fields` INNER JOIN `custom_fields_projects` ON `custom_fields`.id = `custom_fields_projects`.custom_field_id WHERE (`custom_fields_projects`.project_id = 2 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY custom_fields.position[0m
  [4;35;1mIssueCustomField Load (0.0ms)[0m   [0mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 13) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
  [4;36;1mIssueCustomField Load (0.0ms)[0m   [0;1mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 14) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
  [4;35;1mIssueCustomField Load (0.0ms)[0m   [0mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 15) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
  [4;36;1mIssueCustomField Load (0.0ms)[0m   [0;1mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 20) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
  [4;35;1mIssueCustomField Load (0.0ms)[0m   [0mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 21) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
  [4;36;1mIssueCustomField Load (0.0ms)[0m   [0;1mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 22) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
  [4;35;1mIssueCustomField Load (0.0ms)[0m   [0mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 23) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
  [4;36;1mIssueCustomField Load (0.0ms)[0m   [0;1mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 25) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
  [4;35;1mIssueCustomField Load (0.0ms)[0m   [0mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 26) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
  [4;36;1mIssueCustomField Load (0.0ms)[0m   [0;1mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 27) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
  [4;35;1mIssueCustomField Load (0.0ms)[0m   [0mSELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 28) AND (`custom_fields_trackers`.tracker_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1[0m
  [4;36;1mCustomValue Load Including Associations (15.0ms)[0m   [0;1mSELECT `custom_values`.`id` AS t0_r0, `custom_values`.`customized_type` AS t0_r1, `custom_values`.`customized_id` AS t0_r2, `custom_values`.`custom_field_id` AS t0_r3, `custom_values`.`value` AS t0_r4, `custom_fields`.`id` AS t1_r0, `custom_fields`.`type` AS t1_r1, `custom_fields`.`name` AS t1_r2, `custom_fields`.`field_format` AS t1_r3, `custom_fields`.`possible_values` AS t1_r4, `custom_fields`.`regexp` AS t1_r5, `custom_fields`.`min_length` AS t1_r6, `custom_fields`.`max_length` AS t1_r7, `custom_fields`.`is_required` AS t1_r8, `custom_fields`.`is_for_all` AS t1_r9, `custom_fields`.`is_filter` AS t1_r10, `custom_fields`.`position` AS t1_r11, `custom_fields`.`searchable` AS t1_r12, `custom_fields`.`default_value` AS t1_r13, `custom_fields`.`editable` AS t1_r14 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.id = `custom_values`.custom_field_id WHERE (`custom_values`.customized_id = 813 AND `custom_values`.customized_type = 'Issue') ORDER BY custom_fields.position[0m
  [4;35;1mAttachment Load (16.0ms)[0m   [0mSELECT * FROM `attachments` WHERE (`attachments`.container_id = 813 AND `attachments`.container_type = 'Issue') ORDER BY attachments.created_on[0m
  [4;36;1mIssueRelation Load (0.0ms)[0m   [0;1mSELECT * FROM `issue_relations` WHERE (`issue_relations`.issue_from_id = 813) [0m
Rendered issue_relations/_form (0.0ms)
Rendered issues/_relations (0.0ms)
  [4;35;1mUser Load (0.0ms)[0m   [0mSELECT `users`.* FROM `users` INNER JOIN `watchers` ON `users`.id = `watchers`.user_id WHERE ((`watchers`.watchable_id = 813) AND (`watchers`.watchable_type = 'Issue')) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) [0m
Rendered watchers/_watchers (16.0ms)
Rendered issues/_history (0.0ms)
Rendered issues/_action_menu (0.0ms)
  [4;36;1mprojects_trackers Columns (0.0ms)[0m   [0;1mSHOW FIELDS FROM `projects_trackers`[0m
  [4;35;1mTracker Load (47.0ms)[0m   [0mSELECT * FROM `trackers` INNER JOIN `projects_trackers` ON `trackers`.id = `projects_trackers`.tracker_id WHERE (`projects_trackers`.project_id = 2 ) ORDER BY trackers.position[0m
  [4;36;1mMember Load Including Associations (0.0ms)[0m   [0;1mSELECT `members`.`id` AS t0_r0, `members`.`user_id` AS t0_r1, `members`.`project_id` AS t0_r2, `members`.`created_on` AS t0_r3, `members`.`mail_notification` AS t0_r4, `users`.`id` AS t1_r0, `users`.`login` AS t1_r1, `users`.`hashed_password` AS t1_r2, `users`.`firstname` AS t1_r3, `users`.`lastname` AS t1_r4, `users`.`mail` AS t1_r5, `users`.`mail_notification` AS t1_r6, `users`.`admin` AS t1_r7, `users`.`status` AS t1_r8, `users`.`last_login_on` AS t1_r9, `users`.`language` AS t1_r10, `users`.`auth_source_id` AS t1_r11, `users`.`created_on` AS t1_r12, `users`.`updated_on` AS t1_r13, `users`.`type` AS t1_r14, `users`.`identity_url` AS t1_r15, `roles`.`id` AS t2_r0, `roles`.`name` AS t2_r1, `roles`.`position` AS t2_r2, `roles`.`assignable` AS t2_r3, `roles`.`builtin` AS t2_r4, `roles`.`permissions` AS t2_r5 FROM `members` LEFT OUTER JOIN `users` ON `users`.id = `members`.user_id AND (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) LEFT OUTER JOIN `member_roles` ON (`members`.`id` = `member_roles`.`member_id`) LEFT OUTER JOIN `roles` ON (`roles`.`id` = `member_roles`.`role_id`) WHERE (`members`.project_id = 2 AND (users.type='User' AND users.status=1)) [0m
  [4;35;1mSQL (0.0ms)[0m   [0mSELECT count(*) AS count_all FROM `issue_categories` WHERE (`issue_categories`.project_id = 2) [0m
  [4;36;1mProject Load (0.0ms)[0m   [0;1mSELECT * FROM `projects` WHERE (projects.`lft` <= 293 AND projects.`rgt` >= 294) ORDER BY `lft` LIMIT 1[0m
  [4;35;1mCACHE (0.0ms)[0m   [0mSELECT * FROM `projects` WHERE (projects.`lft` <= 293 AND projects.`rgt` >= 294) ORDER BY `lft` LIMIT 1[0m
  [4;36;1mVersion Load (0.0ms)[0m   [0;1mSELECT * FROM `versions` WHERE (`versions`.`id` IS NULL) LIMIT 1[0m
  [4;35;1mVersion Load Including Associations (0.0ms)[0m   [0mSELECT `versions`.`id` AS t0_r0, `versions`.`project_id` AS t0_r1, `versions`.`name` AS t0_r2, `versions`.`description` AS t0_r3, `versions`.`effective_date` AS t0_r4, `versions`.`created_on` AS t0_r5, `versions`.`updated_on` AS t0_r6, `versions`.`wiki_page_title` AS t0_r7, `versions`.`status` AS t0_r8, `versions`.`sharing` AS t0_r9, `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 FROM `versions` LEFT OUTER JOIN `projects` ON `projects`.id = `versions`.project_id WHERE ((`versions`.`status` = 'open') AND (projects.id = 2 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 1 AND projects.rgt <= 308 AND versions.sharing = 'tree') OR (projects.lft < 293 AND projects.rgt > 294 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 293 AND projects.rgt < 294 AND versions.sharing = 'hierarchy'))))) [0m
  [4;36;1mSetting Load (0.0ms)[0m   [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'start_of_week') LIMIT 1[0m
Rendered issues/_form_custom_fields (0.0ms)
Rendered issues/_attributes (31.0ms)
Rendered issues/_form (94.0ms)
  [4;35;1mTimeEntryActivity Load (0.0ms)[0m   [0mSELECT * FROM `enumerations` WHERE (`enumerations`.project_id = 2) AND ( (`enumerations`.`type` = 'TimeEntryActivity' ) ) ORDER BY enumerations.position ASC[0m
  [4;36;1mTimeEntryActivity Load (0.0ms)[0m   [0;1mSELECT * FROM `enumerations` WHERE ((`enumerations`.`project_id` IS NULL AND `enumerations`.`active` = 1)) AND ( (`enumerations`.`type` = 'TimeEntryActivity' ) ) ORDER BY enumerations.position ASC[0m
  [4;35;1mCustomField Load (0.0ms)[0m   [0mSELECT * FROM `custom_fields` WHERE (type = 'TimeEntryCustomField') ORDER BY position[0m
  [4;36;1mSetting Load (0.0ms)[0m   [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'attachment_max_size') LIMIT 1[0m
Rendered attachments/_form (0.0ms)
Rendered issues/_edit (171.0ms)
  [4;35;1mToken Load (0.0ms)[0m   [0mSELECT * FROM `tokens` WHERE (`tokens`.user_id = 10 AND (action='feeds')) LIMIT 1[0m
  [4;36;1mQuery Load (0.0ms)[0m   [0;1mSELECT id, name FROM `queries` WHERE (1=1 AND (is_public = 1 OR user_id = 10) AND (project_id IS NULL OR project_id = 2)) ORDER BY name ASC[0m
Rendered issues/_sidebar (0.0ms)
  [4;35;1mProject Load (0.0ms)[0m   [0mSELECT `projects`.* FROM `projects` INNER JOIN `members` ON `projects`.id = `members`.project_id WHERE ((`members`.user_id = 10) AND ((projects.status=1))) [0m
  [4;36;1mSQL (0.0ms)[0m   [0;1mSELECT count(*) AS count_all FROM `projects` WHERE (((projects.status=1 AND (projects.is_public = 1 or projects.id IN (150,144,116,132,134,135,127,137,115,139,177,66,1,4,2,178,67,5,114,136))) AND (projects.id != 2)) AND (projects.`lft` <= 293 AND projects.`rgt` >= 294)) [0m
  [4;35;1mProject Load (0.0ms)[0m   [0mSELECT * FROM `projects` WHERE (((projects.status=1 AND (projects.is_public = 1 or projects.id IN (150,144,116,132,134,135,127,137,115,139,177,66,1,4,2,178,67,5,114,136))) AND (projects.id != 2)) AND (projects.`lft` <= 293 AND projects.`rgt` >= 294)) ORDER BY `lft`[0m
  [4;36;1mSQL (0.0ms)[0m   [0;1mSELECT count(DISTINCT `versions`.id) AS count_all FROM `versions` LEFT OUTER JOIN `projects` ON `projects`.id = `versions`.project_id WHERE (projects.id = 2 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 1 AND projects.rgt <= 308 AND versions.sharing = 'tree') OR (projects.lft < 293 AND projects.rgt > 294 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 293 AND projects.rgt < 294 AND versions.sharing = 'hierarchy')))) [0m
  [4;35;1mWiki Load (0.0ms)[0m   [0mSELECT * FROM `wikis` WHERE (`wikis`.project_id = 2) LIMIT 1[0m
  [4;36;1mSQL (0.0ms)[0m   [0;1mSELECT count(*) AS count_all FROM `boards` WHERE (`boards`.project_id = 2) [0m
  [4;35;1mRepository Load (0.0ms)[0m   [0mSELECT * FROM `repositories` WHERE (`repositories`.project_id = 2) LIMIT 1[0m
Completed in 3937ms (View: 3422, DB: 328) | 200 OK [http://wit390/redmine/issues/813]
  [4;35;1mSQL (0.0ms)[0m   [0mSET SQL_AUTO_IS_NULL=0[0m

Processing WelcomeController#index (for 10.29.96.8 at 2010-05-06 14:39:23) [GET]
  Parameters: {"action"=>"index", "controller"=>"welcome"}
  [4;36;1mSetting Columns (31.0ms)[0m   [0;1mSHOW FIELDS FROM `settings`[0m
  [4;35;1mSQL (0.0ms)[0m   [0mSELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` [0m
  [4;36;1mUser Columns (0.0ms)[0m   [0;1mSHOW FIELDS FROM `users`[0m
  [4;35;1mUser Load (0.0ms)[0m   [0mSELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) [0m
  [4;36;1mNews Columns (46.0ms)[0m   [0;1mSHOW FIELDS FROM `news`[0m
  [4;35;1mProject Columns (16.0ms)[0m   [0mSHOW FIELDS FROM `projects`[0m
  [4;36;1mNews Load Including Associations (15.0ms)[0m   [0;1mSELECT `news`.`id` AS t0_r0, `news`.`project_id` AS t0_r1, `news`.`title` AS t0_r2, `news`.`summary` AS t0_r3, `news`.`description` AS t0_r4, `news`.`author_id` AS t0_r5, `news`.`created_on` AS t0_r6, `news`.`comments_count` AS t0_r7, `users`.`id` AS t1_r0, `users`.`login` AS t1_r1, `users`.`hashed_password` AS t1_r2, `users`.`firstname` AS t1_r3, `users`.`lastname` AS t1_r4, `users`.`mail` AS t1_r5, `users`.`mail_notification` AS t1_r6, `users`.`admin` AS t1_r7, `users`.`status` AS t1_r8, `users`.`last_login_on` AS t1_r9, `users`.`language` AS t1_r10, `users`.`auth_source_id` AS t1_r11, `users`.`created_on` AS t1_r12, `users`.`updated_on` AS t1_r13, `users`.`type` AS t1_r14, `users`.`identity_url` AS t1_r15, `projects`.`id` AS t2_r0, `projects`.`name` AS t2_r1, `projects`.`description` AS t2_r2, `projects`.`homepage` AS t2_r3, `projects`.`is_public` AS t2_r4, `projects`.`parent_id` AS t2_r5, `projects`.`created_on` AS t2_r6, `projects`.`updated_on` AS t2_r7, `projects`.`identifier` AS t2_r8, `projects`.`status` AS t2_r9, `projects`.`lft` AS t2_r10, `projects`.`rgt` AS t2_r11 FROM `news` LEFT OUTER JOIN `users` ON `users`.id = `news`.author_id AND (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) LEFT OUTER JOIN `projects` ON `projects`.id = `news`.project_id WHERE (projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='news')) ORDER BY news.created_on DESC LIMIT 5[0m
  [4;35;1mProject Load (0.0ms)[0m   [0mSELECT * FROM `projects` WHERE (projects.status=1) ORDER BY created_on DESC LIMIT 5[0m
Rendering template within layouts/base
Rendering welcome/index
  [4;36;1mSetting Load (0.0ms)[0m   [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'welcome_text') LIMIT 1[0m
  [4;35;1mSetting Load (0.0ms)[0m   [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'user_format') LIMIT 1[0m
  [4;36;1mUserPreference Load (16.0ms)[0m   [0;1mSELECT * FRO
Actions
Copy link
 #5

Updated by Jon Lumpkin over 14 years ago

Also, to clean this up, #3 can be deleted, I just don't have permissions to do so.

Actions
Copy link
 #6

Updated by Aaron Parks over 14 years ago

We are running 3733 and it works great . . except for the one guy that has IE 8. He can do anything except create or edit features/bugs. Other browsers on his machine (Chrome, FF) work fine.

We do have people using IE 7 and they seem to work fine

AP

Actions
Copy link
 #7

Updated by Jon Lumpkin over 14 years ago

We are now having yet another user having this issue. Enabling all of the logging possible only gave me what is above, and still not sure what is actually happening.

Actions
Copy link
 #8

Updated by Jon Lumpkin about 14 years ago

  • Status changed from New to Resolved
Actions
Copy link
 #9

Updated by Etienne Massip over 13 years ago

  • Status changed from Resolved to Closed
  • Resolution set to Invalid
Actions
Copy link

Also available in: Atom PDF