Re: Fwd: phpwiki errors when trying to upgrade

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/

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/