Project

General

Profile

Actions

Defect #1652

closed

migrations 91 and 92 fail against SQL Server 2005

Added by Jason Morris about 16 years ago. Updated about 16 years ago.

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

0%

Estimated time:
Resolution:
Invalid
Affected version:

Description

I just attempt to install redmine db onto sql server 2005 and received the following error when running rake db:migrate

91 ChangeChangesetsRevisionToString: migrating ===========================
-- change_column(:changesets, :revision, :string, {:null=>false})
rake aborted!
DBI::DatabaseError: Execute
OLE error code:80040E14 in Microsoft OLE DB Provider for SQL Server
The index 'changesets_repos_rev' is dependent on column 'revision'.
HRESULT error code:0x80020009
Exception occurred.: ALTER TABLE changesets ALTER COLUMN revision varchar(255)

My workaround was to do the two migration manually, which worked fine. I then re-ran the migration and they worked...this also got my db version up to 92.


Files

MigrationPatchr1709.patch (1.53 KB) MigrationPatchr1709.patch Chris Taylor, 2008-07-29 21:49
Actions #1

Updated by Jean-Philippe Lang about 16 years ago

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

Please note that SQLServer database is not supported.

Actions #2

Updated by Chris Taylor about 16 years ago

Migration 91 fails because an index was previously applied to the column, preventing Sql Server from altering it. Migration 92 fails because of a constraint applied to the column. The attached patch resolves both issues.

Actions

Also available in: Atom PDF