Defect #5397

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

Added by Jon Lumpkin over 11 years ago. Updated over 10 years ago.

Status:ClosedStart date:2010-04-28
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:Issues
Target version:-
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.

History

#1 Updated by Holger Just over 11 years ago

might be related to #5401

#2 Updated by Jon Lumpkin over 11 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.

#3 Updated by Jon Lumpkin over 11 years ago

  1. Logfile created on Thu May 06 14:35:12 -0400 2010 SQL (0.0ms) SET SQL_AUTO_IS_NULL=0

Processing WelcomeController#index (for 10.29.96.8 at 2010-05-06 14:35:25) [GET]
Parameters: {"action"=>"index", "controller"=>"welcome"}
Setting Columns (46.0ms) SHOW FIELDS FROM `settings`
SQL (0.0ms) SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 
User Columns (31.0ms) SHOW FIELDS FROM `users`
User Load (0.0ms) SELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 
News Columns (47.0ms) SHOW FIELDS FROM `news`
Project Columns (46.0ms) SHOW FIELDS FROM `projects`
News Load Including Associations (141.0ms) SELECT `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
Project Load (16.0ms) SELECT * FROM `projects` WHERE (projects.status=1) ORDER BY created_on DESC LIMIT 5
Rendering template within layouts/base
Rendering welcome/index
Setting Load (0.0ms) SELECT * FROM `settings` WHERE (`settings`.`name` = 'welcome_text') LIMIT 1
Setting Load (0.0ms) SELECT * FROM `settings` WHERE (`settings`.`name` = 'user_format') LIMIT 1
UserPreference Load (0.0ms) SELECT * FROM `user_preferences` WHERE (`user_preferences`.user_id = 3) LIMIT 1
UserPreference Columns (16.0ms) SHOW FIELDS FROM `user_preferences`
Setting Load (0.0ms) SELECT * FROM `settings` WHERE (`settings`.`name` = 'time_format') LIMIT 1
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)
Setting Load (0.0ms) SELECT * FROM `settings` WHERE (`settings`.`name` = 'text_formatting') LIMIT 1
Token Load (47.0ms) SELECT * FROM `tokens` WHERE (`tokens`.user_id = 3 AND (action='feeds')) LIMIT 1
Token Columns (16.0ms) SHOW FIELDS FROM `tokens`
Setting Load (0.0ms) SELECT * FROM `settings` WHERE (`settings`.`name` = 'app_title') LIMIT 1
Setting Load (15.0ms) SELECT * FROM `settings` WHERE (`settings`.`name` = 'ui_theme') LIMIT 1
Project Load (125.0ms) SELECT `projects`.* FROM `projects` INNER JOIN `members` ON `projects`.id = `members`.project_id WHERE ((`members`.user_id = 3) AND ((projects.status=1))) 
Completed in 1750ms (View: 1078, DB: 546) | 200 OK [http://wit390/redmine/]
SQL (0.0ms) SET SQL_AUTO_IS_NULL=0

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"=>""}}}
Setting Columns (16.0ms) SHOW FIELDS FROM `settings`
SQL (0.0ms) SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 
User Columns (0.0ms) SHOW FIELDS FROM `users`
User Load (0.0ms) SELECT * FROM `users` WHERE (`users`.`id` = 10) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 
Issue Columns (219.0ms) SHOW FIELDS FROM `issues`
Issue Load (47.0ms) SELECT * FROM `issues` WHERE (`issues`.`id` = 813) 
Project Columns (47.0ms) SHOW FIELDS FROM `projects`
Project Load (0.0ms) SELECT * FROM `projects` WHERE (`projects`.`id` = 2) 
Tracker Columns (47.0ms) SHOW FIELDS FROM `trackers`
Tracker Load (15.0ms) SELECT * FROM `trackers` WHERE (`trackers`.`id` = 1) 
IssueStatus Columns (94.0ms) SHOW FIELDS FROM `issue_statuses`
IssueStatus Load (0.0ms) SELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` = 1) 
User Load (0.0ms) SELECT * FROM `users` WHERE (`users`.`id` = 69) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 
IssuePriority Columns (47.0ms) SHOW FIELDS FROM `enumerations`
IssuePriority Load (0.0ms) SELECT * FROM `enumerations` WHERE (`enumerations`.`id` = 4) AND ( (`enumerations`.`type` = 'IssuePriority' ) ) 
EnabledModule Load (0.0ms) SELECT * FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 2) 
EnabledModule Columns (0.0ms) SHOW FIELDS FROM `enabled_modules`
Member Columns (0.0ms) SHOW FIELDS FROM `members`
Role Columns (31.0ms) SHOW FIELDS FROM `roles`
Member Load Including Associations (203.0ms) SELECT `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
Workflow Load (187.0ms) SELECT * FROM `workflows` WHERE (`workflows`.old_status_id = 1 AND (`workflows`.`tracker_id` = 1 AND `workflows`.`role_id` IN (4))) 
Workflow Columns (16.0ms) SHOW FIELDS FROM `workflows`
IssueStatus Load (0.0ms) SELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` IN (6,7,8,9,1,2,3,4,5)) 
IssueRelation Load (47.0ms) SELECT * FROM `issue_relations` WHERE (`issue_relations`.issue_to_id = 813) 
IssuePriority Load (0.0ms) SELECT * FROM `enumerations` WHERE ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC
TimeEntry Columns (62.0ms) SHOW FIELDS FROM `time_entries`
TimeEntryActivity Columns (15.0ms) SHOW FIELDS FROM `enumerations`
TimeEntryActivity Load (0.0ms) SELECT * FROM `enumerations` WHERE (`enumerations`.`is_default` = 1) AND ( (`enumerations`.`type` = 'TimeEntryActivity' ) ) ORDER BY enumerations.position ASC LIMIT 1
Journal Columns (313.0ms) SHOW FIELDS FROM `journals`
IssueStatus Load (0.0ms) SELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` = 0) 
IssueStatus Load (0.0ms) SELECT * FROM `issue_statuses` WHERE (is_default=1) LIMIT 1
IssuePriority Load (0.0ms) SELECT * FROM `enumerations` WHERE (`enumerations`.`id` = 0) AND ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC
IssuePriority Load (0.0ms) SELECT * FROM `enumerations` WHERE (`enumerations`.`is_default` = 1) AND ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC LIMIT 1
CustomValue Columns (375.0ms) SHOW FIELDS FROM `custom_values`
CustomField Columns (109.0ms) SHOW FIELDS FROM `custom_fields`
CustomValue Load Including Associations (16.0ms) SELECT `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
CACHE (0.0ms) SELECT * FROM `trackers` WHERE (`trackers`.`id` = 1) 
IssueCustomField Columns (15.0ms) SHOW FIELDS FROM `custom_fields`
IssueCustomField Load (0.0ms) SELECT * FROM `custom_fields` WHERE (is_for_all=1) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY position
custom_fields_projects Columns (47.0ms) SHOW FIELDS FROM `custom_fields_projects`
IssueCustomField Load (16.0ms) SELECT * 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
IssueCustomField Load (0.0ms) SELECT `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
IssueCustomField Load (0.0ms) SELECT `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
IssueCustomField Load (0.0ms) SELECT `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
IssueCustomField Load (0.0ms) SELECT `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
IssueCustomField Load (0.0ms) SELECT `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
IssueCustomField Load (0.0ms) SELECT `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
IssueCustomField Load (0.0ms) SELECT `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
IssueCustomField Load (0.0ms) SELECT `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
IssueCustomField Load (0.0ms) SELECT `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
IssueCustomField Load (0.0ms) SELECT `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
IssueCustomField Load (0.0ms) SELECT `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
CACHE (0.0ms) SELECT * FROM `enumerations` WHERE (`enumerations`.`is_default` = 1) AND ( (`enumerations`.`type` = 'TimeEntryActivity' ) ) ORDER BY enumerations.position ASC LIMIT 1
IssuePriority Load (0.0ms) SELECT * FROM `enumerations` WHERE (`enumerations`.`id` = 4) AND ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC
CACHE (0.0ms) SELECT * FROM `trackers` WHERE (`trackers`.`id` = 1) 
Setting Load (0.0ms) SELECT * FROM `settings` WHERE (`settings`.`name` = 'issue_done_ratio') LIMIT 1
SQL (0.0ms) BEGIN
Issue Update with optimistic locking (0.0ms)  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

IssueCustomField Load (0.0ms) SELECT `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
IssueCustomField Load (0.0ms) SELECT `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
IssueCustomField Load (0.0ms) SELECT `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
IssueCustomField Load (0.0ms) SELECT `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
IssueCustomField Load (0.0ms) SELECT `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
IssueCustomField Load (0.0ms) SELECT `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
IssueCustomField Load (0.0ms) SELECT `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
IssueCustomField Load (0.0ms) SELECT `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
IssueCustomField Load (0.0ms) SELECT `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
IssueCustomField Load (0.0ms) SELECT `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
IssueCustomField Load (0.0ms) SELECT `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
JournalDetail Columns (391.0ms) SHOW FIELDS FROM `journal_details`
Journal Create (31.0ms) INSERT INTO `journals` (`created_on`, `notes`, `user_id`, `journalized_type`, `journalized_id`) VALUES
JournalDetail Create (0.0ms) INSERT INTO `journal_details` (`property`, `prop_key`, `old_value`, `value`, `journal_id`) VALUES', 'ICR 100408078 did not show up in review queue', 1659)
Setting Load (0.0ms) SELECT * FROM `settings` WHERE (`settings`.`name` = 'notified_events') LIMIT 1
Setting Load (0.0ms) SELECT * FROM `settings` WHERE (`settings`.`name` = 'default_language') LIMIT 1
Setting Load (0.0ms) SELECT * FROM `settings` WHERE (`settings`.`name` = 'mail_from') LIMIT 1
Setting Load (0.0ms) SELECT * FROM `settings` WHERE (`settings`.`name` = 'host_name') LIMIT 1
Setting Load (0.0ms) SELECT * FROM `settings` WHERE (`settings`.`name` = 'app_title') LIMIT 1
Issue Load (0.0ms) SELECT * FROM `issues` WHERE (`issues`.`id` = 813) 
Project Load (0.0ms) SELECT * FROM `projects` WHERE (`projects`.`id` = 2) 
User Load (0.0ms) SELECT * FROM `users` WHERE (`users`.`id` = 69) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 
Member Load Including Associations (0.0ms) SELECT `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)) 
EnabledModule Load (0.0ms) SELECT * FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 2) 
Member Load Including Associations (31.0ms) SELECT `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
Watcher Load (109.0ms) SELECT * FROM `watchers` WHERE (`watchers`.watchable_id = 813 AND `watchers`.watchable_type = 'Issue') 
Watcher Columns (16.0ms) SHOW FIELDS FROM `watchers`
CACHE (0.0ms) SELECT * FROM `users` WHERE (`users`.`id` = 69) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 
CACHE (0.0ms) SELECT `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
Tracker Load (0.0ms) SELECT * FROM `trackers` WHERE (`trackers`.`id` = 1) 
Setting Load (0.0ms) SELECT * FROM `settings` WHERE (`settings`.`name` = 'protocol') LIMIT 1
Setting Load (0.0ms) SELECT * FROM `settings` WHERE (`settings`.`name` = 'plain_text_mail') LIMIT 1
Setting Load (0.0ms) SELECT * FROM `settings` WHERE (`settings`.`name` = 'user_format') LIMIT 1
IssueStatus Load (0.0ms) SELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` = 1) 
IssuePriority Load (0.0ms) SELECT * FROM `enumerations` WHERE (`enumerations`.`id` = 4) AND ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC
CustomValue Load Including Associations (16.0ms) SELECT `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
Rendered mailer/_issue_text_plain (32.0ms)
Setting Load (0.0ms) SELECT * FROM `settings` WHERE (`settings`.`name` = 'emails_footer') LIMIT 1
Attachment Load (297.0ms) SELECT * FROM `attachments` WHERE (`attachments`.container_id = 813 AND `attachments`.container_type = 'Issue') ORDER BY attachments.created_on
Setting Load (15.0ms) SELECT * FROM `settings` WHERE (`settings`.`name` = 'text_formatting') LIMIT 1
Rendered mailer/_issue_text_html (3109.0ms)
UserPreference Load (0.0ms) SELECT * FROM `user_preferences` WHERE (`user_preferences`.user_id = 10) LIMIT 1
UserPreference Columns (0.0ms) SHOW FIELDS FROM `user_preferences`
Setting Load (0.0ms) SELECT * FROM `settings` WHERE (`settings`.`name` = 'bcc_recipients') LIMIT 1
CACHE (0.0ms) SELECT * FROM `issues` WHERE (`issues`.`id` = 813) 
IssueRelation Load (0.0ms) SELECT * FROM `issue_relations` WHERE (`issue_relations`.issue_from_id = 813) 
CACHE (0.0ms) SELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` = 1) 
SQL (0.0ms) COMMIT
SQL (0.0ms) BEGIN
CustomField Load (0.0ms) SELECT * FROM `custom_fields` WHERE (type = 'TimeEntryCustomField') ORDER BY position
CACHE (0.0ms) SELECT * FROM `projects` WHERE (`projects`.`id` = 2) 
SQL (0.0ms) ROLLBACK
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"}
SQL (0.0ms) SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 
User Load (0.0ms) SELECT * FROM `users` WHERE (`users`.`id` = 10) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 
Project Load (0.0ms) SELECT * FROM `projects` WHERE (`projects`.`identifier` = 'prime') LIMIT 1
EnabledModule Load (0.0ms) SELECT * FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 2) 
Member Load Including Associations (16.0ms) SELECT `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
Query Columns (31.0ms) SHOW FIELDS FROM `queries`
Tracker Load Including Associations (62.0ms) SELECT `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
IssueStatus Load (0.0ms) SELECT * FROM `issue_statuses` ORDER BY position
IssuePriority Load (0.0ms) SELECT * FROM `enumerations` WHERE ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC
User Load (0.0ms) SELECT `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' ) ) 
IssueCategory Columns (47.0ms) SHOW FIELDS FROM `issue_categories`
SQL (15.0ms) SELECT count() AS count_all FROM `issue_categories` WHERE (`issue_categories`.project_id = 2) 
Project Load (0.0ms) SELECT * FROM `projects` WHERE (projects.`lft` <= 293 AND projects.`rgt` >= 294) ORDER BY `lft` LIMIT 1
CACHE (0.0ms) SELECT * FROM `projects` WHERE (projects.`lft` <= 293 AND projects.`rgt` >= 294) ORDER BY `lft` LIMIT 1
Version Columns (79.0ms) SHOW FIELDS FROM `versions`
SQL (0.0ms) SELECT 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')))) 
Version Load Including Associations (15.0ms) SELECT `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')))) 
SQL (0.0ms) SELECT count(
) AS count_all FROM `projects` WHERE (((projects.status = 1) AND (projects.id != 2)) AND (projects.`lft` >= 293 AND projects.`rgt` <= 294)) 
IssueCustomField Load (0.0ms) SELECT * FROM `custom_fields` WHERE (is_for_all=1) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY position
IssueCustomField Load (16.0ms) SELECT * 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
Setting Load (0.0ms) SELECT * FROM `settings` WHERE (`settings`.`name` = 'per_page_options') LIMIT 1
CACHE (0.0ms) SELECT count() AS count_all FROM `projects` WHERE (((projects.status = 1) AND (projects.id != 2)) AND (projects.`lft` >= 293 AND projects.`rgt` <= 294)) 
Role Load (0.0ms) SELECT * FROM `roles` WHERE (`roles`.`builtin` = 1) LIMIT 1
SQL (172.0ms) SELECT 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)))) 
CACHE (0.0ms) SELECT count(
) AS count_all FROM `projects` WHERE (((projects.status = 1) AND (projects.id != 2)) AND (projects.`lft` >= 293 AND projects.`rgt` <= 294)) 
CACHE (0.0ms) SELECT * FROM `roles` WHERE (`roles`.`builtin` = 1) LIMIT 1
Issue Load Including Associations (16.0ms) SELECT `issues`.`id` AS t0_r0, `issues`.`tracker_id` AS t0_r1, `issues`.`project_id` AS t0_r2, `issues`.`subject` AS t0_r3, `issues`.`description` AS t0_r4, `issues`.`due_date` AS t0_r5, `issues`.`category_id` AS t0_r6, `issues`.`status_id` AS t0_r7, `issues`.`assigned_to_id` AS t0_r8, `issues`.`priority_id` AS t0_r9, `issues`.`fixed_version_id` AS t0_r10, `issues`.`author_id` AS t0_r11, `issues`.`lock_version` AS t0_r12, `issues`.`created_on` AS t0_r13, `issues`.`updated_on` AS t0_r14, `issues`.`start_date` AS t0_r15, `issues`.`done_ratio` AS t0_r16, `issues`.`estimated_hours` AS t0_r17, `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
Rendering template within layouts/base
Rendering issues/index.rhtml
Rendered queries/_filters (78.0ms)
Setting Load (0.0ms) SELECT * FROM `settings` WHERE (`settings`.`name` = 'issue_list_default_columns') LIMIT 1
Rendered queries/_columns (0.0ms)
UserPreference Load (0.0ms) SELECT * FROM `user_preferences` WHERE (`user_preferences`.user_id = 10) LIMIT 1
Setting Load (0.0ms) SELECT * FROM `settings` WHERE (`settings`.`name` = 'time_format') LIMIT 1
Rendered issues/_list (594.0ms)
Token Load (0.0ms) SELECT * FROM `tokens` WHERE (`tokens`.user_id = 10 AND (action='feeds')) LIMIT 1
Token Columns (0.0ms) SHOW FIELDS FROM `tokens`
Query Load (0.0ms) SELECT 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
Rendered issues/_sidebar (32.0ms)
Setting Load (15.0ms) SELECT * FROM `settings` WHERE (`settings`.`name` = 'ui_theme') LIMIT 1
Project Load (0.0ms) SELECT `projects`.* FROM `projects` INNER JOIN `members` ON `projects`.id = `members`.project_id WHERE ((`members`.user_id = 10) AND ((projects.status=1))) 
SQL (0.0ms) SELECT 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)) 
Project Load (0.0ms) SELECT * 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`
Wiki Load (47.0ms) SELECT * FROM `wikis` WHERE (`wikis`.project_id = 2) LIMIT 1
Board Columns (94.0ms) SHOW FIELDS FROM `boards`
SQL (0.0ms) SELECT count(
) AS count_all FROM `boards` WHERE (`boards`.project_id = 2) 
Repository Load (47.0ms) SELECT * FROM `repositories` WHERE (`repositories`.project_id = 2) LIMIT 1
Repository Columns (16.0ms) SHOW FIELDS FROM `repositories`
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"}
SQL (15.0ms) SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 
User Load (0.0ms) SELECT * FROM `users` WHERE (`users`.`id` = 10) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 
Issue Load (0.0ms) SELECT * FROM `issues` WHERE (`issues`.`id` = 813) 
Project Load (0.0ms) SELECT * FROM `projects` WHERE (`projects`.`id` = 2) 
Tracker Load (0.0ms) SELECT * FROM `trackers` WHERE (`trackers`.`id` = 1) 
IssueStatus Load (0.0ms) SELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` = 1) 
User Load (0.0ms) SELECT * FROM `users` WHERE (`users`.`id` = 69) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 
IssuePriority Load (0.0ms) SELECT * FROM `enumerations` WHERE (`enumerations`.`id` = 4) AND ( (`enumerations`.`type` = 'IssuePriority' ) ) 
EnabledModule Load (0.0ms) SELECT * FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 2) 
Member Load Including Associations (16.0ms) SELECT `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
Journal Load (0.0ms) SELECT * FROM `journals` WHERE (`journals`.journalized_id = 813 AND `journals`.journalized_type = 'Issue') ORDER BY journals.created_on ASC
User Load (0.0ms) SELECT * FROM `users` WHERE (`users`.`id` = 10) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 
JournalDetail Load (0.0ms) SELECT `journal_details`.* FROM `journal_details` WHERE (`journal_details`.journal_id = 1659) 
UserPreference Load (0.0ms) SELECT * FROM `user_preferences` WHERE (`user_preferences`.user_id = 10) LIMIT 1
Role Load (0.0ms) SELECT * FROM `roles` WHERE (`roles`.`builtin` = 1) LIMIT 1
Changeset Columns (172.0ms) SHOW FIELDS FROM `changesets`
Changeset Load Including Associations (47.0ms) SELECT `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
Workflow Load (0.0ms) SELECT * FROM `workflows` WHERE (`workflows`.old_status_id = 1 AND (`workflows`.`tracker_id` = 1 AND `workflows`.`role_id` IN (4))) 
IssueStatus Load (0.0ms) SELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` IN (6,7,8,9,1,2,3,4,5)) 
IssueRelation Load (0.0ms) SELECT * FROM `issue_relations` WHERE (`issue_relations`.issue_to_id = 813) 
IssuePriority Load (0.0ms) SELECT * FROM `enumerations` WHERE ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC
TimeEntryActivity Load (0.0ms) SELECT * FROM `enumerations` WHERE (`enumerations`.`is_default` = 1) AND ( (`enumerations`.`type` = 'TimeEntryActivity' ) ) ORDER BY enumerations.position ASC LIMIT 1
Rendering template within layouts/base
Rendering issues/show.rhtml
Watcher Load (0.0ms) SELECT * FROM `watchers` WHERE (`watchers`.watchable_id = 813 AND `watchers`.watchable_type = 'Issue') 
Rendered issues/_action_menu (31.0ms)
Setting Load (0.0ms) SELECT * FROM `settings` WHERE (`settings`.`name` = 'gravatar_enabled') LIMIT 1
SQL (0.0ms) SELECT sum(`time_entries`.hours) AS sum_hours FROM `time_entries` WHERE (`time_entries`.issue_id = 813) 
IssueCustomField Load (0.0ms) SELECT * FROM `custom_fields` WHERE (is_for_all=1) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY position
IssueCustomField Load (0.0ms) SELECT * 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
IssueCustomField Load (0.0ms) SELECT `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
IssueCustomField Load (0.0ms) SELECT `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
IssueCustomField Load (0.0ms) SELECT `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
IssueCustomField Load (0.0ms) SELECT `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
IssueCustomField Load (0.0ms) SELECT `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
IssueCustomField Load (0.0ms) SELECT `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
IssueCustomField Load (0.0ms) SELECT `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
IssueCustomField Load (0.0ms) SELECT `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
IssueCustomField Load (0.0ms) SELECT `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
IssueCustomField Load (0.0ms) SELECT `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
IssueCustomField Load (0.0ms) SELECT `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
CustomValue Load Including Associations (15.0ms) SELECT `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
Attachment Load (16.0ms) SELECT * FROM `attachments` WHERE (`attachments`.container_id = 813 AND `attachments`.container_type = 'Issue') ORDER BY attachments.created_on
IssueRelation Load (0.0ms) SELECT * FROM `issue_relations` WHERE (`issue_relations`.issue_from_id = 813) 
Rendered issue_relations/_form (0.0ms)
Rendered issues/_relations (0.0ms)
User Load (0.0ms) SELECT `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' ) ) 
Rendered watchers/_watchers (16.0ms)
Rendered issues/_history (0.0ms)
Rendered issues/_action_menu (0.0ms)
projects_trackers Columns (0.0ms) SHOW FIELDS FROM `projects_trackers`
Tracker Load (47.0ms) SELECT * FROM `trackers` INNER JOIN `projects_trackers` ON `trackers`.id = `projects_trackers`.tracker_id WHERE (`projects_trackers`.project_id = 2 ) ORDER BY trackers.position
Member Load Including Associations (0.0ms) SELECT `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)) 
SQL (0.0ms) SELECT count() AS count_all FROM `issue_categories` WHERE (`issue_categories`.project_id = 2) 
Project Load (0.0ms) SELECT * FROM `projects` WHERE (projects.`lft` <= 293 AND projects.`rgt` >= 294) ORDER BY `lft` LIMIT 1
CACHE (0.0ms) SELECT * FROM `projects` WHERE (projects.`lft` <= 293 AND projects.`rgt` >= 294) ORDER BY `lft` LIMIT 1
Version Load (0.0ms) SELECT * FROM `versions` WHERE (`versions`.`id` IS NULL) LIMIT 1
Version Load Including Associations (0.0ms) SELECT `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'))))) 
Setting Load (0.0ms) SELECT * FROM `settings` WHERE (`settings`.`name` = 'start_of_week') LIMIT 1
Rendered issues/_form_custom_fields (0.0ms)
Rendered issues/_attributes (31.0ms)
Rendered issues/_form (94.0ms)
TimeEntryActivity Load (0.0ms) SELECT * FROM `enumerations` WHERE (`enumerations`.project_id = 2) AND ( (`enumerations`.`type` = 'TimeEntryActivity' ) ) ORDER BY enumerations.position ASC
TimeEntryActivity Load (0.0ms) SELECT * FROM `enumerations` WHERE ((`enumerations`.`project_id` IS NULL AND `enumerations`.`active` = 1)) AND ( (`enumerations`.`type` = 'TimeEntryActivity' ) ) ORDER BY enumerations.position ASC
CustomField Load (0.0ms) SELECT * FROM `custom_fields` WHERE (type = 'TimeEntryCustomField') ORDER BY position
Setting Load (0.0ms) SELECT * FROM `settings` WHERE (`settings`.`name` = 'attachment_max_size') LIMIT 1
Rendered attachments/_form (0.0ms)
Rendered issues/_edit (171.0ms)
Token Load (0.0ms) SELECT * FROM `tokens` WHERE (`tokens`.user_id = 10 AND (action='feeds')) LIMIT 1
Query Load (0.0ms) SELECT 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
Rendered issues/_sidebar (0.0ms)
Project Load (0.0ms) SELECT `projects`.
FROM `projects` INNER JOIN `members` ON `projects`.id = `members`.project_id WHERE ((`members`.user_id = 10) AND ((projects.status=1))) 
SQL (0.0ms) SELECT 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)) 
Project Load (0.0ms) SELECT * 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`
SQL (0.0ms) SELECT 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')))) 
Wiki Load (0.0ms) SELECT * FROM `wikis` WHERE (`wikis`.project_id = 2) LIMIT 1
SQL (0.0ms) SELECT count(
) AS count_all FROM `boards` WHERE (`boards`.project_id = 2) 
Repository Load (0.0ms) SELECT * FROM `repositories` WHERE (`repositories`.project_id = 2) LIMIT 1
Completed in 3937ms (View: 3422, DB: 328) | 200 OK [http://wit390/redmine/issues/813]
SQL (0.0ms) SET SQL_AUTO_IS_NULL=0

Processing WelcomeController#index (for 10.29.96.8 at 2010-05-06 14:39:23) [GET]
Parameters: {"action"=>"index", "controller"=>"welcome"}
Setting Columns (31.0ms) SHOW FIELDS FROM `settings`
SQL (0.0ms) SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 
User Columns (0.0ms) SHOW FIELDS FROM `users`
User Load (0.0ms) SELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 
News Columns (46.0ms) SHOW FIELDS FROM `news`
Project Columns (16.0ms) SHOW FIELDS FROM `projects`
News Load Including Associations (15.0ms) SELECT `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
Project Load (0.0ms) SELECT * FROM `projects` WHERE (projects.status=1) ORDER BY created_on DESC LIMIT 5
Rendering template within layouts/base
Rendering welcome/index
Setting Load (0.0ms) SELECT * FROM `settings` WHERE (`settings`.`name` = 'welcome_text') LIMIT 1
Setting Load (0.0ms) SELECT * FROM `settings` WHERE (`settings`.`name` = 'user_format') LIMIT 1
UserPreference Load (16.0ms) SELECT * FROM `user_preferences` WHERE (`user_preferences`.user_id = 3) LI

#4 Updated by Jon Lumpkin over 11 years ago

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


# Logfile created on Thu May 06 14:35:12 -0400 2010  SQL (0.0ms)   SET SQL_AUTO_IS_NULL=0

Processing WelcomeController#index (for 10.29.96.8 at 2010-05-06 14:35:25) [GET]
  Parameters: {"action"=>"index", "controller"=>"welcome"}
  Setting Columns (46.0ms)   SHOW FIELDS FROM `settings`
  SQL (0.0ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 
  User Columns (31.0ms)   SHOW FIELDS FROM `users`
  User Load (0.0ms)   SELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 
  News Columns (47.0ms)   SHOW FIELDS FROM `news`
  Project Columns (46.0ms)   SHOW FIELDS FROM `projects`
  News Load Including Associations (141.0ms)   SELECT `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
  Project Load (16.0ms)   SELECT * FROM `projects` WHERE (projects.status=1) ORDER BY created_on DESC LIMIT 5
Rendering template within layouts/base
Rendering welcome/index
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'welcome_text') LIMIT 1
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'user_format') LIMIT 1
  UserPreference Load (0.0ms)   SELECT * FROM `user_preferences` WHERE (`user_preferences`.user_id = 3) LIMIT 1
  UserPreference Columns (16.0ms)   SHOW FIELDS FROM `user_preferences`
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'time_format') LIMIT 1
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)
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'text_formatting') LIMIT 1
  Token Load (47.0ms)   SELECT * FROM `tokens` WHERE (`tokens`.user_id = 3 AND (action='feeds')) LIMIT 1
  Token Columns (16.0ms)   SHOW FIELDS FROM `tokens`
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'app_title') LIMIT 1
  Setting Load (15.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'ui_theme') LIMIT 1
  Project Load (125.0ms)   SELECT `projects`.* FROM `projects` INNER JOIN `members` ON `projects`.id = `members`.project_id WHERE ((`members`.user_id = 3) AND ((projects.status=1))) 
