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. Changeing View Filter and Saving Views not possible

Changeing View Filter and Saving Views not possible

Added by Tobias Braun over 6 years ago

I migrated our local OpenProject Instance to 8.1.0 bevor Christmas and now discovered the issues, that we can not alter the view in the work packages screen. Also saving a new view throws an error message. Please check the attached screen shot. In the Demo Project now only the closed item (task) should be visible. When I try to create now a standard view by saving it public the error message "An internal error has occurred" is displayed (second screen shot).

In the production log I see the following error (the stack trace I left away but could add it when needed).  Could an update to 8.2.0 help? I saw there some bug fixes related to filters, but not matching exactly our problem.

E, [2019-01-07T10:40:23.510550 #811] ERROR -- :   Grape rescuing from error: API::Errors::InternalError

  Original error: #<NoMethodError: undefined method `highlighting_mode=' for #<Query:0x00005598f803a390>
Did you mean?  highlighting_mode>

Replies (8)

RE: Changeing View Filter and Saving Views not possible - Added by Oliver Günther over 6 years ago

Dear Tobias,

the error looks very much like a missing migration issue.

After every upgrade, you need to run openproject configure to ensure that database migrations, asset compilation and others are taking place before each upgrade. Unfortunately, these cannot be placed as post-install hooks since these tasks tend to run quite a bit and are not available on all distributions we support.

Have you run this script and migrated the database?

Best,

Oliver

RE: Changeing View Filter and Saving Views not possible - Added by Tobias Braun over 6 years ago

Dear Oliver,

I think I run it since I followed the migration guide on the website. Since is was before Christmas I am not sure about it any more. Can I just rerun it?

KR,

Tobias

PS.: Happy New Year ;-)

EDIT: I run it but it did not help:

opdw01:~ # openproject configure
Launching installer for openproject...
Selected addons: legacy-installer mysql apache2 repositories smtp memcached open                                                                          project
[legacy-installer] ./bin/configure
[mysql] ./bin/configure
MySQL connection OK
DONE
[apache2] ./bin/configure
DONE
[repositories] ./bin/configure
DONE
[smtp] ./bin/configure
DONE
[memcached] ./bin/configure
DONE
[openproject] ./bin/configure
[legacy-installer] ./bin/preinstall
[mysql] ./bin/preinstall
[apache2] ./bin/preinstall
[repositories] ./bin/preinstall
"perl" already present
"dav" already present
"dav_svn" already present
"cgi" already present
[smtp] ./bin/preinstall
[memcached] ./bin/preinstall
No memcached server to install. Skipping.
[openproject] ./bin/preinstall
[legacy-installer] ./bin/postinstall
[mysql] ./bin/postinstall
Generating /etc/openproject/conf.d/database...
[apache2] ./bin/postinstall
"rewrite" already present
"proxy" already present
"proxy_http" already present
"headers" already present
"expires" already present
"deflate" already present
"filter" already present
[repositories] ./bin/postinstall
Setting up SVN integration for Apache
[smtp] ./bin/postinstall
[memcached] ./bin/postinstall
[openproject] ./bin/postinstall
WARNING: Nokogiri was built against LibXML version 2.9.1, but has dynamically lo                                                                          aded 2.9.4
WARNING: Nokogiri was built against LibXML version 2.9.1, but has dynamically lo                                                                          aded 2.9.4
^Crake aborted!
Interrupt:
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/aws-sdk-s3-1.9.1/lib/aws-sdk-s3.r                                                                          b:13:in `require_relative'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/aws-sdk-s3-1.9.1/lib/aws-sdk-s3.r                                                                          b:13:in `<top (required)>'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/bundler-1.15.2/lib/bundler/runtim                                                                          e.rb:82:in `require'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/bundler-1.15.2/lib/bundler/runtim                                                                          e.rb:82:in `block (2 levels) in require'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/bundler-1.15.2/lib/bundler/runtim                                                                          e.rb:77:in `each'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/bundler-1.15.2/lib/bundler/runtim                                                                          e.rb:77:in `block in require'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/bundler-1.15.2/lib/bundler/runtim                                                                          e.rb:66:in `each'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/bundler-1.15.2/lib/bundler/runtim                                                                          e.rb:66:in `require'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/bundler-1.15.2/lib/bundler.rb:108                                                                          :in `require'
/opt/openproject/config/application.rb:70:in `<top (required)>'
/opt/openproject/Rakefile:33:in `require'
/opt/openproject/Rakefile:33:in `<top (required)>'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/rake-12.3.1/exe/rake:27:in `<top                                                                           (required)>'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/bundler-1.15.2/lib/bundler/cli/ex                                                                          ec.rb:74:in `load'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/bundler-1.15.2/lib/bundler/cli/ex                                                                          ec.rb:74:in `kernel_load'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/bundler-1.15.2/lib/bundler/cli/ex                                                                          ec.rb:27:in `run'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/bundler-1.15.2/lib/bundler/cli.rb                                                                          :360:in `exec'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/bundler-1.15.2/lib/bundler/vendor                                                                          /thor/lib/thor/command.rb:27:in `run'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/bundler-1.15.2/lib/bundler/vendor                                                                          /thor/lib/thor/invocation.rb:126:in `invoke_command'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/bundler-1.15.2/lib/bundler/vendor                                                                          /thor/lib/thor.rb:369:in `dispatch'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/bundler-1.15.2/lib/bundler/cli.rb                                                                          :20:in `dispatch'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/bundler-1.15.2/lib/bundler/vendor                                                                          /thor/lib/thor/base.rb:444:in `start'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/bundler-1.15.2/lib/bundler/cli.rb                                                                          :10:in `start'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/bundler-1.15.2/exe/bundle:30:in `                                                                          block in <top (required)>'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/bundler-1.15.2/lib/bundler/friend                                                                          ly_errors.rb:121:in `with_friendly_errors'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/bundler-1.15.2/exe/bundle:22:in `                                                                          <top (required)>'
/opt/openproject/bin/bundle:3:in `load'
/opt/openproject/bin/bundle:3:in `<main>'
(See full trace by running task with --trace)

