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

Errors configuring openproject on Fedora21

Added by danny dahan almost 9 years ago

Hi,

I followed instructions for Packaged installation of OpenProject to a Fedora21 machine.
Install went ok I guess… but configuration went wrong.

1. I have already a mysql server installed. it tries to install mariadb when I chosed it to install the MySql database for openproject.

[openproject] ./bin/configure [legacy-installer] ./bin/preinstall [mysql] ./bin/preinstall Loaded plugins: langpacks Package 1:mariadb-server-10.0.21-1.fc21.x86_64 is obsoleted by mysql-community-server-5.7.5-0.2.m15.fc21.x86_64 which is already installed Nothing to do Redirecting to /bin/systemctl start mariadb.service Failed to start mariadb.service: Unit mariadb.service failed to load: No such file or directory.

In order to overcome this I skipped this stage hoping to be able to configure the DB in MySql according to the Manual installation guide.

2. after skipping the above I run the configuration till the end and I get the following output:

DONE [openproject] ./bin/configure [legacy-installer] ./bin/preinstall [mysql] ./bin/preinstall [apache2] ./bin/preinstall getsebool: SELinux is disabled setsebool: SELinux is disabled. Note: Forwarding request to 'systemctl enable httpd.service'. [repositories] ./bin/preinstall [smtp] ./bin/preinstall [memcached] ./bin/preinstall Note: Forwarding request to 'systemctl enable memcached.service'. [openproject] ./bin/preinstall [legacy-installer] ./bin/postinstall [mysql] ./bin/postinstall [apache2] ./bin/postinstall chcon: can't apply partial context to unlabeled file ‘/etc/openproject/addons/apache2/includes/vhost/compression.conf’ chcon: can't apply partial context to unlabeled file ‘/etc/openproject/addons/apache2/includes/vhost/expiration.conf’ chcon: can't apply partial context to unlabeled file ‘/etc/openproject/addons/apache2/includes/vhost/sys.conf’ chcon: can't apply partial context to unlabeled file ‘/etc/openproject/addons/apache2/includes/vhost/assets.conf’ chcon: can't apply partial context to unlabeled file ‘/etc/openproject/addons/apache2/includes/server/proxy_mod.conf’ chcon: can't apply partial context to unlabeled file ‘/etc/openproject/addons/apache2/includes/server/proxy_http_mod.conf’ chcon: can't apply partial context to unlabeled file ‘/etc/openproject/addons/apache2/includes/server/headers_mod.conf’ chcon: can't apply partial context to unlabeled file ‘/etc/openproject/addons/apache2/includes/server/expires_mod.conf’ chcon: can't apply partial context to unlabeled file ‘/etc/openproject/addons/apache2/includes/server/deflate_mod.conf’ chcon: can't apply partial context to unlabeled file ‘/etc/openproject/addons/apache2/includes/server/filter_mod.conf’ chcon: can't apply partial context to unlabeled file ‘/etc/httpd/conf.d/openproject.conf’ Redirecting to /bin/systemctl restart httpd.service [repositories] ./bin/postinstall Setting up SVN integration for Apache chcon: can't apply partial context to unlabeled file ‘/etc/openproject/addons/apache2/includes/vhost/repoman_svn_wrapper.conf’ chcon: can't apply partial context to unlabeled file ‘/etc/openproject/addons/apache2/includes/server/20_repoman_svn_vhost.conf’ chcon: can't apply partial context to unlabeled file ‘/etc/openproject/addons/apache2/includes/vhost/svn_dav.conf’ chcon: can't apply partial context to unlabeled file ‘/var/db/openproject/svn’ chcon: can't apply partial context to unlabeled file ‘/var/db/openproject/svn’ Setting up Git integration for Apache chcon: can't apply partial context to unlabeled file ‘/etc/openproject/addons/apache2/includes/vhost/git_smart_http.conf’ chcon: can't apply partial context to unlabeled file ‘/var/db/openproject/git’ chcon: can't apply partial context to unlabeled file ‘/var/db/openproject/git’ chcon: can't apply partial context to unlabeled file ‘/var/db/openproject/git’ Redirecting to /bin/systemctl restart httpd.service [smtp] ./bin/postinstall [memcached] ./bin/postinstall [openproject] ./bin/postinstall rake aborted! NameError: uninitialized constant ActionView::Helpers::ActiveModelHelper /opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionview-4.2.4/lib/action_view/helpers.rb:40:in `<module:Helpers>' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionview-4.2.4/lib/action_view/helpers.rb:4:in `<module:ActionView>' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionview-4.2.4/lib/action_view/helpers.rb:3:in `<top (required)>' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionview-4.2.4/lib/action_view/base.rb:5:in `<top (required)>' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionview-4.2.4/lib/action_view/view_paths.rb:1:in `<top (required)>' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionpack-4.2.4/lib/abstract_controller/rendering.rb:4:in `<top (required)>' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionpack-4.2.4/lib/action_controller/base.rb:204:in `<class:Base>' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionpack-4.2.4/lib/action_controller/base.rb:164:in `<module:ActionController>' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionpack-4.2.4/lib/action_controller/base.rb:5:in `<top (required)>' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionpack-action_caching-1.1.1/lib/action_controller/action_caching.rb:13:in `<top (required)>' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionpack-action_caching-1.1.1/lib/actionpack/action_caching.rb:1:in `require' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionpack-action_caching-1.1.1/lib/actionpack/action_caching.rb:1:in `<top (required)>' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.7.12/lib/bundler/runtime.rb:85:in `require' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.7.12/lib/bundler/runtime.rb:85:in `rescue in block in require' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.7.12/lib/bundler/runtime.rb:68:in `block in require' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.7.12/lib/bundler/runtime.rb:61:in `each' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.7.12/lib/bundler/runtime.rb:61:in `require' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.7.12/lib/bundler.rb:134:in `require' /opt/openproject/config/application.rb:66:in `<top (required)>' /opt/openproject/Rakefile:33:in `require' /opt/openproject/Rakefile:33:in `<top (required)>' LoadError: cannot load such file -- actionpack-action_caching /opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.7.12/lib/bundler/runtime.rb:76:in `require' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.7.12/lib/bundler/runtime.rb:76:in `block (2 levels) in require' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.7.12/lib/bundler/runtime.rb:72:in `each' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.7.12/lib/bundler/runtime.rb:72:in `block in require' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.7.12/lib/bundler/runtime.rb:61:in `each' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.7.12/lib/bundler/runtime.rb:61:in `require' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.7.12/lib/bundler.rb:134:in `require' /opt/openproject/config/application.rb:66:in `<top (required)>' /opt/openproject/Rakefile:33:in `require' /opt/openproject/Rakefile:33:in `<top (required)>' (See full trace by running task with --trace) rake aborted! NameError: uninitialized constant ActionView::Helpers::ActiveModelHelper /opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionview-4.2.4/lib/action_view/helpers.rb:40:in `<module:Helpers>' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionview-4.2.4/lib/action_view/helpers.rb:4:in `<module:ActionView>' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionview-4.2.4/lib/action_view/helpers.rb:3:in `<top (required)>' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionview-4.2.4/lib/action_view/base.rb:5:in `<top (required)>' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionview-4.2.4/lib/action_view/view_paths.rb:1:in `<top (required)>' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionpack-4.2.4/lib/abstract_controller/rendering.rb:4:in `<top (required)>' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionpack-4.2.4/lib/action_controller/base.rb:204:in `<class:Base>' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionpack-4.2.4/lib/action_controller/base.rb:164:in `<module:ActionController>' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionpack-4.2.4/lib/action_controller/base.rb:5:in `<top (required)>' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionpack-action_caching-1.1.1/lib/action_controller/action_caching.rb:13:in `<top (required)>' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionpack-action_caching-1.1.1/lib/actionpack/action_caching.rb:1:in `require' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionpack-action_caching-1.1.1/lib/actionpack/action_caching.rb:1:in `<top (required)>' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.7.12/lib/bundler/runtime.rb:85:in `require' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.7.12/lib/bundler/runtime.rb:85:in `rescue in block in require' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.7.12/lib/bundler/runtime.rb:68:in `block in require' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.7.12/lib/bundler/runtime.rb:61:in `each' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.7.12/lib/bundler/runtime.rb:61:in `require' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.7.12/lib/bundler.rb:134:in `require' /opt/openproject/config/application.rb:66:in `<top (required)>' /opt/openproject/Rakefile:33:in `require' /opt/openproject/Rakefile:33:in `<top (required)>' LoadError: cannot load such file -- actionpack-action_caching /opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.7.12/lib/bundler/runtime.rb:76:in `require' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.7.12/lib/bundler/runtime.rb:76:in `block (2 levels) in require' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.7.12/lib/bundler/runtime.rb:72:in `each' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.7.12/lib/bundler/runtime.rb:72:in `block in require' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.7.12/lib/bundler/runtime.rb:61:in `each' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.7.12/lib/bundler/runtime.rb:61:in `require' /opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.7.12/lib/bundler.rb:134:in `require' /opt/openproject/config/application.rb:66:in `<top (required)>' /opt/openproject/Rakefile:33:in `require' /opt/openproject/Rakefile:33:in `<top (required)>' (See full trace by running task with --trace)

