Message error : user warning : You have an error in your SQL syntax
| Project: | Referenced By Views Filter |
| Version: | 5.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | bneel |
| Status: | postponed (maintainer needs more info) |
Jump to:
Hi,
I tried to make a view with this module. I used the "Node Reference: Views on node reference" as argument. But I have this message 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 ')) FROM node node' at line 1 query: SELECT count(DISTINCT()) FROM node node in /home.10.8/lefermen/www/includes/database.mysql.inc on line 172.
* 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 'LIMIT 0, 25' at line 1 query: SELECT count( DISTINCT(node.nid)) AS num_nodes FROM node node GROUP BY LIMIT 0, 25 in /home.10.8/lefermen/www/includes/database.mysql.inc on line 172.
Do you have any idea ?
Thanks
#1
What is your view type? Can you give some more info?
#2
This is a page view (table) and I have this warning when I add "Node Reference: Views on node reference" as argument
In fact, I try to do this : http://drupal.org/node/307479