Redmine

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

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

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.

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.

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.

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

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?

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

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?

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 ?

How do you start redmine?

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>

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.

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 ?

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 ...

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…

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 !