Redmine

Processing AccountController#login (for 110.34.4.242 at 2010-11-23 01:37:12) [GET]

  Parameters: {"back_url"=>"http://myserver.com/redmine/", "action"=>"login", "controller"=>"account"}

  SQL (0.1ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 

  AnonymousUser Load (0.1ms)   SELECT * FROM `users` WHERE ( (`users`.`type` = 'AnonymousUser' ) ) LIMIT 1

Rendering template within layouts/base

Rendering account/login

  Project Load (0.1ms)   SELECT `projects`.* FROM `projects` INNER JOIN `members` ON `projects`.id = `members`.project_id WHERE ((`members`.user_id = 2) AND ((projects.status=1))) 

Completed in 30ms (View: 27, DB: 0) | 200 OK [http://myserver.com/login?back_url=http%3A%2F%2Fmyserver.com%2Fredmine%2F]

  SQL (0.1ms)   SET NAMES 'utf8'

  SQL (0.1ms)   SET SQL_AUTO_IS_NULL=0

Processing WelcomeController#index (for 110.34.4.242 at 2010-11-23 01:38:22) [GET]

  Parameters: {"action"=>"index", "controller"=>"welcome"}

  Setting Columns (0.8ms)   SHOW FIELDS FROM `settings`

  SQL (0.1ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 

  Setting Load (0.1ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'rest_api_enabled') LIMIT 1

  AnonymousUser Columns (0.8ms)   SHOW FIELDS FROM `users`

  AnonymousUser Load (0.1ms)   SELECT * FROM `users` WHERE ( (`users`.`type` = 'AnonymousUser' ) ) LIMIT 1

  Setting Load (0.1ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'login_required') LIMIT 1

Redirected to http://myserver.com/redmine/login?back_url=http%3A%2F%2Fmyserver.com%2Fredmine%2F

Filter chain halted as [:check_if_login_required] rendered_or_redirected.

Completed in 9ms (DB: 2) | 302 Found [http://myserver.com/]

Processing AccountController#login (for 110.34.4.242 at 2010-11-23 01:38:27) [GET]

  Parameters: {"back_url"=>"http://myserver.com/redmine/", "action"=>"login", "controller"=>"account"}

  SQL (0.1ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 

  AnonymousUser Load (0.1ms)   SELECT * FROM `users` WHERE ( (`users`.`type` = 'AnonymousUser' ) ) LIMIT 1

Rendering template within layouts/base

Rendering account/login

  Setting Load (0.1ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'autologin') LIMIT 1

  Setting Load (0.1ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'lost_password') LIMIT 1

  Setting Load (0.1ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'app_title') LIMIT 1

  Setting Load (0.1ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'ui_theme') LIMIT 1

  Setting Load (0.1ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'text_formatting') LIMIT 1

  Setting Load (0.1ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'self_registration') LIMIT 1

  Project Load (0.1ms)   SELECT `projects`.* FROM `projects` INNER JOIN `members` ON `projects`.id = `members`.project_id WHERE ((`members`.user_id = 2) AND ((projects.status=1))) 

Completed in 55ms (View: 49, DB: 1) | 200 OK [http://myserver.com/login?back_url=http%3A%2F%2Fmyserver.com%2Fredmine%2F]

  SQL (0.1ms)   SET NAMES 'utf8'

  SQL (0.1ms)   SET SQL_AUTO_IS_NULL=0

Processing AccountController#login (for 110.34.4.242 at 2010-11-23 01:39:04) [POST]

  Parameters: {"back_url"=>"http%3A%2F%2Fmyserver.com%2Fredmine%2F", "action"=>"login", "authenticity_token"=>"YUb/zpoB6kO8+howtGoIlLI2LPypM5BSUtgp7aPZ2Mo=", "username"=>"gaurav", "controller"=>"account", "password"=>"[FILTERED]", "login"=>"Login ?"}

  SQL (0.1ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 

  AnonymousUser Load (0.1ms)   SELECT * FROM `users` WHERE ( (`users`.`type` = 'AnonymousUser' ) ) LIMIT 1

  User Columns (1.2ms)   SHOW FIELDS FROM `users`

  User Load (0.3ms)   SELECT * FROM `users` WHERE (BINARY login = 'gaurav') AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) LIMIT 1

  SQL (0.1ms)   BEGIN

  User Update (0.3ms)   UPDATE `users` SET `last_login_on` = '2010-11-23 01:39:04', `updated_on` = '2010-11-23 01:39:04' WHERE `id` = 3

  CustomField Load (0.1ms)   SELECT * FROM `custom_fields` WHERE (type = 'UserCustomField') ORDER BY position

  SQL (27.0ms)   COMMIT

Redirected to http://myserver.com/redmine/

Completed in 38ms (DB: 29) | 302 Found [http://myserver.com/login]

Processing WelcomeController#index (for 110.34.4.242 at 2010-11-23 01:39:07) [GET]

  Parameters: {"action"=>"index", "controller"=>"welcome"}

  SQL (0.1ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 

  User Load (0.4ms)   SELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 

  News Columns (0.9ms)   SHOW FIELDS FROM `news`

  Project Columns (0.8ms)   SHOW FIELDS FROM `projects`

  News Load Including Associations (0.6ms)   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.1ms)   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.1ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'welcome_text') LIMIT 1

  Setting Load (0.1ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'cache_formatted_text') LIMIT 1

  Setting Load (0.1ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'user_format') LIMIT 1

  UserPreference Load (0.1ms)   SELECT * FROM `user_preferences` WHERE (`user_preferences`.user_id = 3) LIMIT 1

  UserPreference Columns (0.6ms)   SHOW FIELDS FROM `user_preferences`

  Setting Load (0.1ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'time_format') LIMIT 1

Rendered news/_news (10.9ms)

  Token Load (0.1ms)   SELECT * FROM `tokens` WHERE (`tokens`.user_id = 3 AND (action='feeds')) LIMIT 1

  Token Columns (0.5ms)   SHOW FIELDS FROM `tokens`

  Project Load (0.1ms)   SELECT `projects`.* FROM `projects` INNER JOIN `members` ON `projects`.id = `members`.project_id WHERE ((`members`.user_id = 3) AND ((projects.status=1))) 

Completed in 100ms (View: 88, DB: 4) | 200 OK [http://myserver.com/]

Processing ProjectsController#show (for 110.34.4.242 at 2010-11-23 01:39:21) [GET]

  Parameters: {"action"=>"show", "id"=>"max-banner-ads", "controller"=>"projects"}

  SQL (0.1ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 

  User Load (0.1ms)   SELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 

  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (`projects`.`identifier` = 'max-banner-ads') LIMIT 1

  EnabledModule Load (0.1ms)   SELECT name FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 7) 

  EnabledModule Columns (0.8ms)   SHOW FIELDS FROM `enabled_modules`

  Member Columns (0.7ms)   SHOW FIELDS FROM `members`

  Role Columns (0.5ms)   SHOW FIELDS FROM `roles`

  Member Load Including Associations (0.4ms)   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 = 7 AND (users.type='User' AND users.status=1)) 

  News Load (0.1ms)   SELECT * FROM `news` WHERE (`news`.project_id = 7) ORDER BY news.created_on DESC LIMIT 5

  Tracker Columns (0.5ms)   SHOW FIELDS FROM `trackers`

  Tracker Load Including Associations (0.1ms)   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 >= 5 AND projects.rgt <= 6 AND projects.status = 1) ORDER BY trackers.position

  Setting Load (0.1ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'display_subprojects_issues') LIMIT 1

  Issue Columns (0.8ms)   SHOW FIELDS FROM `issues`

  SQL (0.1ms)   SELECT count(DISTINCT `issues`.id) AS count_all, tracker_id AS tracker_id FROM `issues` LEFT OUTER JOIN `projects` ON `projects`.id = `issues`.project_id LEFT OUTER JOIN `issue_statuses` ON `issue_statuses`.id = `issues`.status_id LEFT OUTER JOIN `trackers` ON `trackers`.id = `issues`.tracker_id WHERE (((projects.id = 7 OR (projects.lft > 5 AND projects.rgt < 6))) AND issue_statuses.is_closed=0) AND (projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) GROUP BY tracker_id 

  Tracker Load (0.1ms)   SELECT * FROM `trackers` WHERE (`trackers`.`id` = 2) 

  SQL (0.1ms)   SELECT count(DISTINCT `issues`.id) AS count_all, tracker_id AS tracker_id FROM `issues` LEFT OUTER JOIN `projects` ON `projects`.id = `issues`.project_id LEFT OUTER JOIN `issue_statuses` ON `issue_statuses`.id = `issues`.status_id LEFT OUTER JOIN `trackers` ON `trackers`.id = `issues`.tracker_id WHERE ((projects.id = 7 OR (projects.lft > 5 AND projects.rgt < 6))) AND (projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) GROUP BY tracker_id 

  CACHE (0.0ms)   SELECT * FROM `trackers` WHERE (`trackers`.`id` = 2) 

  TimeEntry Columns (0.6ms)   SHOW FIELDS FROM `time_entries`

  SQL (0.1ms)   SELECT sum(`time_entries`.hours) AS sum_hours FROM `time_entries` LEFT OUTER JOIN `projects` ON `projects`.id = `time_entries`.project_id WHERE ((projects.id = 7 OR (projects.lft > 5 AND projects.rgt < 6))) AND (projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='time_tracking')) 

  Token Load (0.1ms)   SELECT * FROM `tokens` WHERE (`tokens`.user_id = 3 AND (action='feeds')) LIMIT 1

Rendering template within layouts/base

Rendering projects/show

  SQL (0.1ms)   SELECT count(*) AS count_all FROM `projects` WHERE ((projects.status=1) AND (`projects`.`parent_id` = 7)) 

  CustomValue Columns (0.5ms)   SHOW FIELDS FROM `custom_values`

  CustomField Columns (0.7ms)   SHOW FIELDS FROM `custom_fields`

  CustomValue Load Including Associations (0.1ms)   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 = 7 AND `custom_values`.customized_type = 'Project') ORDER BY custom_fields.position

Rendered projects/_members_box (0.5ms)

  Project Load (0.1ms)   SELECT `projects`.* FROM `projects` INNER JOIN `members` ON `projects`.id = `members`.project_id WHERE ((`members`.user_id = 3) AND ((projects.status=1))) 

  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 5 AND projects.`rgt` >= 6) ORDER BY `lft` LIMIT 1

  CACHE (0.0ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 5 AND projects.`rgt` >= 6) ORDER BY `lft` LIMIT 1

  Version Columns (0.7ms)   SHOW FIELDS FROM `versions`

  SQL (0.1ms)   SELECT count(DISTINCT `versions`.id) AS count_all FROM `versions` LEFT OUTER JOIN `projects` ON `projects`.id = `versions`.project_id WHERE (projects.id = 7 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 5 AND projects.rgt <= 6 AND versions.sharing = 'tree') OR (projects.lft < 5 AND projects.rgt > 6 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 5 AND projects.rgt < 6 AND versions.sharing = 'hierarchy')))) 

  Wiki Load (0.1ms)   SELECT * FROM `wikis` WHERE (`wikis`.project_id = 7) LIMIT 1

  Board Columns (0.6ms)   SHOW FIELDS FROM `boards`

  SQL (0.1ms)   SELECT count(*) AS count_all FROM `boards` WHERE (`boards`.project_id = 7) 

  Repository Load (0.2ms)   SELECT * FROM `repositories` WHERE (`repositories`.project_id = 7) LIMIT 1

  Repository Columns (0.5ms)   SHOW FIELDS FROM `repositories`

