Open link in a new tab

Content

Expand project menu

Error when migrating from OpenProject v16 to v17

I want to upgrade OpenProject v16.6.10 oi OpenProject v17

I launch command openproject configure and a error occur

== 20250927215339 CreateJiraMigrationTables: migrated (0.0869s) ===============

I, [2026-05-02T14:24:51.889691 #148610]  INFO -- : Migrating to AddViewAllPrincipalsPermissionToExistingRoles (20250929070310)
== 20250929070310 AddViewAllPrincipalsPermissionToExistingRoles: migrating ====
rake aborted!
StandardError: An error has occurred, this and all later migrations canceled: (StandardError)

Undeclared attribute type for enum 'sharing' in Meeting. Enums must be backed by a database column or declared with an explicit type via `attribute`.
/opt/openproject/vendor/bundle/ruby/4.0.0/gems/activerecord-8.1.2.1/lib/active_record/enum.rb:243:in 'block in ActiveRecord::Enum#_enum'

The OS is Rocky Linux 9.7 and PostgreSQL 16.

Any idea or recommendation?

Message actions

I upgraded Postgresql 16 to Postgresql 17.

I have the same error with this command openproject configure

Message actions

I'm facing the same issue on SLES15SP7.
Upgrading from 16.6.7 to 17.3.1

Message actions

Hi,

This looks like this might be related to the following bug:

https://community.openproject.org/projects/openproject/work_packages/74539/activity

You can either wait for the release of 17.4.0 or you can use the workaround mentioned in the ticket to proceed with the update.

Message actions

Hi Tizian,

Thanks for your reply.

Your mentionned issue concerned a same  migration script AddViewAllPrincipalsPermissionToExistingRoles but It isnt a same error.

My error looks like a problem with ActiveRecord and not a SQL

Best Regards,

Lilian

Tizian Rößler wrote:

Hi,

This looks like this might be related to the following bug:

https://community.openproject.org/projects/openproject/work_packages/74539/activity

You can either wait for the release of 17.4.0 or you can use the workaround mentioned in the ticket to proceed with the update.

Message actions

HI,

Finally, i did a downgrade to 17.0.8

dnf install openproject-17.0.8

So, i was then able to run the configuration command

openproject configure

NOTE: Migrations passed with successed

After, i did install the latest version 17.4.0

dnf install openproject

so, i was able again to run the configure command 

openproject configure

I think you could add these step on migration documentation

Best regards,

Lilian.

Message actions

Hi Lilian,

Thanks for the hint.

 I was able to reproduce the error and created a bug report here:

https://community.openproject.org/projects/openproject/work_packages/75508/activity

The workaround for the other bug also works for this bug.

Best regards

Tizian