Defect #5846

ChangeChangesPathLengthLimit does not remove default for MySQL

Added by Scott Holden about 10 years ago. Updated about 10 years ago.

Status:ClosedStart date:2010-07-08
Priority:NormalDue date:
Assignee:Eric Davis% Done:

100%

Category:Database
Target version:1.0.1
Resolution:Fixed Affected version:

Description

The migration fails for MySQL because default is not allowed on a text column. An explicity change_column_default should correct this.

5846_migration_fix.patch Magnifier (1.09 KB) Holger Just, 2010-07-23 00:24

Related issues

Related to Redmine - Defect #5771: Problem when importing git repository Closed 2010-06-28

Associated revisions

Revision 3860
Added by Eric Davis about 10 years ago

Force-clear the default value for migration from :string to :text. #5846 #5771

This is a special case for MySQL in Win32.

Contributed by Holger Just.

History

#1 Updated by Vladimir Schetinin about 10 years ago

I can't migrate too.
Migration fails with error about ChangeChangesPathLengthLimit and defaults for columns in MySQL.

versions:
Redmine trunk
Rails 2.3.8
MySQL 5.0.67

#2 Updated by Holger Just about 10 years ago

The issue was discussed in depth in the forum in this thread: db migration error.

The attached patch fixes it.

#3 Updated by Eric Davis about 10 years ago

  • Category set to Database
  • Status changed from New to Closed
  • Assignee set to Eric Davis
  • Target version set to 1.0.1
  • % Done changed from 0 to 100
  • Affected version (unused) set to 1.0.0-RC
  • Resolution set to Fixed

Updated the migration in r3860 and r3861.

Also available in: Atom PDF