Completed in 1750ms (View: 1078, DB: 546) | 200 OK [http://wit390/redmine/]
  SQL (0.0ms)   SET SQL_AUTO_IS_NULL=0

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"=>""}}}
  Setting Columns (16.0ms)   SHOW FIELDS FROM `settings`
  SQL (0.0ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 
  User Columns (0.0ms)   SHOW FIELDS FROM `users`
  User Load (0.0ms)   SELECT * FROM `users` WHERE (`users`.`id` = 10) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 
  Issue Columns (219.0ms)   SHOW FIELDS FROM `issues`
  Issue Load (47.0ms)   SELECT * FROM `issues` WHERE (`issues`.`id` = 813) 
  Project Columns (47.0ms)   SHOW FIELDS FROM `projects`
  Project Load (0.0ms)   SELECT * FROM `projects` WHERE (`projects`.`id` = 2) 
  Tracker Columns (47.0ms)   SHOW FIELDS FROM `trackers`
  Tracker Load (15.0ms)   SELECT * FROM `trackers` WHERE (`trackers`.`id` = 1) 
  IssueStatus Columns (94.0ms)   SHOW FIELDS FROM `issue_statuses`
  IssueStatus Load (0.0ms)   SELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` = 1) 
  User Load (0.0ms)   SELECT * FROM `users` WHERE (`users`.`id` = 69) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 
  IssuePriority Columns (47.0ms)   SHOW FIELDS FROM `enumerations`
  IssuePriority Load (0.0ms)   SELECT * FROM `enumerations` WHERE (`enumerations`.`id` = 4) AND ( (`enumerations`.`type` = 'IssuePriority' ) ) 
  EnabledModule Load (0.0ms)   SELECT * FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 2) 
  EnabledModule Columns (0.0ms)   SHOW FIELDS FROM `enabled_modules`
  Member Columns (0.0ms)   SHOW FIELDS FROM `members`
  Role Columns (31.0ms)   SHOW FIELDS FROM `roles`
  Member Load Including Associations (203.0ms)   SELECT `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
  Workflow Load (187.0ms)   SELECT * FROM `workflows` WHERE (`workflows`.old_status_id = 1 AND (`workflows`.`tracker_id` = 1 AND `workflows`.`role_id` IN (4))) 
  Workflow Columns (16.0ms)   SHOW FIELDS FROM `workflows`
  IssueStatus Load (0.0ms)   SELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` IN (6,7,8,9,1,2,3,4,5)) 
  IssueRelation Load (47.0ms)   SELECT * FROM `issue_relations` WHERE (`issue_relations`.issue_to_id = 813) 
  IssuePriority Load (0.0ms)   SELECT * FROM `enumerations` WHERE ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC
  TimeEntry Columns (62.0ms)   SHOW FIELDS FROM `time_entries`
  TimeEntryActivity Columns (15.0ms)   SHOW FIELDS FROM `enumerations`
  TimeEntryActivity Load (0.0ms)   SELECT * FROM `enumerations` WHERE (`enumerations`.`is_default` = 1) AND ( (`enumerations`.`type` = 'TimeEntryActivity' ) ) ORDER BY enumerations.position ASC LIMIT 1
  Journal Columns (313.0ms)   SHOW FIELDS FROM `journals`
  IssueStatus Load (0.0ms)   SELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` = 0) 
  IssueStatus Load (0.0ms)   SELECT * FROM `issue_statuses` WHERE (is_default=1) LIMIT 1
  IssuePriority Load (0.0ms)   SELECT * FROM `enumerations` WHERE (`enumerations`.`id` = 0) AND ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC
  IssuePriority Load (0.0ms)   SELECT * FROM `enumerations` WHERE (`enumerations`.`is_default` = 1) AND ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC LIMIT 1
  CustomValue Columns (375.0ms)   SHOW FIELDS FROM `custom_values`
  CustomField Columns (109.0ms)   SHOW FIELDS FROM `custom_fields`
  CustomValue Load Including Associations (16.0ms)   SELECT `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
  CACHE (0.0ms)   SELECT * FROM `trackers` WHERE (`trackers`.`id` = 1) 
  IssueCustomField Columns (15.0ms)   SHOW FIELDS FROM `custom_fields`
  IssueCustomField Load (0.0ms)   SELECT * FROM `custom_fields` WHERE (is_for_all=1) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY position
  custom_fields_projects Columns (47.0ms)   SHOW FIELDS FROM `custom_fields_projects`
  IssueCustomField Load (16.0ms)   SELECT * 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
  IssueCustomField Load (0.0ms)   SELECT `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
  IssueCustomField Load (0.0ms)   SELECT `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
  IssueCustomField Load (0.0ms)   SELECT `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
  IssueCustomField Load (0.0ms)   SELECT `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
  IssueCustomField Load (0.0ms)   SELECT `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
  IssueCustomField Load (0.0ms)   SELECT `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
  IssueCustomField Load (0.0ms)   SELECT `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
  IssueCustomField Load (0.0ms)   SELECT `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
  IssueCustomField Load (0.0ms)   SELECT `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
  IssueCustomField Load (0.0ms)   SELECT `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
  IssueCustomField Load (0.0ms)   SELECT `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
  CACHE (0.0ms)   SELECT * FROM `enumerations` WHERE (`enumerations`.`is_default` = 1) AND ( (`enumerations`.`type` = 'TimeEntryActivity' ) ) ORDER BY enumerations.position ASC LIMIT 1
  IssuePriority Load (0.0ms)   SELECT * FROM `enumerations` WHERE (`enumerations`.`id` = 4) AND ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC
  CACHE (0.0ms)   SELECT * FROM `trackers` WHERE (`trackers`.`id` = 1) 
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'issue_done_ratio') LIMIT 1
  SQL (0.0ms)   BEGIN
  Issue Update with optimistic locking (0.0ms)    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

  IssueCustomField Load (0.0ms)   SELECT `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
  IssueCustomField Load (0.0ms)   SELECT `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
  IssueCustomField Load (0.0ms)   SELECT `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
  IssueCustomField Load (0.0ms)   SELECT `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
  IssueCustomField Load (0.0ms)   SELECT `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
  IssueCustomField Load (0.0ms)   SELECT `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
  IssueCustomField Load (0.0ms)   SELECT `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
  IssueCustomField Load (0.0ms)   SELECT `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
  IssueCustomField Load (0.0ms)   SELECT `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
  IssueCustomField Load (0.0ms)   SELECT `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
  IssueCustomField Load (0.0ms)   SELECT `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
  JournalDetail Columns (391.0ms)   SHOW FIELDS FROM `journal_details`
  Journal Create (31.0ms)   INSERT INTO `journals` (`created_on`, `notes`, `user_id`, `journalized_type`, `journalized_id`) VALUES('2010-05-06 14:37:05', '', 10, 'Issue', 813)
  JournalDetail Create (0.0ms)   INSERT 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)
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'notified_events') LIMIT 1
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'default_language') LIMIT 1
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'mail_from') LIMIT 1
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'host_name') LIMIT 1
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'app_title') LIMIT 1
  Issue Load (0.0ms)   SELECT * FROM `issues` WHERE (`issues`.`id` = 813) 
  Project Load (0.0ms)   SELECT * FROM `projects` WHERE (`projects`.`id` = 2) 
  User Load (0.0ms)   SELECT * FROM `users` WHERE (`users`.`id` = 69) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 
  Member Load Including Associations (0.0ms)   SELECT `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)) 
  EnabledModule Load (0.0ms)   SELECT * FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 2) 
  Member Load Including Associations (31.0ms)   SELECT `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
  Watcher Load (109.0ms)   SELECT * FROM `watchers` WHERE (`watchers`.watchable_id = 813 AND `watchers`.watchable_type = 'Issue') 
  Watcher Columns (16.0ms)   SHOW FIELDS FROM `watchers`
  CACHE (0.0ms)   SELECT * FROM `users` WHERE (`users`.`id` = 69) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 
  CACHE (0.0ms)   SELECT `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
  Tracker Load (0.0ms)   SELECT * FROM `trackers` WHERE (`trackers`.`id` = 1) 
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'protocol') LIMIT 1
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'plain_text_mail') LIMIT 1
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'user_format') LIMIT 1
  IssueStatus Load (0.0ms)   SELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` = 1) 
  IssuePriority Load (0.0ms)   SELECT * FROM `enumerations` WHERE (`enumerations`.`id` = 4) AND ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC
  CustomValue Load Including Associations (16.0ms)   SELECT `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
