Re: PHPwiki postgres database error

2011/4/17 Pat Grogan <[email protected]>:
> 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/

------------------------------------------------------------------------------
Benefiting from Server Virtualization: Beyond Initial Workload 
Consolidation -- Increasing the use of server virtualization is a top
priority.Virtualization can reduce costs, simplify management, and improve 
application availability and disaster protection. Learn more about boosting 
the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev