Hi guys,
I was trying to upgrade my installation of mediawiki from 1.15.4 to 1.16,
following the procedures listed on the Mediawiki upgrade page, and I ran
into a database error along the way. I'm using Debian Lenny with PHP
5.2.6-1+lenny9 (apache2handler) and Postgres 8.3.12. During the upgrade
procedure I got this error:
Query: CREATE TABLE user_properties(
up_user INTEGER NULL REFERENCES mwuser(user_id) ON DELETE CASCADE,
up_property TEXT NOT NULL,
up_value TEXT
)
Function: DatabaseBase::sourceStream
Error: 1 ERROR: there is no unique constraint matching given keys for
referenced table "mwuser"
And now the wiki is down. Can anyone help me figure out what to do from this
point? Luckily I have daily backups of the database so that's not a huge
problem, but I'd like to get this up and running again ASAP. I actually
restored a backup over the database and tried to install mediawiki 1.15.5
(from Debian's backports repository, since Mediawiki's archives are down)
but now anything related to editing is broken. I did not try deleting the
database and then restoring the backup though, which I probably should when
I get the time. Unfortunately it's a private internal wiki but if any more
information is needed I'd be happy to provide it.
Thanks!
-Ibrahim Awwal