The Serendipity Handbook

You can now read the (german) handbook here: PDF - https://github.com/s9y/Book (LaTeX source).

Forum-Information

Before posting about errors, make sure that the answer cannot already be found in our FAQ or by searching this forum!
Posting is restricted to registered users (registering is free and simple!) due to recent spam attacks. When having trouble with this board, contact garvin(-at)s9y(-dot)org.

Board index Bugs freetag plugin issues query without parameters - SQL error

Found a bug? Tell us!!
ads
Regular
 
Posts: 84
Joined: Sun Oct 29, 2006 12:39 pm

Postby ads » Sun Mar 28, 2010 11:56 pm

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.

User avatar
garvinhicking
Core Developer
 
Posts: 28953
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany

Postby garvinhicking » Mon Mar 29, 2010 9:51 am

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/



Return to Bugs

Who is online

Users browsing this forum: No registered users and 0 guests