Attempting to edit a pool results in "Pool not found."

[rscullin]

Attempting to edit a pool in the latest git commit ( 81b3ce1 ) results in the error "Pool not found."

This seems to be because of a missing GROUP BY clause in the SQL query starting on line 96 in pool.inc.php, which throws a MySQL error. Adding GROUP BY wp.worker_id after the WHERE clause appears to fix this.

[wyze]

I'm wondering if this is still an issue as Ii am not able to duplicate it and can edit pools fine on my end?

[cdhowie]

@wyze, this issue is specific to some versions of MySQL and not others. Newer versions seem to infer the GROUP BY clause, while older versions require it explicitly.

[edgeman16]

Doesn't seem to happen to me on MySQL 5.1.56. FYI.

[wyze]

Why not just add this in there then? It won't hurt newer versions of MySQL and will fix older versions. Wouldn't take a performance hit and a very small and simple change to the code.

[rscullin]

The version of MySQL that's giving me issues is:
mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2

[cdhowie]

I have pushed 83d0672, which might resolve this issue. Can those of you who have had trouble with this query pull down the latest and try again?