The change to make code pgsql compliant introduced a UI bug in the blog.inc file.

  $sql = "SELECT DISTINCT(u.uid), u.name, n.nid FROM {users} u INNER JOIN {node} n ON u.uid = n.uid WHERE n.status = 1 AND n.type = 'blog' ORDER BY n.nid DESC";

Does not return _only_ distinct UIDs, as expected. For pgsql, it is necessary to add n.nid to the SELECT since that is also an ORDER BY field.

The solution is probably to sort by UID, not NID.

  $sql = "SELECT DISTINCT(u.uid), u.name FROM {users} u INNER JOIN {node} n ON u.uid = n.uid WHERE n.status = 1 AND n.type = 'blog'";

Change affects line 45 of blog.inc if you need to patch your installation. I will commit changes later.

Comments

agentrickard’s picture

Status: Active » Fixed

Fixes in 4.7.x.3-dev and 5.x.1-dev.

Anonymous’s picture

Status: Fixed » Closed (fixed)
agentrickard’s picture

Status: Closed (fixed) » Fixed

Left open, because -dev isn't a stable release.

Anonymous’s picture

Status: Fixed » Closed (fixed)