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. Migration from 9.0.4 to 10.4.1: Psych::SyntaxError: (<unknown>): control characters are not allowed at line 1 column 1

Migration from 9.0.4 to 10.4.1: Psych::SyntaxError: (<unknown>): control characters are not allowed at line 1 column 1

Added by L B about 5 years ago

As this is probably not a bug in OpenProject itself, but rather the data I'm converting, I'm not (yet) posting this as a bug. But I filled out the Bug form already, so it has the same format.

Environment:

Your OpenProject Version: 10.4.1

Operating System / Browser / Language: Debian 9.12 / Google Chrome / German

Database: PostgreSQL 9.6.17

Logs

See attached file for full output!

Steps to reproduce:

Not sure if it's easy to reproduce, the problem might originate in the MySQL to PostgreSQL migration or my specific database data.

  1. Upgraded OpenProject from 7.3.2 to 9.0.4 (Debian 8), including database table upgrades
  2. Upgraded Debian 8 to Debian 9
  3. Installed PostgreSQL 9.6.17
  4. Migrated DB from MySQL to PostgreSQL according to guide at https://docs.openproject.org/installation-and-operations/misc/packaged-postgresql-migration/#optional-install-and-create-postgresql-database
  5. Upgraded OpenProject from 9.0.4 to 10.4.1

Actual Behavior

Error message while running openproject configure (see full output attached!)

# sudo openproject configure
...
== 20190826083604 MyProjectPageToGrid: migrating ==============================
rake aborted!
StandardError: An error has occurred, this and all later migrations canceled:

(<unknown>): control characters are not allowed at line 1 column 1
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.2.1/lib/active_record/coders/yaml_column.rb:26:in `load'
...

Expected Behavior

Upgrade runs without errors.

Notes

I'm quite experienced in debugging application errors in general, but I have no idea how to determine the actual database entry which is responsible for this. I'm also unable to tell where to look by analyzing the full error message.

This sounds similar to what is described in a different application context here: https://github.com/collectiveidea/audited/issues/260#issuecomment-186245034


Replies (1)

RE: Migration from 9.0.4 to 10.4.1: Psych::SyntaxError: (<unknown>): control characters are not allowed at line 1 column 1 - Added by L B about 5 years ago

Now handled as a Bug in https://community.openproject.com/projects/openproject/work_packages/33240/activity

Check the bug for updates.

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