Hello,
I am having an issue with the new views. I am getting this error on the page where my view should be showing. What am I doing wrong? Is it something with the mysql setup?
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 'i ('event'))) LIMIT 0, 10' at line 3 query: SELECT node.nid AS nid FROM node node WHERE ((node.type i ('event'))) LIMIT 0, 10 in /Applications/MAMP/htdocs/drupal1/modules/views/includes/view.inc on line 428.
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 'i ('event')))' at line 3 query: SELECT COUNT(node.nid) AS nid FROM node node WHERE ((node.type i ('event'))) in /Applications/MAMP/htdocs/drupal1/modules/views/includes/view.inc on line 433.
Comments
You might not be doing
You might not be doing anything wrong. Views 2 is an alpha release, which means it's still in heavy development.
You'll be much better off to post this to the views 2 issue queue where the developer can respond.
http://drupal.org/project/issues/views?categories=bug
http://www.trailheadinteractive.com
Thanks I will
Rob Lavigne - www.bullportfolio.com