Completed in 67ms (View: 38, DB: 9) | 200 OK [http://myserver.com/projects/max-banner-ads]

Processing RepositoriesController#show (for 110.34.4.242 at 2010-11-23 01:39:35) [GET]

  Parameters: {"action"=>"show", "id"=>"max-banner-ads", "controller"=>"repositories"}

  SQL (0.1ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 

  User Load (0.2ms)   SELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 

  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (`projects`.`identifier` = 'max-banner-ads') LIMIT 1

  Repository Load (0.1ms)   SELECT * FROM `repositories` WHERE (`repositories`.project_id = 7) LIMIT 1

  Repository::Git Columns (1.3ms)   SHOW FIELDS FROM `repositories`

Shelling out: git --git-dir '/home/git/redmine/repositories/git-test.git/' branch

  EnabledModule Load (0.1ms)   SELECT name FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 7) 

  Setting Load (0.1ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'autofetch_changesets') LIMIT 1

  Changeset Load (0.1ms)   SELECT * FROM `changesets` WHERE (`changesets`.repository_id = 16) ORDER BY committed_on DESC, changesets.committed_on DESC, changesets.id DESC LIMIT 1

Shelling out: git --git-dir '/home/git/redmine/repositories/git-test.git/' log --raw --date=iso --pretty=fuller  --all 

Shelling out: git --git-dir '/home/git/redmine/repositories/git-test.git/' ls-tree -l 'HEAD:'

Rendering template within layouts/base

  Project Load (0.1ms)   SELECT `projects`.* FROM `projects` INNER JOIN `members` ON `projects`.id = `members`.project_id WHERE ((`members`.user_id = 3) AND ((projects.status=1))) 

  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 5 AND projects.`rgt` >= 6) ORDER BY `lft` LIMIT 1

  CACHE (0.0ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 5 AND projects.`rgt` >= 6) ORDER BY `lft` LIMIT 1

  SQL (0.1ms)   SELECT count(DISTINCT `versions`.id) AS count_all FROM `versions` LEFT OUTER JOIN `projects` ON `projects`.id = `versions`.project_id WHERE (projects.id = 7 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 5 AND projects.rgt <= 6 AND versions.sharing = 'tree') OR (projects.lft < 5 AND projects.rgt > 6 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 5 AND projects.rgt < 6 AND versions.sharing = 'hierarchy')))) 

  Wiki Load (0.1ms)   SELECT * FROM `wikis` WHERE (`wikis`.project_id = 7) LIMIT 1

  SQL (0.1ms)   SELECT count(*) AS count_all FROM `boards` WHERE (`boards`.project_id = 7) 

