Re: [Phpwiki-talk] PHPwiki postgres database error

[Reini U. <ru...@x-...>]

2011/4/17 Pat Grogan <pat...@bi...>:
> I have just migrated from a very early version of phpwiki to the very
> latest.

which version exactly?
1.4.0-rc1 or svn?

We would recommend svn, because we do not break things.

> I have got the wiki up and working but a soon as I try and edit the main
> page I get the following error:
>
> Fatal Error:
>
> lib/WikiDB/backend/PearDB.php:1061 Error[256]:
> WikiDB_backend_PearDB_pgsql: fatal database error
>
>    * DB Error: constraint violation
>    * (DELETE FROM version WHERE id=98 AND version=1 [nativecode=ERROR:
> update or delete on table "version" violates foreign key constraint
> "recent_id_fkey1" on table "recent"
>    * DETAIL: Key (id,version)=(98,1) is still referenced from table
> "recent".])

Hmm, looks like a major problem with autocleanup of older versions.
We don't really have to delete older versions anymore, only on
restricted size databases.

Please check if these values work for you until I have found the real problem:
MAJOR_MIN_KEEP = 2147483647
MINOR_MIN_KEEP = 2147483647

> Any help would be most appreciated.

-- 
Reini Urban
http://phpwiki.org/           http://murbreak.at/