When I browse to /feeds, I receive the following SQL error and the empty text for the view, even though I have 2 populated feeds. Overriding the default view and removing the "SimpleFeed Feed Item: Parent Feed Node ID" argument clears up the SQL error. Of course, this means that feed items are not restricted to the parent feed's nid.

SQL 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 'DISTINCT(node.nid) AS fpnid, count(node.nid) AS num_nodes, feed_parent_node.titl' at line 1 query: pager_query SELECT simplefeed_feed_item.fid, feed_parent_node.title, feed_parent_ DISTINCT(node.nid) AS fpnid, count(node.nid) AS num_nodes, feed_parent_node.title AS feed_parent_node_title FROM node node LEFT JOIN simplefeed_feed_item simplefeed_feed_item ON node.vid = simplefeed_feed_item.vid LEFT JOIN node feed_parent_node ON simplefeed_feed_item.fid = feed_parent_node.nid WHERE (node.status = '1') AND (node.type IN ('feed_item')) AND (feed_parent_node.nid IS NOT NULL) GROUP BY feed_parent_node.title, feed_parent_node_title ORDER BY feed_parent_node_title ASC LIMIT 0, 10 in .../includes/database.mysql.inc on line 172.

Comments

ezra-g’s picture

ezra-g commented

It seems that I only receive this error when an argument is not specified for this view. When I specify an argument, it works fine.

lennart’s picture

lennart commented

Yes. It is only when there is no argument, but I still think it is a bug that it throws such an error.

At least my other views with arguements in the URL do not throw errors when the argument is missing.

lennart’s picture

lennart commented

Also consider that the direct link to /feeds without the argument is available in the breadcrumb when visiting one of the feeds - so many users will see this error.

ezra-g’s picture

ezra-g commented

I'm not disputing myself and saying that this is not a bug. I was merely adding information to my original bug report.

lennart’s picture

lennart commented

We agree then :)

shane birley’s picture

shane birley commented

Just for the record that this is happening. Thought another error message may help, or not...

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 'DISTINCT(node.nid) AS fpnid, count(node.nid) AS num_nodes, feed_parent_node.titl' at line 1 query: SELECT simplefeed_feed_item.fid, feed_parent_node.title, feed_parent_ DISTINCT(node.nid) AS fpnid, count(node.nid) AS num_nodes, feed_parent_node.title AS feed_parent_node_title FROM node node LEFT JOIN simplefeed_feed_item simplefeed_feed_item ON node.vid = simplefeed_feed_item.vid LEFT JOIN node feed_parent_node ON simplefeed_feed_item.fid = feed_parent_node.nid WHERE (node.status = '1') AND (node.type IN ('feed_item')) AND (feed_parent_node.nid IS NOT NULL) GROUP BY feed_parent_node.title, feed_parent_node_title ORDER BY feed_parent_node_title ASC LIMIT 0, 10 in .../includes/database.mysql.inc on line 172.

m3avrck’s picture

m3avrck commented
Status: Active » Closed (fixed)

With clean checkouts of SimpleFeed dev-Oct3 and Views-Drupal5-Oct3 -- this is not reproducable.