I have some strange problems over here. I have a View with a Page and a Block in it. Everything is fine! As soon as i add an RSS-Feed via Arguments i am getting nasty SQL-Errors ( the SQL ist totally wrong!)

The Block comes up with this 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 ' node_created_created ORDER BY node_created_created DESC LIMIT 0, 1' at line 1 query: SELECT count(node.nid) AS num_nodes, node.created AS node_created_created FROM node node WHERE (node.type IN ('kblog')) GROUP BY , node_created_created ORDER BY node_created_created DESC LIMIT 0, 1 in /server/projekte/kaffee/includes/database.mysql.inc on line 172.

The Page with this one:

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 ' node_created_created ORDER BY node_created_created DESC LIMIT 0, 10' at line 1 query: SELECT count(node.nid) AS num_nodes, node.created AS node_created_created FROM node node WHERE (node.type IN ('kblog')) GROUP BY , node_created_created ORDER BY node_created_created DESC LIMIT 0, 10 in /server/projekte/kaffee/includes/database.mysql.inc on line 172.

Actually the same error. There is a ',' right after the GROUP BY ...

I could really need some help with this issue ;)
Btw. when i remove the RSS-Feed, everything works again.

Comments

dman’s picture

dman commented
Status: Active » Closed (won't fix)

Clean-up Views issue queue as per #572248: Mark "won't fix" any open issue that does not conform to the submission guidelines
Incredibly old issue. Unlikely to still be current.
If anyone can replicate, try supplying an export of the view, but assuming can't fix.