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 '> '0') ORDER BY DESC, DESC LIMIT 0, 4' at line 1 query: SELECT DISTINCT(node.nid), value, users.name AS users_name, users.uid AS users_uid, profile_nascita.value AS profile_nascita_value, profile_sesso.value AS profile_sesso_value, profile_fida.value AS profile_fida_value, profile_comune.value AS profile_comune_value, votingapi_cache_vote_percent_average.value AS votingapi_cache_vote_percent_average_value FROM drupal5_node node INNER JOIN drupal5_users users ON node.uid = users.uid LEFT JOIN drupal5_profile_values profile_nascita ON users.uid = profile_nascita.uid AND profile_nascita.fid = '1' LEFT JOIN drupal5_profile_values profile_sesso ON users.uid = profile_sesso.uid AND profile_sesso.fid = '2' LEFT JOIN drupal5_profile_values profile_fida ON users.uid = profile_fida.uid AND profile_fida.fid = '11' LEFT JOIN drupal5_profile_values profile_comune ON users.uid = profile_comune.uid AND profile_comune.fid = '7' WHERE (node.type IN ('usernode')) AND (.value > '0') ORDER BY DESC, DESC LIMIT 0, 4 in /........../includes/database.mysql.inc on line 172.

that's an error of a view which should show the most voted usernodes. if i unload views bulk operations the view works.
all the views with fivestar field don't work at all with views bulk operations loaded

Comments

VVN’s picture

Title: Views with fivestar field don't work when this module is loaded » Views with votingapi field don't work when this module is loaded

edit: ALL the votingapi fields disappeared! i simply can't select them in the edit view page. i cleared cache.

VVN’s picture

Status: Active » Closed (fixed)

Solved. Sorry, the problem was this: #189311: votingapi_views.inc included in wrong place