can someone tell me what went wrong here?
How can I fix this?

thanks!

Danny


Replies (7)

RE: Errors configuring openproject on Fedora21 - Added by Valeri Rangelov almost 9 years ago

Same issue on Fedora 23. Can somebody assist?

After research I figured out that is rubby issue and more specific with version 2.1. It doesn’t support this type of caching. But I am not able to fix it.

RE: RE: Errors configuring openproject on Fedora21 - Added by Kiran Patil over 8 years ago

Me too have the same issue on Fedora 22.

RE: Errors configuring openproject on Fedora21 - Added by Kiran Patil over 8 years ago

The issue is at line 59 of /usr/share/openproject/installer/addons/openproject/bin/postinstall file, while executing the rake task from file /opt/openproject/lib/tasks/packager.rake.

[openproj@dhcppc33 ~]$ sudo openproject run rake “packager:before_postinstall”
rake aborted!
NameError: uninitialized constant ActionView::Helpers::ActiveModelHelper
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionview-4.2.5.1/lib/action_view/helpers.rb:40:in `module:Helpers’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionview-4.2.5.1/lib/action_view/helpers.rb:4:in `module:ActionView’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionview-4.2.5.1/lib/action_view/helpers.rb:3:in `<top (required)>’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionview-4.2.5.1/lib/action_view/base.rb:5:in `<top (required)>’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionview-4.2.5.1/lib/action_view/view_paths.rb:1:in `<top (required)>’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionpack-4.2.5.1/lib/abstract_controller/rendering.rb:4:in `<top (required)>’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionpack-4.2.5.1/lib/action_controller/base.rb:204:in `class:Base’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionpack-4.2.5.1/lib/action_controller/base.rb:164:in `module:ActionController’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionpack-4.2.5.1/lib/action_controller/base.rb:5:in `<top (required)>’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionpack-action_caching-1.1.1/lib/action_controller/action_caching.rb:13:in `<top (required)>’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionpack-action_caching-1.1.1/lib/actionpack/action_caching.rb:1:in `require’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionpack-action_caching-1.1.1/lib/actionpack/action_caching.rb:1:in `<top (required)>’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.9.7/lib/bundler/runtime.rb:85:in `require’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.9.7/lib/bundler/runtime.rb:85:in `rescue in block in require’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.9.7/lib/bundler/runtime.rb:68:in `block in require’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.9.7/lib/bundler/runtime.rb:61:in `each’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.9.7/lib/bundler/runtime.rb:61:in `require’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.9.7/lib/bundler.rb:134:in `require’
/opt/openproject/config/application.rb:66:in `<top (required)>’
/opt/openproject/Rakefile:33:in `require’
/opt/openproject/Rakefile:33:in `<top (required)>’
LoadError: cannot load such file — actionpack-action_caching
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.9.7/lib/bundler/runtime.rb:76:in `require’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.9.7/lib/bundler/runtime.rb:76:in `block (2 levels) in require’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.9.7/lib/bundler/runtime.rb:72:in `each’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.9.7/lib/bundler/runtime.rb:72:in `block in require’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.9.7/lib/bundler/runtime.rb:61:in `each’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.9.7/lib/bundler/runtime.rb:61:in `require’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/bundler-1.9.7/lib/bundler.rb:134:in `require’
/opt/openproject/config/application.rb:66:in `<top (required)>’
/opt/openproject/Rakefile:33:in `require’
/opt/openproject/Rakefile:33:in `<top (required)>’
(See full trace by running task with —trace)

RE: RE: Errors configuring openproject on Fedora21 - Added by Kiran Patil over 8 years ago

It looks like load error and gem is actionpack-action_caching.

LoadError: cannot load such file — actionpack-action_caching

RE: RE: Errors configuring openproject on Fedora21 - Added by Oliver Günther over 8 years ago

The postinstall rake task is the first time of the installation wizard where the full rails environment is loaded, thus it is the point where issues with the gem installation become apparent.

Can you check:

1. the output of openproject run bundle show actionpack-action_caching prints the path /opt/openproject/vendor/bundle/ruby/2.x.0/gems/actionpack-action_caching-1.1.1

2. The output of openproject run gem list --local contains the line actionpack-action_caching (1.1.1)?

3. Do you use SELinux ? There may be additional steps involved in that case, which we cannot directly control. However, If you find the solution, we’re welcoming you to extend the documentation with the missing steps.

A similar report exists for Redmine, and does not appear to have a specific root cause or solution:

https://www.redmine.org/boards/2/topics/45991
https://www.redmine.org/issues/19419

Best,
Oliver

RE: Errors configuring openproject on Fedora21 - Added by Kiran Patil over 8 years ago

Please find the details where Selinux and Firewall is disabled but still issue persists.

[openproj@localhost ~]$ sudo openproject run bundle show actionpack-action_caching
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/actionpack-action_caching-1.1.1

[openproj@localhost ~]$ sudo openproject run gem list —local | grep actionpack
actionpack (4.2.5.1)
actionpack-action_caching (1.1.1)

[openproj@localhost ~]$ getenforce
Disabled

[openproj@localhost ~]$ sudo systemctl status firewalld.service
● firewalld.service - firewalld - dynamic firewall daemon
Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled; vendor preset: enabled)
Active: inactive (dead) since Sat 2016-03-05 11:19:59 IST; 1min 54s ago
Process: 691 ExecStart=/usr/sbin/firewalld —nofork —nopid $FIREWALLD_ARGS (code=exited, status=0/SUCCESS)
Main PID: 691 (code=exited, status=0/SUCCESS)

Mar 05 11:16:58 localhost.localdomain systemd[1]: Starting firewalld - dynamic firewall daemon…
Mar 05 11:17:03 localhost.localdomain systemd[1]: Started firewalld - dynamic firewall daemon.
Mar 05 11:19:58 localhost.localdomain systemd[1]: Stopping firewalld - dynamic firewall daemon…
Mar 05 11:19:59 localhost.localdomain systemd[1]: Stopped firewalld - dynamic firewall daemon.

PS: Yesterday I did “bundle update” this issue is gone but it asked to install “ssh-net” gem and then “mysql” where I stopped and reinstalled to check with your steps.

RE: Errors configuring openproject on Fedora21 - Added by Kiran Patil over 8 years ago

With the “bundle update” and few changes I could manage to get it work but now it gives migration error as below.

Below are the modification steps.

1) sudo openproject run bundle update

2) sudo openproject configure ==> here it will prompt for load errors and for that we need to install net-ssh,
mysql and rmagick gems then repeat step 2

My Gemfile snippet:
gem ‘net-ssh’
gem ‘mysql’
gem ‘rmagick’

3) For that install below packages
sudo dnf install mariadb-devel
sudo dnf install ImageMagick
sudo dnf install ImageMagick-devel

4) sudo openproject run bundle exec gem pristine rmagick
sudo ldconfig /usr/local/lib
sudo ldconfig /usr/local/lib64

5) sudo openproject run gem uninstall -i /opt/openproject/vendor/bundle/ruby/2.1.0 rmagick
sudo openproject run gem install -i /opt/openproject/vendor/bundle/ruby/2.1.0 rmagick

6) check everytime the rake command works or not.
sudo openproject run rake -T

7) sudo openproject configure

The migration error :

20131018134590 AddMissingCustomizableJournals: migrating =
— Add missing customizable journals
rake aborted!
StandardError: An error has occurred, all later migrations canceled:

Mysql::Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘AS cvd
WHERE EXISTS
(
SELECT w.id, cf.id, cfp.pr’ at line 1: DELETE FROM custom_values AS cvd
WHERE EXISTS
(
SELECT w.id, cf.id, cfp.project_id, p.name, cft.type_id
FROM work_packages AS w
JOIN custom_values AS cv ON (w.id = cv.customized_id AND cv.customized_type = ‘WorkPackage’)
JOIN custom_fields AS cf ON (cv.custom_field_id = cf.id)
JOIN projects AS p ON (w.project_id = p.id)
LEFT JOIN custom_fields_projects AS cfp ON (cv.custom_field_id = cfp.custom_field_id AND w.project_id = cfp.project_id)
LEFT JOIN custom_fields_types AS cft ON (cv.custom_field_id = cft.custom_field_id AND w.type_id = cft.type_id)
WHERE (cfp.project_id IS NULL AND cf.is_for_all = FALSE
OR cft.type_id IS NULL)
AND cv.id = cvd.id
);
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/connection_adapters/mysql_adapter.rb:339:in `query’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/connection_adapters/mysql_adapter.rb:339:in `block in exec_without_stmt’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/connection_adapters/abstract_adapter.rb:472:in `block in log’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.5.2/lib/active_support/notifications/instrumenter.rb:20:in `instrument’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/connection_adapters/abstract_adapter.rb:466:in `log’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/connection_adapters/mysql_adapter.rb:338:in `exec_without_stmt’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/connection_adapters/mysql_adapter.rb:255:in `exec_query’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/connection_adapters/mysql_adapter.rb:382:in `exec_delete’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/connection_adapters/abstract/database_statements.rb:119:in `delete’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/connection_adapters/abstract/query_cache.rb:14:in `delete’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:665:in `block in method_missing’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:634:in `block in say_with_time’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:634:in `say_with_time’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:654:in `method_missing’
/opt/openproject/db/migrate/migration_utils/customizable_utils.rb:105:in `delete_invalid_work_package_custom_values’
/opt/openproject/db/migrate/migration_utils/customizable_utils.rb:41:in `add_missing_customizable_journals’
/opt/openproject/db/migrate/20131018134590_add_missing_customizable_journals.rb:38:in `block in up’
/opt/openproject/db/migrate/migration_utils/utils.rb:37:in `block (2 levels) in say_with_time_silently’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:642:in `suppress_messages’
/opt/openproject/db/migrate/migration_utils/utils.rb:36:in `block in say_with_time_silently’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:634:in `block in say_with_time’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:634:in `say_with_time’
/opt/openproject/db/migrate/migration_utils/utils.rb:35:in `say_with_time_silently’
/opt/openproject/db/migrate/20131018134590_add_missing_customizable_journals.rb:37:in `up’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:611:in `exec_migration’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:592:in `block (2 levels) in migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:591:in `block in migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:292:in `with_connection’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:590:in `migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:768:in `migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:998:in `block in execute_migration_in_transaction’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:1046:in `ddl_transaction’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:997:in `execute_migration_in_transaction’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:959:in `block in migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:955:in `each’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:955:in `migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:823:in `up’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:801:in `migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/tasks/database_tasks.rb:137:in `migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/railties/databases.rake:44:in `block (2 levels) in <top (required)>’
ActiveRecord::StatementInvalid: Mysql::Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘AS cvd
WHERE EXISTS
(
SELECT w.id, cf.id, cfp.pr’ at line 1: DELETE FROM custom_values AS cvd
WHERE EXISTS
(
SELECT w.id, cf.id, cfp.project_id, p.name, cft.type_id
FROM work_packages AS w
JOIN custom_values AS cv ON (w.id = cv.customized_id AND cv.customized_type = ‘WorkPackage’)
JOIN custom_fields AS cf ON (cv.custom_field_id = cf.id)
JOIN projects AS p ON (w.project_id = p.id)
LEFT JOIN custom_fields_projects AS cfp ON (cv.custom_field_id = cfp.custom_field_id AND w.project_id = cfp.project_id)
LEFT JOIN custom_fields_types AS cft ON (cv.custom_field_id = cft.custom_field_id AND w.type_id = cft.type_id)
WHERE (cfp.project_id IS NULL AND cf.is_for_all = FALSE
OR cft.type_id IS NULL)
AND cv.id = cvd.id
);
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/connection_adapters/mysql_adapter.rb:339:in `query’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/connection_adapters/mysql_adapter.rb:339:in `block in exec_without_stmt’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/connection_adapters/abstract_adapter.rb:472:in `block in log’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.5.2/lib/active_support/notifications/instrumenter.rb:20:in `instrument’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/connection_adapters/abstract_adapter.rb:466:in `log’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/connection_adapters/mysql_adapter.rb:338:in `exec_without_stmt’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/connection_adapters/mysql_adapter.rb:255:in `exec_query’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/connection_adapters/mysql_adapter.rb:382:in `exec_delete’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/connection_adapters/abstract/database_statements.rb:119:in `delete’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/connection_adapters/abstract/query_cache.rb:14:in `delete’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:665:in `block in method_missing’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:634:in `block in say_with_time’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:634:in `say_with_time’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:654:in `method_missing’
/opt/openproject/db/migrate/migration_utils/customizable_utils.rb:105:in `delete_invalid_work_package_custom_values’
/opt/openproject/db/migrate/migration_utils/customizable_utils.rb:41:in `add_missing_customizable_journals’
/opt/openproject/db/migrate/20131018134590_add_missing_customizable_journals.rb:38:in `block in up’
/opt/openproject/db/migrate/migration_utils/utils.rb:37:in `block (2 levels) in say_with_time_silently’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:642:in `suppress_messages’
/opt/openproject/db/migrate/migration_utils/utils.rb:36:in `block in say_with_time_silently’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:634:in `block in say_with_time’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:634:in `say_with_time’
/opt/openproject/db/migrate/migration_utils/utils.rb:35:in `say_with_time_silently’
/opt/openproject/db/migrate/20131018134590_add_missing_customizable_journals.rb:37:in `up’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:611:in `exec_migration’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:592:in `block (2 levels) in migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:591:in `block in migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:292:in `with_connection’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:590:in `migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:768:in `migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:998:in `block in execute_migration_in_transaction’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:1046:in `ddl_transaction’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:997:in `execute_migration_in_transaction’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:959:in `block in migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:955:in `each’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:955:in `migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:823:in `up’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:801:in `migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/tasks/database_tasks.rb:137:in `migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/railties/databases.rake:44:in `block (2 levels) in <top (required)>’
Mysql::Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘AS cvd
WHERE EXISTS
(
SELECT w.id, cf.id, cfp.pr’ at line 1
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/connection_adapters/mysql_adapter.rb:339:in `query’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/connection_adapters/mysql_adapter.rb:339:in `block in exec_without_stmt’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/connection_adapters/abstract_adapter.rb:472:in `block in log’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.5.2/lib/active_support/notifications/instrumenter.rb:20:in `instrument’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/connection_adapters/abstract_adapter.rb:466:in `log’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/connection_adapters/mysql_adapter.rb:338:in `exec_without_stmt’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/connection_adapters/mysql_adapter.rb:255:in `exec_query’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/connection_adapters/mysql_adapter.rb:382:in `exec_delete’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/connection_adapters/abstract/database_statements.rb:119:in `delete’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/connection_adapters/abstract/query_cache.rb:14:in `delete’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:665:in `block in method_missing’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:634:in `block in say_with_time’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:634:in `say_with_time’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:654:in `method_missing’
/opt/openproject/db/migrate/migration_utils/customizable_utils.rb:105:in `delete_invalid_work_package_custom_values’
/opt/openproject/db/migrate/migration_utils/customizable_utils.rb:41:in `add_missing_customizable_journals’
/opt/openproject/db/migrate/20131018134590_add_missing_customizable_journals.rb:38:in `block in up’
/opt/openproject/db/migrate/migration_utils/utils.rb:37:in `block (2 levels) in say_with_time_silently’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:642:in `suppress_messages’
/opt/openproject/db/migrate/migration_utils/utils.rb:36:in `block in say_with_time_silently’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:634:in `block in say_with_time’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:634:in `say_with_time’
/opt/openproject/db/migrate/migration_utils/utils.rb:35:in `say_with_time_silently’
/opt/openproject/db/migrate/20131018134590_add_missing_customizable_journals.rb:37:in `up’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:611:in `exec_migration’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:592:in `block (2 levels) in migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:591:in `block in migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:292:in `with_connection’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:590:in `migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:768:in `migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:998:in `block in execute_migration_in_transaction’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:1046:in `ddl_transaction’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:997:in `execute_migration_in_transaction’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:959:in `block in migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:955:in `each’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:955:in `migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:823:in `up’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/migration.rb:801:in `migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/tasks/database_tasks.rb:137:in `migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/railties/databases.rake:44:in `block (2 levels) in <top (required)>’
Tasks: TOP => db:migrate
(See full trace by running task with —trace)

Thanks.

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