log-nov-22-2010.txt

gaurabmani shrestha, 2010-11-23 08:45

Download (61.3 KB)

 
1
Processing AccountController#login (for 110.34.4.242 at 2010-11-23 01:37:12) [GET]
2
  Parameters: {"back_url"=>"http://myserver.com/redmine/", "action"=>"login", "controller"=>"account"}
3
  SQL (0.1ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 
4
  AnonymousUser Load (0.1ms)   SELECT * FROM `users` WHERE ( (`users`.`type` = 'AnonymousUser' ) ) LIMIT 1
5
Rendering template within layouts/base
6
Rendering account/login
7
  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))) 
8
Completed in 30ms (View: 27, DB: 0) | 200 OK [http://myserver.com/login?back_url=http%3A%2F%2Fmyserver.com%2Fredmine%2F]
9
  SQL (0.1ms)   SET NAMES 'utf8'
10
  SQL (0.1ms)   SET SQL_AUTO_IS_NULL=0
11

    
12

    
13
Processing WelcomeController#index (for 110.34.4.242 at 2010-11-23 01:38:22) [GET]
14
  Parameters: {"action"=>"index", "controller"=>"welcome"}
15
  Setting Columns (0.8ms)   SHOW FIELDS FROM `settings`
16
  SQL (0.1ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 
17
  Setting Load (0.1ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'rest_api_enabled') LIMIT 1
18
  AnonymousUser Columns (0.8ms)   SHOW FIELDS FROM `users`
19
  AnonymousUser Load (0.1ms)   SELECT * FROM `users` WHERE ( (`users`.`type` = 'AnonymousUser' ) ) LIMIT 1
20
  Setting Load (0.1ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'login_required') LIMIT 1
21
Redirected to http://myserver.com/redmine/login?back_url=http%3A%2F%2Fmyserver.com%2Fredmine%2F
22
Filter chain halted as [:check_if_login_required] rendered_or_redirected.
23
Completed in 9ms (DB: 2) | 302 Found [http://myserver.com/]
24

    
25

    
26
Processing AccountController#login (for 110.34.4.242 at 2010-11-23 01:38:27) [GET]
27
  Parameters: {"back_url"=>"http://myserver.com/redmine/", "action"=>"login", "controller"=>"account"}
28
  SQL (0.1ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 
29
  AnonymousUser Load (0.1ms)   SELECT * FROM `users` WHERE ( (`users`.`type` = 'AnonymousUser' ) ) LIMIT 1
30
Rendering template within layouts/base
31
Rendering account/login
32
  Setting Load (0.1ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'autologin') LIMIT 1
33
  Setting Load (0.1ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'lost_password') LIMIT 1
34
  Setting Load (0.1ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'app_title') LIMIT 1
35
  Setting Load (0.1ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'ui_theme') LIMIT 1
36
  Setting Load (0.1ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'text_formatting') LIMIT 1
37
  Setting Load (0.1ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'self_registration') LIMIT 1
38
  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))) 
39
Completed in 55ms (View: 49, DB: 1) | 200 OK [http://myserver.com/login?back_url=http%3A%2F%2Fmyserver.com%2Fredmine%2F]
40
  SQL (0.1ms)   SET NAMES 'utf8'
41
  SQL (0.1ms)   SET SQL_AUTO_IS_NULL=0
42

    
43

    
44
Processing AccountController#login (for 110.34.4.242 at 2010-11-23 01:39:04) [POST]
45
  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 ?"}
46
  SQL (0.1ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 
47
  AnonymousUser Load (0.1ms)   SELECT * FROM `users` WHERE ( (`users`.`type` = 'AnonymousUser' ) ) LIMIT 1
48
  User Columns (1.2ms)   SHOW FIELDS FROM `users`
49
  User Load (0.3ms)   SELECT * FROM `users` WHERE (BINARY login = 'gaurav') AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) LIMIT 1
50
  SQL (0.1ms)   BEGIN
51
  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
52
  CustomField Load (0.1ms)   SELECT * FROM `custom_fields` WHERE (type = 'UserCustomField') ORDER BY position
53
  SQL (27.0ms)   COMMIT
54
Redirected to http://myserver.com/redmine/
55
Completed in 38ms (DB: 29) | 302 Found [http://myserver.com/login]
56

    
57

    
58
Processing WelcomeController#index (for 110.34.4.242 at 2010-11-23 01:39:07) [GET]
59
  Parameters: {"action"=>"index", "controller"=>"welcome"}
60
  SQL (0.1ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 
61
  User Load (0.4ms)   SELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 
62
  News Columns (0.9ms)   SHOW FIELDS FROM `news`
63
  Project Columns (0.8ms)   SHOW FIELDS FROM `projects`
64
  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
65
  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (projects.status=1) ORDER BY created_on DESC LIMIT 5
66
Rendering template within layouts/base
67
Rendering welcome/index
68
  Setting Load (0.1ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'welcome_text') LIMIT 1
69
  Setting Load (0.1ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'cache_formatted_text') LIMIT 1
70
  Setting Load (0.1ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'user_format') LIMIT 1
71
  UserPreference Load (0.1ms)   SELECT * FROM `user_preferences` WHERE (`user_preferences`.user_id = 3) LIMIT 1
72
  UserPreference Columns (0.6ms)   SHOW FIELDS FROM `user_preferences`
73
  Setting Load (0.1ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'time_format') LIMIT 1
74
Rendered news/_news (10.9ms)
75
  Token Load (0.1ms)   SELECT * FROM `tokens` WHERE (`tokens`.user_id = 3 AND (action='feeds')) LIMIT 1
76
  Token Columns (0.5ms)   SHOW FIELDS FROM `tokens`
77
  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))) 
78
Completed in 100ms (View: 88, DB: 4) | 200 OK [http://myserver.com/]
79

    
80

    
81
Processing ProjectsController#show (for 110.34.4.242 at 2010-11-23 01:39:21) [GET]
82
  Parameters: {"action"=>"show", "id"=>"max-banner-ads", "controller"=>"projects"}
83
  SQL (0.1ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 
84
  User Load (0.1ms)   SELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 
85
  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (`projects`.`identifier` = 'max-banner-ads') LIMIT 1
86
  EnabledModule Load (0.1ms)   SELECT name FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 7) 
87
  EnabledModule Columns (0.8ms)   SHOW FIELDS FROM `enabled_modules`
88
  Member Columns (0.7ms)   SHOW FIELDS FROM `members`
89
  Role Columns (0.5ms)   SHOW FIELDS FROM `roles`
90
  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)) 
