Project

General

Profile

Actions

Defect #1652

closed

migrations 91 and 92 fail against SQL Server 2005

Added by Jason Morris over 16 years ago. Updated over 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

Also available in: Atom PDF