Top Menu

Jump to content
Home
    Modules
      • Projects
      • Activity
      • Work packages
      • Gantt charts
      • Calendars
      • Team planners
      • Boards
      • News
    • Getting started
    • Introduction video
      Welcome to OpenProject Community
      Get a quick overview of project management and team collaboration with OpenProject. You can restart this video from the help menu.
    • Help and support
    • Upgrade to Enterprise edition
    • User guides
    • Videos
    • Shortcuts
    • Community forum
    • Enterprise support
    • Additional resources
    • Data privacy and security policy
    • Digital accessibility (DE)
    • OpenProject website
    • Security alerts / Newsletter
    • OpenProject blog
    • Release notes
    • Report a bug
    • Development roadmap
    • Add and edit translations
    • API documentation
  • Sign in
      Forgot your password?

      or sign in with your existing account

      Google

Side Menu

  • Overview
  • Activity
    Activity
  • Roadmap
  • Work packages
    Work packages
  • Gantt charts
    Gantt charts
  • Calendars
    Calendars
  • Team planners
    Team planners
  • Boards
    Boards
  • News
  • Forums

Content

Support Installation & Updates
  1. OpenProject
  2. Forums
  3. Support Installation & Updates
  4. Error adding work package: work_+packages.fixed_version_id does not exist

Error adding work package: work_+packages.fixed_version_id does not exist

Added by Rick Green over 4 years ago

Still fighting some issues after the upgrade to 11.0.1 from version 7.1 with the database migration.  Here is a show stopper for me.  When attempting to add a work package in any project, I get this error.

OpenProject logs confirm.

Querying the work_packages table shows the column fixed___version_id does not exist.

Suggestions on how to correct this would be appreciated.  I suppose I could create the field manually, but I would be making assumptions on this such as datatype (I assume bigint) and I have no idea if it has any foreign keys, etc.


Replies (6)

RE: Error adding work package: work_+packages.fixed_version_id does not exist - Added by Rick Green over 4 years ago

I just saw there was an update to 11.0.2.  I applied it and reran openproject configure.  There were no errors from the configure command, but it made no difference.  I still get the same error when trying to create a new work package.

I did get a new failure with starting the apache2 service.  It was failing because of the Includes in the /etc/apache2/sites-available/openproject.conf file (lines 1 and 9).  It used a wildcard to load configuration files from those directories, but the directories were empty.  I had to comment out lines 1 and 9 to get apache2 to start.

RE: Error adding work package: work_+packages.fixed_version_id does not exist - Added by Rick Green over 4 years ago

Just upgraded to 11.0.3.  I reran the openproject configure again.  There were no errors.  I also rebooted due to a grub and kernel upgrade.  Still have the same problem trying to create work packages.

RE: Error adding work package: work_+packages.fixed_version_id does not exist - Added by Rick Green over 4 years ago

Upgraded to the latest again.  OpenProject said a database migration was needed, so I reran openproject configure again.  It ran with no errors.  Still have the same problem trying to create work packages.  I am also unable to create new projects.

RE: Error adding work package: work_+packages.fixed_version_id does not exist - Added by Rick Green over 4 years ago

Just upgraded to 11.1.1.  Still have the same issue with the same log entries.  I am still unable to add work packages to any of the projects.

RE: Error adding work package: work_+packages.fixed_version_id does not exist - Added by Rick Green over 4 years ago

I checked out the schema on the github site and saw that the field name in the workpackages table is supposed to be called fixed_version_id and not version_id.  As a test, I tried renaming the version_id column to fixed_version_id.  This did not work - it just gave me an error and I was not able to see any of the existing work packages.  I then just added a column to the public.workpackages table called fixed_version_id.  This worked, and I am now able to create work packages.  I am still unable to create new projects, though.  I will be checking this to make sure there are no ill effects after adding this column, but so far it looks OK.

RE: Error adding work package: work_+packages.fixed_version_id does not exist - Added by Max Mutzge over 4 years ago

Hi Rick, thank you for documenting your process here!

  • (1 - 6/6)
Loading...