Serendipity Forums

Posted: **Sun Mar 28, 2010 11:56 pm**

The following query is sometimes issues by the freetag plugin:

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.

Posted: **Mon Mar 29, 2010 9:51 am**

Hi!

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

Regards,
Garvin

freetag plugin issues query without parameters - SQL error