bug with sort in nodes
| Project: | NodeReview |
| Version: | 5.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | dawood |
| Status: | active |
Jump to:
There is a major bug that gives and error code on any nodereview sort criteria.
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 '.value AS votingapi_vote_Overall Rating_percent_value FROM node node LEFT JOIN ' at line 1 query: views_build_view SELECT node.nid, votingapi_vote_Overall Rating_percent.value AS votingapi_vote_Overall Rating_percent_value FROM node node LEFT JOIN votingapi_vote votingapi_vote_Overall Rating_percent ON node.nid = votingapi_vote_Overall Rating_percent.content_id AND votingapi_vote_Overall Rating_percent.content_type = 'node' AND votingapi_vote_Overall Rating_percent.value_type = 'percent' AND votingapi_vote_Overall Rating_percent.tag = 'Overall Rating' WHERE (node.type IN ('nodereview')) AND (node.type IN ('blog')) ORDER BY votingapi_vote_Overall Rating_percent_value ASC LIMIT 0, 5 in /home/dawood/public_html/includes/database.mysql.inc on line 172.

#1
Any updates on this? I had the same issue.
Thanks,