91
  News Load (0.1ms)   SELECT * FROM `news` WHERE (`news`.project_id = 7) ORDER BY news.created_on DESC LIMIT 5
92
  Tracker Columns (0.5ms)   SHOW FIELDS FROM `trackers`
93
  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
94
  Setting Load (0.1ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'display_subprojects_issues') LIMIT 1
95
  Issue Columns (0.8ms)   SHOW FIELDS FROM `issues`
96
  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 
97
  Tracker Load (0.1ms)   SELECT * FROM `trackers` WHERE (`trackers`.`id` = 2) 
98
  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 
99
  CACHE (0.0ms)   SELECT * FROM `trackers` WHERE (`trackers`.`id` = 2) 
100
  TimeEntry Columns (0.6ms)   SHOW FIELDS FROM `time_entries`
101
  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')) 
102
  Token Load (0.1ms)   SELECT * FROM `tokens` WHERE (`tokens`.user_id = 3 AND (action='feeds')) LIMIT 1
103
Rendering template within layouts/base
104
Rendering projects/show
105
  SQL (0.1ms)   SELECT count(*) AS count_all FROM `projects` WHERE ((projects.status=1) AND (`projects`.`parent_id` = 7)) 
106
  CustomValue Columns (0.5ms)   SHOW FIELDS FROM `custom_values`
107
  CustomField Columns (0.7ms)   SHOW FIELDS FROM `custom_fields`
108
  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
109
Rendered projects/_members_box (0.5ms)
110
  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))) 
111
  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 5 AND projects.`rgt` >= 6) ORDER BY `lft` LIMIT 1
112
  CACHE (0.0ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 5 AND projects.`rgt` >= 6) ORDER BY `lft` LIMIT 1
113
  Version Columns (0.7ms)   SHOW FIELDS FROM `versions`
114
  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')))) 
115
  Wiki Load (0.1ms)   SELECT * FROM `wikis` WHERE (`wikis`.project_id = 7) LIMIT 1
116
  Board Columns (0.6ms)   SHOW FIELDS FROM `boards`
117
  SQL (0.1ms)   SELECT count(*) AS count_all FROM `boards` WHERE (`boards`.project_id = 7) 
118
  Repository Load (0.2ms)   SELECT * FROM `repositories` WHERE (`repositories`.project_id = 7) LIMIT 1
119
  Repository Columns (0.5ms)   SHOW FIELDS FROM `repositories`
120
Completed in 67ms (View: 38, DB: 9) | 200 OK [http://myserver.com/projects/max-banner-ads]
121

    
122

    
123
Processing RepositoriesController#show (for 110.34.4.242 at 2010-11-23 01:39:35) [GET]
124
  Parameters: {"action"=>"show", "id"=>"max-banner-ads", "controller"=>"repositories"}
125
  SQL (0.1ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 
126
  User Load (0.2ms)   SELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 
127
  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (`projects`.`identifier` = 'max-banner-ads') LIMIT 1
128
  Repository Load (0.1ms)   SELECT * FROM `repositories` WHERE (`repositories`.project_id = 7) LIMIT 1
129
  Repository::Git Columns (1.3ms)   SHOW FIELDS FROM `repositories`
130
Shelling out: git --git-dir '/home/git/redmine/repositories/git-test.git/' branch
131
  EnabledModule Load (0.1ms)   SELECT name FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 7) 
132
  Setting Load (0.1ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'autofetch_changesets') LIMIT 1
133
  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
134
Shelling out: git --git-dir '/home/git/redmine/repositories/git-test.git/' log --raw --date=iso --pretty=fuller  --all 
135
Shelling out: git --git-dir '/home/git/redmine/repositories/git-test.git/' ls-tree -l 'HEAD:'
136
Rendering template within layouts/base
137
  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))) 
138
  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 5 AND projects.`rgt` >= 6) ORDER BY `lft` LIMIT 1
139
  CACHE (0.0ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 5 AND projects.`rgt` >= 6) ORDER BY `lft` LIMIT 1
140
  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')))) 
141
  Wiki Load (0.1ms)   SELECT * FROM `wikis` WHERE (`wikis`.project_id = 7) LIMIT 1
142
  SQL (0.1ms)   SELECT count(*) AS count_all FROM `boards` WHERE (`boards`.project_id = 7) 
143
Completed in 208ms (View: 16, DB: 3) | 500 Internal Server Error [http://myserver.com/projects/max-banner-ads/repository]
144

    
145

    
146
Processing ProjectsController#settings (for 110.34.4.242 at 2010-11-23 01:39:45) [GET]
147
  Parameters: {"action"=>"settings", "id"=>"max-banner-ads", "controller"=>"projects"}
148
  SQL (0.1ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 
149
  User Load (0.1ms)   SELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 
150
  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (`projects`.`identifier` = 'max-banner-ads') LIMIT 1
151
  EnabledModule Load (0.1ms)   SELECT name FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 7) 
152
  IssueCustomField Columns (1.0ms)   SHOW FIELDS FROM `custom_fields`
153
  IssueCustomField Load (0.1ms)   SELECT * FROM `custom_fields` WHERE ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY custom_fields.position
154
  IssueCategory Columns (0.5ms)   SHOW FIELDS FROM `issue_categories`
155
  Tracker Load (0.1ms)   SELECT * FROM `trackers` ORDER BY position
156
  Repository Load (0.1ms)   SELECT * FROM `repositories` WHERE (`repositories`.project_id = 7) LIMIT 1
157
  Wiki Load (0.1ms)   SELECT * FROM `wikis` WHERE (`wikis`.project_id = 7) LIMIT 1
158
Rendering template within layouts/base
159
Rendering projects/settings
160
  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (projects.status=1) 
161
  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (projects.`lft` >= 5 AND projects.`rgt` <= 6) ORDER BY `lft`
162
  CustomField Load (0.1ms)   SELECT * FROM `custom_fields` WHERE (type = 'ProjectCustomField') ORDER BY position
163
  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
164
  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
165
  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
166
Rendered projects/_form (39.7ms)
167
Rendered projects/_edit (44.4ms)
168
  EnabledModule Load (0.1ms)   SELECT * FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 7) 
169
Rendered projects/settings/_modules (90.5ms)
170
  Role Load (0.1ms)   SELECT * FROM `roles` WHERE (`roles`.`builtin` = 0) ORDER BY position
171
  Principal Columns (1.0ms)   SHOW FIELDS FROM `users`
172
  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))) 
173
  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
174
  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)))) 
175
Rendered projects/settings/_members (15.3ms)
176
  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 5 AND projects.`rgt` >= 6) ORDER BY `lft` LIMIT 1
177
  CACHE (0.0ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 5 AND projects.`rgt` >= 6) ORDER BY `lft` LIMIT 1
178
  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')))) 
179
  SQL (0.1ms)   SELECT count(*) AS count_all FROM `versions` WHERE (`versions`.project_id = 7) 
180
Rendered projects/settings/_versions (5.7ms)
181
  SQL (0.1ms)   SELECT count(*) AS count_all FROM `issue_categories` WHERE (`issue_categories`.project_id = 7) 