Completed in 208ms (View: 16, DB: 3) | 500 Internal Server Error [http://myserver.com/projects/max-banner-ads/repository]

Processing ProjectsController#settings (for 110.34.4.242 at 2010-11-23 01:39:45) [GET]

  Parameters: {"action"=>"settings", "id"=>"max-banner-ads", "controller"=>"projects"}

  SQL (0.1ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 

  User Load (0.1ms)   SELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 

  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (`projects`.`identifier` = 'max-banner-ads') LIMIT 1

  EnabledModule Load (0.1ms)   SELECT name FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 7) 

  IssueCustomField Columns (1.0ms)   SHOW FIELDS FROM `custom_fields`

  IssueCustomField Load (0.1ms)   SELECT * FROM `custom_fields` WHERE ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY custom_fields.position

  IssueCategory Columns (0.5ms)   SHOW FIELDS FROM `issue_categories`

  Tracker Load (0.1ms)   SELECT * FROM `trackers` ORDER BY position

  Repository Load (0.1ms)   SELECT * FROM `repositories` WHERE (`repositories`.project_id = 7) LIMIT 1

  Wiki Load (0.1ms)   SELECT * FROM `wikis` WHERE (`wikis`.project_id = 7) LIMIT 1

Rendering template within layouts/base

Rendering projects/settings

  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (projects.status=1) 

  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (projects.`lft` >= 5 AND projects.`rgt` <= 6) ORDER BY `lft`

  CustomField Load (0.1ms)   SELECT * FROM `custom_fields` WHERE (type = 'ProjectCustomField') ORDER BY position

  Tracker Load (0.1ms)   SELECT `trackers`.id FROM `trackers` INNER JOIN `projects_trackers` ON `trackers`.id = `projects_trackers`.tracker_id WHERE (`trackers`.`id` = 1) AND (`projects_trackers`.project_id = 7 ) ORDER BY trackers.position LIMIT 1

  Tracker Load (0.1ms)   SELECT `trackers`.id FROM `trackers` INNER JOIN `projects_trackers` ON `trackers`.id = `projects_trackers`.tracker_id WHERE (`trackers`.`id` = 2) AND (`projects_trackers`.project_id = 7 ) ORDER BY trackers.position LIMIT 1

  Tracker Load (0.1ms)   SELECT `trackers`.id FROM `trackers` INNER JOIN `projects_trackers` ON `trackers`.id = `projects_trackers`.tracker_id WHERE (`trackers`.`id` = 3) AND (`projects_trackers`.project_id = 7 ) ORDER BY trackers.position LIMIT 1

Rendered projects/_form (39.7ms)

Rendered projects/_edit (44.4ms)

  EnabledModule Load (0.1ms)   SELECT * FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 7) 

Rendered projects/settings/_modules (90.5ms)

  Role Load (0.1ms)   SELECT * FROM `roles` WHERE (`roles`.`builtin` = 0) ORDER BY position

  Principal Columns (1.0ms)   SHOW FIELDS FROM `users`

  Member Load Including Associations (0.4ms)   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, `roles`.`id` AS t1_r0, `roles`.`name` AS t1_r1, `roles`.`position` AS t1_r2, `roles`.`assignable` AS t1_r3, `roles`.`builtin` AS t1_r4, `roles`.`permissions` AS t1_r5, `users`.`id` AS t2_r0, `users`.`login` AS t2_r1, `users`.`hashed_password` AS t2_r2, `users`.`firstname` AS t2_r3, `users`.`lastname` AS t2_r4, `users`.`mail` AS t2_r5, `users`.`mail_notification` AS t2_r6, `users`.`admin` AS t2_r7, `users`.`status` AS t2_r8, `users`.`last_login_on` AS t2_r9, `users`.`language` AS t2_r10, `users`.`auth_source_id` AS t2_r11, `users`.`created_on` AS t2_r12, `users`.`updated_on` AS t2_r13, `users`.`type` AS t2_r14, `users`.`identity_url` AS t2_r15 FROM `members` LEFT OUTER JOIN `member_roles` ON (`members`.`id` = `member_roles`.`member_id`) LEFT OUTER JOIN `roles` ON (`roles`.`id` = `member_roles`.`role_id`) LEFT OUTER JOIN `users` ON `users`.id = `members`.user_id WHERE (`members`.project_id = 7 AND (users.type='Group' OR (users.type='User' AND users.status=1))) 

  Principal Load (0.3ms)   SELECT * FROM `users` WHERE (users.type='Group' OR (users.type='User' AND users.status = 1)) ORDER BY type, login, lastname ASC LIMIT 100

  Principal Load (0.2ms)   SELECT `users`.* FROM `users` INNER JOIN `members` ON `users`.id = `members`.user_id WHERE ((`members`.project_id = 7) AND ((users.type='Group' OR (users.type='User' AND users.status=1)))) 

Rendered projects/settings/_members (15.3ms)

  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 5 AND projects.`rgt` >= 6) ORDER BY `lft` LIMIT 1

  CACHE (0.0ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 5 AND projects.`rgt` >= 6) ORDER BY `lft` LIMIT 1

  SQL (0.1ms)   SELECT count(DISTINCT `versions`.id) AS count_all FROM `versions` LEFT OUTER JOIN `projects` ON `projects`.id = `versions`.project_id WHERE (projects.id = 7 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 5 AND projects.rgt <= 6 AND versions.sharing = 'tree') OR (projects.lft < 5 AND projects.rgt > 6 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 5 AND projects.rgt < 6 AND versions.sharing = 'hierarchy')))) 

  SQL (0.1ms)   SELECT count(*) AS count_all FROM `versions` WHERE (`versions`.project_id = 7) 

Rendered projects/settings/_versions (5.7ms)

  SQL (0.1ms)   SELECT count(*) AS count_all FROM `issue_categories` WHERE (`issue_categories`.project_id = 7) 

Rendered projects/settings/_issue_categories (2.4ms)

  Wiki Columns (0.7ms)   SHOW FIELDS FROM `wikis`

Rendered projects/settings/_wiki (5.8ms)

  Setting Load (0.1ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'enabled_scm') LIMIT 1

Rendered projects/settings/_repository (9.0ms)

  SQL (0.1ms)   SELECT count(*) AS count_all FROM `boards` WHERE (`boards`.project_id = 7) 

