Error when loading users page

[mattbucci]

Warning: pg_query(): Query failed: ERROR: syntax error at or near "GROUP" LINE 2: INNER GROUP BY false)) AS count0, false)) AS count1 ^ in wp-content/plugins/pg4wp/driver_pgsql.php on line 213

Original query:

SELECT COUNT(NULLIF(`meta_value` LIKE '%"administrator"%', false)), COUNT(NULLIF(`meta_value` = 'a:0:{}', false)), COUNT(*) FROM wp_usermeta INNER JOIN wp_users ON user_id = ID WHERE meta_key = 'wp_capabilities'  

Transformed query:

SELECT COUNT(NULLIF(meta_value ILIKE '%"administrator"%', false)) AS count0, COUNT(NULLIF(meta_value = 'a:0:{}', false)) AS count1, COUNT(*) FROM wp_usermeta INNER GROUP BY false)) AS count0, false)) AS count1

[mattbucci]

this is a bug in ensureGroupByOrAggregate,

commenting that rewrite rule results in

SELECT COUNT(NULLIF(meta_value ILIKE '%"administrator"%', false)) AS count0, COUNT(NULLIF(meta_value = 'a:0:{}', false)) AS count1, COUNT(*) FROM wp_usermeta INNER JOIN wp_users ON user_id = "ID" WHERE meta_key = 'wp_capabilities'