Closed (won't fix)
Project:
Views Calc
Version:
5.x-1.x-dev
Component:
Code
Priority:
Critical
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
19 May 2008 at 15:37 UTC
Updated:
24 Apr 2012 at 12:26 UTC
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.