Defect #8028

Migration error under MSSQL 2000

Added by Petr Pospisil over 6 years ago. Updated 26 days ago.

Status:ClosedStart date:2011-03-31
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:DatabaseEstimated time:0.50 hour
Target version:-
Resolution:Wont fix Affected version:1.1.2

Description

Hello,

I tried to install the Redmine on MSSQL 2000 and I had to change a migration file, because some kind of error occured on MSSQL side. (cannot change a column because it is in use by other object)

091_change_changesets_revision_to_string.rb
-------------------------------------------
line 3 change_column :changesets, :revision, :string, :null => false
-------------------------------------------

patched:
remove_index :changesets, :name => :changesets_repos_rev
change_column :changesets, :revision, :string, :null => false
add_index :changesets, [:repository_id, :revision], :unique => true, :name => :changesets_repos_rev

Regards
Petr

History

#1 Updated by Jean-Philippe Lang over 6 years ago

MSSQL is not officially supported (and totally untested) but I'm curious about how Redmine behaves with it.
Did all other migrations run fine?

#2 Updated by Petr Pospisil over 6 years ago

yep, only this one.

But I don't know if all pages are working as expected, I tested only migration.

#3 Updated by Go MAEDA 26 days ago

  • Status changed from New to Closed
  • Resolution set to Wont fix

Since SQL Server 2000 is too old, I am closing this issue.

Also available in: Atom PDF