Rendered projects/settings/_boards (2.4ms)

  TimeEntryActivity Columns (0.8ms)   SHOW FIELDS FROM `enumerations`

  CustomField Load (0.1ms)   SELECT * FROM `custom_fields` WHERE (type = 'TimeEntryActivityCustomField') ORDER BY position

  TimeEntryActivity Load (0.1ms)   SELECT * FROM `enumerations` WHERE (`enumerations`.project_id = 7) AND ( (`enumerations`.`type` = 'TimeEntryActivity' ) ) ORDER BY enumerations.position ASC

  TimeEntryActivity Load (0.1ms)   SELECT * FROM `enumerations` WHERE (`enumerations`.`project_id` IS NULL) AND ( (`enumerations`.`type` = 'TimeEntryActivity' ) ) ORDER BY enumerations.position ASC

  CACHE (0.0ms)   SELECT * FROM `custom_fields` WHERE (type = 'TimeEntryActivityCustomField') ORDER BY position

  CACHE (0.0ms)   SELECT * FROM `custom_fields` WHERE (type = 'TimeEntryActivityCustomField') ORDER BY position

Rendered projects/settings/_activities (19.6ms)

Rendered common/_tabs (204.1ms)

  Project Load (0.1ms)   SELECT `projects`.* FROM `projects` INNER JOIN `members` ON `projects`.id = `members`.project_id WHERE ((`members`.user_id = 3) AND ((projects.status=1))) 

  CACHE (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 = 7 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 5 AND projects.rgt <= 6 AND versions.sharing = 'tree') OR (projects.lft < 5 AND projects.rgt > 6 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 5 AND projects.rgt < 6 AND versions.sharing = 'hierarchy')))) 

Completed in 229ms (View: 213, DB: 7) | 200 OK [http://myserver.com/projects/max-banner-ads/settings]

Processing ProjectsController#settings (for 110.34.4.242 at 2010-11-23 01:40:01) [GET]

  Parameters: {"action"=>"settings", "id"=>"max-banner-ads", "controller"=>"projects", "tab"=>"repository"}

  SQL (0.1ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 

  User Load (0.1ms)   SELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 

  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (`projects`.`identifier` = 'max-banner-ads') LIMIT 1

  EnabledModule Load (0.1ms)   SELECT name FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 7) 

  IssueCustomField Load (0.1ms)   SELECT * FROM `custom_fields` WHERE ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY custom_fields.position

  Tracker Load (0.1ms)   SELECT * FROM `trackers` ORDER BY position

  Repository Load (0.1ms)   SELECT * FROM `repositories` WHERE (`repositories`.project_id = 7) LIMIT 1

  Wiki Load (0.1ms)   SELECT * FROM `wikis` WHERE (`wikis`.project_id = 7) LIMIT 1

Rendering template within layouts/base

Rendering projects/settings

  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (projects.status=1) 

  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (projects.`lft` >= 5 AND projects.`rgt` <= 6) ORDER BY `lft`

  CustomField Load (0.1ms)   SELECT * FROM `custom_fields` WHERE (type = 'ProjectCustomField') ORDER BY position

  Tracker Load (0.1ms)   SELECT `trackers`.id FROM `trackers` INNER JOIN `projects_trackers` ON `trackers`.id = `projects_trackers`.tracker_id WHERE (`trackers`.`id` = 1) AND (`projects_trackers`.project_id = 7 ) ORDER BY trackers.position LIMIT 1

  Tracker Load (0.1ms)   SELECT `trackers`.id FROM `trackers` INNER JOIN `projects_trackers` ON `trackers`.id = `projects_trackers`.tracker_id WHERE (`trackers`.`id` = 2) AND (`projects_trackers`.project_id = 7 ) ORDER BY trackers.position LIMIT 1

  Tracker Load (0.1ms)   SELECT `trackers`.id FROM `trackers` INNER JOIN `projects_trackers` ON `trackers`.id = `projects_trackers`.tracker_id WHERE (`trackers`.`id` = 3) AND (`projects_trackers`.project_id = 7 ) ORDER BY trackers.position LIMIT 1

Rendered projects/_form (8.7ms)

Rendered projects/_edit (9.9ms)

  EnabledModule Load (0.1ms)   SELECT * FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 7) 

Rendered projects/settings/_modules (5.0ms)

  Role Load (0.1ms)   SELECT * FROM `roles` WHERE (`roles`.`builtin` = 0) ORDER BY position

  Member Load Including Associations (0.1ms)   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, `roles`.`id` AS t1_r0, `roles`.`name` AS t1_r1, `roles`.`position` AS t1_r2, `roles`.`assignable` AS t1_r3, `roles`.`builtin` AS t1_r4, `roles`.`permissions` AS t1_r5, `users`.`id` AS t2_r0, `users`.`login` AS t2_r1, `users`.`hashed_password` AS t2_r2, `users`.`firstname` AS t2_r3, `users`.`lastname` AS t2_r4, `users`.`mail` AS t2_r5, `users`.`mail_notification` AS t2_r6, `users`.`admin` AS t2_r7, `users`.`status` AS t2_r8, `users`.`last_login_on` AS t2_r9, `users`.`language` AS t2_r10, `users`.`auth_source_id` AS t2_r11, `users`.`created_on` AS t2_r12, `users`.`updated_on` AS t2_r13, `users`.`type` AS t2_r14, `users`.`identity_url` AS t2_r15 FROM `members` LEFT OUTER JOIN `member_roles` ON (`members`.`id` = `member_roles`.`member_id`) LEFT OUTER JOIN `roles` ON (`roles`.`id` = `member_roles`.`role_id`) LEFT OUTER JOIN `users` ON `users`.id = `members`.user_id WHERE (`members`.project_id = 7 AND (users.type='Group' OR (users.type='User' AND users.status=1))) 

  Principal Load (0.1ms)   SELECT * FROM `users` WHERE (users.type='Group' OR (users.type='User' AND users.status = 1)) ORDER BY type, login, lastname ASC LIMIT 100

  Principal Load (0.1ms)   SELECT `users`.* FROM `users` INNER JOIN `members` ON `users`.id = `members`.user_id WHERE ((`members`.project_id = 7) AND ((users.type='Group' OR (users.type='User' AND users.status=1)))) 

Rendered projects/settings/_members (7.3ms)

  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 5 AND projects.`rgt` >= 6) ORDER BY `lft` LIMIT 1

  CACHE (0.0ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 5 AND projects.`rgt` >= 6) ORDER BY `lft` LIMIT 1

  SQL (0.1ms)   SELECT count(DISTINCT `versions`.id) AS count_all FROM `versions` LEFT OUTER JOIN `projects` ON `projects`.id = `versions`.project_id WHERE (projects.id = 7 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 5 AND projects.rgt <= 6 AND versions.sharing = 'tree') OR (projects.lft < 5 AND projects.rgt > 6 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 5 AND projects.rgt < 6 AND versions.sharing = 'hierarchy')))) 

  SQL (0.1ms)   SELECT count(*) AS count_all FROM `versions` WHERE (`versions`.project_id = 7) 

