Hi Mark,
Are you using the latest revision of CE from the Rails3 branch? I ran into
this error a couple weeks ago, it's coming from
acts_as_taggable_on_steroids (and a bug/quirk in the way Rails constructs
queries after invoking the 'count' method, see my comment on this
issue<https://github.com/rails/rails/issues/2541#issuecomment-2430984>).
I thought I had it fixed (in fact, I even forked aatos to fix it:
https://github.com/bborn/acts_as_taggable_on_steroids/tree/).
More details on your setup (Rails version, Ruby version, and CE version/git
commit) would help.
Thanks,
Bruno
On Sat, Oct 29, 2011 at 7:02 PM, mark mcdonald <mark.mcdon...@gmail.com>wrote:
> I just got the beta running on heroku...well sort of. But I am
> getting errors on the bottom of the page when it tries to access the
> most recent tags/ comments. Almost there!
>
> heroku logs prints:
>
>
> 2011-10-29T23:56:23+00:00 app[web.1]: ActionView::Template::Error
> (PGError: ERROR: column "count" does not exist
> 2011-10-29T23:56:23+00:00 app[web.1]: LINE 1: ... = "tags"."id" GROUP
> BY tags.id, tags.name HAVING count >= 0...
> 2011-10-29T23:56:23+00:00 app[web.
> 1]: ^
> 2011-10-29T23:56:23+00:00 app[web.1]: : SELECT "tags".id,
> "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN
> "taggings" ON "taggings"."tag_id" = "tags"."id" GROUP BY tags.id,
> tags.name HAVING count >= 0 ORDER BY count DESC LIMIT 30):
> 2011-10-29T23:56:23+00:00 app[web.1]: 8: .yui-u
> 2011-10-29T23:56:23+00:00 app[web.1]: 9: -box do
> 2011-10-29T23:56:23+00:00 app[web.1]: 10: %h3=:tags.l
> 2011-10-29T23:56:23+00:00 app[web.1]: 11: - tag_cloud
> @popular_tags, %w(nube1 nube2 nube3 nube4 nube5) do |tag, css_class|
> 2011-10-29T23:56:23+00:00 app[web.1]: 12: = link_to
> tag.name, tag_path(URI.escape(tag.name, /[\/.?#]/)), :class =>
> css_class
> 2011-10-29T23:56:23+00:00 app[web.1]: 13:
> %h6.all=link_to :all_tags.l, tags_path
> 2011-10-29T23:56:23+00:00 app[web.1]:
> 2011-10-29T23:56:23+00:00 app[web.1]:
>
> --
> You received this message because you are subscribed to the Google Groups
> "CommunityEngine" group.
> To post to this group, send email to communityengine@googlegroups.com.
> To unsubscribe from this group, send email to
> communityengine+unsubscr...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/communityengine?hl=en.
>
>
--
You received this message because you are subscribed to the Google Groups
"CommunityEngine" group.
To post to this group, send email to communityengine@googlegroups.com.
To unsubscribe from this group, send email to
communityengine+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/communityengine?hl=en.
