Project

General

Profile

Defect #7850 » development.xml.log

Artem Konoplin, 2011-03-15 05:42

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


Processing ProjectsController#create to xml (for 127.0.0.1 at 2011-03-15 09:34:01) [POST]
Parameters: {"format"=>"xml", "action"=>"create", "project"=>{"name"=>"test123", "identifier"=>"test123"}, "controller"=>"projects"}
Setting Columns (5.0ms) SHOW FIELDS FROM `settings`
SQL (1.0ms) SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 
Setting Load (1.0ms) SELECT * FROM `settings` WHERE (`settings`.`name` = 'rest_api_enabled') LIMIT 1
User Columns (6.0ms) SHOW FIELDS FROM `users`
User Load (1.0ms) SELECT * FROM `users` WHERE (BINARY login = 'admin') AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) LIMIT 1
SQL (0.0ms) BEGIN
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
CustomField Load (1.0ms) SELECT * FROM `custom_fields` WHERE (type = 'UserCustomField') ORDER BY position
SQL (26.0ms) COMMIT
IssueCustomField Columns (6.0ms) SHOW FIELDS FROM `custom_fields`
IssueCustomField Load (2.0ms) SELECT * FROM `custom_fields` WHERE ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY custom_fields.position
Tracker Load (2.0ms) SELECT * FROM `trackers` ORDER BY position
Project Columns (7.0ms) SHOW FIELDS FROM `projects`
Setting Load (1.0ms) SELECT * FROM `settings` WHERE (`settings`.`name` = 'sequential_project_identifiers') LIMIT 1
Setting Load (1.0ms) SELECT * FROM `settings` WHERE (`settings`.`name` = 'default_projects_public') LIMIT 1
Setting Load (1.0ms) SELECT * FROM `settings` WHERE (`settings`.`name` = 'default_projects_modules') LIMIT 1
EnabledModule Columns (6.0ms) SHOW FIELDS FROM `enabled_modules`
SQL (1.0ms) BEGIN
SQL (0.0ms) COMMIT
SQL (0.0ms) BEGIN
SQL (0.0ms) COMMIT
SQL (1.0ms) BEGIN
SQL (0.0ms) COMMIT
SQL (0.0ms) BEGIN
SQL (1.0ms) COMMIT
SQL (0.0ms) BEGIN
SQL (0.0ms) COMMIT
SQL (0.0ms) BEGIN
SQL (1.0ms) COMMIT
SQL (0.0ms) BEGIN
SQL (0.0ms) COMMIT
SQL (0.0ms) BEGIN
SQL (0.0ms) COMMIT
SQL (0.0ms) BEGIN
SQL (0.0ms) COMMIT
SQL (1.0ms) BEGIN
SQL (0.0ms) COMMIT
CACHE (0.0ms) SELECT * FROM `trackers` ORDER BY position
SQL (1.0ms) BEGIN
Tracker Columns (6.0ms) SHOW FIELDS FROM `trackers`
SQL (0.0ms) COMMIT
SQL (0.0ms) BEGIN
CustomField Load (2.0ms) SELECT * FROM `custom_fields` WHERE (type = 'ProjectCustomField') ORDER BY position
CustomField Columns (6.0ms) SHOW FIELDS FROM `custom_fields`
CustomValue Columns (5.0ms) SHOW FIELDS FROM `custom_values`
ProjectCustomField Columns (6.0ms) SHOW FIELDS FROM `custom_fields`
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
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
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
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
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
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
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
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
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
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
Project Load (1.0ms) SELECT `projects`.id FROM `projects` WHERE (`projects`.`identifier` = BINARY 'test123') LIMIT 1
SQL (0.0ms) SELECT max(`projects`.rgt) AS max_rgt FROM `projects` 
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)
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
EnabledModule Create (0.0ms) INSERT INTO `enabled_modules` (`name`, `project_id`) VALUES('issue_tracking', 10)
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
EnabledModule Create (1.0ms) INSERT INTO `enabled_modules` (`name`, `project_id`) VALUES('time_tracking', 10)
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
EnabledModule Create (1.0ms) INSERT INTO `enabled_modules` (`name`, `project_id`) VALUES('news', 10)
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
EnabledModule Create (1.0ms) INSERT INTO `enabled_modules` (`name`, `project_id`) VALUES('documents', 10)
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
EnabledModule Create (0.0ms) INSERT INTO `enabled_modules` (`name`, `project_id`) VALUES('files', 10)
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
EnabledModule Create (0.0ms) INSERT INTO `enabled_modules` (`name`, `project_id`) VALUES('wiki', 10)
Project Load (1.0ms) SELECT * FROM `projects` WHERE (`projects`.`id` = 10) 
Wiki Load (1.0ms) SELECT * FROM `wikis` WHERE (`wikis`.project_id = 10) LIMIT 1
Wiki Columns (6.0ms) SHOW FIELDS FROM `wikis`
Wiki Create (0.0ms) INSERT INTO `wikis` (`project_id`, `start_page`, `status`) VALUES(10, 'Wiki', 1)
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
EnabledModule Create (1.0ms) INSERT INTO `enabled_modules` (`name`, `project_id`) VALUES('repository', 10)
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
EnabledModule Create (0.0ms) INSERT INTO `enabled_modules` (`name`, `project_id`) VALUES('boards', 10)
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
EnabledModule Create (0.0ms) INSERT INTO `enabled_modules` (`name`, `project_id`) VALUES('calendar', 10)
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
EnabledModule Create (1.0ms) INSERT INTO `enabled_modules` (`name`, `project_id`) VALUES('gantt', 10)
SQL (6.0ms) describe `projects_trackers`
projects_trackers Columns (5.0ms) SHOW FIELDS FROM `projects_trackers`
SQL (1.0ms) INSERT INTO `projects_trackers` (`project_id`, `tracker_id`) VALUES (10, 1)
SQL (6.0ms) describe `projects_trackers`
SQL (0.0ms) INSERT INTO `projects_trackers` (`project_id`, `tracker_id`) VALUES (10, 2)
SQL (5.0ms) describe `projects_trackers`
SQL (0.0ms) INSERT INTO `projects_trackers` (`project_id`, `tracker_id`) VALUES (10, 3)
CustomValue Create (1.0ms) INSERT INTO `custom_values` (`customized_id`, `customized_type`, `custom_field_id`, `value`) VALUES(10, 'Project', 2, 'rr')
SQL (42.0ms) COMMIT
Rendering projects/show (created)
CustomField Load (2.0ms) SELECT * FROM `custom_fields` WHERE (type = 'ProjectCustomField') ORDER BY position
Completed in 10110ms (View: 579, DB: 186) | 201 Created [http://localhost/projects.xml]
(1-1/2)