I have an excellent view working on my site :) with one small issue which I can't seem to find a workaround for...
I have exposed 2 filters to the user. In the config of each I had to set the 'Optional' check box otherwise I get the error below when the view is compiled. The 'Optional' box checked ensures that when the page loads it also loads all of the results. I want the page to load with no results showing until the user selects from the filters.
Any thoughts?
• warning: Illegal offset type in /hsphere/local/home/brianmurray/sitename/sites/default/modules/views_old/includes/handlers.inc on line 677.
• 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 ') WHERE () AND (node.status <> 0 OR node.uid = 1 or 1 = 1) ORDER BY _random ' at line 4 query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid, RAND() AS _random FROM node node LEFT JOIN term_node term_node_Array ON node.vid = term_node_Array.vid AND term_node_Array.tid IN () WHERE () AND (node.status <> 0 OR node.uid = 1 or 1 = 1) ORDER BY _random ASC ) count_alias in /hsphere/local/home/brianmurray/sitename/sites/default/modules/views_old/includes/view.inc on line 659.
• 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 ') WHERE () AND (node.status <> 0 OR node.uid = 1 or 1 = 1) ORDER BY _random ' at line 4 query: SELECT DISTINCT(node.nid) AS nid, RAND() AS _random FROM node node LEFT JOIN term_node term_node_Array ON node.vid = term_node_Array.vid AND term_node_Array.tid IN () WHERE () AND (node.status <> 0 OR node.uid = 1 or 1 = 1) ORDER BY _random ASC LIMIT 0, 10 in /hsphere/local/home/brianmurray/sitename/sites/default/modules/views_old/includes/view.inc on line 685.