182
Rendered projects/settings/_issue_categories (2.4ms)
183
  Wiki Columns (0.7ms)   SHOW FIELDS FROM `wikis`
184
Rendered projects/settings/_wiki (5.8ms)
185
  Setting Load (0.1ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'enabled_scm') LIMIT 1
186
Rendered projects/settings/_repository (9.0ms)
187
  SQL (0.1ms)   SELECT count(*) AS count_all FROM `boards` WHERE (`boards`.project_id = 7) 
188
Rendered projects/settings/_boards (2.4ms)
189
  TimeEntryActivity Columns (0.8ms)   SHOW FIELDS FROM `enumerations`
190
  CustomField Load (0.1ms)   SELECT * FROM `custom_fields` WHERE (type = 'TimeEntryActivityCustomField') ORDER BY position
191
  TimeEntryActivity Load (0.1ms)   SELECT * FROM `enumerations` WHERE (`enumerations`.project_id = 7) AND ( (`enumerations`.`type` = 'TimeEntryActivity' ) ) ORDER BY enumerations.position ASC
192
  TimeEntryActivity Load (0.1ms)   SELECT * FROM `enumerations` WHERE (`enumerations`.`project_id` IS NULL) AND ( (`enumerations`.`type` = 'TimeEntryActivity' ) ) ORDER BY enumerations.position ASC
193
  CACHE (0.0ms)   SELECT * FROM `custom_fields` WHERE (type = 'TimeEntryActivityCustomField') ORDER BY position
194
  CACHE (0.0ms)   SELECT * FROM `custom_fields` WHERE (type = 'TimeEntryActivityCustomField') ORDER BY position
195
Rendered projects/settings/_activities (19.6ms)
196
Rendered common/_tabs (204.1ms)
197
  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))) 
198
  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')))) 
199
Completed in 229ms (View: 213, DB: 7) | 200 OK [http://myserver.com/projects/max-banner-ads/settings]
200

    
201

    
202
Processing ProjectsController#settings (for 110.34.4.242 at 2010-11-23 01:40:01) [GET]
203
  Parameters: {"action"=>"settings", "id"=>"max-banner-ads", "controller"=>"projects", "tab"=>"repository"}
204
  SQL (0.1ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 
205
  User Load (0.1ms)   SELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 
206
  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (`projects`.`identifier` = 'max-banner-ads') LIMIT 1
207
  EnabledModule Load (0.1ms)   SELECT name FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 7) 
208
  IssueCustomField Load (0.1ms)   SELECT * FROM `custom_fields` WHERE ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY custom_fields.position
209
  Tracker Load (0.1ms)   SELECT * FROM `trackers` ORDER BY position
210
  Repository Load (0.1ms)   SELECT * FROM `repositories` WHERE (`repositories`.project_id = 7) LIMIT 1
211
  Wiki Load (0.1ms)   SELECT * FROM `wikis` WHERE (`wikis`.project_id = 7) LIMIT 1
212
Rendering template within layouts/base
213
Rendering projects/settings
214
  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (projects.status=1) 
215
  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (projects.`lft` >= 5 AND projects.`rgt` <= 6) ORDER BY `lft`
216
  CustomField Load (0.1ms)   SELECT * FROM `custom_fields` WHERE (type = 'ProjectCustomField') ORDER BY position
217
  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
218
  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
219
  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
220
Rendered projects/_form (8.7ms)
221
Rendered projects/_edit (9.9ms)
222
  EnabledModule Load (0.1ms)   SELECT * FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 7) 
223
Rendered projects/settings/_modules (5.0ms)
224
  Role Load (0.1ms)   SELECT * FROM `roles` WHERE (`roles`.`builtin` = 0) ORDER BY position
225
  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))) 
226
  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
227
  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)))) 
228
Rendered projects/settings/_members (7.3ms)
229
  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 5 AND projects.`rgt` >= 6) ORDER BY `lft` LIMIT 1
230
  CACHE (0.0ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 5 AND projects.`rgt` >= 6) ORDER BY `lft` LIMIT 1
231
  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')))) 
232
  SQL (0.1ms)   SELECT count(*) AS count_all FROM `versions` WHERE (`versions`.project_id = 7) 
233
Rendered projects/settings/_versions (69.1ms)
234
  SQL (0.1ms)   SELECT count(*) AS count_all FROM `issue_categories` WHERE (`issue_categories`.project_id = 7) 
235
Rendered projects/settings/_issue_categories (1.1ms)
236
Rendered projects/settings/_wiki (2.9ms)
237
Rendered projects/settings/_repository (9.0ms)
238
  SQL (0.1ms)   SELECT count(*) AS count_all FROM `boards` WHERE (`boards`.project_id = 7) 
