freetag plugin issues query without parameters - SQL error

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

freetag plugin issues query without parameters - SQL error

Post by ads »

The following query is sometimes issues by the freetag plugin:

Code: Select all

SELECT neg.tag AS tag, count(neg.tag)  AS total
  FROM serendipity_entrytags AS main
 WHERE ()
     AND ()
  GROUP BY neg.tag
Resulting in a SQL error:
2010-03-28 23:32:23 CEST ERROR: syntax error at or near ")" at character 146
There should be no WHERE and AND, if the () are empty.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: freetag plugin issues query without parameters - SQL error

Post by garvinhicking »

Hi!

Thanks a lot, I've fixed the plugin to check for this condition.

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/
Post Reply