Rendered mailer/_issue_text_plain (32.0ms)
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'emails_footer') LIMIT 1
  Attachment Load (297.0ms)   SELECT * FROM `attachments` WHERE (`attachments`.container_id = 813 AND `attachments`.container_type = 'Issue') ORDER BY attachments.created_on
  Setting Load (15.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'text_formatting') LIMIT 1
Rendered mailer/_issue_text_html (3109.0ms)
  UserPreference Load (0.0ms)   SELECT * FROM `user_preferences` WHERE (`user_preferences`.user_id = 10) LIMIT 1
  UserPreference Columns (0.0ms)   SHOW FIELDS FROM `user_preferences`
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'bcc_recipients') LIMIT 1
  CACHE (0.0ms)   SELECT * FROM `issues` WHERE (`issues`.`id` = 813) 
  IssueRelation Load (0.0ms)   SELECT * FROM `issue_relations` WHERE (`issue_relations`.issue_from_id = 813) 
  CACHE (0.0ms)   SELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` = 1) 
  SQL (0.0ms)   COMMIT
  SQL (0.0ms)   BEGIN
  CustomField Load (0.0ms)   SELECT * FROM `custom_fields` WHERE (type = 'TimeEntryCustomField') ORDER BY position
  CACHE (0.0ms)   SELECT * FROM `projects` WHERE (`projects`.`id` = 2) 
  SQL (0.0ms)   ROLLBACK
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"}
  SQL (0.0ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 
  User Load (0.0ms)   SELECT * FROM `users` WHERE (`users`.`id` = 10) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 
  Project Load (0.0ms)   SELECT * FROM `projects` WHERE (`projects`.`identifier` = 'prime') LIMIT 1
  EnabledModule Load (0.0ms)   SELECT * FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 2) 
  Member Load Including Associations (16.0ms)   SELECT `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
  Query Columns (31.0ms)   SHOW FIELDS FROM `queries`
  Tracker Load Including Associations (62.0ms)   SELECT `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
  IssueStatus Load (0.0ms)   SELECT * FROM `issue_statuses` ORDER BY position
  IssuePriority Load (0.0ms)   SELECT * FROM `enumerations` WHERE ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC
  User Load (0.0ms)   SELECT `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' ) ) 
  IssueCategory Columns (47.0ms)   SHOW FIELDS FROM `issue_categories`
  SQL (15.0ms)   SELECT count(*) AS count_all FROM `issue_categories` WHERE (`issue_categories`.project_id = 2) 
  Project Load (0.0ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 293 AND projects.`rgt` >= 294) ORDER BY `lft` LIMIT 1
  CACHE (0.0ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 293 AND projects.`rgt` >= 294) ORDER BY `lft` LIMIT 1
  Version Columns (79.0ms)   SHOW FIELDS FROM `versions`
  SQL (0.0ms)   SELECT 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')))) 
  Version Load Including Associations (15.0ms)   SELECT `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')))) 
  SQL (0.0ms)   SELECT count(*) AS count_all FROM `projects` WHERE (((projects.status = 1) AND (projects.id != 2)) AND (projects.`lft` >= 293 AND projects.`rgt` <= 294)) 
  IssueCustomField Load (0.0ms)   SELECT * FROM `custom_fields` WHERE (is_for_all=1) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY position
  IssueCustomField Load (16.0ms)   SELECT * 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
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'per_page_options') LIMIT 1
  CACHE (0.0ms)   SELECT count(*) AS count_all FROM `projects` WHERE (((projects.status = 1) AND (projects.id != 2)) AND (projects.`lft` >= 293 AND projects.`rgt` <= 294)) 
  Role Load (0.0ms)   SELECT * FROM `roles` WHERE (`roles`.`builtin` = 1) LIMIT 1
  SQL (172.0ms)   SELECT 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)))) 
  CACHE (0.0ms)   SELECT count(*) AS count_all FROM `projects` WHERE (((projects.status = 1) AND (projects.id != 2)) AND (projects.`lft` >= 293 AND projects.`rgt` <= 294)) 
  CACHE (0.0ms)   SELECT * FROM `roles` WHERE (`roles`.`builtin` = 1) LIMIT 1
  Issue Load Including Associations (16.0ms)   SELECT `issues`.`id` AS t0_r0, `issues`.`tracker_id` AS t0_r1, `issues`.`project_id` AS t0_r2, `issues`.`subject` AS t0_r3, `issues`.`description` AS t0_r4, `issues`.`due_date` AS t0_r5, `issues`.`category_id` AS t0_r6, `issues`.`status_id` AS t0_r7, `issues`.`assigned_to_id` AS t0_r8, `issues`.`priority_id` AS t0_r9, `issues`.`fixed_version_id` AS t0_r10, `issues`.`author_id` AS t0_r11, `issues`.`lock_version` AS t0_r12, `issues`.`created_on` AS t0_r13, `issues`.`updated_on` AS t0_r14, `issues`.`start_date` AS t0_r15, `issues`.`done_ratio` AS t0_r16, `issues`.`estimated_hours` AS t0_r17, `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
