getting database-error when editing as "major edit"
Sven Roederer <[email protected]>
| Newsgroups | gmane.comp.web.wiki.phpwiki.talk |
|---|---|
| Message-ID | <[email protected]> |
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 ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Phpwiki-talk mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
signature.asc
(application/pgp-signature, 189 B)
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQBIo1y0X4Ba324MkD4RAjJpAKDJ7h82/zsdR1jpffmsgfg/nVjhuACfepE7 IIa+nmRkx32+OI8DfH6uYpY= =Dm5r -----END PGP SIGNATURE-----