Defect #19485
Updated by Toshi MARUYAMA over 9 years ago
Hello. i`ve got the following error after upgrading from 2.6.1 to 3.0.1 <pre> Mysql2::Error: Column 'address' in where clause is ambiguous: SELECT DISTINCT `users`.* FROM `users` INNER JOIN `email_addresses` ON `email_addresses`.`user_id` = `users`.`id` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND (LOWER(address) IN ('myemail@mail.com')) ORDER BY `users`.`id` ASC LIMIT 1 </pre> emails received by cronjob every minute. rake redmine:email:receive_imap RAILS_ENV="production" host=imap.gmail.com port=993 username=email@email password=password ssl=true move_on_success=read project=public-project247 category=HelpDesk unknown_user=create no_permission_check=1 allow_override=tracker,priority,project,status,category,assigned_to Please give advise for solving this issue Environment: Redmine version 3.0.1.stable Ruby version 1.9.3-p194 (2012-04-20) [x86_64-linux] Rails version 4.2.0 Environment production Database adapter Mysql2 SCM: Git 1.7.10.4 Filesystem Redmine plugins: redmine_agile 1.3.8 redmine_email_fetcher 0.3.0 redmine_issue_history 1.0.0 redmine_wysiwyg 1.0.0 plugins Redmine Agile plugin (Light version) redmine_issue_history redmine_wysiwyg