239
Rendered projects/settings/_boards (1.8ms)
240
  CustomField Load (0.1ms)   SELECT * FROM `custom_fields` WHERE (type = 'TimeEntryActivityCustomField') ORDER BY position
241
  TimeEntryActivity Load (0.1ms)   SELECT * FROM `enumerations` WHERE (`enumerations`.project_id = 7) AND ( (`enumerations`.`type` = 'TimeEntryActivity' ) ) ORDER BY enumerations.position ASC
242
  TimeEntryActivity Load (0.1ms)   SELECT * FROM `enumerations` WHERE (`enumerations`.`project_id` IS NULL) AND ( (`enumerations`.`type` = 'TimeEntryActivity' ) ) ORDER BY enumerations.position ASC
243
  CACHE (0.0ms)   SELECT * FROM `custom_fields` WHERE (type = 'TimeEntryActivityCustomField') ORDER BY position
244
  CACHE (0.0ms)   SELECT * FROM `custom_fields` WHERE (type = 'TimeEntryActivityCustomField') ORDER BY position
245
Rendered projects/settings/_activities (10.7ms)
246
Rendered common/_tabs (124.1ms)
247
  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))) 
248
  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')))) 
249
Completed in 147ms (View: 139, DB: 2) | 200 OK [http://myserver.com/projects/max-banner-ads/settings/repository]
250

    
251

    
252
Processing RepositoriesController#destroy (for 110.34.4.242 at 2010-11-23 01:40:21) [POST]
253
  Parameters: {"action"=>"destroy", "authenticity_token"=>"Z6TJI9dGgADr25gQuCKDITbZ7r6M4EaZtIqNHhMKrsA=", "id"=>"max-banner-ads", "controller"=>"repositories"}
254
  SQL (0.1ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 
255
  User Load (0.1ms)   SELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 
256
  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (`projects`.`identifier` = 'max-banner-ads') LIMIT 1
257
  Repository Load (0.1ms)   SELECT * FROM `repositories` WHERE (`repositories`.project_id = 7) LIMIT 1
258
Shelling out: git --git-dir '/home/git/redmine/repositories/git-test.git/' branch
259
  EnabledModule Load (0.1ms)   SELECT name FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 7) 
260
  SQL (0.1ms)   BEGIN
261
  SQL (0.2ms)   DELETE FROM changes WHERE changes.changeset_id IN (SELECT changesets.id FROM changesets WHERE changesets.repository_id = 16)
262
  SQL (0.1ms)   DELETE FROM changesets_issues WHERE changesets_issues.changeset_id IN (SELECT changesets.id FROM changesets WHERE changesets.repository_id = 16)
263
  SQL (0.1ms)   DELETE FROM changesets WHERE changesets.repository_id = 16
264
  Repository::Git Destroy (0.1ms)   DELETE FROM `repositories` WHERE `id` = 16
265
  SQL (2.0ms)   COMMIT
266
Redirected to http://myserver.com/redmine/projects/max-banner-ads/settings/repository
267
Completed in 31ms (DB: 3) | 302 Found [http://myserver.com/projects/max-banner-ads/repository/destroy]
268

    
269

    
270
Processing ProjectsController#settings (for 110.34.4.242 at 2010-11-23 01:40:23) [GET]
271
  Parameters: {"action"=>"settings", "id"=>"max-banner-ads", "controller"=>"projects", "tab"=>"repository"}
272
  SQL (0.1ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 
273
  User Load (0.1ms)   SELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 
274
  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (`projects`.`identifier` = 'max-banner-ads') LIMIT 1
275
  EnabledModule Load (0.1ms)   SELECT name FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 7) 
276
  IssueCustomField Load (0.1ms)   SELECT * FROM `custom_fields` WHERE ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY custom_fields.position
277
  Tracker Load (0.1ms)   SELECT * FROM `trackers` ORDER BY position
278
  Repository Load (0.3ms)   SELECT * FROM `repositories` WHERE (`repositories`.project_id = 7) LIMIT 1
279
  Wiki Load (0.1ms)   SELECT * FROM `wikis` WHERE (`wikis`.project_id = 7) LIMIT 1
280
Rendering template within layouts/base
281
Rendering projects/settings
282
  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (projects.status=1) 
283
  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (projects.`lft` >= 5 AND projects.`rgt` <= 6) ORDER BY `lft`
284
  CustomField Load (0.1ms)   SELECT * FROM `custom_fields` WHERE (type = 'ProjectCustomField') ORDER BY position
285
  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
286
  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
287
  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
288
Rendered projects/_form (17.1ms)
289
Rendered projects/_edit (19.1ms)
290
  EnabledModule Load (0.1ms)   SELECT * FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 7) 
291
Rendered projects/settings/_modules (9.8ms)
292
  Role Load (0.1ms)   SELECT * FROM `roles` WHERE (`roles`.`builtin` = 0) ORDER BY position
293
  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))) 
