Skip to content

Instantly share code, notes, and snippets.

@marjinal1st
Created December 9, 2013 10:48
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 marjinal1st/7870427 to your computer and use it in GitHub Desktop.
Save marjinal1st/7870427 to your computer and use it in GitHub Desktop.
HABTM Error 2
SELECT "kebapress_posts"."id" AS t0_r0, "kebapress_posts"."title" AS t0_r1, "kebapress_posts"."body" AS t0_r2, "kebapress_posts"."published_at" AS t0_r3, "kebapress_posts"."commentable" AS t0_r4, "kebapress_posts"."published" AS t0_r5, "kebapress_posts"."author_id" AS t0_r6, "kebapress_posts"."created_at" AS t0_r7, "kebapress_posts"."updated_at" AS t0_r8, "kebapress_categories"."id" AS t1_r0, "kebapress_categories"."title" AS t1_r1, "kebapress_categories"."created_at" AS t1_r2, "kebapress_categories"."updated_at" AS t1_r3 FROM "kebapress_posts" LEFT OUTER JOIN "kebapress_categories_posts" ON "kebapress_categories_posts"."post_id" = "kebapress_posts"."id" LEFT OUTER JOIN "kebapress_categories" ON "kebapress_categories"."id" = "kebapress_categories_posts"."category_id" WHERE "categories"."id" IS NULL
SQLite3::SQLException: no such column: categories.id: SELECT "kebapress_posts"."id" AS t0_r0, "kebapress_posts"."title" AS t0_r1, "kebapress_posts"."body" AS t0_r2, "kebapress_posts"."published_at" AS t0_r3, "kebapress_posts"."commentable" AS t0_r4, "kebapress_posts"."published" AS t0_r5, "kebapress_posts"."author_id" AS t0_r6, "kebapress_posts"."created_at" AS t0_r7, "kebapress_posts"."updated_at" AS t0_r8, "kebapress_categories"."id" AS t1_r0, "kebapress_categories"."title" AS t1_r1, "kebapress_categories"."created_at" AS t1_r2, "kebapress_categories"."updated_at" AS t1_r3 FROM "kebapress_posts" LEFT OUTER JOIN "kebapress_categories_posts" ON "kebapress_categories_posts"."post_id" = "kebapress_posts"."id" LEFT OUTER JOIN "kebapress_categories" ON "kebapress_categories"."id" = "kebapress_categories_posts"."category_id" WHERE "categories"."id" IS NULL
ActiveRecord::StatementInvalid: SQLite3::SQLException: no such column: categories.id: SELECT "kebapress_posts"."id" AS t0_r0, "kebapress_posts"."title" AS t0_r1, "kebapress_posts"."body" AS t0_r2, "kebapress_posts"."published_at" AS t0_r3, "kebapress_posts"."commentable" AS t0_r4, "kebapress_posts"."published" AS t0_r5, "kebapress_posts"."author_id" AS t0_r6, "kebapress_posts"."created_at" AS t0_r7, "kebapress_posts"."updated_at" AS t0_r8, "kebapress_categories"."id" AS t1_r0, "kebapress_categories"."title" AS t1_r1, "kebapress_categories"."created_at" AS t1_r2, "kebapress_categories"."updated_at" AS t1_r3 FROM "kebapress_posts" LEFT OUTER JOIN "kebapress_categories_posts" ON "kebapress_categories_posts"."post_id" = "kebapress_posts"."id" LEFT OUTER JOIN "kebapress_categories" ON "kebapress_categories"."id" = "kebapress_categories_posts"."category_id" WHERE "categories"."id" IS NULL
from /home/marjinal1st/.rvm/gems/ruby-2.0.0-p247/gems/sqlite3-1.3.8/lib/sqlite3/database.rb:91:in `initialize'
from /home/marjinal1st/.rvm/gems/ruby-2.0.0-p247/gems/sqlite3-1.3.8/lib/sqlite3/database.rb:91:in `new'
from /home/marjinal1st/.rvm/gems/ruby-2.0.0-p247/gems/sqlite3-1.3.8/lib/sqlite3/database.rb:91:in `prepare'
from /home/marjinal1st/.rvm/gems/ruby-2.0.0-p247/gems/activerecord-4.0.0/lib/active_record/connection_adapters/sqlite3_adapter.rb:296:in `block in exec_query'
from /home/marjinal1st/.rvm/gems/ruby-2.0.0-p247/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract_adapter.rb:425:in `block in log'
from /home/marjinal1st/.rvm/gems/ruby-2.0.0-p247/gems/activesupport-4.0.0/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
from /home/marjinal1st/.rvm/gems/ruby-2.0.0-p247/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract_adapter.rb:420:in `log'
from /home/marjinal1st/.rvm/gems/ruby-2.0.0-p247/gems/activerecord-4.0.0/lib/active_record/connection_adapters/sqlite3_adapter.rb:292:in `exec_query'
from /home/marjinal1st/.rvm/gems/ruby-2.0.0-p247/gems/activerecord-4.0.0/lib/active_record/connection_adapters/sqlite3_adapter.rb:504:in `select'
from /home/marjinal1st/.rvm/gems/ruby-2.0.0-p247/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract/database_statements.rb:24:in `select_all'
from /home/marjinal1st/.rvm/gems/ruby-2.0.0-p247/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract/query_cache.rb:63:in `select_all'
from /home/marjinal1st/.rvm/gems/ruby-2.0.0-p247/gems/activerecord-4.0.0/lib/active_record/relation/finder_methods.rb:206:in `find_with_associations'
from /home/marjinal1st/.rvm/gems/ruby-2.0.0-p247/gems/activerecord-4.0.0/lib/active_record/relation.rb:585:in `exec_queries'
from /home/marjinal1st/.rvm/gems/ruby-2.0.0-p247/gems/activerecord-4.0.0/lib/active_record/relation.rb:471:in `load'
from /home/marjinal1st/.rvm/gems/ruby-2.0.0-p247/gems/activerecord-4.0.0/lib/active_record/relation.rb:220:in `to_a'
from /home/marjinal1st/.rvm/gems/ruby-2.0.0-p247/gems/activerecord-4.0.0/lib/active_record/relation.rb:573:in `inspect'
from /home/marjinal1st/.rvm/gems/ruby-2.0.0-p247/gems/railties-4.0.0/lib/rails/commands/console.rb:90:in `start'
from /home/marjinal1st/.rvm/gems/ruby-2.0.0-p247/gems/railties-4.0.0/lib/rails/commands/console.rb:9:in `start'
from /home/marjinal1st/.rvm/gems/ruby-2.0.0-p247/gems/railties-4.0.0/lib/rails/commands.rb:64:in `<top (required)>'
from bin/rails:4:in `require'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment