After finally figuring out how to sort criteria on the front page with this module it won't allow me to finish. I'm using FiveStar and Voting API to do this. While Editing Audio In views I attempted to sort Music by Voting API percent vote result (average). When I submitted the request I received this 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 ' votingapi_cache_vote_percent_average.value AS votingapi_cache_vote_percent_aver' at line 1 query: SELECT node.nid, node.created AS node_created_created, , votingapi_cache_vote_percent_average.value AS votingapi_cache_vote_percent_average_value, node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN votingapi_cache votingapi_cache_vote_percent_average ON node.nid = votingapi_cache_vote_percent_average.content_id AND votingapi_cache_vote_percent_average.content_type = 'node' AND votingapi_cache_vote_percent_average.value_type = 'percent' AND votingapi_cache_vote_percent_average.tag = 'vote' AND votingapi_cache_vote_percent_average.function = 'average' WHERE (node.type IN ('audio')) AND (node.status = '1') ORDER BY node_created_created DESC, , , , , , , votingapi_cache_vote_percent_average_value ASC LIMIT 0, 3 in
Can anyone help me I'm stumped on how to fix this...
Comments
does anyone know how to fix
does anyone know how to fix this?