migration 91 and 92 fail against SQL Server 2005

Added by Jason Morris over 9 years ago

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.

I believe I have a working redmine, but I am worried that future version will cause me similar pain.

I will submit this as an issue, but wanted to check here first if there was already a solution I didn't find via search.

Replies (2)

RE: migration 91 and 92 fail against SQL Server 2005 - Added by Thomas Lecavelier over 9 years ago

Please open a defect to follow this issue. Thank you.

(1-2/2)