Rendered projects/settings/_versions (69.1ms)

  SQL (0.1ms)   SELECT count(*) AS count_all FROM `issue_categories` WHERE (`issue_categories`.project_id = 7) 

Rendered projects/settings/_issue_categories (1.1ms)

Rendered projects/settings/_wiki (2.9ms)

Rendered projects/settings/_repository (9.0ms)

  SQL (0.1ms)   SELECT count(*) AS count_all FROM `boards` WHERE (`boards`.project_id = 7) 

Rendered projects/settings/_boards (1.8ms)

  CustomField Load (0.1ms)   SELECT * FROM `custom_fields` WHERE (type = 'TimeEntryActivityCustomField') ORDER BY position

  TimeEntryActivity Load (0.1ms)   SELECT * FROM `enumerations` WHERE (`enumerations`.project_id = 7) AND ( (`enumerations`.`type` = 'TimeEntryActivity' ) ) ORDER BY enumerations.position ASC

  TimeEntryActivity Load (0.1ms)   SELECT * FROM `enumerations` WHERE (`enumerations`.`project_id` IS NULL) AND ( (`enumerations`.`type` = 'TimeEntryActivity' ) ) ORDER BY enumerations.position ASC

  CACHE (0.0ms)   SELECT * FROM `custom_fields` WHERE (type = 'TimeEntryActivityCustomField') ORDER BY position

  CACHE (0.0ms)   SELECT * FROM `custom_fields` WHERE (type = 'TimeEntryActivityCustomField') ORDER BY position

Rendered projects/settings/_activities (10.7ms)

Rendered common/_tabs (124.1ms)

  Project Load (0.1ms)   SELECT `projects`.* FROM `projects` INNER JOIN `members` ON `projects`.id = `members`.project_id WHERE ((`members`.user_id = 3) AND ((projects.status=1))) 

  CACHE (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 = 7 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 5 AND projects.rgt <= 6 AND versions.sharing = 'tree') OR (projects.lft < 5 AND projects.rgt > 6 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 5 AND projects.rgt < 6 AND versions.sharing = 'hierarchy')))) 

Completed in 147ms (View: 139, DB: 2) | 200 OK [http://myserver.com/projects/max-banner-ads/settings/repository]

Processing RepositoriesController#destroy (for 110.34.4.242 at 2010-11-23 01:40:21) [POST]

  Parameters: {"action"=>"destroy", "authenticity_token"=>"Z6TJI9dGgADr25gQuCKDITbZ7r6M4EaZtIqNHhMKrsA=", "id"=>"max-banner-ads", "controller"=>"repositories"}

  SQL (0.1ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 

  User Load (0.1ms)   SELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 

  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (`projects`.`identifier` = 'max-banner-ads') LIMIT 1

  Repository Load (0.1ms)   SELECT * FROM `repositories` WHERE (`repositories`.project_id = 7) LIMIT 1

Shelling out: git --git-dir '/home/git/redmine/repositories/git-test.git/' branch

  EnabledModule Load (0.1ms)   SELECT name FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 7) 

  SQL (0.1ms)   BEGIN

  SQL (0.2ms)   DELETE FROM changes WHERE changes.changeset_id IN (SELECT changesets.id FROM changesets WHERE changesets.repository_id = 16)

  SQL (0.1ms)   DELETE FROM changesets_issues WHERE changesets_issues.changeset_id IN (SELECT changesets.id FROM changesets WHERE changesets.repository_id = 16)

  SQL (0.1ms)   DELETE FROM changesets WHERE changesets.repository_id = 16

  Repository::Git Destroy (0.1ms)   DELETE FROM `repositories` WHERE `id` = 16

  SQL (2.0ms)   COMMIT

Redirected to http://myserver.com/redmine/projects/max-banner-ads/settings/repository

Completed in 31ms (DB: 3) | 302 Found [http://myserver.com/projects/max-banner-ads/repository/destroy]

Processing ProjectsController#settings (for 110.34.4.242 at 2010-11-23 01:40:23) [GET]

  Parameters: {"action"=>"settings", "id"=>"max-banner-ads", "controller"=>"projects", "tab"=>"repository"}

  SQL (0.1ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 

  User Load (0.1ms)   SELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 

  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (`projects`.`identifier` = 'max-banner-ads') LIMIT 1

  EnabledModule Load (0.1ms)   SELECT name FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 7) 

  IssueCustomField Load (0.1ms)   SELECT * FROM `custom_fields` WHERE ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY custom_fields.position

  Tracker Load (0.1ms)   SELECT * FROM `trackers` ORDER BY position

  Repository Load (0.3ms)   SELECT * FROM `repositories` WHERE (`repositories`.project_id = 7) LIMIT 1

  Wiki Load (0.1ms)   SELECT * FROM `wikis` WHERE (`wikis`.project_id = 7) LIMIT 1

Rendering template within layouts/base

Rendering projects/settings

  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (projects.status=1) 

  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (projects.`lft` >= 5 AND projects.`rgt` <= 6) ORDER BY `lft`

  CustomField Load (0.1ms)   SELECT * FROM `custom_fields` WHERE (type = 'ProjectCustomField') ORDER BY position

  Tracker Load (0.1ms)   SELECT `trackers`.id FROM `trackers` INNER JOIN `projects_trackers` ON `trackers`.id = `projects_trackers`.tracker_id WHERE (`trackers`.`id` = 1) AND (`projects_trackers`.project_id = 7 ) ORDER BY trackers.position LIMIT 1

  Tracker Load (0.1ms)   SELECT `trackers`.id FROM `trackers` INNER JOIN `projects_trackers` ON `trackers`.id = `projects_trackers`.tracker_id WHERE (`trackers`.`id` = 2) AND (`projects_trackers`.project_id = 7 ) ORDER BY trackers.position LIMIT 1

  Tracker Load (0.1ms)   SELECT `trackers`.id FROM `trackers` INNER JOIN `projects_trackers` ON `trackers`.id = `projects_trackers`.tracker_id WHERE (`trackers`.`id` = 3) AND (`projects_trackers`.project_id = 7 ) ORDER BY trackers.position LIMIT 1

Rendered projects/_form (17.1ms)

Rendered projects/_edit (19.1ms)

  EnabledModule Load (0.1ms)   SELECT * FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 7) 

Rendered projects/settings/_modules (9.8ms)

  Role Load (0.1ms)   SELECT * FROM `roles` WHERE (`roles`.`builtin` = 0) ORDER BY position

  Member Load Including Associations (0.1ms)   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, `roles`.`id` AS t1_r0, `roles`.`name` AS t1_r1, `roles`.`position` AS t1_r2, `roles`.`assignable` AS t1_r3, `roles`.`builtin` AS t1_r4, `roles`.`permissions` AS t1_r5, `users`.`id` AS t2_r0, `users`.`login` AS t2_r1, `users`.`hashed_password` AS t2_r2, `users`.`firstname` AS t2_r3, `users`.`lastname` AS t2_r4, `users`.`mail` AS t2_r5, `users`.`mail_notification` AS t2_r6, `users`.`admin` AS t2_r7, `users`.`status` AS t2_r8, `users`.`last_login_on` AS t2_r9, `users`.`language` AS t2_r10, `users`.`auth_source_id` AS t2_r11, `users`.`created_on` AS t2_r12, `users`.`updated_on` AS t2_r13, `users`.`type` AS t2_r14, `users`.`identity_url` AS t2_r15 FROM `members` LEFT OUTER JOIN `member_roles` ON (`members`.`id` = `member_roles`.`member_id`) LEFT OUTER JOIN `roles` ON (`roles`.`id` = `member_roles`.`role_id`) LEFT OUTER JOIN `users` ON `users`.id = `members`.user_id WHERE (`members`.project_id = 7 AND (users.type='Group' OR (users.type='User' AND users.status=1))) 

  Principal Load (0.1ms)   SELECT * FROM `users` WHERE (users.type='Group' OR (users.type='User' AND users.status = 1)) ORDER BY type, login, lastname ASC LIMIT 100

  Principal Load (0.1ms)   SELECT `users`.* FROM `users` INNER JOIN `members` ON `users`.id = `members`.user_id WHERE ((`members`.project_id = 7) AND ((users.type='Group' OR (users.type='User' AND users.status=1)))) 

Rendered projects/settings/_members (12.6ms)

  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 5 AND projects.`rgt` >= 6) ORDER BY `lft` LIMIT 1

  CACHE (0.0ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 5 AND projects.`rgt` >= 6) ORDER BY `lft` LIMIT 1

  SQL (0.1ms)   SELECT count(DISTINCT `versions`.id) AS count_all FROM `versions` LEFT OUTER JOIN `projects` ON `projects`.id = `versions`.project_id WHERE (projects.id = 7 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 5 AND projects.rgt <= 6 AND versions.sharing = 'tree') OR (projects.lft < 5 AND projects.rgt > 6 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 5 AND projects.rgt < 6 AND versions.sharing = 'hierarchy')))) 

  SQL (0.1ms)   SELECT count(*) AS count_all FROM `versions` WHERE (`versions`.project_id = 7) 

