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
    • 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
  • Feature tour
    Feature tour

Content

You are here:
  1. Forums
  2. Support Installation & Updates

Upgrade is pending database migrations

Added by Rick Green about 4 years ago

I managed to get past the errors of the migration script when upgrading from 7.1 to 11, but the OpenProject system is displaying this error.  I ran through the reconfigure after importing according to the instructions.  Going to a project and selecting work packages gives this error.  What else is left to do to get this working?  It looks like the migration left some things out.


Replies (10)

RE: Upgrade is pending database migrations - Added by Jens Ulferts about 4 years ago

Hi Rick,

given the warning on the bottom of the page, migrations are clearly missing. Are you sure to have properly run openproject configure to get all migrations to be executed?

Regards

Jens

RE: Upgrade is pending database migrations - Added by Rick Green about 4 years ago

Thanks for the reply.  I ran openproject configure, but it gives me an error about a missing relation and stops there.  Any idea what happened, or better yet, how to correct this? I know enough to be able to connect to the Postgres database and make any manual changes, but I would not consider myself an expert and I am not familiar enough with the OpenProject schema to know where to add this relation.

RE: Upgrade is pending database migrations - Added by Jens Ulferts about 4 years ago

Hi Rick,

this is a known issue with OP 11.0.0 and 11.0.1 which we had hoped to have fixed. We'll try to issue a fix soon but you might want to try the steps described here: https://community.openproject.com/topics/12691

RE: Upgrade is pending database migrations - Added by Rick Green about 4 years ago

Thanks for the feedback.  That helped a little.  I renamed the indexes for cost_objects and cost___objects_pkey as directed in that topic and reran the openproject configure.  It got a bit further, but apparently there are more issues with other keys.  Here is the next one.

I searched for this key and here are the results.  Looks like it is in the settings table.  Have you seen this one before?

RE: RE: Upgrade is pending database migrations - Added by Rick Green about 4 years ago

Looks like my screenshots did not work for some reason.  Trying again.

RE: Upgrade is pending database migrations - Added by Rick Green about 4 years ago

Just to let you know, I performed an upgrade to the system after the other thread stated that version 11.0.1 was going to fix these problems.  I did have the upgrade to 11.0.1 available and applied it.  I ran the openproject configure after this and everything works now!  Thanks for all your help with this.  I really appreciate it.

RE: Upgrade is pending database migrations - Added by Rick Green about 4 years ago

Now that I have it up and running with 11.0.1, I am getting Error 500 when I add a new user from the administration screen.  I see that the new user does get added, since they show up in the list.  I then try to add the user to a project.  After I click the Add button, the same Error 500 pops up again.  I check the newly added user, and they were not added to the project.  I can view existing users and see that they are still members of their projects from the imported data.  So, at this time, I am unable to add users to projects.  Is there an error log somewhere that can give me more information about what happened so I can troubleshoot?

RE: Upgrade is pending database migrations - Added by Rick Green about 4 years ago

As an update to this new problem, I am receiving this same Error 500 when manually sending invites to users.  The users are not receiving the invites.  In the email notification section of administration screen, the settings are correct and I can successfully send a test email to myself from this screen.  The problem seems to involve sending email notifications to users.

RE: Upgrade is pending database migrations - Added by Jens Ulferts about 4 years ago

Is there an error log somewhere that can give me more information about what happened so I can troubleshoot?

https://docs.openproject.org/installation-and-operations/operation/monitoring/

RE: Upgrade is pending database migrations - Added by Stacy Proctor 11 months ago

Jens Ulferts wrote:

Is there an error log somewhere that can give me more information about what happened so I can troubleshoot?

https://docs.openproject.org/installation-and-operations/operation/monitoring/ rainbow friends

Great. This is what I am looking for. My error is solved

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