# 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]