1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
|
<?php
// $Id$
/**
* @file
* Administrative page for handling updates from one Drupal version to another.
*
* Point your browser to "http://www.site.com/update.php" and follow the
* instructions.
*
* If you are not logged in as administrator, you will need to modify the access
* check statement below. Change the TRUE into a FALSE to disable the access
* check. After finishing the upgrade, be sure to open this file and change the
* FALSE back into a TRUE!
*/
// Enforce access checking?
$access_check = TRUE;
if (!ini_get("safe_mode")) {
set_time_limit(180);
}
include_once "database/updates.inc";
function update_data($start) {
global $sql_updates;
$output = '';
$sql_updates = array_slice($sql_updates, ($start-- ? $start : 0));
foreach ($sql_updates as $date => $func) {
$output .= '<h3 class="update">'. $date .'</h3><pre class="update">';
$ret = $func();
foreach ($ret as $return) {
$output .= $return[1];
}
variable_set("update_start", $date);
$output .= "</pre>\n";
}
db_query('DELETE FROM {cache}');
return $output;
}
function update_selection_page() {
global $sql_updates;
$start = variable_get("update_start", 0);
$i = 1;
foreach ($sql_updates as $date => $sql) {
$dates[$i++] = $date;
if ($date == $start) {
$selected = $i;
}
}
$dates[$i] = "No updates available";
// make update form and output it.
$form = form_select("Perform updates from", "start", (isset($selected) ? $selected : -1), $dates, "This defaults to the first available update since the last update you performed.");
$form .= form_submit("Update");
drupal_set_title('Drupal database update');
return form($form);
}
function update_do_updates() {
$edit = $_POST['edit'];
drupal_set_title('Drupal database update');
// NOTE: we can't use l() here because the URL would point to 'update.php?q=admin'.
$links[] = "<a href=\"index.php\">main page</a>";
$links[] = "<a href=\"index.php?q=admin\">administration pages</a>";
$output = theme('item_list', $links);
$output .= update_data($edit['start']);
$output .= '<p>Updates were attempted. If you see no failures above, you may proceed happily to the <a href="index.php?q=admin">administration pages</a>. Otherwise, you may need to update your database manually.</p>';
if ($GLOBALS['access_check'] == FALSE) {
$output .= "<p><strong>Reminder: don't forget to set the <code>\$access_check</code> value at the top of <code>update.php</code> back to <code>TRUE</code>.</strong>";
}
return $output;
}
function update_info_page() {
drupal_set_title('Drupal database update');
$output = "<ol>\n";
$output .= "<li>Use this script to <strong>upgrade an existing Drupal installation</strong>. You don't need this script when installing Drupal from scratch.</li>";
$output .= "<li>Before doing anything, backup your database. This process will change your database and its values, and some things might get lost.</li>\n";
$output .= "<li>Update your Drupal sources, check the notes below and <a href=\"update.php?op=update\">run the database upgrade script</a>. Don't upgrade your database twice as it may cause problems.</li>\n";
$output .= "<li>Go through the various administration pages to change the existing and new settings to your liking.</li>\n";
$output .= "</ol>";
$output .= "Notes:";
$output .= "<ol>";
$output .= " <li>If you <strong>upgrade from Drupal 4.4.x</strong>, you will need to create the <code>users_roles</code> and <code>locales_meta</code> tables manually before upgrading. To create these tables, issue the following SQL commands:
<p>MySQL specific example:</p>
<pre>
CREATE TABLE users_roles (
uid int(10) unsigned NOT NULL default '0',
rid int(10) unsigned NOT NULL default '0',
PRIMARY KEY (uid, rid)
);
CREATE TABLE locales_meta (
locale varchar(12) NOT NULL default '',
name varchar(64) NOT NULL default '',
enabled int(2) NOT NULL default '0',
isdefault int(2) NOT NULL default '0',
plurals int(1) NOT NULL default '0',
formula varchar(128) NOT NULL default '',
PRIMARY KEY (locale)
);
</pre>
<p>PostgreSQL specific example:</p>
<pre>
CREATE TABLE users_roles (
uid integer NOT NULL default '0',
rid integer NOT NULL default '0',
PRIMARY KEY (uid, rid)
);
CREATE TABLE locales_meta (
locale varchar(12) NOT NULL default '',
name varchar(64) NOT NULL default '',
enabled int4 NOT NULL default '0',
isdefault int4 NOT NULL default '0',
plurals int4 NOT NULL default '0',
formula varchar(128) NOT NULL default '',
PRIMARY KEY (locale)
);
</pre>
</li>";
$output .= " <li>If you <strong>upgrade from Drupal 4.3.x</strong>, you will need to add the <code>bootstrap</code> and <code>throttle</code> fields to the <code>system</code> table manually before upgrading. To add the required fields, issue the following SQL commands:
<p>MySQL specific example:</p>
<pre>
ALTER TABLE system ADD throttle tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE system ADD bootstrap int(2);
</pre>
<p>PostgreSQL specific example:</p>
<pre>
ALTER TABLE system ADD throttle smallint;
ALTER TABLE system ALTER COLUMN throttle SET DEFAULT '0';
UPDATE system SET throttle = 0;
ALTER TABLE system ALTER COLUMN throttle SET NOT NULL;
ALTER TABLE system ADD bootstrap integer;
</pre>
</li>";
$output .= " <li>If you <strong>upgrade from Drupal 4.2.0</strong>, you will need to create the <code>sessions</code> table manually before upgrading. After creating the table, you will want to log in and immediately continue the upgrade. To create the <code>sessions</code> table, issue the following SQL command:
<p>MySQL specific example:</p>
<pre>
CREATE TABLE sessions (
uid int(10) unsigned NOT NULL,
sid varchar(32) NOT NULL default '',
hostname varchar(128) NOT NULL default '',
timestamp int(11) NOT NULL default '0',
session text,
KEY uid (uid),
KEY sid (sid(4)),
KEY timestamp (timestamp));
</pre>
</li>";
$output .= "</ol>";
$output .= '<p>For more help, see the <a href="http://drupal.org/node/258">Installation and upgrading handbook</a>. If you are unsure what these terms mean you should probably contact your hosting provider.</p>';
return $output;
}
function update_access_denied_page() {
drupal_set_title('Access denied');
return '<p>Access denied. You are not authorized to access this page. Please log in as the admin user (the first user you created). If you cannot log in, you will have to edit <code>update.php</code> to bypass this access check. To do this:</p>
<ol>
<li>With a text editor find the update.php file on your system. It should be in the main Drupal directory that you installed all the files into.</li>
<li>There is a line near top of update.php that says <code>$access_check = TRUE;</code>. Change it to <code>$access_check = FALSE;</code>.</li>
<li>As soon as the script is done, you must change the update.php script back to its original form to <code>$access_check = TRUE;</code>.</li>
<li>To avoid having this problem in future, remember to log in to your website as the admin user (the user you first created) before you backup your database at the beginning of the update process.</li>
</ol>';
}
include_once "includes/bootstrap.inc";
drupal_maintenance_theme();
if (isset($_GET["op"])) {
drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);
// Access check:
if (($access_check == 0) || ($user->uid == 1)) {
$op = isset($_POST['op']) ? $_POST['op'] : '';
switch ($op) {
case 'Update':
$output = update_do_updates();
break;
default:
$output = update_selection_page();
break;
}
}
else {
$output = update_access_denied_page();
}
}
else {
$output = update_info_page();
}
if ($output) {
print theme('maintenance_page', $output);
}
?>
|
