[Phpwiki-talk] getting database-error when editing as "major edit"

[Sven R. <Mai...@ro...>]

Hi,

I started using phpwiki some years ago, as it was the first system which I 
easily integrated into my running software (LDAP-auth; Postgres).
Some months ago (in 2007) I upgraded to version 1.3.14, according to the 
steps in the manual.
In case I remember correctly since this upgrade I've some trouble with 
editing some pages of the wiki.
My problem is the following:
The not working pages behaves 
as "https://www.roederer.dhs.org/wiki/index.php/EinkaufsListe" 
(https://www.roederer.dhs.org/wiki/index.php/Knowledge
 is a working page). I can only save edits of this page when they are 
marked as "minor change". When this marking is not done (automatically or 
manually) I get the following error-msg:
-----------------------------------------------------------------------------
Fatal Error:
lib/WikiDB/backend/PearDB.php:1059 Error: wikidb_backend_peardb_pgsql: 
fatal database error 
 DB Error: constraint violation
 (INSERT INTO recent (id, latestversion, latestmajor, latestminor) SELECT 
id, MAX(version), MAX(CASE WHEN minor_edit=0 THEN version END), MAX(CASE 
WHEN minor_edit<>0 THEN version END) FROM version WHERE id=553 GROUP BY 
id [nativecode=ERROR: new row for relation "recent" violates check 
constraint "$1"])

Fatal PhpWiki Error
lib/WikiDB/backend/PearDB.php:1059 Error: wikidb_backend_peardb_pgsql: 
fatal database error 
 DB Error: constraint violation
 (INSERT INTO recent (id, latestversion, latestmajor, latestminor) SELECT 
id, MAX(version), MAX(CASE WHEN minor_edit=0 THEN version END), MAX(CASE 
WHEN minor_edit<>0 THEN version END) FROM version WHERE id=553 GROUP BY 
id [nativecode=ERROR: new row for relation "recent" violates check 
constraint "$1"])
-----------------------------------------------------------------------------

As written by the databse-engine, there is a constraint violation. 

Can anyone give me a hint how to fix this? As I'm not familar with the 
internal database-organization.

Kind regards  
Sven