Bug#517237: mediawiki: cannot delete a page

[Marc Dequènes]

Package: mediawiki
Version: 1:1.12.0-2lenny3




Here is the missed upgrade path:
ALTER TABLE recentchanges DROP CONSTRAINT recentchanges_rc_cur_id_fkey;

As the "ON DELETE SET NULL" was missing, this triggered the bug.

Thanks.

--
Marc Dequènes
Homepage: http://www.proformatique.com/
Proformatique - 67 rue Voltaire - 92800 Puteaux
Tel. : 01 41 38 99 64 - Fax. : 01 41 38 99 70

I'm using a postgresql database, and deleting a page causes an SQL error, due to a mismatch between constraints on the 'recentchanges' table in /usr/share/mediawiki/maintenance/postgres/tables.sql and the one in my base after successive upgrades over time. The bug was probably present a while back, but we are not deleting pages very often. ALTER TABLE recentchanges ADD FOREIGN KEY (rc_cur_id) REFERENCES page(page_id) ON DELETE SET NULL;

pgpXZ8ND88Foh.pgp
Description: PGP Digital Signature