SQL error in Group By clause

Here's the fix:

In nodehierachy_views.module, look for:
$fieldinfo['field'] = 'hierarchy.parent';
and replace it with
$fieldinfo['field'] = 'nodehierarchy.parent';

There are two instances of it.