Upgrading from 0.6.x to 0.7

Added by Geordee Naliyath over 9 years ago

I am trying to upgrade from 0.6 to 0.7 and getting the following error.

Mysql::Error: #42S01Table 'user_preferences' already exists: CREATE TABLE `user_preferences` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `user_id` int(11) DEFAULT 0 NOT NULL, `others` text DEFAULT NULL) ENGINE=InnoDB

I am following instructions as per http://www.redmine.org/wiki/redmine/RedmineUpgrade

Any thoughts?

Replies (5)

RE: Upgrading from 0.6.x to 0.7 - Added by Thomas Lecavelier over 9 years ago

The table user_preferences was added in migration 8, it's rather strange that ActiveRecord tried to recreate it. Have you altered your database by hand before migrating (like working on a patch or something like that)?

RE: Upgrading from 0.6.x to 0.7 - Added by Geordee Naliyath over 9 years ago

I have deleted records. I have not changed any database/table structure

RE: Upgrading from 0.6.x to 0.7 - Added by Thomas Lecavelier over 9 years ago

Why having deleted records? O_o

If you deleted every records, and don't need to keep any data from your previous redmine installation, the best to do is to drop your database and to recreate it from scratch, then running the migrations.

RE: Upgrading from 0.6.x to 0.7 - Added by Geordee Naliyath over 9 years ago

I have a lot of data in Redmine, even in user preference tables. This is just one thing I am stuck with, otherwise I would like to upgrade to 0.7. I have done a clean installation in another server, and it works fine. Is there any other way to migrate data from 0.6 to 0.7. - from an old 0.6 installation to a clean 0.7 installation?

RE: Upgrading from 0.6.x to 0.7 - Added by Geordee Naliyath over 9 years ago

I just copied over the data from 0.6 database to 0.7 vanilla installation and it worked! I used PHPMyAdmin Export/Import (only data).

Thanks. No major trouble in upgrading, even if I had to do the database stuff manually.

(1-5/5)