This seems like a useful module. In order to get it to work I needed to change line 244 of entityreference_count.module from
$select->condition('n.status', 1);
to
$select->condition('e.status', 1);
Now the queries look ok and the count is made correctly.

CommentFileSizeAuthor
#2 entityreference_count-unknown_column_n.status-2053273-2.patch639 bytestien.xuan.vo

Comments

tien.xuan.vo’s picture

tien.xuan.vo commented
Title: bug in query conditions? » Unknown column 'n.status'

Yeah, I saw this issue too. I think this is a typo.

tien.xuan.vo’s picture

tien.xuan.vo commented
StatusFileSize
new entityreference_count-unknown_column_n.status-2053273-2.patch639 bytes

Here is the patch

klokie’s picture

klokie commented
Status: Active » Needs review

Thanks :) Looks ok to me.

klokie’s picture

klokie commented
Issue summary: View changes
Status: Needs review » Reviewed & tested by the community

Works for me - can we please commit this patch?

damienmckenna’s picture

damienmckenna
Location TN, USA
commented

+1

damienmckenna’s picture

damienmckenna
Location TN, USA
commented
Parent issue: » #1894122: Plan for EntityReference_Count 7.x-1.0 release

WorldFallz’s picture

WorldFallz commented
Status: Reviewed & tested by the community » Fixed

Working my way through the issue queue in preparation for a release. Thanks everyone!

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.