From: Chris O'H. <cm...@gm...> - 2007-07-23 02:29:32
|
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. Regards Chris |
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/ |
From: Chris O'H. <cm...@gm...> - 2007-07-23 22:53:43
|
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 <ru...@x-...> 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 > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phpwiki-talk > |