invalid sql query from the versioning plugin

[Evil Azrael]

i just upgraded to the latest snapshot and now i get this error when updating an article :

Code: Select all

Warning: pg_query() [function.pg-query]: Query failed: ERROR: column "v.id" must appear in the GROUP BY clause or be used in an aggregate function in /www/blog.evilazrael.de/include/db/postgres.inc.php on line 210
Error in SELECT max(v.version) AS maxVer, v.id, a.realname, v.version_date FROM serendipity_versioning AS v LEFT OUTER JOIN serendipity_authors AS a ON a.authorid = v.version_author WHERE entry_id = 25 GROUP BY v.entry_id
ERROR: column "v.id" must appear in the GROUP BY clause or be used in an aggregate function

i think i will disable this plugin as it´s not really needed.

[garvinhicking]

Hi!

Thanks for reporting, I fixed that pgsql bug in the plugin.

Regards,
Garvin