Closed (fixed)
Project:
Views Bulk Operations (VBO)
Version:
5.x-1.0-beta5
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
7 Mar 2008 at 16:25 UTC
Updated:
8 Mar 2008 at 22:18 UTC
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
Comment #1
VVN commentededit: ALL the votingapi fields disappeared! i simply can't select them in the edit view page. i cleared cache.
Comment #2
VVN commentedSolved. Sorry, the problem was this: #189311: votingapi_views.inc included in wrong place