Bug 690159
| Summary: | PGerror when sorting on provider account table | ||||||
|---|---|---|---|---|---|---|---|
| Product: | [Retired] CloudForms Cloud Engine | Reporter: | Dave Johnson <dajohnso> | ||||
| Component: | aeolus-conductor | Assignee: | Richard Su <rwsu> | ||||
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Dave Johnson <dajohnso> | ||||
| Severity: | medium | Docs Contact: | |||||
| Priority: | unspecified | ||||||
| Version: | 0.3.1 | CC: | akarol, dajohnso, deltacloud-maint, dgao, ssachdev, whayutin | ||||
| Target Milestone: | beta | ||||||
| Target Release: | --- | ||||||
| Hardware: | Unspecified | ||||||
| OS: | Unspecified | ||||||
| Whiteboard: | |||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||
| Doc Text: | Story Points: | --- | |||||
| Clone Of: | Environment: | ||||||
| Last Closed: | 2011-12-08 13:47:20 UTC | Type: | --- | ||||
| Regression: | --- | Mount Type: | --- | ||||
| Documentation: | --- | CRM: | |||||
| Verified Versions: | Category: | --- | |||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||
| Embargoed: | |||||||
| Bug Depends On: | |||||||
| Bug Blocks: | 684278 | ||||||
| Attachments: |
|
||||||
jzigmund's credential model changes removed the ability to sort this table. The sort error shouldn't occur now. release pending... release pending... perm close |
Created attachment 487039 [details] error in ui Description of problem: If you click on the name or type column heading fields of the provider table, the page blows up with a PGerror. Version-Release number of selected component (if applicable): aeolus-conductor-doc-0.0.3-0.fc1420110322191726gitbdedf42.x86_64 aeolus-configure-2.0.0-4.fc1420110322151756gitbc1637e.noarch aeolus-conductor-daemons-0.0.3-0.fc1420110322191726gitbdedf42.x86_64 aeolus-conductor-0.0.3-0.fc1420110322191726gitbdedf42.x86_64 How reproducible: 100% Steps to Reproduce: 1. add a provider 2. on the provider table, click on name column header to sort and see error 3. username seems to work correctly 4. same error when sorting on provider type Additional info: Processing Admin::ProviderAccountsController#index (for 10.11.231.77 at 2011-03-23 09:24:08) [GET] Parameters: {"action"=>"index", "controller"=>"admin/provider_accounts", "order_dir"=>"desc", "order_field"=>"name"} ActiveRecord::StatementInvalid (PGError: ERROR: column "name" does not exist LINE 1: SELECT * FROM "provider_accounts" ORDER BY name desc LIMIT ... ^ : SELECT * FROM "provider_accounts" ORDER BY name desc LIMIT 30 OFFSET 0): /usr/lib/ruby/gems/1.8/gems/will_paginate-2.3.14/lib/will_paginate/finder.rb:82:in `send' /usr/lib/ruby/gems/1.8/gems/will_paginate-2.3.14/lib/will_paginate/finder.rb:82:in `paginate' /usr/lib/ruby/gems/1.8/gems/will_paginate-2.3.14/lib/will_paginate/collection.rb:85:in `create' /usr/lib/ruby/gems/1.8/gems/will_paginate-2.3.14/lib/will_paginate/finder.rb:76:in `paginate' app/controllers/admin/provider_accounts_controller.rb:171:in `load_accounts' app/controllers/admin/provider_accounts_controller.rb:9:in `index' compass (0.10.4) lib/compass/app_integration/rails/actionpack2/action_controller.rb:7:in `process' haml (3.0.18) rails/./lib/sass/plugin/rack.rb:41:in `call' haml (3.0.18) rails/./lib/sass/plugin/rack.rb:41:in `call' thin (1.2.5) lib/thin/connection.rb:76:in `pre_process' thin (1.2.5) lib/thin/connection.rb:74:in `catch' thin (1.2.5) lib/thin/connection.rb:74:in `pre_process' thin (1.2.5) lib/thin/connection.rb:57:in `process' thin (1.2.5) lib/thin/connection.rb:42:in `receive_data' eventmachine (0.12.10) lib/eventmachine.rb:256:in `run_machine' eventmachine (0.12.10) lib/eventmachine.rb:256:in `run' thin (1.2.5) lib/thin/backends/base.rb:57:in `start' thin (1.2.5) lib/thin/server.rb:156:in `start' thin (1.2.5) lib/thin/controllers/controller.rb:80:in `start' thin (1.2.5) lib/thin/runner.rb:177:in `send' thin (1.2.5) lib/thin/runner.rb:177:in `run_command' thin (1.2.5) lib/thin/runner.rb:143:in `run!' thin (1.2.5) bin/thin:6 /usr/bin/thin:19:in `load' /usr/bin/thin:19 Processing Admin::ProviderAccountsController#index (for 10.11.231.77 at 2011-03-23 09:23:59) [GET] Parameters: {"action"=>"index", "controller"=>"admin/provider_accounts", "order_dir"=>"desc", "order_field"=>"provider_type"} ActiveRecord::StatementInvalid (PGError: ERROR: column "provider_type" does not exist LINE 1: SELECT * FROM "provider_accounts" ORDER BY provider_type de... ^ : SELECT * FROM "provider_accounts" ORDER BY provider_type desc LIMIT 30 OFFSET 0): /usr/lib/ruby/gems/1.8/gems/will_paginate-2.3.14/lib/will_paginate/finder.rb:82:in `send' /usr/lib/ruby/gems/1.8/gems/will_paginate-2.3.14/lib/will_paginate/finder.rb:82:in `paginate' /usr/lib/ruby/gems/1.8/gems/will_paginate-2.3.14/lib/will_paginate/collection.rb:85:in `create' /usr/lib/ruby/gems/1.8/gems/will_paginate-2.3.14/lib/will_paginate/finder.rb:76:in `paginate' app/controllers/admin/provider_accounts_controller.rb:171:in `load_accounts' app/controllers/admin/provider_accounts_controller.rb:9:in `index' compass (0.10.4) lib/compass/app_integration/rails/actionpack2/action_controller.rb:7:in `process' haml (3.0.18) rails/./lib/sass/plugin/rack.rb:41:in `call' haml (3.0.18) rails/./lib/sass/plugin/rack.rb:41:in `call' thin (1.2.5) lib/thin/connection.rb:76:in `pre_process' thin (1.2.5) lib/thin/connection.rb:74:in `catch' thin (1.2.5) lib/thin/connection.rb:74:in `pre_process' thin (1.2.5) lib/thin/connection.rb:57:in `process' thin (1.2.5) lib/thin/connection.rb:42:in `receive_data' eventmachine (0.12.10) lib/eventmachine.rb:256:in `run_machine' eventmachine (0.12.10) lib/eventmachine.rb:256:in `run' thin (1.2.5) lib/thin/backends/base.rb:57:in `start' thin (1.2.5) lib/thin/server.rb:156:in `start' thin (1.2.5) lib/thin/controllers/controller.rb:80:in `start' thin (1.2.5) lib/thin/runner.rb:177:in `send' thin (1.2.5) lib/thin/runner.rb:177:in `run_command' thin (1.2.5) lib/thin/runner.rb:143:in `run!' thin (1.2.5) bin/thin:6 /usr/bin/thin:19:in `load' /usr/bin/thin:19