Skip to content

Instantly share code, notes, and snippets.

@slaskis
Created August 25, 2009 08:39
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save slaskis/174541 to your computer and use it in GitHub Desktop.
Save slaskis/174541 to your computer and use it in GitHub Desktop.
~ (0.066093) SELECT "feed_items"."id", "feed_items"."url_id", "feed_items"."title", "feed_items"."link", "feed_items"."updated", "feed_items"."published", "feed_items"."media", "feed_items"."parent_id", "feed_items"."feed_id" FROM "feed_items" INNER JOIN "feeds" ON "feeds"."id" = "feed_items"."feed_id" WHERE "feed_items"."parent_id" = 0 AND "feeds"."type" = 1 GROUP BY "feed_items"."id", "feed_items"."url_id", "feed_items"."title", "feed_items"."link", "feed_items"."updated", "feed_items"."published", "feed_items"."media", "feed_items"."parent_id", "feed_items"."feed_id" ORDER BY "feed_items"."updated" DESC LIMIT 1000
~ (0.001025) SELECT "feed_items"."id", "feed_items"."content" FROM "feed_items" INNER JOIN "feeds" ON "feeds"."id" = "feed_items"."feed_id" WHERE "feed_items"."parent_id" = 0 AND "feeds"."type" = 1 GROUP BY "feed_items"."id", "feed_items"."content" ORDER BY "feed_items"."updated" DESC LIMIT 1000
~ ERROR: column "feed_items.updated" must appear in the GROUP BY clause or be used in an aggregate function
Query: SELECT "feed_items"."id", "feed_items"."content" FROM "feed_items" INNER JOIN "feeds" ON "feeds"."id" = "feed_items"."feed_id" WHERE "feed_items"."parent_id" = 0 AND "feeds"."type" = 1 GROUP BY "feed_items"."id", "feed_items"."content" ORDER BY "feed_items"."updated" DESC LIMIT 1000
PostgresError - ERROR: column "feed_items.updated" must appear in the GROUP BY clause or be used in an aggregate function
Query: SELECT "feed_items"."id", "feed_items"."content" FROM "feed_items" INNER JOIN "feeds" ON "feeds"."id" = "feed_items"."feed_id" WHERE "feed_items"."parent_id" = 0 AND "feeds"."type" = 1 GROUP BY "feed_items"."id", "feed_items"."content" ORDER BY "feed_items"."updated" DESC LIMIT 1000
:
/disk1/home/slugs/12218_830a701_65b5/mnt/vendor/gems/dm-core/lib/dm-core/adapters/data_objects_adapter.rb:89:in `execute_reader'
/disk1/home/slugs/12218_830a701_65b5/mnt/vendor/gems/dm-core/lib/dm-core/adapters/data_objects_adapter.rb:89:in `read'
/disk1/home/slugs/12218_830a701_65b5/mnt/vendor/gems/dm-core/lib/dm-core/adapters/data_objects_adapter.rb:267:in `with_connection'
/disk1/home/slugs/12218_830a701_65b5/mnt/vendor/gems/dm-core/lib/dm-core/adapters/data_objects_adapter.rb:85:in `read'
/disk1/home/slugs/12218_830a701_65b5/mnt/vendor/gems/dm-core/lib/dm-core/repository.rb:146:in `read'
/disk1/home/slugs/12218_830a701_65b5/mnt/vendor/gems/dm-core/lib/dm-core/collection.rb:991:in `lazy_load'
/disk1/home/slugs/12218_830a701_65b5/mnt/vendor/gems/extlib/lib/extlib/lazy_array.rb:451:in `map'
/disk1/home/slugs/12218_830a701_65b5/mnt/vendor/gems/dm-core/lib/dm-core/collection.rb:633:in `replace'
/disk1/home/slugs/12218_830a701_65b5/mnt/vendor/gems/dm-core/lib/dm-core/collection.rb:89:in `reload'
/disk1/home/slugs/12218_830a701_65b5/mnt/vendor/gems/dm-core/lib/dm-core/resource.rb:723:in `reload_attributes'
/disk1/home/slugs/12218_830a701_65b5/mnt/vendor/gems/dm-core/lib/dm-core/resource.rb:709:in `lazy_load'
/disk1/home/slugs/12218_830a701_65b5/mnt/vendor/gems/dm-core/lib/dm-core/property.rb:660:in `send'
/disk1/home/slugs/12218_830a701_65b5/mnt/vendor/gems/dm-core/lib/dm-core/property.rb:660:in `lazy_load'
/disk1/home/slugs/12218_830a701_65b5/mnt/vendor/gems/dm-core/lib/dm-core/property.rb:539:in `get'
/disk1/home/slugs/12218_830a701_65b5/mnt/vendor/gems/dm-core/lib/dm-core/model/property.rb:206:in `content'
/disk1/home/slugs/12218_830a701_65b5/mnt/views/seo_feed.erb:5:in `render_erb'
/disk1/home/slugs/12218_830a701_65b5/mnt/vendor/gems/extlib/lib/extlib/lazy_array.rb:452:in `each'
/disk1/home/slugs/12218_830a701_65b5/mnt/vendor/gems/extlib/lib/extlib/lazy_array.rb:452:in `each'
/disk1/home/slugs/12218_830a701_65b5/mnt/views/seo_feed.erb:2:in `render_erb'
aggregate.rb:138:in `GET /:page/'
/home/slugs/12218_830a701_65b5/mnt/.gems/gems/nakajima-rack-flash-0.1.0/lib/rack/flash.rb:154:in `call'
/home/heroku_rack/lib/minilint.rb:23:in `call'
/home/heroku_rack/lib/static_assets.rb:9:in `call'
/home/heroku_rack/lib/last_access.rb:18:in `call'
/usr/local/bin/thin:20:in `load'
/usr/local/bin/thin:2080.216.162.106, 127.0.0.1 - - [25/Aug/2009 01:36:56] "GET /work/ HTTP/1.0" 500 30 0.0729
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment