Defect #13097
closedProject copy fails when wiki module is disabled
0%
Description
Information
Redmine 2.1.2
Ruby version 1.9.3 (x86_64-linux)
RubyGems version 1.8.24
Rack version 1.4
Rails version 3.2.8
Active Record version 3.2.8
Action Pack version 3.2.8
Active Resource version 3.2.8
Action Mailer version 3.2.8
Active Support version 3.2.8
Environment production
Database adapter mysql2
Database: mysql Ver 14.16 Distrib 5.2.12-MariaDB, for suse-linux-gnu (x86_64) using readline 5.1
Problem
When you copy a project that it doesn't have the wiki module activated, the copy crash. When you copy a project that have the wiki module activated there's no problem.
Code
In app/models/project.rb
def copy_wiki(project) # Check that the source project has a wiki first unless project.wiki.nil? self.wiki ||= Wiki.new wiki.attributes = project.wiki.attributes.dup.except("id", "project_id") wiki_pages_map = {} project.wiki.pages.each do |page| # Skip pages without content next if page.content.nil? new_wiki_content = WikiContent.new(page.content.attributes.dup.except("id", "page_id", "updated_on")) new_wiki_page = WikiPage.new(page.attributes.dup.except("id", "wiki_id", "created_on", "parent_id")) new_wiki_page.content = new_wiki_content wiki.pages << new_wiki_page wiki_pages_map[page.id] = new_wiki_page end wiki.save # Reproduce page hierarchy project.wiki.pages.each do |page| if page.parent_id && wiki_pages_map[page.id] wiki_pages_map[page.id].parent = wiki_pages_map[page.parent_id] wiki_pages_map[page.id].save end end end end
if you change the code it works correctly
def copy_wiki(project) # Check that the source project has a wiki first unless project.wiki.nil? wiki = Wiki.new wiki.attributes = project.wiki.attributes.dup.except("id", "project_id") wiki_pages_map = {} project.wiki.pages.each do |page| # Skip pages without content next if page.content.nil? new_wiki_content = WikiContent.new(page.content.attributes.dup.except("id", "page_id", "updated_on")) new_wiki_page = WikiPage.new(page.attributes.dup.except("id", "wiki_id", "created_on", "parent_id")) new_wiki_page.content = new_wiki_content wiki.pages << new_wiki_page wiki_pages_map[page.id] = new_wiki_page end self.wiki = wiki wiki.save # Reproduce page hierarchy project.wiki.pages.each do |page| if page.parent_id && wiki_pages_map[page.id] wiki_pages_map[page.id].parent = wiki_pages_map[page.parent_id] wiki_pages_map[page.id].save end end end end
Error log
Started POST "/projects/prova/copy" for 127.0.0.1 at 2013-02-07 11:54:14 +0100
Processing by ProjectsController#copy as HTML
Parameters: {"utf8"=>"✓", "authenticity_token"=>"R/TuuUitlFGsay8MNeshen6pJWpRaquVDl+fyFTVMN8=", "project"=>{"name"=>"testttt", "parent_id"=>"", "description"=>"dasdas", "identifier"=>"testttt", "homepage"=>"", "is_public"=>"0", "custom_field_values"=>{"1"=>"prova"}, "enabled_module_names"=>["issue_tracking", "time_tracking", "news", "documents", "files", "repository", "boards", "calendar", "gantt", "alfresco", "wiki_extensions", ""], "tracker_ids"=>["1", "2", "3", ""]}, "only"=>["members", "versions", "issue_categories", "issues", "queries", "boards", "wiki", ""], "commit"=>"Copia", "id"=>"prova"}
[1m[36m (0.4ms)[0m [1mSELECT MAX AS max_id FROM `settings` [0m
[1m[35mUser Load (0.6ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `users`.`id` = 3 AND (users.status = 1) LIMIT 1
Current user: gtanya (id=3)
[1m[36m (0.1ms)[0m [1mBEGIN[0m
[1m[35m (0.2ms)[0m SELECT * FROM concurrency_redmine FOR UPDATE
[1m[36mIssueCustomField Load (0.3ms)[0m [1mSELECT `custom_fields`.* FROM `custom_fields` WHERE `custom_fields`.`type` IN ('IssueCustomField') ORDER BY custom_fields.position[0m
[1m[35mTracker Load (0.3ms)[0m SELECT `trackers`.* FROM `trackers` ORDER BY trackers.position ASC
[1m[36mProject Load (0.8ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE (parent_id IS NULL AND status = 1) ORDER BY name[0m
[1m[35mProject Load (0.3ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`identifier` = 'prova' LIMIT 1
[1m[36mSetting Load (0.3ms)[0m [1mSELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'default_projects_public' LIMIT 1[0m
[1m[35mCACHE (0.0ms)[0m SELECT `trackers`.* FROM `trackers` ORDER BY trackers.position ASC
[1m[36mTracker Load (0.3ms)[0m [1mSELECT `trackers`.* FROM `trackers` WHERE `trackers`.`id` IN (1, 2, 3)[0m
[1m[35m (0.1ms)[0m DELETE FROM `projects_trackers` WHERE `projects_trackers`.`project_id` IS NULL AND `projects_trackers`.`tracker_id` IN (4)
[1m[36mCustomField Load (0.2ms)[0m [1mSELECT `custom_fields`.* FROM `custom_fields` WHERE (type = 'ProjectCustomField') ORDER BY position[0m
[1m[35mEnabledModule Exists (0.4ms)[0m SELECT 1 AS one FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'issue_tracking' AND `enabled_modules`.`project_id` IS NULL) LIMIT 1
[1m[36mEnabledModule Exists (0.3ms)[0m [1mSELECT 1 AS one FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'time_tracking' AND `enabled_modules`.`project_id` IS NULL) LIMIT 1[0m
[1m[35mEnabledModule Exists (0.2ms)[0m SELECT 1 AS one FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'news' AND `enabled_modules`.`project_id` IS NULL) LIMIT 1
[1m[36mEnabledModule Exists (0.2ms)[0m [1mSELECT 1 AS one FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'documents' AND `enabled_modules`.`project_id` IS NULL) LIMIT 1[0m
[1m[35mEnabledModule Exists (0.2ms)[0m SELECT 1 AS one FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'files' AND `enabled_modules`.`project_id` IS NULL) LIMIT 1
[1m[36mEnabledModule Exists (0.2ms)[0m [1mSELECT 1 AS one FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'repository' AND `enabled_modules`.`project_id` IS NULL) LIMIT 1[0m
[1m[35mEnabledModule Exists (0.2ms)[0m SELECT 1 AS one FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'boards' AND `enabled_modules`.`project_id` IS NULL) LIMIT 1
[1m[36mEnabledModule Exists (0.2ms)[0m [1mSELECT 1 AS one FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'calendar' AND `enabled_modules`.`project_id` IS NULL) LIMIT 1[0m
[1m[35mEnabledModule Exists (0.2ms)[0m SELECT 1 AS one FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'gantt' AND `enabled_modules`.`project_id` IS NULL) LIMIT 1
[1m[36mEnabledModule Exists (0.2ms)[0m [1mSELECT 1 AS one FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'alfresco' AND `enabled_modules`.`project_id` IS NULL) LIMIT 1[0m
[1m[35mEnabledModule Exists (0.2ms)[0m SELECT 1 AS one FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'wiki_extensions' AND `enabled_modules`.`project_id` IS NULL) LIMIT 1
[1m[36mProject Exists (0.2ms)[0m [1mSELECT 1 AS one FROM `projects` WHERE `projects`.`identifier` = BINARY 'testttt' LIMIT 1[0m
[1m[35mProject Load (0.4ms)[0m SELECT `projects`.* FROM `projects` ORDER BY `rgt` desc LIMIT 1 FOR UPDATE
[1m[36mSQL (0.3ms)[0m [1mINSERT INTO `projects` (`created_on`, `description`, `homepage`, `identifier`, `is_public`, `lft`, `name`, `parent_id`, `rgt`, `status`, `updated_on`) VALUES ('2013-02-07 11:54:14', 'dasdas', '', 'testttt', 0, 141, 'testttt', NULL, 142, 1, '2013-02-07 11:54:14')[0m
[1m[35mEnabledModule Exists (0.5ms)[0m SELECT 1 AS one FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'issue_tracking' AND `enabled_modules`.`project_id` = 87) LIMIT 1
[1m[36mSQL (0.8ms)[0m [1mINSERT INTO `enabled_modules` (`name`, `project_id`) VALUES ('issue_tracking', 87)[0m
[1m[35mEnabledModule Exists (0.3ms)[0m SELECT 1 AS one FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'time_tracking' AND `enabled_modules`.`project_id` = 87) LIMIT 1
[1m[36mSQL (0.2ms)[0m [1mINSERT INTO `enabled_modules` (`name`, `project_id`) VALUES ('time_tracking', 87)[0m
[1m[35mEnabledModule Exists (0.3ms)[0m SELECT 1 AS one FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'news' AND `enabled_modules`.`project_id` = 87) LIMIT 1
[1m[36mSQL (0.2ms)[0m [1mINSERT INTO `enabled_modules` (`name`, `project_id`) VALUES ('news', 87)[0m
[1m[35mEnabledModule Exists (0.3ms)[0m SELECT 1 AS one FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'documents' AND `enabled_modules`.`project_id` = 87) LIMIT 1
[1m[36mSQL (0.2ms)[0m [1mINSERT INTO `enabled_modules` (`name`, `project_id`) VALUES ('documents', 87)[0m
[1m[35mEnabledModule Exists (0.2ms)[0m SELECT 1 AS one FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'files' AND `enabled_modules`.`project_id` = 87) LIMIT 1
[1m[36mSQL (0.1ms)[0m [1mINSERT INTO `enabled_modules` (`name`, `project_id`) VALUES ('files', 87)[0m
[1m[35mEnabledModule Exists (0.2ms)[0m SELECT 1 AS one FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'repository' AND `enabled_modules`.`project_id` = 87) LIMIT 1
[1m[36mSQL (0.3ms)[0m [1mINSERT INTO `enabled_modules` (`name`, `project_id`) VALUES ('repository', 87)[0m
[1m[35mEnabledModule Exists (0.3ms)[0m SELECT 1 AS one FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'boards' AND `enabled_modules`.`project_id` = 87) LIMIT 1
[1m[36mSQL (0.2ms)[0m [1mINSERT INTO `enabled_modules` (`name`, `project_id`) VALUES ('boards', 87)[0m
[1m[35mEnabledModule Exists (0.3ms)[0m SELECT 1 AS one FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'calendar' AND `enabled_modules`.`project_id` = 87) LIMIT 1
[1m[36mSQL (0.2ms)[0m [1mINSERT INTO `enabled_modules` (`name`, `project_id`) VALUES ('calendar', 87)[0m
[1m[35mEnabledModule Exists (0.3ms)[0m SELECT 1 AS one FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'gantt' AND `enabled_modules`.`project_id` = 87) LIMIT 1
[1m[36mSQL (0.1ms)[0m [1mINSERT INTO `enabled_modules` (`name`, `project_id`) VALUES ('gantt', 87)[0m
[1m[35mEnabledModule Exists (0.2ms)[0m SELECT 1 AS one FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'alfresco' AND `enabled_modules`.`project_id` = 87) LIMIT 1
[1m[36mSQL (0.2ms)[0m [1mINSERT INTO `enabled_modules` (`name`, `project_id`) VALUES ('alfresco', 87)[0m
[1m[35mEnabledModule Exists (0.2ms)[0m SELECT 1 AS one FROM `enabled_modules` WHERE (`enabled_modules`.`name` = BINARY 'wiki_extensions' AND `enabled_modules`.`project_id` = 87) LIMIT 1
[1m[36mSQL (0.1ms)[0m [1mINSERT INTO `enabled_modules` (`name`, `project_id`) VALUES ('wiki_extensions', 87)[0m
[1m[35m (0.1ms)[0m INSERT INTO `projects_trackers` (`project_id`, `tracker_id`) VALUES (87, 1)
[1m[36m (0.1ms)[0m [1mINSERT INTO `projects_trackers` (`project_id`, `tracker_id`) VALUES (87, 2)[0m
[1m[35m (0.1ms)[0m INSERT INTO `projects_trackers` (`project_id`, `tracker_id`) VALUES (87, 3)
[1m[36mSQL (0.2ms)[0m [1mINSERT INTO `custom_values` (`custom_field_id`, `customized_id`, `customized_type`, `value`) VALUES (1, 87, 'Project', '')[0m
[1m[35m (0.3ms)[0m UPDATE `custom_values` SET `value` = 'prova' WHERE `custom_values`.`id` = 87
[1m[36mProject Load (0.7ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`parent_id` IS NULL ORDER BY `lft`[0m
[1m[35mProject Load (0.3ms)[0m SELECT `lft`, `rgt`, `parent_id` FROM `projects` WHERE `projects`.`id` = 25 LIMIT 1 FOR UPDATE
[1m[36mProject Load (0.2ms)[0m [1mSELECT `lft`, `rgt`, `parent_id` FROM `projects` WHERE `projects`.`id` = 87 LIMIT 1 FOR UPDATE[0m
[1m[35mSQL (1.0ms)[0m UPDATE `projects` SET `lft` = CASE WHEN `lft` BETWEEN 123 AND 140 THEN `lft` + 142 - 140 WHEN `lft` BETWEEN 141 AND 142 THEN `lft` + 123 - 141 ELSE `lft` END, `rgt` = CASE WHEN `rgt` BETWEEN 123 AND 140 THEN `rgt` + 142 - 140 WHEN `rgt` BETWEEN 141 AND 142 THEN `rgt` + 123 - 141 ELSE `rgt` END, `parent_id` = CASE WHEN id = 87 THEN NULL ELSE `parent_id` END ORDER BY `projects`.`lft`
[1m[36mProject Load (0.3ms)[0m [1mSELECT `lft`, `rgt`, `parent_id` FROM `projects` WHERE `projects`.`id` = 25 LIMIT 1 FOR UPDATE[0m
[1m[35mProject Load (0.3ms)[0m SELECT `lft`, `rgt`, `parent_id` FROM `projects` WHERE `projects`.`id` = 87 LIMIT 1 FOR UPDATE
[1m[36mProject Load (0.3ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 87 LIMIT 1[0m
[1m[35mWiki Load (0.4ms)[0m SELECT `wikis`.* FROM `wikis` WHERE `wikis`.`project_id` = 1 LIMIT 1
[1m[36mWiki Load (0.3ms)[0m [1mSELECT `wikis`.* FROM `wikis` WHERE `wikis`.`project_id` = 87 LIMIT 1[0m
[1m[35m (0.3ms)[0m UPDATE concurrency_redmine SET id=id+1
[1m[36m (14.6ms)[0m [1mROLLBACK[0m
Completed 500 Internal Server Error in 121ms
ActiveRecord::RecordNotSaved (Failed to save the new associated wiki.):
app/models/project.rb:724:in `copy_wiki'
app/models/project.rb:675:in `block (2 levels) in copy'
app/models/project.rb:674:in `each'
app/models/project.rb:674:in `block in copy'
app/models/project.rb:671:in `copy'
app/controllers/projects_controller.rb:128:in `block in copy'
app/models/mailer.rb:364:in `with_deliveries'
app/controllers/projects_controller.rb:125:in `copy'
Updated by Etienne Massip over 11 years ago
- Category set to Projects
- Status changed from New to Confirmed
- Target version set to Candidate for next minor release
- Affected version (unused) set to 2.1.2
- Affected version set to 2.1.2
Confirmed on demo (2.1.0), even if there's no wiki page created before wiki module has been deactivated.
Untested on trunk but don't remember any related fix.
Updated by Jean-Philippe Lang over 11 years ago
- Subject changed from Copy project crash without wiki module activated to Project copy fails when wiki module is disabled
- Status changed from Confirmed to Resolved
- Assignee set to Jean-Philippe Lang
- Target version changed from Candidate for next minor release to 2.2.3
- Resolution set to Fixed
Fixed in r11332, thanks for pointing this out.
Updated by Jean-Philippe Lang over 11 years ago
- Status changed from Resolved to Closed