redmine_importer icon indicating copy to clipboard operation
redmine_importer copied to clipboard

Error updating existing issues win Redmine 3.3.0

Open leaver opened this issue 8 years ago • 0 comments

The error in the production.log is:

I, [2017-02-09T11:45:38.957629 #7928] INFO -- : STATEMENT projects.id = 4 AND (issues.status_id IS NOT NULL) AND issues.id IN (SELECT issues.id FROM issues LEFT OUTER JOIN custom_values ON custom_values.customized_type='Issue' AND custom_values.customized_id=issues.id AND custom_values.custom_field_id=1 WHERE (custom_values.value IN ('SHR1600729')) AND (((1=1) AND (issues.tracker_id IN (SELECT tracker_id FROM custom_fields_trackers WHERE custom_field_id = 1)) AND (EXISTS (SELECT 1 FROM custom_fields ifa WHERE ifa.is_for_all = 1 AND ifa.id = 1) OR issues.project_id IN (SELECT project_id FROM custom_fields_projects WHERE custom_field_id = 1))))) I, [2017-02-09T11:45:38.964629 #7928] INFO -- : Completed 500 Internal Server Error in 256ms (ActiveRecord: 131.0ms) F, [2017-02-09T11:45:38.967630 #7928] FATAL -- : ActiveRecord::StatementInvalid (Mysql2::Error: Unknown column 'projects.id' in 'where clause': SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM issuesWHERE (projects.id = 4 AND (issues.status_id IS NOT NULL) AND issues.id IN (SELECT issues.id FROM issues LEFT OUTER JOIN custom_values ON custom_values.customized_type='Issue' AND custom_values.customized_id=issues.id AND custom_values.custom_field_id=1 WHERE (custom_values.value IN ('SHR1600729')) AND (((1=1) AND (issues.tracker_id IN (SELECT tracker_id FROM custom_fields_trackers WHERE custom_field_id = 1)) AND (EXISTS (SELECT 1 FROM custom_fields ifa WHERE ifa.is_for_all = 1 AND ifa.id = 1) OR issues.project_id IN (SELECT project_id FROM custom_fields_projects WHERE custom_field_id = 1)))))) LIMIT 2) subquery_for_count): plugins/redmine_importer/app/controllers/importer_controller.rb:172:inissue_for_unique_attr' plugins/redmine_importer/app/controllers/importer_controller.rb:361:in block in result' plugins/redmine_importer/app/controllers/importer_controller.rb:304:in result' lib/redmine/sudo_mode.rb:63:in sudo_mode'

My environment: Environment: Redmine version 3.3.0.stable Ruby version 2.1.8-p440 (2015-12-16) [i386-mingw32] Rails version 4.2.6 Environment production Database adapter Mysql2

leaver avatar Feb 13 '17 10:02 leaver