Re: Fwd: phpwiki errors when trying to upgrade

Thanks for the response.

The upgrade process looked to be working nicely until..

http://homepages.slingshot.co.nz/~cmoman/phpwiki/snapshot3.png

http://homepages.slingshot.co.nz/~cmoman/phpwiki/snapshot4.png

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.

Regards,

Chris

On 23/07/07, Reini Urban <[email protected]> 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
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
>

-------------------------------------------------------------------------
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/