Rendering template within layouts/base
Rendering issues/index.rhtml
Rendered queries/_filters (78.0ms)
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'issue_list_default_columns') LIMIT 1
Rendered queries/_columns (0.0ms)
  UserPreference Load (0.0ms)   SELECT * FROM `user_preferences` WHERE (`user_preferences`.user_id = 10) LIMIT 1
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'time_format') LIMIT 1
Rendered issues/_list (594.0ms)
  Token Load (0.0ms)   SELECT * FROM `tokens` WHERE (`tokens`.user_id = 10 AND (action='feeds')) LIMIT 1
  Token Columns (0.0ms)   SHOW FIELDS FROM `tokens`
  Query Load (0.0ms)   SELECT 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
Rendered issues/_sidebar (32.0ms)
  Setting Load (15.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'ui_theme') LIMIT 1
  Project Load (0.0ms)   SELECT `projects`.* FROM `projects` INNER JOIN `members` ON `projects`.id = `members`.project_id WHERE ((`members`.user_id = 10) AND ((projects.status=1))) 
  SQL (0.0ms)   SELECT 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)) 
  Project Load (0.0ms)   SELECT * 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`
  Wiki Load (47.0ms)   SELECT * FROM `wikis` WHERE (`wikis`.project_id = 2) LIMIT 1
  Board Columns (94.0ms)   SHOW FIELDS FROM `boards`
  SQL (0.0ms)   SELECT count(*) AS count_all FROM `boards` WHERE (`boards`.project_id = 2) 
  Repository Load (47.0ms)   SELECT * FROM `repositories` WHERE (`repositories`.project_id = 2) LIMIT 1
  Repository Columns (16.0ms)   SHOW FIELDS FROM `repositories`
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"}
  SQL (15.0ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 
  User Load (0.0ms)   SELECT * FROM `users` WHERE (`users`.`id` = 10) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 
  Issue Load (0.0ms)   SELECT * FROM `issues` WHERE (`issues`.`id` = 813) 
  Project Load (0.0ms)   SELECT * FROM `projects` WHERE (`projects`.`id` = 2) 
  Tracker Load (0.0ms)   SELECT * FROM `trackers` WHERE (`trackers`.`id` = 1) 
  IssueStatus Load (0.0ms)   SELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` = 1) 
  User Load (0.0ms)   SELECT * FROM `users` WHERE (`users`.`id` = 69) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 
  IssuePriority Load (0.0ms)   SELECT * FROM `enumerations` WHERE (`enumerations`.`id` = 4) AND ( (`enumerations`.`type` = 'IssuePriority' ) ) 
  EnabledModule Load (0.0ms)   SELECT * FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 2) 
  Member Load Including Associations (16.0ms)   SELECT `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
  Journal Load (0.0ms)   SELECT * FROM `journals` WHERE (`journals`.journalized_id = 813 AND `journals`.journalized_type = 'Issue') ORDER BY journals.created_on ASC
  User Load (0.0ms)   SELECT * FROM `users` WHERE (`users`.`id` = 10) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 
  JournalDetail Load (0.0ms)   SELECT `journal_details`.* FROM `journal_details` WHERE (`journal_details`.journal_id = 1659) 
  UserPreference Load (0.0ms)   SELECT * FROM `user_preferences` WHERE (`user_preferences`.user_id = 10) LIMIT 1
  Role Load (0.0ms)   SELECT * FROM `roles` WHERE (`roles`.`builtin` = 1) LIMIT 1
  Changeset Columns (172.0ms)   SHOW FIELDS FROM `changesets`
  Changeset Load Including Associations (47.0ms)   SELECT `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
  Workflow Load (0.0ms)   SELECT * FROM `workflows` WHERE (`workflows`.old_status_id = 1 AND (`workflows`.`tracker_id` = 1 AND `workflows`.`role_id` IN (4))) 
  IssueStatus Load (0.0ms)   SELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` IN (6,7,8,9,1,2,3,4,5)) 
  IssueRelation Load (0.0ms)   SELECT * FROM `issue_relations` WHERE (`issue_relations`.issue_to_id = 813) 
  IssuePriority Load (0.0ms)   SELECT * FROM `enumerations` WHERE ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC
  TimeEntryActivity Load (0.0ms)   SELECT * FROM `enumerations` WHERE (`enumerations`.`is_default` = 1) AND ( (`enumerations`.`type` = 'TimeEntryActivity' ) ) ORDER BY enumerations.position ASC LIMIT 1
Rendering template within layouts/base
Rendering issues/show.rhtml
  Watcher Load (0.0ms)   SELECT * FROM `watchers` WHERE (`watchers`.watchable_id = 813 AND `watchers`.watchable_type = 'Issue') 
Rendered issues/_action_menu (31.0ms)
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'gravatar_enabled') LIMIT 1
  SQL (0.0ms)   SELECT sum(`time_entries`.hours) AS sum_hours FROM `time_entries` WHERE (`time_entries`.issue_id = 813) 
  IssueCustomField Load (0.0ms)   SELECT * FROM `custom_fields` WHERE (is_for_all=1) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY position
  IssueCustomField Load (0.0ms)   SELECT * 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
  IssueCustomField Load (0.0ms)   SELECT `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
  IssueCustomField Load (0.0ms)   SELECT `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
  IssueCustomField Load (0.0ms)   SELECT `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
  IssueCustomField Load (0.0ms)   SELECT `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
  IssueCustomField Load (0.0ms)   SELECT `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
  IssueCustomField Load (0.0ms)   SELECT `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
  IssueCustomField Load (0.0ms)   SELECT `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
  IssueCustomField Load (0.0ms)   SELECT `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
  IssueCustomField Load (0.0ms)   SELECT `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
  IssueCustomField Load (0.0ms)   SELECT `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
  IssueCustomField Load (0.0ms)   SELECT `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
  CustomValue Load Including Associations (15.0ms)   SELECT `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
  Attachment Load (16.0ms)   SELECT * FROM `attachments` WHERE (`attachments`.container_id = 813 AND `attachments`.container_type = 'Issue') ORDER BY attachments.created_on
  IssueRelation Load (0.0ms)   SELECT * FROM `issue_relations` WHERE (`issue_relations`.issue_from_id = 813) 
Rendered issue_relations/_form (0.0ms)
Rendered issues/_relations (0.0ms)
  User Load (0.0ms)   SELECT `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' ) ) 
