userpoints is not displaying id, name, and points

Is this the 'users by points' menu entry you're referring to?

If so, I had the same issue in the 2006/08/28 4.7.0 release. The following error when trying to go to /userpoints:

You have an error in your SQL syntax near 'WHERE u.uid = p.uid GROUP BY p.uid ORDER BY p.points DESC LIMIT 0, 30' at line 1 query: SELECT p.uid, u.name, p.points FROM userpoints p INNER JOIN users u WHERE u.uid = p.uid GROUP BY p.uid ORDER BY p.points DESC LIMIT 0, 30 in /includes/database.mysql.inc on line 120.

To resolve I just had to change the sql statement to:

SELECT p.uid, u.name, p.points FROM userpoints p INNER JOIN users u ON u.uid = p.uid GROUP BY p.uid ORDER BY p.points DESC LIMIT 0, 30

Cheers,

Jon

Fixed in 4.7 and HEAD.