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

General discussion
  1. OpenProject
  2. Forums
  3. General discussion
  4. OpenProject Internal Error when Wiki entry contains single "!"

OpenProject Internal Error when Wiki entry contains single "!"

Added by Lars Liden about 4 years ago

After using OpenProject Wiki for some weeks without problems I added a new Wiki entry named "!" (just the exclamation mark) in order to show this entry at the top of the Wiki TOC on the left.
Not a good idea! I can now not access the project at all, just getting "Internal error" when selecting the project.
The log shows the message "ERROR - - : ... No route matches ... title: "!" ...

feb 19 11:18:37 cyborg-N141CU openproject-web-1.service[981]: E, [2021-02-19T11:18:37.764145 #24995] ERROR -- : [current_user=Anonymous] No route matches {:action=>"show", :controller=>"wiki", :id=>#<WikiPage id: 89, wiki_id: 7, title: "!", created_at: "2021-02-19 09:06:59", protected: false, parent_id: 4, slug: "", updated_at: "2021-02-19 09:06:59">, :project_id=>#<Project id: 8, name: "Nabben-Hb", description: "Projektet syftar initialt, i Förstudien, till att ...", public: true, parent_id: nil, created_at: "2021-01-03 10:03:12", updated_at: "2021-01-12 12:52:37", identifier: "nabben-hb", lft: 13, rgt: 14, active: true, templated: false>}, possible unmatched constraints: [:id]: No route matches {:action=>"show", :controller=>"wiki", :id=>#<WikiPage id: 89, wiki_id: 7, title: "!", created_at: "2021-02-19 09:06:59", protected: false, parent_id: 4, slug: "", updated_at: "2021-02-19 09:06:59">, :project_id=>#<Project id: 8, name: "Nabben-Hb", description: "Projektet syftar initialt, i Förstudien, till att ...", public: true, parent_id: nil, created_at: "2021-01-03 10:03:12", updated_at: "2021-01-12 12:52:37", identifier: "nabben-hb", lft: 13, rgt: 14, active: true, templated: false>}, possible unmatched constraints: [:id]

What can I do to make OpenProject work again?

Some ideas (my knowledge of OpenProject, Wiki or postgre is not good enough to figure out how to do)
* Use an openproject command operating on the Wiki ? (I have not found a suitable command)
* Remove this entry from the database (postgre? SQL command?)
* Change "!" to "A" in the faulty entry directly in the database (I have no idea of how the database is organised with indexes etc)
* Reset database version ?? (There are some files in .../postgresql/10/main/base/ that I guess are backup files, one of them just one day old)

If the "!" or other entries create problems like this it seems to be a good idea to check entry names before storing them in the database. BUG ?

I appreciate any help on this issue.


Replies (2)

RE: OpenProject Internal Error when Wiki entry contains single "!" - Added by Samantha Machon about 4 years ago

Hello Lars,

Thank you very much for reporting this behaviour. 

I have created a bug report for this: https://community.openproject.org/projects/openproject/work_packages/36345/activity
We have prioritised it as it is causing an internal error. 

Kind regards
Samantha

RE: OpenProject Internal Error when Wiki entry contains single "!" - Added by Lars Liden about 4 years ago

Thanks for confirming that this behaviour is not acceptable.

I have now restored my database so I don't need your help on this problem.

And THANKS for a good tool!

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