Top Menu

Jump to content
  • OpenProject
    • View all projects
Home
    • Projects
    • Work packages
    • News
    • Getting started
    • Introduction video

      • Welcome to OpenProject

      Get an overview

      Get a quick overview of project management and team collaboration with OpenProject.
      You can restart this video from the help menu
    • Help and support
    • User guides
    • Videos
    • Shortcuts
    • Community forum
    • Professional support
    • Additional resources
    • Legal notice
    • Data privacy and security policy
    • 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?
      Create a new account

      or sign in with your existing account

      Google

Side Menu

  • Overview
  • Activity
  • Roadmap
  • Work packages
  • Boards
  • Calendar
  • Forums
You are here:
  • Forums
  • Support Installation & Updates

Content

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

Added by Rick Green 2 months 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 (5)

RE: Error adding work package: work_+packages.fixed_version_id does not exist - Added by Rick Green 2 months 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 about 2 months 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 about 1 month 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 9 days 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 9 days 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.

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