{"issue":{"state":"open","created_at":"2011-12-01T16:51:26Z","updated_at":"2011-12-02T01:04:17Z","comments":2,"user":{"gravatar_id":"22c95921dd234e5f55aa48467d9a16e3","id":41059,"url":"https://api.github.com/users/kpitn","avatar_url":"https://secure.gravatar.com/avatar/22c95921dd234e5f55aa48467d9a16e3?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","login":"kpitn"},"body":"File :  /core/lib/spree/product_filters.rb\r\nLine 111 :   conds  = Hash[*brands.map {|b| [b, \"product_properties.value = '#{b}'\"]}.flatten]\r\n\r\nError : \r\nMysql2::Error: Unknown column 'product_properties.value' in 'where clause': SELECT  DISTINCT `spree_products`.id FROM `spree_products` INNER JOIN `spree_products_taxons` ON `spree_products_taxons`.`product_id` = `spree_products`.`id` INNER JOIN `spree_taxons` ON `spree_taxons`.`id` = `spree_products_taxons`.`taxon_id` INNER JOIN `spree_product_properties` ON `spree_product_properties`.`product_id` = `spree_products`.`id` INNER JOIN `spree_properties` ON `spree_properties`.`id` = `spree_product_properties`.`property_id` LEFT OUTER JOIN `spree_assets` ON `spree_assets`.`viewable_id` = `spree_products`.`id` AND `spree_assets`.`type` IN ('Spree::Image') AND `spree_assets`.`viewable_type` = 'Spree::Product' LEFT OUTER JOIN `spree_variants` ON `spree_variants`.`product_id` = `spree_products`.`id` AND `spree_variants`.is_master = 1 AND `spree_variants`.deleted_at IS NULL WHERE `spree_products`.`deleted_at` IS NULL AND `spree_taxons`.`id` IN (31989848) AND `spree_properties`.`name` = 'brand' AND (available_on <= '2011-12-01 16:50:26') AND ((product_properties.value = 'Wannabe Sports')) LIMIT 12 OFFSET 0\r\n\r\nSolution : add correct table \"spree_product_properties\"\r\n","assignee":null,"id":2416769,"labels":[],"pull_request":{"patch_url":null,"html_url":null,"diff_url":null},"number":829,"title":"old table name in edge","html_url":"https://github.com/spree/spree/issues/829","closed_at":null,"url":"https://api.github.com/repos/spree/spree/issues/829","milestone":null},"action":"created","comment":{"created_at":"2011-12-02T01:04:17Z","updated_at":"2011-12-02T01:04:17Z","user":{"gravatar_id":"9a2a53db8e9b4476038c94a64b32833f","id":2687,"url":"https://api.github.com/users/radar","avatar_url":"https://secure.gravatar.com/avatar/9a2a53db8e9b4476038c94a64b32833f?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","login":"radar"},"body":"Oh, it's line 101, not 111.\r\n","id":2984803,"url":"https://api.github.com/repos/spree/spree/issues/comments/2984803"}}