Rendered projects/settings/_versions (4.9ms)

  SQL (0.1ms)   SELECT count(*) AS count_all FROM `issue_categories` WHERE (`issue_categories`.project_id = 7) 

Rendered projects/settings/_issue_categories (1.5ms)

Rendered projects/settings/_wiki (4.7ms)

Rendered projects/settings/_repository (5.0ms)

  SQL (0.1ms)   SELECT count(*) AS count_all FROM `boards` WHERE (`boards`.project_id = 7) 

Rendered projects/settings/_boards (1.5ms)

  CustomField Load (0.1ms)   SELECT * FROM `custom_fields` WHERE (type = 'TimeEntryActivityCustomField') ORDER BY position

  TimeEntryActivity Load (0.1ms)   SELECT * FROM `enumerations` WHERE (`enumerations`.project_id = 7) AND ( (`enumerations`.`type` = 'TimeEntryActivity' ) ) ORDER BY enumerations.position ASC

  TimeEntryActivity Load (0.1ms)   SELECT * FROM `enumerations` WHERE (`enumerations`.`project_id` IS NULL) AND ( (`enumerations`.`type` = 'TimeEntryActivity' ) ) ORDER BY enumerations.position ASC

  CACHE (0.0ms)   SELECT * FROM `custom_fields` WHERE (type = 'TimeEntryActivityCustomField') ORDER BY position

  CACHE (0.0ms)   SELECT * FROM `custom_fields` WHERE (type = 'TimeEntryActivityCustomField') ORDER BY position

Rendered projects/settings/_activities (9.9ms)

Rendered common/_tabs (79.4ms)

  Project Load (0.1ms)   SELECT `projects`.* FROM `projects` INNER JOIN `members` ON `projects`.id = `members`.project_id WHERE ((`members`.user_id = 3) AND ((projects.status=1))) 

  CACHE (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 = 7 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 5 AND projects.rgt <= 6 AND versions.sharing = 'tree') OR (projects.lft < 5 AND projects.rgt > 6 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 5 AND projects.rgt < 6 AND versions.sharing = 'hierarchy')))) 

Completed in 186ms (View: 175, DB: 3) | 200 OK [http://myserver.com/projects/max-banner-ads/settings/repository]

Processing RepositoriesController#edit (for 110.34.4.242 at 2010-11-23 01:40:36) [GET]

  Parameters: {"action"=>"edit", "authenticity_token"=>"Z6TJI9dGgADr25gQuCKDITbZ7r6M4EaZtIqNHhMKrsA=", "id"=>"max-banner-ads", "controller"=>"repositories", "repository_scm"=>"Git"}

  SQL (0.1ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 

  User Load (0.1ms)   SELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 

  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (`projects`.`identifier` = 'max-banner-ads') LIMIT 1

  EnabledModule Load (0.1ms)   SELECT name FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 7) 

  Repository Load (0.1ms)   SELECT * FROM `repositories` WHERE (`repositories`.project_id = 7) LIMIT 1

Rendered projects/settings/_repository (8.8ms)

  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (`projects`.`id` = 7) 

  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 5 AND projects.`rgt` >= 6) ORDER BY `lft` LIMIT 1

  CACHE (0.0ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 5 AND projects.`rgt` >= 6) ORDER BY `lft` LIMIT 1

  SQL (0.1ms)   SELECT count(DISTINCT `versions`.id) AS count_all FROM `versions` LEFT OUTER JOIN `projects` ON `projects`.id = `versions`.project_id WHERE (projects.id = 7 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 5 AND projects.rgt <= 6 AND versions.sharing = 'tree') OR (projects.lft < 5 AND projects.rgt > 6 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 5 AND projects.rgt < 6 AND versions.sharing = 'hierarchy')))) 

  Wiki Load (0.1ms)   SELECT * FROM `wikis` WHERE (`wikis`.project_id = 7) LIMIT 1

  SQL (0.1ms)   SELECT count(*) AS count_all FROM `boards` WHERE (`boards`.project_id = 7) 

  CACHE (0.0ms)   SELECT * FROM `repositories` WHERE (`repositories`.project_id = 7) LIMIT 1

Completed in 39ms (View: 21, DB: 1) | 200 OK [http://myserver.com/projects/max-banner-ads/repository/edit?authenticity_token=Z6TJI9dGgADr25gQuCKDITbZ7r6M4EaZtIqNHhMKrsA%3D&authenticity_token=Z6TJI9dGgADr25gQuCKDITbZ7r6M4EaZtIqNHhMKrsA%3D&repository_scm=Git]

Processing RepositoriesController#edit (for 110.34.4.242 at 2010-11-23 01:40:56) [POST]

  Parameters: {"repository"=>{"url"=>"/home/git/git-test/.git"}, "commit"=>"Create", "action"=>"edit", "authenticity_token"=>"Z6TJI9dGgADr25gQuCKDITbZ7r6M4EaZtIqNHhMKrsA=", "id"=>"max-banner-ads", "controller"=>"repositories", "repository_scm"=>"Git"}

  SQL (0.1ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 

  User Load (0.1ms)   SELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 

  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (`projects`.`identifier` = 'max-banner-ads') LIMIT 1

  EnabledModule Load (0.1ms)   SELECT name FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 7) 

  Repository Load (0.1ms)   SELECT * FROM `repositories` WHERE (`repositories`.project_id = 7) LIMIT 1

  SQL (0.1ms)   BEGIN

  Repository::Git Create (0.2ms)   INSERT INTO `repositories` (`project_id`, `url`, `type`, `login`, `password`, `root_url`) VALUES(7, '/home/git/git-test/.git', 'Git', '', '', '')

  SQL (0.8ms)   COMMIT

Rendered projects/settings/_repository (5.3ms)

  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (`projects`.`id` = 7) 

  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 5 AND projects.`rgt` >= 6) ORDER BY `lft` LIMIT 1

  CACHE (0.0ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 5 AND projects.`rgt` >= 6) ORDER BY `lft` LIMIT 1

  SQL (0.1ms)   SELECT count(DISTINCT `versions`.id) AS count_all FROM `versions` LEFT OUTER JOIN `projects` ON `projects`.id = `versions`.project_id WHERE (projects.id = 7 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 5 AND projects.rgt <= 6 AND versions.sharing = 'tree') OR (projects.lft < 5 AND projects.rgt > 6 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 5 AND projects.rgt < 6 AND versions.sharing = 'hierarchy')))) 

  Wiki Load (0.1ms)   SELECT * FROM `wikis` WHERE (`wikis`.project_id = 7) LIMIT 1

  SQL (0.1ms)   SELECT count(*) AS count_all FROM `boards` WHERE (`boards`.project_id = 7) 

  Repository Load (0.3ms)   SELECT * FROM `repositories` WHERE (`repositories`.project_id = 7) LIMIT 1

Completed in 24ms (View: 15, DB: 2) | 200 OK [http://myserver.com/projects/max-banner-ads/repository/edit]

Processing RepositoriesController#edit (for 110.34.4.242 at 2010-11-23 01:41:04) [POST]

  Parameters: {"repository"=>{"url"=>"/home/git/git-test/.git"}, "commit"=>"Save", "action"=>"edit", "authenticity_token"=>"Z6TJI9dGgADr25gQuCKDITbZ7r6M4EaZtIqNHhMKrsA=", "id"=>"max-banner-ads", "controller"=>"repositories"}

  SQL (0.1ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 

  User Load (0.1ms)   SELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 

  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (`projects`.`identifier` = 'max-banner-ads') LIMIT 1

  EnabledModule Load (0.1ms)   SELECT name FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 7) 

  Repository Load (0.1ms)   SELECT * FROM `repositories` WHERE (`repositories`.project_id = 7) LIMIT 1

  SQL (0.1ms)   BEGIN

  SQL (0.1ms)   COMMIT

Rendered projects/settings/_repository (7.4ms)

Completed in 17ms (View: 9, DB: 1) | 200 OK [http://myserver.com/projects/max-banner-ads/repository/edit]

Processing RepositoriesController#show (for 110.34.4.242 at 2010-11-23 01:41:08) [GET]

  Parameters: {"action"=>"show", "id"=>"max-banner-ads", "controller"=>"repositories"}

  SQL (0.1ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 

  User Load (0.1ms)   SELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 

  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (`projects`.`identifier` = 'max-banner-ads') LIMIT 1

  Repository Load (0.1ms)   SELECT * FROM `repositories` WHERE (`repositories`.project_id = 7) LIMIT 1

Shelling out: git --git-dir '/home/git/git-test/.git/' log --pretty=fuller --no-merges -n 1 

  SQL (0.1ms)   BEGIN

  Repository::Git Update (0.2ms)   UPDATE `repositories` SET `root_url` = '/home/git/git-test/.git' WHERE `id` = 17

  SQL (15.2ms)   COMMIT

Shelling out: git --git-dir '/home/git/git-test/.git/' branch

  EnabledModule Load (0.1ms)   SELECT name FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 7) 

  Changeset Load (0.4ms)   SELECT * FROM `changesets` WHERE (`changesets`.repository_id = 17) ORDER BY committed_on DESC, changesets.committed_on DESC, changesets.id DESC LIMIT 1

Shelling out: git --git-dir '/home/git/git-test/.git/' log --raw --date=iso --pretty=fuller  --all 

Shelling out: git --git-dir '/home/git/git-test/.git/' ls-tree -l 'HEAD:'

Rendering template within layouts/base

  Project Load (0.1ms)   SELECT `projects`.* FROM `projects` INNER JOIN `members` ON `projects`.id = `members`.project_id WHERE ((`members`.user_id = 3) AND ((projects.status=1))) 

  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 5 AND projects.`rgt` >= 6) ORDER BY `lft` LIMIT 1

  CACHE (0.0ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 5 AND projects.`rgt` >= 6) ORDER BY `lft` LIMIT 1

  SQL (0.1ms)   SELECT count(DISTINCT `versions`.id) AS count_all FROM `versions` LEFT OUTER JOIN `projects` ON `projects`.id = `versions`.project_id WHERE (projects.id = 7 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 5 AND projects.rgt <= 6 AND versions.sharing = 'tree') OR (projects.lft < 5 AND projects.rgt > 6 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 5 AND projects.rgt < 6 AND versions.sharing = 'hierarchy')))) 

  Wiki Load (0.1ms)   SELECT * FROM `wikis` WHERE (`wikis`.project_id = 7) LIMIT 1

  SQL (0.1ms)   SELECT count(*) AS count_all FROM `boards` WHERE (`boards`.project_id = 7) 

