Top Menu

Jump to content
    Modules
      • Projects
      • Activity
      • Work packages
      • Gantt charts
      • Calendars
      • Team planners
      • Boards
      • News
    Home
    • 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

      OpenProject ID Google

Side Menu

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

Content

Expand project menu
Support Installation & Updates
  1. OpenProject Community
  2. OpenProject
  3. Forums
  4. Support Installation & Updates
  5. Migration error when running migrate-from-pre-8.sh

Migration error when running migrate-from-pre-8.sh

Added by Mirko Ciecinski over 3 years ago

Hi, 

I installed OpenProject 11.4.1 with PostgreSQL 12.8 on Ubuntu 20.04 (focal) and "Demo project" works fine. 
After that I wanted to migrate my old openproject database dump (mysql - don't know which version it was - I guess V7.1) to OpenProject 11, running your shell script /opt/openproject/script/migration/migrate-from-pre-8.sh 

I called it in the following way: 

/opt/openproject/script/migration# bash migrate-from-pre-8.sh 85.214.243.8 /private-backup/mysql-backup/openproject.sql sql 

A couple of errors / warning have been displayed, but finally it stops after 

2.5) Migrating from 10 to current (11) 
. 
. 
. 
migration unsuccessful. Please check migration.log 

Attached you can find my migration.log. On the same folder the file openproject-mysql-dump-8.sql was created by your bash script. 
In migration.log I see several errors regarding unknown column "updated_on", but I'm not able to fix it 

StandardError: An error has occurred, this and all later migrations canceled: 
PG::UndefinedColumn: ERROR:  column "updated_on" of relation "users" does not exist 
LINE 1: UPDATE "users" SET "admin" = $1, "updated_on" = $2 WHERE "us... 
                                         ^ 

Please could you help me? 

Thanks in advance! 
Mirko


Loading...