Thanks for the response.
The upgrade process looked to be working nicely until..
Is this an error with my configuration, the database.
I've checkout the lastest wiki via cvs and I notice in the mysql
initialize file there are a few other upgrades to the mysql database
since 1.3.11, should I apply these as well. They look mostly
authorisation related and I am not really using too strict an
authorisation for my wiki. Do I need to apply those changes too?
Sorry if it seems like I require a bit of hand holding. I am keen
linux user but don't have an IT background so have to figure most
things out for myself. Or ask questions :)
I appreciate the quick responses though.
On 23/07/07, Reini Urban <rurban@...> wrote:
> 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/
> Phpwiki-talk mailing list