Project

General

Profile

Problems upgrading from 0.8.7 to 0.9.3.

Added by Alberto Perez about 14 years ago

I'm trying to upgrade from 0.8.7 to 0.9.3.

I got errors when run the rake db:migrate command.

I have installed the folowing plugins:

redmine_issues_group
awesome_nested_set
redmine_graphs
open_flash_chart
redmine_charts
redmine_issues_due_date

rake db:migrate RAILS_ENV="production" 
(in /opt/bitnami/apps/redmine)
==  AddCustomFieldsEditable: migrating ========================================
-- add_column(:custom_fields, :editable, :boolean, {:default=>true})
   -> 0.0527s
==  AddCustomFieldsEditable: migrated (0.0529s) ===============================

==  SetCustomFieldsEditable: migrating ========================================
==  SetCustomFieldsEditable: migrated (0.0041s) ===============================

==  AddProjectsLftAndRgt: migrating ===========================================
-- add_column(:projects, :lft, :integer)
   -> 0.0145s
-- add_column(:projects, :rgt, :integer)
   -> 0.0060s
==  AddProjectsLftAndRgt: migrated (0.0206s) ==================================

==  BuildProjectsTree: migrating ==============================================
==  BuildProjectsTree: migrated (0.1304s) =====================================

==  RemoveProjectsProjectsCount: migrating ====================================
-- remove_column(:projects, :projects_count)
   -> 0.0065s
==  RemoveProjectsProjectsCount: migrated (0.0066s) ===========================

==  AddOpenIdAuthenticationTables: migrating ==================================
-- create_table(:open_id_authentication_associations, {:force=>true})
   -> 0.0048s
-- create_table(:open_id_authentication_nonces, {:force=>true})
   -> 0.0052s
==  AddOpenIdAuthenticationTables: migrated (0.0102s) =========================

==  AddIdentityUrlToUsers: migrating ==========================================
-- add_column(:users, :identity_url, :string)
   -> 0.0068s
==  AddIdentityUrlToUsers: migrated (0.0069s) =================================

==  AddWatchersUserIdTypeIndex: migrating =====================================
-- add_index(:watchers, [:user_id, :watchable_type], {:name=>:watchers_user_id_type})
   -> 0.0082s
==  AddWatchersUserIdTypeIndex: migrated (0.0083s) ============================

==  AddQueriesSortCriteria: migrating =========================================
-- add_column(:queries, :sort_criteria, :text)
   -> 0.0057s
==  AddQueriesSortCriteria: migrated (0.0058s) ================================

==  AddProjectsTrackersUniqueIndex: migrating =================================
-- add_index(:projects_trackers, [:project_id, :tracker_id], {:unique=>true, :name=>:projects_trackers_unique})
   -> 0.0066s
==  AddProjectsTrackersUniqueIndex: migrated (0.0125s) ========================

==  ExtendSettingsName: migrating =============================================
-- change_column(:settings, :name, :string, {:default=>"", :null=>false, :limit=>255})
   -> 0.0083s
==  ExtendSettingsName: migrated (0.0084s) ====================================

==  AddTypeToEnumerations: migrating ==========================================
-- add_column(:enumerations, :type, :string)
   -> 0.0068s
==  AddTypeToEnumerations: migrated (0.0069s) =================================

==  UpdateEnumerationsToSti: migrating ========================================
==  UpdateEnumerationsToSti: migrated (0.0024s) ===============================

==  AddActiveFieldToEnumerations: migrating ===================================
-- add_column(:enumerations, :active, :boolean, {:default=>true, :null=>false})
   -> 0.0053s
==  AddActiveFieldToEnumerations: migrated (0.0054s) ==========================

==  AddProjectToEnumerations: migrating =======================================
-- add_column(:enumerations, :project_id, :integer, {:default=>nil, :null=>true})
   -> 0.0058s
-- add_index(:enumerations, :project_id)
   -> 0.0050s
==  AddProjectToEnumerations: migrated (0.0109s) ==============================

==  AddParentIdToEnumerations: migrating ======================================
-- add_column(:enumerations, :parent_id, :integer, {:default=>nil, :null=>true})
   -> 0.0052s
==  AddParentIdToEnumerations: migrated (0.0053s) =============================

==  AddQueriesGroupBy: migrating ==============================================
-- add_column(:queries, :group_by, :string)
rake aborted!
An error has occurred, all later migrations canceled:

Mysql::Error: Duplicate column name 'group_by': ALTER TABLE `queries` ADD `group_by` varchar(255)

(See full trace by running task with --trace)


Replies (2)

RE: Problems upgrading from 0.8.7 to 0.9.3. - Added by Alberto Perez about 14 years ago

sorry adding system info:

About your application's environment
Ruby version 1.8.7 (i686-linux)
RubyGems version 1.3.5
Rack version 1.0
Rails version 2.3.5
Active Record version 2.3.5
Active Resource version 2.3.5
Action Mailer version 2.3.5
Active Support version 2.3.5
Application root /opt/bitnami/apps/redmine
Environment production
Database adapter mysql
Database schema version 20090406161854

About your Redmine plugins
Issue Due Date 0.1.0
Redmine Graphs plugin 0.1.0
Charts Plugin 0.0.14
Redmine Issues Group plugin 0.1.6

RE: Problems upgrading from 0.8.7 to 0.9.3. - Added by Alberto Perez almost 14 years ago

Solved.

The problem was the columns added by the plugin "Redmine Issues Group plugin".

Looking the plugin migration commands it is possible to rollback this changes.

Issues:

Delete lgt,rgt,and ParentID columns.

Queries:

Delete Cathegory and group by columns.

Execute the version upgrade rake command: rake db:migrate RAILS_ENV=production

later I install again all the plugins but Redmine Issues Group plugin and execute the migration commands for the plugins.

    (1-2/2)