Migrate a project to redmine 0.9 to 1.0.2
Added by Camille NERON almost 14 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 almost 14 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 almost 14 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 almost 14 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 almost 14 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 almost 14 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 almost 14 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 almost 14 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 almost 14 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 (102 KB) Capture-5.png | Description of issues table |
RE: Migrate a project to redmine 0.9 to 1.0.2
-
Added by Felix Schäfer almost 14 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 almost 14 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 Felix Schäfer almost 14 years ago
How do you start redmine?
RE: Migrate a project to redmine 0.9 to 1.0.2
-
Added by Camille NERON almost 14 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 almost 14 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 almost 14 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 almost 14 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 almost 14 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 almost 14 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 !