Migrate a project to redmine 0.9 to 1.0.2

Added by Camille NERON over 8 years ago

Hello,

I have one server with redmine 0.9 (mysql) with my project in progress, and i have a new server with redmine 1.0.2 witout project.

I would like to migrate my project of my old server on my new.

I try to get a dump of my database and restore it on the new. It works but on the Issues page i have a "Internal error" message.

If you have an idea ... :-)

Thanks for your help

CaMs

Note : sorry to my english, i'm french ...

Replies (17)

RE: Migrate a project to redmine 0.9 to 1.0.2 - Added by Felix Schäfer over 8 years ago

Run RAILS_ENV=production rake db:migrate on the new server to upgrade the database from the 0.9 version to 1.0.2.

RE: Migrate a project to redmine 0.9 to 1.0.2 - Added by Camille NERON over 8 years ago

thanks to your response

i try it but it doesn't work

maybe i must install on my new server redmine 0.9, coping the database, and upgrade redmine a new version

i will try it

RE: Migrate a project to redmine 0.9 to 1.0.2 - Added by Felix Schäfer over 8 years ago

Camille NERON wrote:

i try it but it doesn't work

What doesn't work? It makes no difference whether you upgrade the DB on your old or your new server, but you have to upgrade it for the DB to work correctly with redmine 1.0.

RE: Migrate a project to redmine 0.9 to 1.0.2 - Added by Camille NERON over 8 years ago

the command works :

# RAILS_ENV=production rake db:migrate
(in /srv/www/htdocs/redmine)
# echo $?
0

but i have always my problem on the issues page

Internal error

An error occurred on the page you were trying to access.
If you continue to experience problems please contact your redMine administrator for assistance.

RE: Migrate a project to redmine 0.9 to 1.0.2 - Added by Felix Schäfer over 8 years ago

Do you run redmine in production mode?

Anyway, please post the trace of the error from log/production.log (or development.log if you run redmine in development mode), maybe it's not related to the DB after all.

RE: Migrate a project to redmine 0.9 to 1.0.2 - Added by Camille NERON over 8 years ago

when i go to myproject then in issues page, in production.log i had this :

I go to the project page :

Processing ProjectsController#show (for 192.168.1.38 at 2010-11-01 16:19:46) [GET]
  Parameters: {"action"=>"show", "id"=>"intranetsup", "controller"=>"projects"}
