Project

General

Profile

Actions
Copy link

Defect #23966

closed

db:migrate InsertBuiltinGroups needs to be after RemoveUsersMail

Added by Equipe Evolix over 8 years ago. Updated over 8 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Database
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Invalid
Affected version:
3.2.0

Description

Hello,

db:migate fails with old Redmine versions :

InsertBuiltinGroups (20140920094058_insert_builtin_groups.rb) fails with old versions because users.mail column always exists :

Mysql2::Error: Field 'mail' doesn't have a default value: INSERT INTO `users` (`type`, `lastname`, `created_on`, `updated_on`, `firstname`) VALUES ('GroupAnonymous', 'Anonymous users', '2016-10-01 14:28:55', '2016-10-01 14:28:55','')/home/foo/.gem/ruby/2.1.0/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:305:in `query'

users.mail column is deleted after by RemoveUsersMail (20150113213922_remove_users_mail.rb)

If I change order with InsertBuiltinGroups just after RemoveUsersMail, all is right.

Regards,

Grégory Colpart / Evolix

Actions
Copy link
 #1

Updated by Toshi MARUYAMA over 8 years ago

  • Status changed from New to Closed
  • Resolution set to Invalid

source:tags/3.3.0/db/migrate/001_setup.rb#L210

    create_table "users", :force => true do |t|
      ...
      t.column "mail", :string, :limit => 60, :default => "", :null => false
Actions
Copy link

Also available in: Atom PDF