Bug 690159 - PGerror when sorting on provider account table
Summary: PGerror when sorting on provider account table
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: CloudForms Cloud Engine
Classification: Retired
Component: aeolus-conductor
Version: 0.3.1
Hardware: Unspecified
OS: Unspecified
unspecified
medium
Target Milestone: beta
Assignee: Richard Su
QA Contact: Dave Johnson
URL:
Whiteboard:
Depends On:
Blocks: ce-beta
TreeView+ depends on / blocked
 
Reported: 2011-03-23 13:32 UTC by Dave Johnson
Modified: 2012-01-26 12:25 UTC (History)
6 users (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2011-12-08 13:47:20 UTC
Embargoed:


Attachments (Terms of Use)
error in ui (22.59 KB, image/png)
2011-03-23 13:32 UTC, Dave Johnson
no flags Details

Description Dave Johnson 2011-03-23 13:32:38 UTC
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

Comment 1 Richard Su 2011-04-05 17:44:38 UTC
jzigmund's credential model changes removed the ability to sort this table. The sort error shouldn't occur now.

Comment 2 wes hayutin 2011-08-01 19:53:31 UTC
release pending...

Comment 3 wes hayutin 2011-08-01 19:55:40 UTC
release pending...

Comment 5 wes hayutin 2011-12-08 13:47:20 UTC
perm close


Note You need to log in before you can comment on or make changes to this bug.