invalid sql query from the versioning plugin
Posted: Fri May 04, 2007 4:59 pm
i just upgraded to the latest snapshot and now i get this error when updating an article :
i think i will disable this plugin as it´s not really needed.
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