Project

General

Profile

Bug #1839

puppetclass listing on postgres isn't showing up

Added by Hannes Schaller almost 10 years ago. Updated over 9 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Database
Target version:
Difficulty:
Triaged:
No
Bugzilla link:
Pull request:
Fixed in Releases:
Found in Releases:

Description

Hello!

I am using foreman-1.0.1-1.el6 on Postgres (the rpm package). If i try to go to http://foreman/puppetclasses it gives me the following error:

ActiveRecord::StatementInvalid
PG::Error: ERROR: column "lookup_keys.key" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ... 83, 1, 2) GROUP BY puppetclass_id ORDER BY LOWER(lookup_key... ^ : SELECT COUNT(*) AS count_all, puppetclass_id AS puppetclass_id FROM "lookup_keys" WHERE "lookup_keys"."puppetclass_id" IN (184, 139, 158, 96, 95, 109, 178, 180, 252, 194, 189, 188, 190, 193, 253, 191, 192, 97, 157, 108, 177, 179, 83, 1, 2) GROUP BY puppetclass_id ORDER BY LOWER(lookup_keys.key)
app/controllers/puppetclasses_controller.rb:21:in `index'
app/controllers/puppetclasses_controller.rb:17:in `index'

Despite that http://foreman/puppetclasses?format=json is working.

The debug output in production.log is:

Started GET "/puppetclasses" for 172.25.49.62 at Mon Aug 27 11:48:45 +0200 2012
  Processing by PuppetclassesController#index as HTML
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 3 LIMIT 1
Setting current user thread-local variable to naglha
  Puppetclass Load (0.5ms)  SELECT "puppetclasses".* FROM "puppetclasses" ORDER BY LOWER(puppetclasses.name) LIMIT 1
  SQL (0.6ms)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
 FROM pg_attribute a LEFT JOIN pg_attrdef d
 ON a.attrelid = d.adrelid AND a.attnum = d.adnum
 WHERE a.attrelid = '"puppetclasses"'::regclass
 AND a.attnum > 0 AND NOT a.attisdropped
 ORDER BY a.attnum
  Puppetclass Load (0.6ms)  SELECT "puppetclasses".* FROM "puppetclasses" ORDER BY LOWER(puppetclasses.name) LIMIT 25 OFFSET 0
  Environment Load (0.6ms)  SELECT "environments".*, t0.puppetclass_id as the_parent_record_id FROM "environments" INNER JOIN "environments_puppetclasses" t0 ON "environments".id = t0.environment_id WHERE (t0.puppetclass_id IN (184,139,158,96,95,109,178,180,252,194,189,188,190,193,253,191,192,97,157,108,177,179,83,1,2))
  Hostgroup Load (0.5ms)  SELECT "hostgroups".*, t0.puppetclass_id as the_parent_record_id FROM "hostgroups" INNER JOIN "hostgroups_puppetclasses" t0 ON "hostgroups".id = t0.hostgroup_id WHERE (t0.puppetclass_id IN (184,139,158,96,95,109,178,180,252,194,189,188,190,193,253,191,192,97,157,108,177,179,83,1,2))
  SQL (0.2ms)  SELECT COUNT(*) FROM "puppetclasses" 
  SQL (0.5ms)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
 FROM pg_attribute a LEFT JOIN pg_attrdef d
 ON a.attrelid = d.adrelid AND a.attnum = d.adnum
 WHERE a.attrelid = '"host_classes"'::regclass
 AND a.attnum > 0 AND NOT a.attisdropped
 ORDER BY a.attnum

  SQL (0.5ms)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
 FROM pg_attribute a LEFT JOIN pg_attrdef d
 ON a.attrelid = d.adrelid AND a.attnum = d.adnum
 WHERE a.attrelid = '"host_classes"'::regclass
 AND a.attnum > 0 AND NOT a.attisdropped
 ORDER BY a.attnum
  SQL (0.7ms)  SELECT COUNT(*) AS count_all, puppetclass_id AS puppetclass_id FROM "hosts" INNER JOIN "host_classes" ON "hosts"."id" = "host_classes"."host_id" INNER JOIN "puppetclasses" ON "puppetclasses"."id" = "host_classes"."puppetclass_id" WHERE "puppetclasses"."id" IN (184, 139, 158, 96, 95, 109, 178, 180, 252, 194, 189, 188, 190, 193, 253, 191, 192, 97, 157, 108, 177, 179, 83, 1, 2) GROUP BY puppetclass_id
  SQL (0.4ms)  SELECT COUNT(*) AS count_all, puppetclass_id AS puppetclass_id FROM "lookup_keys" WHERE "lookup_keys"."puppetclass_id" IN (184, 139, 158, 96, 95, 109, 178, 180, 252, 194, 189, 188, 190, 193, 253, 191, 192, 97, 157, 108, 177, 179, 83, 1, 2) GROUP BY puppetclass_id ORDER BY LOWER(lookup_keys.key)
PG::Error: ERROR:  column "lookup_keys.key" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ... 83, 1, 2) GROUP BY puppetclass_id ORDER BY LOWER(lookup_key...
                                                             ^
: SELECT COUNT(*) AS count_all, puppetclass_id AS puppetclass_id FROM "lookup_keys" WHERE "lookup_keys"."puppetclass_id" IN (184, 139, 158, 96, 95, 109, 178, 180, 252, 194, 189, 188, 190, 193, 253, 191, 192, 97, 157, 108, 177, 179, 83, 1, 2) GROUP BY puppetclass_id ORDER BY LOWER(lookup_keys.key)
Operation FAILED: PG::Error: ERROR:  column "lookup_keys.key" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ... 83, 1, 2) GROUP BY puppetclass_id ORDER BY LOWER(lookup_key...
                                                             ^
: SELECT COUNT(*) AS count_all, puppetclass_id AS puppetclass_id FROM "lookup_keys" WHERE "lookup_keys"."puppetclass_id" IN (184, 139, 158, 96, 95, 109, 178, 180, 252, 194, 189, 188, 190, 193, 253, 191, 192, 97, 157, 108, 177, 179, 83, 1, 2) GROUP BY puppetclass_id ORDER BY LOWER(lookup_keys.key)
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/connection_adapters/postgresql_adapter.rb:518:in `exec'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/connection_adapters/postgresql_adapter.rb:518:in `execute'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/connection_adapters/abstract_adapter.rb:202:in `log'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/notifications/instrumenter.rb:21:in `instrument'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/connection_adapters/abstract_adapter.rb:200:in `log'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/connection_adapters/postgresql_adapter.rb:514:in `execute'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/connection_adapters/postgresql_adapter.rb:1004:in `select_raw'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/connection_adapters/postgresql_adapter.rb:997:in `select'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/connection_adapters/abstract/query_cache.rb:54:in `select_all'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/connection_adapters/abstract/query_cache.rb:68:in `cache_sql'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/connection_adapters/abstract/query_cache.rb:54:in `select_all'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/relation/calculations.rb:235:in `execute_grouped_calculation'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/relation/calculations.rb:180:in `perform_calculation'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/relation/calculations.rb:152:in `calculate'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/relation/calculations.rb:147:in `calculate'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/relation/calculations.rb:58:in `count'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/base.rb:448:in `__send__'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/base.rb:448:in `count'
/usr/share/foreman/app/controllers/puppetclasses_controller.rb:21:in `index'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_controller/metal/mime_responds.rb:192:in `call'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_controller/metal/mime_responds.rb:192:in `respond_to'
/usr/share/foreman/app/controllers/puppetclasses_controller.rb:17:in `index'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_controller/metal/implicit_render.rb:4:in `send_action'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_controller/metal/implicit_render.rb:4:in `send_action'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/abstract_controller/base.rb:150:in `process_action'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_controller/metal/rendering.rb:11:in `process_action'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/abstract_controller/callbacks.rb:18:in `process_action'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/callbacks.rb:479:in `_run__2117744461__process_action__199225275__callbacks'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/callbacks.rb:221:in `_conditional_callback_around_3205'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/callbacks.rb:331:in `around'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/callbacks.rb:315:in `send'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/callbacks.rb:315:in `_callback_around_2668'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/callbacks.rb:220:in `_conditional_callback_around_3205'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/callbacks.rb:473:in `_run__2117744461__process_action__199225275__callbacks'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/callbacks.rb:221:in `_conditional_callback_around_3204'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/callbacks.rb:331:in `around'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/callbacks.rb:315:in `send'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/callbacks.rb:315:in `_callback_around_13'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/callbacks.rb:220:in `_conditional_callback_around_3204'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/callbacks.rb:436:in `_run__2117744461__process_action__199225275__callbacks'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/callbacks.rb:410:in `send'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/callbacks.rb:410:in `_run_process_action_callbacks'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/callbacks.rb:94:in `send'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/callbacks.rb:94:in `run_callbacks'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/abstract_controller/callbacks.rb:17:in `process_action'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_controller/metal/rescue.rb:17:in `process_action'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_controller/metal/instrumentation.rb:30:in `process_action'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/notifications.rb:52:in `instrument'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/notifications/instrumenter.rb:21:in `instrument'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/notifications.rb:52:in `instrument'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_controller/metal/instrumentation.rb:29:in `process_action'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/abstract_controller/base.rb:119:in `process'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/abstract_controller/rendering.rb:41:in `process'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_controller/metal.rb:138:in `dispatch'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_controller/metal/rack_delegation.rb:14:in `dispatch'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_controller/metal.rb:178:in `action'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_dispatch/routing/route_set.rb:68:in `call'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_dispatch/routing/route_set.rb:68:in `dispatch'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_dispatch/routing/route_set.rb:33:in `call'
/usr/lib/ruby/gems/1.8/gems/rack-mount-0.6.14/lib/rack/mount/route_set.rb:148:in `call'
/usr/lib/ruby/gems/1.8/gems/rack-mount-0.6.14/lib/rack/mount/code_generation.rb:93:in `recognize'
/usr/lib/ruby/gems/1.8/gems/rack-mount-0.6.14/lib/rack/mount/code_generation.rb:131:in `optimized_each'
/usr/lib/ruby/gems/1.8/gems/rack-mount-0.6.14/lib/rack/mount/code_generation.rb:92:in `recognize'
/usr/lib/ruby/gems/1.8/gems/rack-mount-0.6.14/lib/rack/mount/route_set.rb:139:in `call'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_dispatch/routing/route_set.rb:499:in `call'
/usr/lib/ruby/gems/1.8/gems/apipie-rails-0.0.9/lib/apipie/static_dispatcher.rb:57:in `call'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_dispatch/middleware/best_standards_support.rb:17:in `call'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_dispatch/middleware/head.rb:14:in `call'
/usr/lib/ruby/gems/1.8/gems/rack-1.2.5/lib/rack/methodoverride.rb:24:in `call'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_dispatch/middleware/params_parser.rb:21:in `call'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_dispatch/middleware/flash.rb:182:in `call'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_dispatch/middleware/session/abstract_store.rb:149:in `call'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_dispatch/middleware/cookies.rb:302:in `call'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/query_cache.rb:32:in `call'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/connection_adapters/abstract/query_cache.rb:28:in `cache'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/query_cache.rb:12:in `cache'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/query_cache.rb:31:in `call'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/connection_adapters/abstract/connection_pool.rb:354:in `call'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_dispatch/middleware/callbacks.rb:46:in `call'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/callbacks.rb:416:in `_run_call_callbacks'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_dispatch/middleware/callbacks.rb:44:in `call'
/usr/lib/ruby/gems/1.8/gems/rack-1.2.5/lib/rack/sendfile.rb:106:in `call'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_dispatch/middleware/remote_ip.rb:48:in `call'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_dispatch/middleware/show_exceptions.rb:47:in `call'
/usr/lib/ruby/gems/1.8/gems/railties-3.0.15/lib/rails/rack/logger.rb:13:in `call'
/usr/lib/ruby/gems/1.8/gems/rack-1.2.5/lib/rack/runtime.rb:17:in `call'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/cache/strategy/local_cache.rb:72:in `call'
/usr/lib/ruby/gems/1.8/gems/rack-1.2.5/lib/rack/lock.rb:13:in `call'
/usr/lib/ruby/gems/1.8/gems/rack-1.2.5/lib/rack/lock.rb:13:in `synchronize'
/usr/lib/ruby/gems/1.8/gems/rack-1.2.5/lib/rack/lock.rb:13:in `call'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_dispatch/middleware/static.rb:30:in `call'
/usr/lib/ruby/gems/1.8/gems/railties-3.0.15/lib/rails/application.rb:168:in `call'
/usr/lib/ruby/gems/1.8/gems/railties-3.0.15/lib/rails/application.rb:77:in `send'
/usr/lib/ruby/gems/1.8/gems/railties-3.0.15/lib/rails/application.rb:77:in `method_missing'
/usr/lib/ruby/gems/1.8/gems/rack-1.2.5/lib/rack/urlmap.rb:47:in `call'
/usr/lib/ruby/gems/1.8/gems/rack-1.2.5/lib/rack/urlmap.rb:41:in `each'
/usr/lib/ruby/gems/1.8/gems/rack-1.2.5/lib/rack/urlmap.rb:41:in `call'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/rack/request_handler.rb:96:in `process_request'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/abstract_request_handler.rb:513:in `accept_and_process_next_request'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/abstract_request_handler.rb:274:in `main_loop'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/rack/application_spawner.rb:206:in `start_request_handler'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/rack/application_spawner.rb:171:in `send'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/rack/application_spawner.rb:171:in `handle_spawn_application'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/utils.rb:479:in `safe_fork'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/rack/application_spawner.rb:166:in `handle_spawn_application'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/abstract_server.rb:357:in `__send__'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/abstract_server.rb:357:in `server_main_loop'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/abstract_server.rb:206:in `start_synchronously'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/abstract_server.rb:180:in `start'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/rack/application_spawner.rb:129:in `start'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/spawn_manager.rb:253:in `spawn_rack_application'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/abstract_server_collection.rb:132:in `lookup_or_add'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/spawn_manager.rb:246:in `spawn_rack_application'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/abstract_server_collection.rb:82:in `synchronize'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/spawn_manager.rb:244:in `spawn_rack_application'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/spawn_manager.rb:137:in `spawn_application'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/spawn_manager.rb:275:in `handle_spawn_application'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/abstract_server.rb:357:in `__send__'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/abstract_server.rb:357:in `server_main_loop'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/abstract_server.rb:206:in `start_synchronously'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/helper-scripts/passenger-spawn-server:99
Read fragment views/tabs_and_title_records-3 (0.3ms)
Rendered home/_topbar.rhtml (1.0ms)
  Bookmark Load (0.4ms)  SELECT "bookmarks".* FROM "bookmarks" WHERE (((bookmarks.public = 't') OR (bookmarks.owner_id = 3 AND bookmarks.owner_type = 'User'))) AND (controller = 'puppetclasses') ORDER BY name
Rendered common/_searchbar.erb (4.1ms)
Rendered common/500.rhtml within layouts/application (13.7ms)
Completed 500 Internal Server Error in 52ms (Views: 14.0ms | ActiveRecord: 7.0ms)

Thanks
Hannes

Associated revisions

Revision 4e493ad7 (diff)
Added by Joseph Magen almost 10 years ago

removed lower() on default_scope to get tests to pass in postgresql

fixes #1887
fixes #1839

History

#1 Updated by Ohad Levy almost 10 years ago

  • Category set to Database
  • Assignee set to Joseph Magen
  • Target version set to 1.1

#2 Updated by Anonymous almost 10 years ago

  • Status changed from New to Closed
  • % Done changed from 0 to 100

Also available in: Atom PDF