mysql errors and warnings

[AllKnightAccess]

trying to run "clean index", i get this error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /.../admin/cleanup_engine.php on line 60

trying to update a site, i get this error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /.../admin/update.php on line 138

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /.../admin/update.php on line 140

and i am unable to login to update at all.

[Charter]

Using a fresh install?

[AllKnightAccess]

Yes. It was a fresh install.

[Charter]

Never had those errors with a fresh install. Can you provide any further details?

[AllKnightAccess]

What kind of info would be helpful in particular?

[AllKnightAccess]

adding mysql_error() to the code, I get this message:

'nuke_phpdig_spider.spider_id' isn't in GROUP BY

what does that mean? Is the code really incorrect?

Should the query be

GROUP BY path, spider_id

instead of

GROUP BY path ?