Project

General

Profile

Defect #7850 » development.xml.log

Artem Konoplin, 2011-03-15 05:42

 
1
# Logfile created on Tue Mar 15 09:33:26 +0500 2011  SQL (0.0ms)   SET NAMES 'utf8'
2
  SQL (0.0ms)   SET SQL_AUTO_IS_NULL=0
3
  SQL (0.0ms)   SET NAMES 'utf8'
4
  SQL (0.0ms)   SET SQL_AUTO_IS_NULL=0
5

    
6

    
7
Processing ProjectsController#create to xml (for 127.0.0.1 at 2011-03-15 09:34:01) [POST]
8
  Parameters: {"format"=>"xml", "action"=>"create", "project"=>{"name"=>"test123", "identifier"=>"test123"}, "controller"=>"projects"}
9
  Setting Columns (5.0ms)   SHOW FIELDS FROM `settings`
10
  SQL (1.0ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 
11
  Setting Load (1.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'rest_api_enabled') LIMIT 1
12
  User Columns (6.0ms)   SHOW FIELDS FROM `users`
13
  User Load (1.0ms)   SELECT * FROM `users` WHERE (BINARY login = 'admin') AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) LIMIT 1
14
  SQL (0.0ms)   BEGIN
15
  User Update (0.0ms)   UPDATE `users` SET `last_login_on` = '2011-03-15 09:34:08', `updated_on` = '2011-03-15 09:34:08' WHERE `id` = 1
16
  CustomField Load (1.0ms)   SELECT * FROM `custom_fields` WHERE (type = 'UserCustomField') ORDER BY position
17
  SQL (26.0ms)   COMMIT
18
  IssueCustomField Columns (6.0ms)   SHOW FIELDS FROM `custom_fields`
19
  IssueCustomField Load (2.0ms)   SELECT * FROM `custom_fields` WHERE ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY custom_fields.position
20
  Tracker Load (2.0ms)   SELECT * FROM `trackers` ORDER BY position
21
  Project Columns (7.0ms)   SHOW FIELDS FROM `projects`
22
  Setting Load (1.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'sequential_project_identifiers') LIMIT 1
23
  Setting Load (1.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'default_projects_public') LIMIT 1
24
  Setting Load (1.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'default_projects_modules') LIMIT 1
25
  EnabledModule Columns (6.0ms)   SHOW FIELDS FROM `enabled_modules`
26
  SQL (1.0ms)   BEGIN
27
  SQL (0.0ms)   COMMIT
28
  SQL (0.0ms)   BEGIN
29
  SQL (0.0ms)   COMMIT
30
  SQL (1.0ms)   BEGIN
31
  SQL (0.0ms)   COMMIT
32
  SQL (0.0ms)   BEGIN
33
  SQL (1.0ms)   COMMIT
34
  SQL (0.0ms)   BEGIN
35
  SQL (0.0ms)   COMMIT
36
  SQL (0.0ms)   BEGIN
37
  SQL (1.0ms)   COMMIT
38
  SQL (0.0ms)   BEGIN
39
  SQL (0.0ms)   COMMIT
40
  SQL (0.0ms)   BEGIN
41
  SQL (0.0ms)   COMMIT
42
  SQL (0.0ms)   BEGIN
43
  SQL (0.0ms)   COMMIT
44
  SQL (1.0ms)   BEGIN
45
  SQL (0.0ms)   COMMIT
46
  CACHE (0.0ms)   SELECT * FROM `trackers` ORDER BY position
47
  SQL (1.0ms)   BEGIN
48
  Tracker Columns (6.0ms)   SHOW FIELDS FROM `trackers`
49
  SQL (0.0ms)   COMMIT
50
  SQL (0.0ms)   BEGIN
51
  CustomField Load (2.0ms)   SELECT * FROM `custom_fields` WHERE (type = 'ProjectCustomField') ORDER BY position
52
  CustomField Columns (6.0ms)   SHOW FIELDS FROM `custom_fields`
53
  CustomValue Columns (5.0ms)   SHOW FIELDS FROM `custom_values`
54
  ProjectCustomField Columns (6.0ms)   SHOW FIELDS FROM `custom_fields`
55
  EnabledModule Load (1.0ms)   SELECT `enabled_modules`.id FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'issue_tracking' AND `enabled_modules`.project_id IS NULL) LIMIT 1
56
  EnabledModule Load (0.0ms)   SELECT `enabled_modules`.id FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'time_tracking' AND `enabled_modules`.project_id IS NULL) LIMIT 1
57
  EnabledModule Load (0.0ms)   SELECT `enabled_modules`.id FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'news' AND `enabled_modules`.project_id IS NULL) LIMIT 1
58
  EnabledModule Load (0.0ms)   SELECT `enabled_modules`.id FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'documents' AND `enabled_modules`.project_id IS NULL) LIMIT 1
59
  EnabledModule Load (0.0ms)   SELECT `enabled_modules`.id FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'files' AND `enabled_modules`.project_id IS NULL) LIMIT 1
60
  EnabledModule Load (1.0ms)   SELECT `enabled_modules`.id FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'wiki' AND `enabled_modules`.project_id IS NULL) LIMIT 1
61
  EnabledModule Load (1.0ms)   SELECT `enabled_modules`.id FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'repository' AND `enabled_modules`.project_id IS NULL) LIMIT 1
62
  EnabledModule Load (1.0ms)   SELECT `enabled_modules`.id FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'boards' AND `enabled_modules`.project_id IS NULL) LIMIT 1
63
  EnabledModule Load (0.0ms)   SELECT `enabled_modules`.id FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'calendar' AND `enabled_modules`.project_id IS NULL) LIMIT 1
