When I updated to version 1.2, I started getting this message in Watchdog every time someone tried to use the views bookmark function:

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 ''') AND (node_comment_statistics.last_comment_timestamp 0 + 0)' at line 1 query: SELECT count(node.nid) FROM node node LEFT JOIN views_bookmark_nodes views_bookmark_nodes_1 ON node.nid = views_bookmark_nodes_1.nid AND views_bookmark_nodes_1.vbid = '1' AND views_bookmark_nodes_1.uid = '1' LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid INNER JOIN users users ON node.uid = users.uid LEFT JOIN views_bookmark_nodetypes views_bookmark_nodetypes_1 ON node.type = views_bookmark_nodetypes_1.type AND views_bookmark_nodetypes_1.vbid = '1' WHERE (node.status = '1') AND (views_bookmark_nodes_1.uid IS NOT NULL) AND (node_comment_statistics.comment_count '') AND (node_comment_statistics.last_comment_timestamp 0 + 0) in /home/ubersoft/public_html/includes/database.mysql.inc on line 172.

Anyone know why this is occurring? They are cck nodes... could that have something to do with it?

Comments

Xabi’s picture

Xabi commented

Same bug here also with CCK nodes.

criz’s picture

criz
he/him
Location Vienna/Austria
commented

same here. but deleting the comment filters in the view (or adding values) solved the issue...

ubersoft’s picture

ubersoft commented

The view for the bookmark?

criz’s picture

criz
he/him
Location Vienna/Austria
commented

yes

quicksketch’s picture

quicksketch
he/him
commented
Status: Active » Fixed

Thanks guys! I fixed this in the latest CVS commit. It was a few problems in the default_views hook, so overriding the view could fix the problem, but otherwise it would make incorrect SQL queries.

drupalina’s picture

drupalina commented

Sorry, where do I get the version of this module that works? I notice that the latest official release is for July 15 and the latest dev version is on July 16. But these comments came after that date.

thanks

ubersoft’s picture

ubersoft commented

It was fixed in CVS Commit, which means it may not have been released yet.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)
Nijip’s picture

Nijip commented

Has this error been resolved? (I really want to use this module! happy happy please please.)

physiotek’s picture

physiotek commented

can you please explain what i have to do to resolve the pb?

deleting the comment filters in the view (or adding values) solved the issue...

i cant's see where i can acheive this..

thanks

physiotek’s picture

physiotek commented

ok i found it:
i edited the bookmarks view and changed the comment settings for:
greater or equal:0
thanks