Completed in 110ms (View: 17, DB: 17) | 500 Internal Server Error [http://myserver.com/projects/max-banner-ads/repository]

Processing ProjectsController#settings (for 110.34.4.242 at 2010-11-23 01:41:22) [GET]

  Parameters: {"action"=>"settings", "id"=>"max-banner-ads", "controller"=>"projects"}

  SQL (0.1ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 

  User Load (0.1ms)   SELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 

  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (`projects`.`identifier` = 'max-banner-ads') LIMIT 1

  EnabledModule Load (0.1ms)   SELECT name FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 7) 

  IssueCustomField Load (0.1ms)   SELECT * FROM `custom_fields` WHERE ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY custom_fields.position

  Tracker Load (0.1ms)   SELECT * FROM `trackers` ORDER BY position

  Repository Load (0.3ms)   SELECT * FROM `repositories` WHERE (`repositories`.project_id = 7) LIMIT 1

  Wiki Load (0.1ms)   SELECT * FROM `wikis` WHERE (`wikis`.project_id = 7) LIMIT 1

Rendering template within layouts/base

Rendering projects/settings

  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (projects.status=1) 

  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (projects.`lft` >= 5 AND projects.`rgt` <= 6) ORDER BY `lft`

  CustomField Load (0.1ms)   SELECT * FROM `custom_fields` WHERE (type = 'ProjectCustomField') ORDER BY position

  Tracker Load (0.1ms)   SELECT `trackers`.id FROM `trackers` INNER JOIN `projects_trackers` ON `trackers`.id = `projects_trackers`.tracker_id WHERE (`trackers`.`id` = 1) AND (`projects_trackers`.project_id = 7 ) ORDER BY trackers.position LIMIT 1

  Tracker Load (0.1ms)   SELECT `trackers`.id FROM `trackers` INNER JOIN `projects_trackers` ON `trackers`.id = `projects_trackers`.tracker_id WHERE (`trackers`.`id` = 2) AND (`projects_trackers`.project_id = 7 ) ORDER BY trackers.position LIMIT 1

  Tracker Load (0.1ms)   SELECT `trackers`.id FROM `trackers` INNER JOIN `projects_trackers` ON `trackers`.id = `projects_trackers`.tracker_id WHERE (`trackers`.`id` = 3) AND (`projects_trackers`.project_id = 7 ) ORDER BY trackers.position LIMIT 1

Rendered projects/_form (10.3ms)

Rendered projects/_edit (11.7ms)

  EnabledModule Load (0.1ms)   SELECT * FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 7) 

Rendered projects/settings/_modules (5.4ms)

  Role Load (0.1ms)   SELECT * FROM `roles` WHERE (`roles`.`builtin` = 0) ORDER BY position

  Member Load Including Associations (0.2ms)   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, `roles`.`id` AS t1_r0, `roles`.`name` AS t1_r1, `roles`.`position` AS t1_r2, `roles`.`assignable` AS t1_r3, `roles`.`builtin` AS t1_r4, `roles`.`permissions` AS t1_r5, `users`.`id` AS t2_r0, `users`.`login` AS t2_r1, `users`.`hashed_password` AS t2_r2, `users`.`firstname` AS t2_r3, `users`.`lastname` AS t2_r4, `users`.`mail` AS t2_r5, `users`.`mail_notification` AS t2_r6, `users`.`admin` AS t2_r7, `users`.`status` AS t2_r8, `users`.`last_login_on` AS t2_r9, `users`.`language` AS t2_r10, `users`.`auth_source_id` AS t2_r11, `users`.`created_on` AS t2_r12, `users`.`updated_on` AS t2_r13, `users`.`type` AS t2_r14, `users`.`identity_url` AS t2_r15 FROM `members` LEFT OUTER JOIN `member_roles` ON (`members`.`id` = `member_roles`.`member_id`) LEFT OUTER JOIN `roles` ON (`roles`.`id` = `member_roles`.`role_id`) LEFT OUTER JOIN `users` ON `users`.id = `members`.user_id WHERE (`members`.project_id = 7 AND (users.type='Group' OR (users.type='User' AND users.status=1))) 

  Principal Load (0.1ms)   SELECT * FROM `users` WHERE (users.type='Group' OR (users.type='User' AND users.status = 1)) ORDER BY type, login, lastname ASC LIMIT 100

  Principal Load (0.1ms)   SELECT `users`.* FROM `users` INNER JOIN `members` ON `users`.id = `members`.user_id WHERE ((`members`.project_id = 7) AND ((users.type='Group' OR (users.type='User' AND users.status=1)))) 

Rendered projects/settings/_members (92.5ms)

  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 5 AND projects.`rgt` >= 6) ORDER BY `lft` LIMIT 1

  CACHE (0.0ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 5 AND projects.`rgt` >= 6) ORDER BY `lft` LIMIT 1

  SQL (0.1ms)   SELECT count(DISTINCT `versions`.id) AS count_all FROM `versions` LEFT OUTER JOIN `projects` ON `projects`.id = `versions`.project_id WHERE (projects.id = 7 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 5 AND projects.rgt <= 6 AND versions.sharing = 'tree') OR (projects.lft < 5 AND projects.rgt > 6 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 5 AND projects.rgt < 6 AND versions.sharing = 'hierarchy')))) 

  SQL (0.1ms)   SELECT count(*) AS count_all FROM `versions` WHERE (`versions`.project_id = 7) 

Rendered projects/settings/_versions (3.4ms)

  SQL (0.1ms)   SELECT count(*) AS count_all FROM `issue_categories` WHERE (`issue_categories`.project_id = 7) 

Rendered projects/settings/_issue_categories (0.9ms)

Rendered projects/settings/_wiki (2.6ms)

Rendered projects/settings/_repository (5.7ms)

  SQL (0.1ms)   SELECT count(*) AS count_all FROM `boards` WHERE (`boards`.project_id = 7) 

Rendered projects/settings/_boards (0.9ms)

  CustomField Load (0.1ms)   SELECT * FROM `custom_fields` WHERE (type = 'TimeEntryActivityCustomField') ORDER BY position

  TimeEntryActivity Load (0.1ms)   SELECT * FROM `enumerations` WHERE (`enumerations`.project_id = 7) AND ( (`enumerations`.`type` = 'TimeEntryActivity' ) ) ORDER BY enumerations.position ASC

  TimeEntryActivity Load (0.1ms)   SELECT * FROM `enumerations` WHERE (`enumerations`.`project_id` IS NULL) AND ( (`enumerations`.`type` = 'TimeEntryActivity' ) ) ORDER BY enumerations.position ASC

  CACHE (0.0ms)   SELECT * FROM `custom_fields` WHERE (type = 'TimeEntryActivityCustomField') ORDER BY position

  CACHE (0.0ms)   SELECT * FROM `custom_fields` WHERE (type = 'TimeEntryActivityCustomField') ORDER BY position

Rendered projects/settings/_activities (7.2ms)

Rendered common/_tabs (137.4ms)

  Project Load (0.1ms)   SELECT `projects`.* FROM `projects` INNER JOIN `members` ON `projects`.id = `members`.project_id WHERE ((`members`.user_id = 3) AND ((projects.status=1))) 

  CACHE (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 = 7 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 5 AND projects.rgt <= 6 AND versions.sharing = 'tree') OR (projects.lft < 5 AND projects.rgt > 6 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 5 AND projects.rgt < 6 AND versions.sharing = 'hierarchy')))) 

Completed in 158ms (View: 149, DB: 2) | 200 OK [http://myserver.com/projects/max-banner-ads/settings]