Recent Topics

1 May 22, 2006 07:54    

Hi,

I am using a linkblog, but I want to use it in a slightly different manner.

X...(Y)

X is the title of the page that links to the mentioned page.
Y is the amount of comments to the topic, and when clicked on it will open the comments. (for an example, see http://www.geencommentaar.nl)

I tweaked _linkblog.php here and there and it now works as I want it to. But there is a slight problem. When doing searches on specific words and requesting the complete archives I get an error:

MySQL error!

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY comment_post_ID, comment_type' at line 3(Errno=1064)

Your query:

SELECT comment_post_ID, comment_type, COUNT(*) AS type_count 
              FROM evo_comments 
              WHERE comment_post_ID IN () 
              GROUP BY comment_post_ID, comment_type


I tracked it down to this added line in my _linkblog.php:

$Item->feedback_link('comments','...(',')','0','1','%d');

I have absolutely no clue why this is happening. Maybe I am missing some variables or something?


Form is loading...