RE: Changeing View Filter and Saving Views not possible - Added by Oliver Günther over 6 years ago

^Crake aborted! Interrupt:

You can safely run openproject configure multiple times, it will result in no-op for database migrations.

In the log output above, you appear to have interrupted the output.

Best,

Oliver

RE: Changeing View Filter and Saving Views not possible - Added by Tobias Braun over 6 years ago

Hi Oliver,

wonder why this happened. Now I come further but fail at pandoc:

== 20180706150714 ConvertToMarkdown: migrating ================================
I, [2019-01-07T14:51:25.085793 #10622]  INFO -- : Starting conversion of Textile fields to CommonMark.
I, [2019-01-07T14:51:25.085885 #10622]  INFO -- : Decreasing ActiveRecord logger to avoid flooding your logs.
I, [2019-01-07T14:51:25.085934 #10622]  INFO -- : Checking compatibility of your installed pandoc version.
You have no compatible (>= 2.0) of pandoc in path. We're now trying to download a recent version for your amd64 linux
from 'https://github.com/jgm/pandoc/releases/download/2.2.3.2/pandoc-2.2.3.2-linux.tar.gz' to '/opt/openproject/vendor/pandoc'.

For more information, please visit this page: https://www.openproject.org/textile-to-markdown-migration
Error occurred while trying to find / download compatible pandoc version for your system:

Failed to open TCP connection to github.com:443 (getaddrinfo: Name or service not known)
rake aborted!
StandardError: An error has occurred, all later migrations canceled:

            Pandoc failed  with code [127] [Stopped=false]
            Process did not receive signal

The proxy is well setup on the the server, we can download an install packages, even download it with wget, but for some reason it does not work for OP. I tried to manually download and install the Pandoc package in the mentioned folder but for some reason the script is not detecting it. Any idea how to solve this issue? By the way: there is also a warning about

WARNING: Nokogiri was built against LibXML version 2.9.1, but has dynamically loaded 2.9.4

I guess this should not be a show stopper?

UPDATE: I solved the first issue by unzipping the tar file with 

tar xvzf $TGZ --strip-components 1 -C $DEST

Where $TGZ is the tar gile and $DEST is the /opt/openproject/vendor/pandoc folder

KR,

Tobias

RE: Changeing View Filter and Saving Views not possible - Added by Oliver Günther over 6 years ago

Hi Tobias,

the openproject user probably needs the http_proxy and https_proxy variables set in order to function. You can do this with openproject config:set http_proxy="127.0.0.1:234" . This would otherwise also affect all requests OpenProject may perform (webhooks would be one example).

The warning you linked is not a problem, but just a packaging flaw on some distributions that ship with minor different versions.

Re. the pandoc issue, you can also provide your own installation by downloading it and setting the OPENPROJECT_PANDOC_PATH variable to the executable path.

For more information about this and why it's necessary in 8.0., see: https://github.com/opf/openproject/tree/dev/docs/user/textile-to-markdown-migration#1294 

Best,

Oliver

RE: Changeing View Filter and Saving Views not possible - Added by Tobias Braun over 6 years ago

Hi Oliver,

thanks a lot for your help. The issue is solved for now. Filtering works now as expected.

About setting the http_proxy:

openproject config:set http_proxy="USER:PASSWORT@IP:PORT" does not work. I get the following error:

/etc/openproject/conf.d/other: line 1: export: `=': not a valid identifier

Thanks,

Tobias

RE: Changeing View Filter and Saving Views not possible - Added by Oliver Günther over 6 years ago

Weird, works on my linux. You can try to edit the line manually in /etc/openproject/conf.d/other to match your output. Its a simple shell include file so if source /etc/openproject/conf.d/other works it should be fine.,

Best,

Oliver

RE: Changeing View Filter and Saving Views not possible - Added by Tobias Braun over 6 years ago

In the other file there was an empty export command. Deleting it solved the issue.

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