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

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

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

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

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

Ok, got it ;)

Thanks!