Project

General

Profile

Actions

Defect #8028

closed

Migration error under MSSQL 2000

Added by Petr Pospisil almost 13 years ago. Updated over 6 years ago.

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

0%

Estimated time:
0.50 h
Resolution:
Wont fix
Affected version:

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

Actions #1

Updated by Jean-Philippe Lang almost 13 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?

Actions #2

Updated by Petr Pospisil almost 13 years ago

yep, only this one.

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

Actions #3

Updated by Go MAEDA over 6 years ago

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

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

Actions

Also available in: Atom PDF