294
  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
295
  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)))) 
296
Rendered projects/settings/_members (12.6ms)
297
  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 5 AND projects.`rgt` >= 6) ORDER BY `lft` LIMIT 1
298
  CACHE (0.0ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 5 AND projects.`rgt` >= 6) ORDER BY `lft` LIMIT 1
299
  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')))) 
300
  SQL (0.1ms)   SELECT count(*) AS count_all FROM `versions` WHERE (`versions`.project_id = 7) 
301
Rendered projects/settings/_versions (4.9ms)
302
  SQL (0.1ms)   SELECT count(*) AS count_all FROM `issue_categories` WHERE (`issue_categories`.project_id = 7) 
303
Rendered projects/settings/_issue_categories (1.5ms)
304
Rendered projects/settings/_wiki (4.7ms)
305
Rendered projects/settings/_repository (5.0ms)
306
  SQL (0.1ms)   SELECT count(*) AS count_all FROM `boards` WHERE (`boards`.project_id = 7) 
307
Rendered projects/settings/_boards (1.5ms)
308
  CustomField Load (0.1ms)   SELECT * FROM `custom_fields` WHERE (type = 'TimeEntryActivityCustomField') ORDER BY position
309
  TimeEntryActivity Load (0.1ms)   SELECT * FROM `enumerations` WHERE (`enumerations`.project_id = 7) AND ( (`enumerations`.`type` = 'TimeEntryActivity' ) ) ORDER BY enumerations.position ASC
310
  TimeEntryActivity Load (0.1ms)   SELECT * FROM `enumerations` WHERE (`enumerations`.`project_id` IS NULL) AND ( (`enumerations`.`type` = 'TimeEntryActivity' ) ) ORDER BY enumerations.position ASC
311
  CACHE (0.0ms)   SELECT * FROM `custom_fields` WHERE (type = 'TimeEntryActivityCustomField') ORDER BY position
312
  CACHE (0.0ms)   SELECT * FROM `custom_fields` WHERE (type = 'TimeEntryActivityCustomField') ORDER BY position
313
Rendered projects/settings/_activities (9.9ms)
314
Rendered common/_tabs (79.4ms)
315
  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))) 
316
  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')))) 
317
Completed in 186ms (View: 175, DB: 3) | 200 OK [http://myserver.com/projects/max-banner-ads/settings/repository]
318

    
319

    
320
Processing RepositoriesController#edit (for 110.34.4.242 at 2010-11-23 01:40:36) [GET]
321
  Parameters: {"action"=>"edit", "authenticity_token"=>"Z6TJI9dGgADr25gQuCKDITbZ7r6M4EaZtIqNHhMKrsA=", "id"=>"max-banner-ads", "controller"=>"repositories", "repository_scm"=>"Git"}
322
  SQL (0.1ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 
323
  User Load (0.1ms)   SELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 
324
  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (`projects`.`identifier` = 'max-banner-ads') LIMIT 1
325
  EnabledModule Load (0.1ms)   SELECT name FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 7) 
326
  Repository Load (0.1ms)   SELECT * FROM `repositories` WHERE (`repositories`.project_id = 7) LIMIT 1
327
Rendered projects/settings/_repository (8.8ms)
328
  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (`projects`.`id` = 7) 
329
  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 5 AND projects.`rgt` >= 6) ORDER BY `lft` LIMIT 1
330
  CACHE (0.0ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 5 AND projects.`rgt` >= 6) ORDER BY `lft` LIMIT 1
331
  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')))) 
332
  Wiki Load (0.1ms)   SELECT * FROM `wikis` WHERE (`wikis`.project_id = 7) LIMIT 1
333
  SQL (0.1ms)   SELECT count(*) AS count_all FROM `boards` WHERE (`boards`.project_id = 7) 
334
  CACHE (0.0ms)   SELECT * FROM `repositories` WHERE (`repositories`.project_id = 7) LIMIT 1
335
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]
336

    
337

    
338
Processing RepositoriesController#edit (for 110.34.4.242 at 2010-11-23 01:40:56) [POST]
339
  Parameters: {"repository"=>{"url"=>"/home/git/git-test/.git"}, "commit"=>"Create", "action"=>"edit", "authenticity_token"=>"Z6TJI9dGgADr25gQuCKDITbZ7r6M4EaZtIqNHhMKrsA=", "id"=>"max-banner-ads", "controller"=>"repositories", "repository_scm"=>"Git"}
