Added by Lilian BENOIT 23 days ago
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?
Replies (5)
I upgraded Postgresql 16 to Postgresql 17.
I have the same error with this command openproject configure
I'm facing the same issue on SLES15SP7.
Upgrading from 16.6.7 to 17.3.1
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.
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,
Finally, i did a downgrade to 17.0.8
So, i was then able to run the configuration command
NOTE: Migrations passed with successed
After, i did install the latest version 17.4.0
so, i was able again to run the configure command
I think you could add these step on migration documentation
Best regards,
Lilian.