From: Reini U. <ru...@x-...> - 2007-07-23 06:41:37
|
Chris O'Halloran schrieb: > Hello people. > > I am having a few issues with the upgrade process > > I recently had a harddrive die but I managed to recover the phpwiki > database from the mysql directory. > > the wiki had been running version 11 but in rebuilding the phpwiki I > thought I would use the latest version 14. > > I have got the wiki working again but the edit function isn't working > and I thought this was probably related to the upgrade function > ?action=upgrade > > I tried running this with the following config file > > http://homepages.slingshot.co.nz/~cmoman/phpwiki/config.ini > > and I got the following errors. > > http://homepages.slingshot.co.nz/~cmoman/phpwiki/snapshot1.png > > http://homepages.slingshot.co.nz/~cmoman/phpwiki/snapshot2.png > > I suppose this relates to the mysql schema. > > Is there someway I can manually upgrade the mysql schema without using > the wiki interface. I seem to recall this was an option in the past. > > Thoughts comments welcome. I've made no special upgrade script yet to add relations to the link table. But this is trivial: ALTER TABLE link ADD relation INT DEFAULT 0; CREATE INDEX relation ON link (relation); Normally such upgrade recipes are in schemas/*-initialize.sql I just added it now. -- Reini Urban http://phpwiki.org/ http://murbreak.at/ http://helsinki.at/ http://spacemovie.mur.at/ |