340
  SQL (0.1ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 
341
  User Load (0.1ms)   SELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 
342
  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (`projects`.`identifier` = 'max-banner-ads') LIMIT 1
343
  EnabledModule Load (0.1ms)   SELECT name FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 7) 
344
  Repository Load (0.1ms)   SELECT * FROM `repositories` WHERE (`repositories`.project_id = 7) LIMIT 1
345
  SQL (0.1ms)   BEGIN
346
  Repository::Git Create (0.2ms)   INSERT INTO `repositories` (`project_id`, `url`, `type`, `login`, `password`, `root_url`) VALUES(7, '/home/git/git-test/.git', 'Git', '', '', '')
347
  SQL (0.8ms)   COMMIT
348
Rendered projects/settings/_repository (5.3ms)
349
  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (`projects`.`id` = 7) 
350
  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 5 AND projects.`rgt` >= 6) ORDER BY `lft` LIMIT 1
351
  CACHE (0.0ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 5 AND projects.`rgt` >= 6) ORDER BY `lft` LIMIT 1
352
  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')))) 
353
  Wiki Load (0.1ms)   SELECT * FROM `wikis` WHERE (`wikis`.project_id = 7) LIMIT 1
354
  SQL (0.1ms)   SELECT count(*) AS count_all FROM `boards` WHERE (`boards`.project_id = 7) 
355
  Repository Load (0.3ms)   SELECT * FROM `repositories` WHERE (`repositories`.project_id = 7) LIMIT 1
356
Completed in 24ms (View: 15, DB: 2) | 200 OK [http://myserver.com/projects/max-banner-ads/repository/edit]
357

    
358

    
359
Processing RepositoriesController#edit (for 110.34.4.242 at 2010-11-23 01:41:04) [POST]
360
  Parameters: {"repository"=>{"url"=>"/home/git/git-test/.git"}, "commit"=>"Save", "action"=>"edit", "authenticity_token"=>"Z6TJI9dGgADr25gQuCKDITbZ7r6M4EaZtIqNHhMKrsA=", "id"=>"max-banner-ads", "controller"=>"repositories"}
361
  SQL (0.1ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 
362
  User Load (0.1ms)   SELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 
363
  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (`projects`.`identifier` = 'max-banner-ads') LIMIT 1
364
  EnabledModule Load (0.1ms)   SELECT name FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 7) 
365
  Repository Load (0.1ms)   SELECT * FROM `repositories` WHERE (`repositories`.project_id = 7) LIMIT 1
366
  SQL (0.1ms)   BEGIN
367
  SQL (0.1ms)   COMMIT
368
Rendered projects/settings/_repository (7.4ms)
369
Completed in 17ms (View: 9, DB: 1) | 200 OK [http://myserver.com/projects/max-banner-ads/repository/edit]
370

    
371

    
372
Processing RepositoriesController#show (for 110.34.4.242 at 2010-11-23 01:41:08) [GET]
373
  Parameters: {"action"=>"show", "id"=>"max-banner-ads", "controller"=>"repositories"}
374
  SQL (0.1ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 
375
  User Load (0.1ms)   SELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 
376
  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (`projects`.`identifier` = 'max-banner-ads') LIMIT 1
377
  Repository Load (0.1ms)   SELECT * FROM `repositories` WHERE (`repositories`.project_id = 7) LIMIT 1
378
Shelling out: git --git-dir '/home/git/git-test/.git/' log --pretty=fuller --no-merges -n 1 
379
  SQL (0.1ms)   BEGIN
380
  Repository::Git Update (0.2ms)   UPDATE `repositories` SET `root_url` = '/home/git/git-test/.git' WHERE `id` = 17
381
  SQL (15.2ms)   COMMIT
382
Shelling out: git --git-dir '/home/git/git-test/.git/' branch
383
  EnabledModule Load (0.1ms)   SELECT name FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 7) 
384
  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
385
Shelling out: git --git-dir '/home/git/git-test/.git/' log --raw --date=iso --pretty=fuller  --all 
386
Shelling out: git --git-dir '/home/git/git-test/.git/' ls-tree -l 'HEAD:'
387
Rendering template within layouts/base
388
  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))) 
389
  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 5 AND projects.`rgt` >= 6) ORDER BY `lft` LIMIT 1
390
  CACHE (0.0ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 5 AND projects.`rgt` >= 6) ORDER BY `lft` LIMIT 1
