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

criznach’s picture

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

rlavigne99’s picture

Rob Lavigne - www.bullportfolio.com