Missing GROUP BY clause or aggregate function

Found a bug? Tell us!!
ads
Regular
Posts: 93
Joined: Sun Oct 29, 2006 11:39 am

Re: Missing GROUP BY clause or aggregate function

Post by ads »

Ok, let's start the other way around:
garvinhicking wrote:The list of possible entries is restricted by only allowing those that have exactly 3 tags assigned (matching the list of possible tags)
What exactly is needed (which tables are involved) to fulfill this one requirement?
ads
Regular
Posts: 93
Joined: Sun Oct 29, 2006 11:39 am

Re: Missing GROUP BY clause or aggregate function

Post by ads »

Garvin: Can you answer this question? Then i try to build a specific query.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Missing GROUP BY clause or aggregate function

Post by garvinhicking »

Hi!

Hm, this query thing is very complex, since I haven't written this part of the freetag plugin. It somehows compiles the list of related entries...

I have this post on my todolist, when I have a couple of hourse to inspect this query a bit better, I will come back here - I'm sorry!

Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
ads
Regular
Posts: 93
Joined: Sun Oct 29, 2006 11:39 am

Re: Missing GROUP BY clause or aggregate function

Post by ads »

Ok. I will delay this bug until then.
Post Reply