Closed (fixed)
Project:
MySite
Version:
5.x-1.10
Component:
- Type plugin
Priority:
Normal
Category:
Bug report
Assigned:
Reporter:
Created:
7 Mar 2007 at 20:47 UTC
Updated:
5 Apr 2007 at 18:33 UTC
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
Comment #1
agentrickardFixes in 4.7.x.3-dev and 5.x.1-dev.
Comment #2
(not verified) commentedComment #3
agentrickardLeft open, because -dev isn't a stable release.
Comment #4
(not verified) commented