Redmine

look at #5907

Hi Stepan, I've carefully read #5907, I droped the db and migrated it again... but seems it's all ok in the db... I've search for the columns listed in #5907 and it's all ok.

Here's the result of rake db:migrate RAILS_ENV=production

==  AddActivityIndexes: migrating =============================================
-- add_index(:journals, :created_on)
   -> 0.0232s
-- add_index(:changesets, :committed_on)
   -> 0.0168s
-- add_index(:wiki_content_versions, :updated_on)
   -> 0.0049s
-- add_index(:messages, :created_on)
   -> 0.0047s
-- add_index(:issues, :created_on)
   -> 0.0321s
-- add_index(:news, :created_on)
   -> 0.0044s
-- add_index(:attachments, :created_on)
   -> 0.0053s
-- add_index(:documents, :created_on)
   -> 0.0052s
-- add_index(:time_entries, :created_on)
   -> 0.0070s
==  AddActivityIndexes: migrated (0.1041s) ====================================

==  AddVersionsStatus: migrating ==============================================
-- add_column(:versions, :status, :string, {:default=>"open"})
   -> 0.0047s
==  AddVersionsStatus: migrated (0.0051s) =====================================

==  AddViewIssuesPermission: migrating ========================================
==  AddViewIssuesPermission: migrated (0.0785s) ===============================

==  AddDefaultDoneRatioToIssueStatus: migrating ===============================
-- add_column(:issue_statuses, :default_done_ratio, :integer)
   -> 0.0049s
==  AddDefaultDoneRatioToIssueStatus: migrated (0.0050s) ======================

==  AddVersionsSharing: migrating =============================================
-- add_column(:versions, :sharing, :string, {:null=>false, :default=>"none"})
   -> 0.0043s
-- add_index(:versions, :sharing)
   -> 0.0041s
==  AddVersionsSharing: migrated (0.0086s) ====================================

==  AddLftAndRgtIndexesToProjects: migrating ==================================
-- add_index(:projects, :lft)
   -> 0.0046s
-- add_index(:projects, :rgt)
   -> 0.0046s
==  AddLftAndRgtIndexesToProjects: migrated (0.0094s) =========================

==  AddIndexToSettingsName: migrating =========================================
-- add_index(:settings, :name)
   -> 0.0056s
==  AddIndexToSettingsName: migrated (0.0056s) ================================

==  AddIndexesToIssueStatus: migrating ========================================
-- add_index(:issue_statuses, :position)
   -> 0.0042s
-- add_index(:issue_statuses, :is_closed)
   -> 0.0044s
-- add_index(:issue_statuses, :is_default)
   -> 0.0044s
==  AddIndexesToIssueStatus: migrated (0.0132s) ===============================

==  RemoveEnumerationsOpt: migrating ==========================================
-- remove_column(:enumerations, :opt)
   -> 0.0044s
==  RemoveEnumerationsOpt: migrated (0.0045s) =================================

==  ChangeWikiContentsTextLimit: migrating ====================================
-- change_column(:wiki_contents, :text, :text, {:limit=>16777216})
   -> 0.0052s
-- change_column(:wiki_content_versions, :data, :binary, {:limit=>16777216})
   -> 0.0044s
==  ChangeWikiContentsTextLimit: migrated (0.0099s) ===========================

==  AddIndexOnChangesetsScmid: migrating ======================================
-- add_index(:changesets, [:repository_id, :scmid], {:name=>:changesets_repos_scmid})
   -> 0.0075s
==  AddIndexOnChangesetsScmid: migrated (0.0076s) =============================

==  AddIssuesNestedSetsColumns: migrating =====================================
-- add_column(:issues, :parent_id, :integer, {:default=>nil})
   -> 0.0339s
-- add_column(:issues, :root_id, :integer, {:default=>nil})
   -> 0.0311s
-- add_column(:issues, :lft, :integer, {:default=>nil})
   -> 0.0306s
-- add_column(:issues, :rgt, :integer, {:default=>nil})
   -> 0.0333s
==  AddIssuesNestedSetsColumns: migrated (0.1648s) ============================

==  AddIndexOnIssuesNestedSet: migrating ======================================
-- add_index(:issues, [:root_id, :lft, :rgt])
   -> 0.0565s
==  AddIndexOnIssuesNestedSet: migrated (0.0566s) =============================

==  ChangeChangesPathLengthLimit: migrating ===================================
-- change_column(:changes, :path, :text, {:null=>false})
   -> 0.1150s
-- change_column(:changes, :from_path, :text)
   -> 0.0885s
==  ChangeChangesPathLengthLimit: migrated (0.2037s) ==========================

Can't seem to identify the problem...

I had a similar problem moving from 0.8.4.devel to 1.0.0 stable.

I was able to resolve the issue by migrating from 0.8.4.devel to 0.9 stable, then from 0.9 stable to 1.0.0 stable.

Cheers,

Leon.