Rendering template within layouts/base
Rendering projects/show
Completed in 617ms (View: 334, DB: 42) | 200 OK [http://red.m2env.org/projects/intranetsup]

I go to issue page :

Processing IssuesController#index (for 192.168.1.38 at 2010-11-01 16:19:50) [GET]
  Parameters: {"project_id"=>"intranetsup", "action"=>"index", "controller"=>"issues"}
Rendering template within layouts/base
Rendering issues/index.rhtml

ActionView::TemplateError (undefined method `-' for nil:NilClass) on line #16 of app/views/issues/_list.rhtml:
13:     </tr></thead>
14:     <% previous_group = false %>
15:     <tbody>
16:     <% issue_list(issues) do |issue, level| -%>
17:   <% if @query.grouped? && (group = @query.group_by_column.value(issue)) != previous_group %>
18:     <% reset_cycle %>
19:     <tr class="group open">

    app/helpers/issues_helper.rb:28:in `issue_list'
    app/helpers/issues_helper.rb:23:in `each'
    app/helpers/issues_helper.rb:23:in `issue_list'
    app/views/issues/_list.rhtml:16:in `_run_rhtml_app47views47issues47_list46rhtml_locals_issues_list_object_query'
    app/views/issues/_list.rhtml:1:in `_run_rhtml_app47views47issues47_list46rhtml_locals_issues_list_object_query'
    app/views/issues/index.rhtml:63:in `_run_rhtml_app47views47issues47index46rhtml'
    app/controllers/issues_controller.rb:84:in `index'
    app/controllers/issues_controller.rb:83:in `index'
    passenger (2.2.15) lib/phusion_passenger/rack/request_handler.rb:92:in `process_request'
    passenger (2.2.15) lib/phusion_passenger/abstract_request_handler.rb:207:in `main_loop'
    passenger (2.2.15) lib/phusion_passenger/railz/application_spawner.rb:441:in `start_request_handler'
    passenger (2.2.15) lib/phusion_passenger/railz/application_spawner.rb:381:in `handle_spawn_application'
    passenger (2.2.15) lib/phusion_passenger/utils.rb:252:in `safe_fork'
    passenger (2.2.15) lib/phusion_passenger/railz/application_spawner.rb:377:in `handle_spawn_application'
    passenger (2.2.15) lib/phusion_passenger/abstract_server.rb:352:in `__send__'
    passenger (2.2.15) lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
    passenger (2.2.15) lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'
    passenger (2.2.15) lib/phusion_passenger/abstract_server.rb:163:in `start'
    passenger (2.2.15) lib/phusion_passenger/railz/application_spawner.rb:222:in `start'
    passenger (2.2.15) lib/phusion_passenger/spawn_manager.rb:253:in `spawn_rails_application'
    passenger (2.2.15) lib/phusion_passenger/abstract_server_collection.rb:126:in `lookup_or_add'
    passenger (2.2.15) lib/phusion_passenger/spawn_manager.rb:247:in `spawn_rails_application'
    passenger (2.2.15) lib/phusion_passenger/abstract_server_collection.rb:80:in `synchronize'
    passenger (2.2.15) lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize'
    passenger (2.2.15) lib/phusion_passenger/spawn_manager.rb:246:in `spawn_rails_application'
    passenger (2.2.15) lib/phusion_passenger/spawn_manager.rb:145:in `spawn_application'
    passenger (2.2.15) lib/phusion_passenger/spawn_manager.rb:278:in `handle_spawn_application'
    passenger (2.2.15) lib/phusion_passenger/abstract_server.rb:352:in `__send__'
    passenger (2.2.15) lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
    passenger (2.2.15) lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'
*
Rendering /srv/www/htdocs/redmine/public/500.html (500 Internal Server Error)*

I use apache server with passenger mod.

Thanks to your help

RE: Migrate a project to redmine 0.9 to 1.0.2 - Added by Felix Schäfer over 8 years ago

This looks like a data consistency problem. Could you have a look at your DB and see if any rows in the issues table have an empty rgt, lft or root (names are from memory, could be slightly different) entry?

RE: Migrate a project to redmine 0.9 to 1.0.2 - Added by Camille NERON over 8 years ago

Hello,

Sorry for the late, i was very busy this week and do not have a good access to my server ...

i don't understand what you mean, in my issues table i don't have a with this names

in attachment i add the description of issues table

thanks to your help and good afternoon :-)

CaMs

Capture-5.png - Description of issues table (102 KB)

RE: Migrate a project to redmine 0.9 to 1.0.2 - Added by Felix Schäfer over 8 years ago

Camille NERON wrote:

in attachment i add the description of issues table

This DB is not updated, do you run redmine in development or production mode?

RE: Migrate a project to redmine 0.9 to 1.0.2 - Added by Camille NERON over 8 years ago

in my config/database.yml i have configured my DB in production mode so i think i am in production mode but i'm not sure, how can i check please ?

RE: Migrate a project to redmine 0.9 to 1.0.2 - Added by Camille NERON over 8 years ago

i use apache, with this VirtualHost :

<VirtualHost *:80>
        ServerName red.m2env.org
        DocumentRoot /srv/www/htdocs/redmine/public
<Directory /srv/www/htdocs/redmine/public>
        AllowOverride all
        Options -MultiViews
</Directory>
</VirtualHost>

RE: Migrate a project to redmine 0.9 to 1.0.2 - Added by Felix Schäfer over 8 years ago

Then you are using passenger, and that should start redmine in production mode.

Run RAILS_ENV=production rake db:migrate in your redmine directory to upgrade the DB.

RE: Migrate a project to redmine 0.9 to 1.0.2 - Added by Camille NERON over 8 years ago

if i do :

apache:/srv/www/htdocs/redmine# RAILS_ENV=production rake db:migrate
(in /srv/www/htdocs/redmine)
apache:/srv/www/htdocs/redmine# echo $?
0

nothing it's display in my console, and in the table issues, nothing has been changed ... i think it doesn't work, were i can find log about this command ?

RE: Migrate a project to redmine 0.9 to 1.0.2 - Added by Camille NERON over 8 years ago

i retry with the option -t and -v :

apache:/srv/www/htdocs/redmine# RAILS_ENV=production rake db:migrate -tv
(in /srv/www/htdocs/redmine)
** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:migrate
** Invoke db:schema:dump (first_time)
** Invoke environment 
** Execute db:schema:dump

it seems good ...

RE: Migrate a project to redmine 0.9 to 1.0.2 - Added by Felix Schäfer over 8 years ago

Yes, but the DB you have shown me up there is not one that has been upgraded to 1.0. I'm really sorry, I'm a little out of ideas now…

RE: Migrate a project to redmine 0.9 to 1.0.2 - Added by Camille NERON over 8 years ago

ok i doesn't matter, thanks to your help

i have finally success

1. i have up my old version to the last
2. i have make a dump of my old DB
3. i have restore the db on the new DB

and it's ok !

(1-17/17)