Rendered watchers/_watchers (16.0ms)
Rendered issues/_history (0.0ms)
Rendered issues/_action_menu (0.0ms)
  projects_trackers Columns (0.0ms)   SHOW FIELDS FROM `projects_trackers`
  Tracker Load (47.0ms)   SELECT * FROM `trackers` INNER JOIN `projects_trackers` ON `trackers`.id = `projects_trackers`.tracker_id WHERE (`projects_trackers`.project_id = 2 ) ORDER BY trackers.position
  Member Load Including Associations (0.0ms)   SELECT `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)) 
  SQL (0.0ms)   SELECT count(*) AS count_all FROM `issue_categories` WHERE (`issue_categories`.project_id = 2) 
  Project Load (0.0ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 293 AND projects.`rgt` >= 294) ORDER BY `lft` LIMIT 1
  CACHE (0.0ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 293 AND projects.`rgt` >= 294) ORDER BY `lft` LIMIT 1
  Version Load (0.0ms)   SELECT * FROM `versions` WHERE (`versions`.`id` IS NULL) LIMIT 1
  Version Load Including Associations (0.0ms)   SELECT `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'))))) 
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'start_of_week') LIMIT 1
Rendered issues/_form_custom_fields (0.0ms)
Rendered issues/_attributes (31.0ms)
Rendered issues/_form (94.0ms)
  TimeEntryActivity Load (0.0ms)   SELECT * FROM `enumerations` WHERE (`enumerations`.project_id = 2) AND ( (`enumerations`.`type` = 'TimeEntryActivity' ) ) ORDER BY enumerations.position ASC
  TimeEntryActivity Load (0.0ms)   SELECT * FROM `enumerations` WHERE ((`enumerations`.`project_id` IS NULL AND `enumerations`.`active` = 1)) AND ( (`enumerations`.`type` = 'TimeEntryActivity' ) ) ORDER BY enumerations.position ASC
  CustomField Load (0.0ms)   SELECT * FROM `custom_fields` WHERE (type = 'TimeEntryCustomField') ORDER BY position
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'attachment_max_size') LIMIT 1
Rendered attachments/_form (0.0ms)
Rendered issues/_edit (171.0ms)
  Token Load (0.0ms)   SELECT * FROM `tokens` WHERE (`tokens`.user_id = 10 AND (action='feeds')) LIMIT 1
  Query Load (0.0ms)   SELECT 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