391
  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')))) 
392
  Wiki Load (0.1ms)   SELECT * FROM `wikis` WHERE (`wikis`.project_id = 7) LIMIT 1
393
  SQL (0.1ms)   SELECT count(*) AS count_all FROM `boards` WHERE (`boards`.project_id = 7) 
394
Completed in 110ms (View: 17, DB: 17) | 500 Internal Server Error [http://myserver.com/projects/max-banner-ads/repository]
395

    
396

    
397
Processing ProjectsController#settings (for 110.34.4.242 at 2010-11-23 01:41:22) [GET]
398
  Parameters: {"action"=>"settings", "id"=>"max-banner-ads", "controller"=>"projects"}
399
  SQL (0.1ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 
400
  User Load (0.1ms)   SELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 
401
  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (`projects`.`identifier` = 'max-banner-ads') LIMIT 1
402
  EnabledModule Load (0.1ms)   SELECT name FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 7) 
403
  IssueCustomField Load (0.1ms)   SELECT * FROM `custom_fields` WHERE ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY custom_fields.position
404
  Tracker Load (0.1ms)   SELECT * FROM `trackers` ORDER BY position
405
  Repository Load (0.3ms)   SELECT * FROM `repositories` WHERE (`repositories`.project_id = 7) LIMIT 1
406
  Wiki Load (0.1ms)   SELECT * FROM `wikis` WHERE (`wikis`.project_id = 7) LIMIT 1
407
Rendering template within layouts/base
408
Rendering projects/settings
409
  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (projects.status=1) 
410
  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (projects.`lft` >= 5 AND projects.`rgt` <= 6) ORDER BY `lft`
411
  CustomField Load (0.1ms)   SELECT * FROM `custom_fields` WHERE (type = 'ProjectCustomField') ORDER BY position
412
  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
413
  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
414
  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
415
Rendered projects/_form (10.3ms)
416
Rendered projects/_edit (11.7ms)
417
  EnabledModule Load (0.1ms)   SELECT * FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 7) 
418
Rendered projects/settings/_modules (5.4ms)
419
  Role Load (0.1ms)   SELECT * FROM `roles` WHERE (`roles`.`builtin` = 0) ORDER BY position
420
  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))) 
421
  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
422
  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)))) 
423
Rendered projects/settings/_members (92.5ms)
424
  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 5 AND projects.`rgt` >= 6) ORDER BY `lft` LIMIT 1
425
  CACHE (0.0ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 5 AND projects.`rgt` >= 6) ORDER BY `lft` LIMIT 1
426
  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')))) 
427
  SQL (0.1ms)   SELECT count(*) AS count_all FROM `versions` WHERE (`versions`.project_id = 7) 
428
Rendered projects/settings/_versions (3.4ms)
429
  SQL (0.1ms)   SELECT count(*) AS count_all FROM `issue_categories` WHERE (`issue_categories`.project_id = 7) 
430
Rendered projects/settings/_issue_categories (0.9ms)
431
Rendered projects/settings/_wiki (2.6ms)
432
Rendered projects/settings/_repository (5.7ms)
433
  SQL (0.1ms)   SELECT count(*) AS count_all FROM `boards` WHERE (`boards`.project_id = 7) 
434
Rendered projects/settings/_boards (0.9ms)
435
  CustomField Load (0.1ms)   SELECT * FROM `custom_fields` WHERE (type = 'TimeEntryActivityCustomField') ORDER BY position
436
  TimeEntryActivity Load (0.1ms)   SELECT * FROM `enumerations` WHERE (`enumerations`.project_id = 7) AND ( (`enumerations`.`type` = 'TimeEntryActivity' ) ) ORDER BY enumerations.position ASC
437
  TimeEntryActivity Load (0.1ms)   SELECT * FROM `enumerations` WHERE (`enumerations`.`project_id` IS NULL) AND ( (`enumerations`.`type` = 'TimeEntryActivity' ) ) ORDER BY enumerations.position ASC
438
  CACHE (0.0ms)   SELECT * FROM `custom_fields` WHERE (type = 'TimeEntryActivityCustomField') ORDER BY position
439
  CACHE (0.0ms)   SELECT * FROM `custom_fields` WHERE (type = 'TimeEntryActivityCustomField') ORDER BY position
440
Rendered projects/settings/_activities (7.2ms)
441
Rendered common/_tabs (137.4ms)
442
  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))) 
443
  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')))) 
444
Completed in 158ms (View: 149, DB: 2) | 200 OK [http://myserver.com/projects/max-banner-ads/settings]