Got the following SQL errors on a Drupal 5.7 site when attempting to use views_calc with http://drupal.org/project/nodereview
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 'Invested, Saved, Gained_percent_count_value FROM lfcnode node LEFT JOIN lfcvoti' at line 1 query: SELECT DISTINCT(node.nid), node.created AS node_created_created, node.title AS node_title, node.changed AS node_changed, node.created AS node_created, votingapi_cache_Money Invested, Saved, Gained_percent_count.value AS votingapi_cache_Money Invested, Saved, Gained_percent_count_value FROM lfcnode node LEFT JOIN lfcvotingapi_cache votingapi_cache_Money Invested, Saved, Gained_percent_count ON node.nid = votingapi_cache_Money Invested, Saved, Gained_percent_count.content_id AND votingapi_cache_Money Invested, Saved, Gained_percent_count.content_type = 'node' AND votingapi_cache_Money Invested, Saved, Gained_percent_count.value_type = 'percent' AND votingapi_cache_Money Invested, Saved, Gained_percent_count.tag = 'Money Invested, Saved, Gained' AND votingapi_cache_Money Invested, Saved, Gained_percent_count.function = 'count' WHERE (node.type IN ('nodereview')) ORDER BY node_created_created DESC LIMIT 0, 10 in /home/admin/public_html/olfscdev/includes/database.mysql.inc on line 172.
No actual views page was displayed, due to this error.
Comments
Comment #1
karens commentedComment #2
karens commentedThe D5 version is no longer supported.