以下のバージョンでCSVインポートすると、ActiveRecord::StatementInvalidが発生しました。原因わかる方いらっしゃいましたら、助けて下さい。。。
【バージョン】
Environment:
Redmine version 3.2.0.stable
Ruby version 2.1.7-p400 (2015-08-18) [i386-mingw32]
Rails version 4.2.5
Environment production
Database adapter Mysql2
SCM:
Subversion 1.8.9
Git 2.5.1
Filesystem
Redmine plugins:
redmine_importer 1.2.2
【エラー内容】
ActiveRecord::StatementInvalid (Mysql2::Error: Unknown column 'projects.id' in 'where clause': SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM issues
WHERE ((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 ('201602020037')) 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))))) AND projects.id = 1) LIMIT 2) subquery_for_count):
lib/redmine/sudo_mode.rb:63:in `sudo_mode'
あなたの回答
tips
プレビュー