64
  EnabledModule Load (0.0ms)   SELECT `enabled_modules`.id FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'gantt' AND `enabled_modules`.project_id IS NULL) LIMIT 1
65
  Project Load (1.0ms)   SELECT `projects`.id FROM `projects` WHERE (`projects`.`identifier` = BINARY 'test123') LIMIT 1
66
  SQL (0.0ms)   SELECT max(`projects`.rgt) AS max_rgt FROM `projects` 
67
  Project Create (0.0ms)   INSERT INTO `projects` (`name`, `created_on`, `lft`, `updated_on`, `homepage`, `parent_id`, `description`, `is_public`, `identifier`, `status`, `rgt`) VALUES('test123', '2011-03-15 09:34:10', 7, '2011-03-15 09:34:10', '', NULL, NULL, 1, 'test123', 1, 8)
68
  EnabledModule Load (0.0ms)   SELECT `enabled_modules`.id FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'issue_tracking' AND `enabled_modules`.project_id = 10) LIMIT 1
69
  EnabledModule Create (0.0ms)   INSERT INTO `enabled_modules` (`name`, `project_id`) VALUES('issue_tracking', 10)
70
  EnabledModule Load (0.0ms)   SELECT `enabled_modules`.id FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'time_tracking' AND `enabled_modules`.project_id = 10) LIMIT 1
71
  EnabledModule Create (1.0ms)   INSERT INTO `enabled_modules` (`name`, `project_id`) VALUES('time_tracking', 10)
72
  EnabledModule Load (0.0ms)   SELECT `enabled_modules`.id FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'news' AND `enabled_modules`.project_id = 10) LIMIT 1
73
  EnabledModule Create (1.0ms)   INSERT INTO `enabled_modules` (`name`, `project_id`) VALUES('news', 10)
74
  EnabledModule Load (1.0ms)   SELECT `enabled_modules`.id FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'documents' AND `enabled_modules`.project_id = 10) LIMIT 1
75
  EnabledModule Create (1.0ms)   INSERT INTO `enabled_modules` (`name`, `project_id`) VALUES('documents', 10)
76
  EnabledModule Load (0.0ms)   SELECT `enabled_modules`.id FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'files' AND `enabled_modules`.project_id = 10) LIMIT 1
77
  EnabledModule Create (0.0ms)   INSERT INTO `enabled_modules` (`name`, `project_id`) VALUES('files', 10)
78
  EnabledModule Load (0.0ms)   SELECT `enabled_modules`.id FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'wiki' AND `enabled_modules`.project_id = 10) LIMIT 1
79
  EnabledModule Create (0.0ms)   INSERT INTO `enabled_modules` (`name`, `project_id`) VALUES('wiki', 10)
80
  Project Load (1.0ms)   SELECT * FROM `projects` WHERE (`projects`.`id` = 10) 
81
  Wiki Load (1.0ms)   SELECT * FROM `wikis` WHERE (`wikis`.project_id = 10) LIMIT 1
82
  Wiki Columns (6.0ms)   SHOW FIELDS FROM `wikis`
83
  Wiki Create (0.0ms)   INSERT INTO `wikis` (`project_id`, `start_page`, `status`) VALUES(10, 'Wiki', 1)
84
  EnabledModule Load (1.0ms)   SELECT `enabled_modules`.id FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'repository' AND `enabled_modules`.project_id = 10) LIMIT 1
85
  EnabledModule Create (1.0ms)   INSERT INTO `enabled_modules` (`name`, `project_id`) VALUES('repository', 10)
86
  EnabledModule Load (0.0ms)   SELECT `enabled_modules`.id FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'boards' AND `enabled_modules`.project_id = 10) LIMIT 1
87
  EnabledModule Create (0.0ms)   INSERT INTO `enabled_modules` (`name`, `project_id`) VALUES('boards', 10)
88
  EnabledModule Load (0.0ms)   SELECT `enabled_modules`.id FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'calendar' AND `enabled_modules`.project_id = 10) LIMIT 1
89
  EnabledModule Create (0.0ms)   INSERT INTO `enabled_modules` (`name`, `project_id`) VALUES('calendar', 10)
90
  EnabledModule Load (0.0ms)   SELECT `enabled_modules`.id FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'gantt' AND `enabled_modules`.project_id = 10) LIMIT 1
91
  EnabledModule Create (1.0ms)   INSERT INTO `enabled_modules` (`name`, `project_id`) VALUES('gantt', 10)
92
  SQL (6.0ms)   describe `projects_trackers`
93
  projects_trackers Columns (5.0ms)   SHOW FIELDS FROM `projects_trackers`
94
  SQL (1.0ms)   INSERT INTO `projects_trackers` (`project_id`, `tracker_id`) VALUES (10, 1)
95
  SQL (6.0ms)   describe `projects_trackers`
96
  SQL (0.0ms)   INSERT INTO `projects_trackers` (`project_id`, `tracker_id`) VALUES (10, 2)
97
  SQL (5.0ms)   describe `projects_trackers`
98
  SQL (0.0ms)   INSERT INTO `projects_trackers` (`project_id`, `tracker_id`) VALUES (10, 3)
99
  CustomValue Create (1.0ms)   INSERT INTO `custom_values` (`customized_id`, `customized_type`, `custom_field_id`, `value`) VALUES(10, 'Project', 2, 'rr')
100
  SQL (42.0ms)   COMMIT
101
Rendering projects/show (created)
102
  CustomField Load (2.0ms)   SELECT * FROM `custom_fields` WHERE (type = 'ProjectCustomField') ORDER BY position
103
Completed in 10110ms (View: 579, DB: 186) | 201 Created [http://localhost/projects.xml]
(1-1/2)