Hi John,

your assumption is correct that you could upgrade to 4.2.9 using your current package source. However, the migrations on OpenProject are all incremental, so you could immediately upgrade to 6.0.4 and all intermittent migrations will be run automatically.

The required changes mainly concern changes in the package in the migration guide as you already described and that is where my only unceirtanty regarding the upgrade paths lies. Once you migrated the application itself, the database migrations will run regardless you choose to upgrade 4.0 -> 4.2 -> 5.0 -> 6.0 or straight to 6.0.

Let us know what path you chose and how the upgrade worked for you! :-)

Best,
Oliver

OK,
I finally began the process of upgrading from 4.0.10 to 6.x. When I ran openproject reconfigure I hit an error with a duplicate column and index on the wiki_pages table which I was able to resolve by removing the column and index from the table. However I’m stuck as shown below. Any assistance would be appreciated.
Thanks,
-John

Launching installer for openproject…
Selected addons: legacy-installer mysql apache2 repositories smtp memcached openproject
[legacy-installer] ./bin/configure
[mysql] ./bin/configure
MySQL connection OK
DONE
[apache2] ./bin/configure
DONE
[repositories] ./bin/configure
No server installed. Skipping.
DONE
[smtp] ./bin/configure
DONE
[memcached] ./bin/configure
DONE
[openproject] ./bin/configure
[legacy-installer] ./bin/preinstall
[mysql] ./bin/preinstall
[apache2] ./bin/preinstall
[repositories] ./bin/preinstall
[smtp] ./bin/preinstall
[memcached] ./bin/preinstall
No memcached server to install. Skipping.
[openproject] ./bin/preinstall
[legacy-installer] ./bin/postinstall
[mysql] ./bin/postinstall
Generating /etc/openproject/conf.d/database…
[apache2] ./bin/postinstall
[repositories] ./bin/postinstall
[smtp] ./bin/postinstall
[memcached] ./bin/postinstall
[openproject] ./bin/postinstall
/opt/openproject/lib/open_project/version.rb:61:in `rescue in revision’ : Tried to parse version REVISION, but failed with No such file or directory - git. (StandardWarning)
/opt/openproject/lib/open_project/version.rb:61:in `rescue in revision’ : Tried to parse version REVISION, but failed with No such file or directory - git. (StandardWarning)

***** Seeding for locale: ‘en’

***** Seeding basic data
â³ BuiltinRolesSeeder
***** Skipping built in role Non member - already exists
***** Skipping built in role Anonymous - already exists
â³ RoleSeeder
***** Skipping roles as there are already some configured
â³ ActivitySeeder
***** Skipping activities as there are already some configured
â³ ColorSeeder
***** Skipping colors as there are already some configured
â³ WorkflowSeeder
***** Skipping types, statuses and workflows as there are already some configured
â³ PrioritySeeder
***** Skipping priorities as there are already some configured
â³ ProjectStatusSeeder
***** Skipping reported project status as there are already some configured
â³ ProjectTypeSeeder
***** Skipping project types as there are already some configured
â³ SettingSeeder
Loading discovered seeders:
â³ SettingSeeder
***** Skipping BasicData::Backlogs::SettingSeeder
â³ EnumerationsSeeder

***** Seeding admin user
***** No need to seed an admin as there already is one.

***** Seeding demo data
â³ ProjectSeeder
***** Skipping DemoData::ProjectSeeder

***** Loading date_validator_engine seed data

***** Loading bourbon_engine seed data

***** Loading i18n_js_engine seed data

***** Loading prototype_rails_engine seed data

***** Loading openproject_translations seed data

***** Loading openproject_global_roles seed data

***** Loading openproject_auth_plugins seed data

***** Loading openproject_auth_saml seed data

***** Loading lobby_boy seed data

***** Loading openproject_openid_connect seed data

***** Loading openproject_documents seed data

***** Loading openproject_my_project_page seed data

***** Loading openproject_xls_export seed data

***** Loading reportingengine seed data

***** Loading openproject_costs seed data

***** Loading openproject_reporting seed data

***** Loading openproject_meeting seed data

***** Loading openproject_pdf_export seed data

***** Loading openproject_backlogs seed data

***** Loading openproject_themes_dark seed data

***** Loading openproject_local_avatars seed data

***** Loading openproject_webhooks seed data

***** Loading openproject_github_integration seed data
rake aborted!
ArgumentError: bad argument (expected URI object or URI string)
/opt/openproject/lib/tasks/packager.rake:102:in `block (3 levels) in <top (required)>’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/rake-11.2.2/exe/rake:27:in `<top (required)>’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.13.2/lib/bundler/cli/exec.rb:74:in `load’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.13.2/lib/bundler/cli/exec.rb:74:in `kernel_load’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.13.2/lib/bundler/cli/exec.rb:27:in `run’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.13.2/lib/bundler/cli.rb:332:in `exec’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.13.2/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.13.2/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:in `invoke_command’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.13.2/lib/bundler/vendor/thor/lib/thor.rb:359:in `dispatch’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.13.2/lib/bundler/cli.rb:20:in `dispatch’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.13.2/lib/bundler/vendor/thor/lib/thor/base.rb:440:in `start’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.13.2/lib/bundler/cli.rb:11:in `start’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.13.2/exe/bundle:34:in `block in <top (required)>’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.13.2/lib/bundler/friendly_errors.rb:100:in `with_friendly_errors’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.13.2/exe/bundle:26:in `<top (required)>’
/opt/openproject/bin/bundle:3:in `load’
/opt/openproject/bin/bundle:3:in `

’
ArgumentError: bad argument (expected URI object or URI string)
/opt/openproject/lib/tasks/packager.rake:102:in `block (3 levels) in <top (required)>’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/rake-11.2.2/exe/rake:27:in `<top (required)>’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.13.2/lib/bundler/cli/exec.rb:74:in `load’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.13.2/lib/bundler/cli/exec.rb:74:in `kernel_load’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.13.2/lib/bundler/cli/exec.rb:27:in `run’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.13.2/lib/bundler/cli.rb:332:in `exec’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.13.2/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.13.2/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:in `invoke_command’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.13.2/lib/bundler/vendor/thor/lib/thor.rb:359:in `dispatch’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.13.2/lib/bundler/cli.rb:20:in `dispatch’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.13.2/lib/bundler/vendor/thor/lib/thor/base.rb:440:in `start’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.13.2/lib/bundler/cli.rb:11:in `start’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.13.2/exe/bundle:34:in `block in <top (required)>’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.13.2/lib/bundler/friendly_errors.rb:100:in `with_friendly_errors’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.13.2/exe/bundle:26:in `<top (required)>’
/opt/openproject/bin/bundle:3:in `load’
/opt/openproject/bin/bundle:3:in `

’
Tasks: TOP => packager:postinstall => packager:setup:scm
(See full trace by running task with —trace)

Hi John,

the error stems from the script trying to set up a SVN checkout url with one of the environment variables from the package wizard not being set.
I assume that one of the following variables were not set:

SERVER_PROTOCOL
SERVER_HOSTNAME

Can you post here the output of openproject config ?

Best,
Oliver