Project

General

Profile

Defect #19485

Updated by Toshi MARUYAMA about 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

Back