I observe that the default monthly archive for Views Bonus Pack does not filter for published nodes, so that in the default setting, if I enable the archive, users see both drafts and published material. I don't want users to have access to drafts, however.

I figured the fix for this would be easy: simply edit the view and add "node:published" to filters. But as soon as I click the "add filter" button to do this, I receive the following error:

user warning: 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 DATE_FORMAT(FROM_UNIXTIME(node.created+21600), '%Y%m'), name ORDER ' at line 1 query: SELECT node.created, DATE_FORMAT(FROM_UNIXTIME(node.created+21600), '%Y%m') AS name, count(node.nid) AS num_nodes FROM node node WHERE (. '') GROUP BY DATE_FORMAT(FROM_UNIXTIME(node.created+21600), '%Y%m'), name ORDER BY name DESC LIMIT 0, 5 in /home/femrich/public_html/includes/database.mysql.inc on line 172.

My host uses MySQL 4.1.22-standard. I'm a complete MySQL novice. Could you tell me please how to fix this?

Thanks.

Comments

pomliane’s picture

pomliane commented
Status: Active » Closed (won't fix)

This version of Views Bonus Pack is not supported anymore. The issue is closed for this reason.
Please upgrade to a supported version and feel free to reopen the issue on the new version if applicable.

This issue has been automagically closed by a script.