Re: Refinery Blog : missing FROM-clause entry for table "categories"

[pascal huynh]

Hi,

I have the same problem also. Anyone with a solution for this issue ?

Regards,

Pascal

On Tuesday, September 18, 2012 8:56:34 AM UTC+7, Jonathon Batson wrote:

I am experimenting with blog engine and get this on a new refinery app with the blog engine installed.
Occurs when clicking on "Uncategorized Posts" of the Posts menu under Blog tab. 
All other functionality of the blog seems to work fine. 
Using :
refinerycms (2.0.8)
refinerycms-blog (2.0.4)

ActiveRecord::StatementInvalid in Refinery/blog/admin/posts#uncategorized

PG::Error: ERROR:  missing FROM-clause entry for table "categories"
LINE 1: ...g_categories_blog_posts"."blog_category_id" WHERE "categorie...
                                                             ^
: SELECT COUNT(DISTINCT "refinery_blog_posts"."id") FROM "refinery_blog_posts" LEFT OUTER JOIN "refinery_blog_categories_blog_posts" ON "refinery_blog_categories_blog_posts"."blog_post_id" = "refinery_blog_posts"."id" LEFT OUTER JOIN "refinery_blog_categories" ON "refinery_blog_categories"."id" = "refinery_blog_categories_blog_posts"."blog_category_id" WHERE "categories"."refinery_blog_categories_blog_posts" = '---
:blog_category_id: 
' AND (published_at < '2012-09-18 01:46:16.271281' and draft = 'f')

Extracted source (around line #13):

10:       <p><%= t('no_results', :scope => 'refinery.admin.search') %></p>
11:     <% end %>
12:   <% else %>
13:     <% if @posts.any? %>
14:       <%= will_paginate @posts %>
15: 
16:       <%= render :partial => "sortable_list" %>