Content
Time and cost reporting, budget planning (database error)
Added by Carlos Freixo about 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
@
- gem “openproject-plugins”, “~> 1.0.3”, :branch => ‘stable’
- Required for each plug-in
gem “openproject-plugins”, :git => “https://github.com/opf/openproject-plugins.git”, :branch => “stable”
- 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)
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’
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”
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:
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!