SQL Errors on clicking feed icon

Fresh installation of 4.7.2 and subscriptions module (tried both cvs and reg).

One thing you have to do is to enable 'my subscription' menu in the nav block and use that and not the one that's under my account/subscription.

Tried with/without clean url. Same error. But if I click on the tab again, it goes away. but each time I click on the feed icon and then on one of the subscription tabs, I get this error. Clicking the same tab again and the error goes away.

Digging some more, this is definitely a bug in mysql 4.x but not 5.x.

The patch is

$sql = "SELECT n.nid, max( n.created ) AS nc FROM {node} n LEFT JOIN {term_node} tn ON n.nid=tn.nid";
if ($cond) {
$sql.= " WHERE ". implode(' OR ', $cond);
}
$sql .= " GROUP BY n.nid ORDER BY nc DESC";
$result = db_query_range(db_rewrite_sql($sql), 0, variable_get('feed_default_items', 10));
$channel['title'] = t("%name Subscriptions", array('%name' => $account->name));
$channel['link'] = url("subscriptions/feed", NULL, NULL, TRUE);
// $channel['description'] = ;
node_feed($result, $channel);

at the end of subscription.module. Note alias for the order by clause. Mysql 4.x cannot parse that without an error. Mysql 5.0 is fine with it.

Thanks