Rendered issues/_sidebar (0.0ms)
  Project Load (0.0ms)   SELECT `projects`.* FROM `projects` INNER JOIN `members` ON `projects`.id = `members`.project_id WHERE ((`members`.user_id = 10) AND ((projects.status=1))) 
  SQL (0.0ms)   SELECT 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)) 
  Project Load (0.0ms)   SELECT * 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`
  SQL (0.0ms)   SELECT 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')))) 
  Wiki Load (0.0ms)   SELECT * FROM `wikis` WHERE (`wikis`.project_id = 2) LIMIT 1
  SQL (0.0ms)   SELECT count(*) AS count_all FROM `boards` WHERE (`boards`.project_id = 2) 
  Repository Load (0.0ms)   SELECT * FROM `repositories` WHERE (`repositories`.project_id = 2) LIMIT 1
Completed in 3937ms (View: 3422, DB: 328) | 200 OK [http://wit390/redmine/issues/813]
  SQL (0.0ms)   SET SQL_AUTO_IS_NULL=0

Processing WelcomeController#index (for 10.29.96.8 at 2010-05-06 14:39:23) [GET]
  Parameters: {"action"=>"index", "controller"=>"welcome"}
  Setting Columns (31.0ms)   SHOW FIELDS FROM `settings`
  SQL (0.0ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 
  User Columns (0.0ms)   SHOW FIELDS FROM `users`
  User Load (0.0ms)   SELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 
  News Columns (46.0ms)   SHOW FIELDS FROM `news`
  Project Columns (16.0ms)   SHOW FIELDS FROM `projects`
  News Load Including Associations (15.0ms)   SELECT `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
  Project Load (0.0ms)   SELECT * FROM `projects` WHERE (projects.status=1) ORDER BY created_on DESC LIMIT 5
Rendering template within layouts/base
Rendering welcome/index
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'welcome_text') LIMIT 1
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'user_format') LIMIT 1
  UserPreference Load (16.0ms)   SELECT * FRO

#5 Updated by Jon Lumpkin over 11 years ago

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

#6 Updated by Aaron Parks over 11 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

#7 Updated by Jon Lumpkin over 11 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.

#8 Updated by Jon Lumpkin over 11 years ago

  • Status changed from New to Resolved

#9 Updated by Etienne Massip over 10 years ago

  • Status changed from Resolved to Closed
  • Resolution set to Invalid

Also available in: Atom PDF