Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error updating existing issues win Redmine 3.3.0 #49

Open
leaver opened this issue Feb 13, 2017 · 0 comments
Open

Error updating existing issues win Redmine 3.3.0 #49

leaver opened this issue Feb 13, 2017 · 0 comments

Comments

@leaver
Copy link

leaver commented Feb 13, 2017

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant