5 ALTER TABLE session ADD sess_ip CHAR(15) NOT NULL;
6 CREATE INDEX sess_date ON session (sess_date);
10 New pref and session tables have been added for more
15 WikiUser and signin.tmpl changed from $user->getId() to
16 $user->getAuthenticatedId()
17 Authenticated reflects the level (confirmed by password),
18 Signed just the username (possibly by cookie only)
22 To upgrade not-existing pages add "?action=upgrade" to
23 your HomePage url and press "Enter", which will
24 add all fresh pages from pgsrc to your pageset.
25 If you deleted some pages on purpose, you'll have to removed
26 them again with PhpWikiAdminisstration/Remove then.
28 There's no smart "Merge Diffs" yet to upgrade existing docs,
29 this will come with the next release. Also upgrading the
30 database automatically.
34 FIXME: WARNING WARNING: the schemas used by the new databases
35 are completely incompatible with schemas in any previous version
36 (i.e. before release 1.3.1 of PhpWiki). If you install this new
37 PhpWiki, you must start with a new empty database (currently
38 either mysql, postgres or dba). (It will be filled with the
43 Here's an excerpt from a note I posted on phpwiki-talk with my
44 recommendation on how to move a wiki from and older version of
45 PhpWiki to a 1.3.x PhpWiki:
47 From: Jeff Dairiki <dairiki@dairiki.org>
48 Cc: phpwiki-talk@lists.sourceforge.net
49 Date: Fri, 9 Nov 2001 11:33:18 -0800
51 > Now, say I want to migrate all my 1.2.1 pages. I need to do a zip dump
52 > (does the admin page let me do that?) and then.... what?
54 It's still a bit of a messy process at this point. Here's my suggestion.
56 1. Start 1.3.x with an empty database. Browse the FrontPage. This should
57 fill the wiki with the distributed default 1.3.x pgsrc. (You've probably
58 already gotten this far.)
60 2. Make a zip dump of your 1.2 wiki. If the contents of
61 PhpWikiAdministration are correct there should be a links
62 (near the top) which will do that for you. You need to be
63 in admin mode, though. This means you must have set an
64 admin user and passwd in admin.php, and you should be browsing
66 http://path.to.your/wiki/admin.php?PhpWikiAdministration
67 (If your PhpWikAdministration page is broken, then
68 http://path.to.your/wiki/admin.php?zip=all
69 should get you a zip dump.)
71 WARNING! WARNING! WARNING! There is a bug in releases 1.2.0
72 and 1.2.1 of PhpWiki which results in corrupt zip dumps if
73 you are using the DBA, DBM or flat-file backends. If you
74 are using one of those backends you should make sure to
75 fix that bug (see note below) before making the zip dump.
78 3. Now upload your zip dump to your new 1.3 wiki. (First you need to
79 have set the admin user/passwd in the new index.php.) You should
80 be able to use the "Upload File" form on the PhpWikiAdministration
84 If that works, the pages from your 1.2 wiki have now overwritten
85 the 1.3 pages (though the 1.3 pages are still saved in the archive).
86 This will break a bunch of 1.3 functionality until you restore
87 the page contents. Of the top of my head, some pages for which
88 this will be an issue are:
89 MostPopular, RecentChanges, PhpWikiAdministration,
90 MagicPhpWikiURLs, and ReleaseNotes.
92 To restore these pages to the original (1.3) contents:
94 4a. Login as the administration user (using the SignIn button at the
95 bottom right corner of the page.) (You need to do this because
96 some of the pages which need fixing are locked.)
98 4b. Browse to a page which needs restoring. Hit the "History" button
99 (at the bottom of the page). This should get you a list of all
100 archived versions of the page.
102 4c. Browse to the archive 1.3 version of the page (probably version number
103 1) by clicking on the version number of the desired version.
105 4d. Click the "Edit old revision" button (bottom of page). This should
106 get you to the edit form.
108 4e. Click the "Save" button. This should save the archived page contents
109 as the current contents.
111 We really need to figure out a way to simplify this process, but, for now,
112 that's what you gotta do.
114 An older note of mine on the same subject can be found at:
115 http://sourceforge.net/forum/message.php?msg_id=107858
117 $Id: UPGRADING,v 1.7 2004-04-12 14:07:10 rurban Exp $