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

Plugins
  1. OpenProject
  2. Forums
  3. Plugins
  4. Time and cost reporting, budget planning (database error)

Time and cost reporting, budget planning (database error)

Added by Carlos Freixo over 10 years ago

Hello there.

I’m having problems installing this plugin.

After the installation, I have the following error (prodution.log)

@

Processing by AccountController#login as HTML
Parameters: {“utf8”=>“✓”, “authenticity_token”=>“ObpUgFeop/ttDIpWoAEWQD1tTDwA2+v822Q5fw42Pvw=”, “back_url”=>“/”, “username”=>“cfreixo”, “password”=>“[FILTERED]”, “login”=>“Login”}
Completed 500 Internal Server Error in 18.9ms

ActiveRecord::StatementInvalid (PG::UndefinedTable: ERROR: relation “rates” does not exist
LINE 5: WHERE a.attrelid = ‘“rates”’::regclass
^
: SELECT a.attname, format_type(a.atttypid, a.atttypmod),
pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = ‘“rates”’::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
):
app/models/user.rb:873:in `reset_failed_login_count_for’
app/models/user.rb:880:in `block_user_if_too_many_recent_attempts_failed’
app/models/user.rb:862:in `prevent_brute_force_attack’
app/models/user.rb:259:in `try_to_login’
app/controllers/account_controller.rb:189:in `password_authentication’
app/controllers/account_controller.rb:184:in `authenticate_user’
app/controllers/account_controller.rb:41:in `login’

@

As you can see, this is just after I login. A table is missing and I don’t know why…

This is the content of my Gemfile.plugins

@

  1. gem “openproject-plugins”, “~> 1.0.3”, :branch => ‘stable’
  1. Required for each plug-in
    gem “openproject-plugins”, :git => “https://github.com/opf/openproject-plugins.git”, :branch => “stable”
  1. Required by backlogs
    gem “openproject-pdf_export”, git: “https://github.com/finnlabs/openproject-pdf_export.git”, :branch => “stable”

gem “openproject-backlogs”, git: “https://github.com/finnlabs/openproject-backlogs.git”, :branch => “stable”

gem “openproject-costs”, git: “https://github.com/finnlabs/openproject-costs.git”, :branch => “stable”

@

I followed the instructions in this page:
https://github.com/finnlabs/openproject-costs

Can anyone help me?

Thanks in advance,
Carlos


Replies (6)

RE: Time and cost reporting, budget planning (database error) - Added by Robin Wagner over 10 years ago

Hi Carlos,

there is a known error when putting the backlogs plugin before the costs plugin in the Gemfile.plugin.
Could you change the order of the plugins and try again?

Please take a look at the following bug report for more information:

You may also want to look at the following forum posts:
https://community.openproject.org/topics/2041
https://community.openproject.org/topics/2043

Best,
Robin

RE: Time and cost reporting, budget planning (database error) - Added by Carlos Freixo over 10 years ago

Thanks for your reply!

Unfortunately, the error persists.

ActiveRecord::StatementInvalid (PG::UndefinedTable: ERROR: relation "rates" does not exist LINE 5: WHERE a.attrelid = '"rates"'::regclass ^ : SELECT a.attname, format_type(a.atttypid, a.atttypmod), pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attrelid = '"rates"'::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum ): app/models/user.rb:873:in `reset_failed_login_count_for' app/models/user.rb:880:in `block_user_if_too_many_recent_attempts_failed' app/models/user.rb:862:in `prevent_brute_force_attack' app/models/user.rb:259:in `try_to_login' app/controllers/account_controller.rb:189:in `password_authentication' app/controllers/account_controller.rb:184:in `authenticate_user' app/controllers/account_controller.rb:41:in `login'

The content of my Gemfile.plugins

@# gem “openproject-plugins”, “~> 1.0.3”, :branch => ‘stable’

  1. Required for each plug-in
    gem “openproject-plugins”, :git => “https://github.com/opf/openproject-plugins.git”, :branch => “stable”

gem “openproject-costs”, git: “https://github.com/finnlabs/openproject-costs.git”, :branch => “stable”

  1. Required by backlogs
    gem “openproject-pdf_export”, git: “https://github.com/finnlabs/openproject-pdf_export.git”, :branch => “stable”

gem “openproject-backlogs”, git: “https://github.com/finnlabs/openproject-backlogs.git”, :branch => “stable”@

I followed the instructions for the uninstallation the reinstallation on this page:
https://github.com/finnlabs/openproject-costs

Any other advice?

Thanks again,
Carlos

RE: Time and cost reporting, budget planning (database error) - Added by Christian Ratz over 10 years ago

Hello Carlos,

an error like this (PG::UndefinedTable: ERROR: relation “tablename” does not exist) is usually an indicator for a missing migration. It should work after you run the following command from your rails root folder.

Assuming you wanna run OpenProject in production mode:

RAILS_ENV=production bundle exec rake db:migrate

Best
Ratzi

RE: Time and cost reporting, budget planning (database error) - Added by Carlos Freixo over 10 years ago

Hello Ratzi,

Thank you very much. My issue is SOLVED.

For further understanding, what was the difference between

RAILS_ENV=production bundle exec rake db:migrate

and

rake db:migrate

the, command I was executing?

Additionally, since I followed this tutorial:

https://community.openproject.org/projects/openproject/wiki/Debian_Stable_with_MySQL_in_production

I needed an extra step:
RAILS_ENV="production" bundle exec rake assets:precompile

After that command, I got no more errors.

Thanks again :)
Carlos

RE: Time and cost reporting, budget planning (database error) - Added by Christian Ratz over 10 years ago

Hi again,

if you run the migration command without “RAILS_ENV=production” it will run in development environment and also uses the development database (see config/database.yml.example there is a ‘production’, ‘development’ and ‘test’ section) but you start your server in production mode and it will use the production database where the migrations are not applied.

Search the web for ‘rails environment(s)’ if you need more information about the rails environment stuff.

Best
Ratzi

RE: Time and cost reporting, budget planning (database error) - Added by Carlos Freixo over 10 years ago

Ok, got it ;)

Thanks!

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