rendered paste body<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"><html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>Drupal database update</title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><link type="text/css" rel="stylesheet" media="all" href="/47/misc/maintenance.css" /><link type="text/css" rel="stylesheet" media="all" href="/47/modules/system/defaults.css" /><link type="text/css" rel="stylesheet" media="all" href="/47/modules/system/system.css" /><link rel="shortcut icon" href="/47/misc/favicon.ico" type="image/x-icon" /> <link type="text/css" rel="stylesheet" media="all" href="/47/themes/garland/minnelli/style.css" /> <!--[if lt IE 7]> <link type="text/css" rel="stylesheet" media="all" href="/47/themes/garland/minnelli/fix-ie.css" /> <![endif]--> </head> <body class="sidebar-left"><!-- Layout --> <div id="header-region" class="clear-block"></div> <div id="wrapper"> <div id="container" class="clear-block"> <div id="header"> <div id="logo-floater"> <h1><a href="/47/"><img src="/47/themes/garland/minnelli/logo.png" alt="Drupal" id="logo" /><span>Drupal</span></a></h1> </div> </div> <!-- /header --> <div id="sidebar-left" class="sidebar"> <ol class="task-list"><li class="done">Overview</li><li class="done">Select updates</li><li class="done">Run updates</li><li class="done">Review log</li></ol> </div> <div id="center"><div id="squeeze"><div class="right-corner"><div class="left-corner"> <h2>Drupal database update</h2> <p>Updates were attempted. If you see no failures below, you may proceed happily to the <a href="index.php?q=admin">administration pages</a>. Otherwise, you may need to update your database manually. All errors have been <a href="index.php?q=admin/logs/watchdog">logged</a>.</p><div class="item-list"><ul><li><a href="/47/">Main page</a></li><li><a href="/47/?q=admin">Administration pages</a></li></ul></div><div id="update-results"><h2>The following queries were executed</h2><h3>system module</h3><h4>Update #6000</h4><ul><li class="success">ALTER TABLE {boxes} CHANGE COLUMN bid bid int NOT NULL</li><li class="success">REPLACE INTO {sequences} VALUES ('{boxes}_bid', 0)</li></ul><h4>Update #6001</h4><ul><li class="success">ALTER TABLE {term_node} ADD `vid` INT unsigned NOT NULL DEFAULT 0</li><li class="success">ALTER TABLE {term_node} DROP PRIMARY KEY</li><li class="success">ALTER TABLE {term_node} ADD PRIMARY KEY (vid, tid, nid)</li><li class="success">ALTER TABLE {term_node} ADD INDEX vid (vid)</li></ul><h4>Update #6002</h4><ul><li class="success">ALTER TABLE {variable} DROP PRIMARY KEY</li><li class="success">ALTER TABLE {variable} CHANGE name `name` VARCHAR(128) NOT NULL DEFAULT ''</li><li class="success">ALTER TABLE {variable} ADD PRIMARY KEY (name)</li></ul><h4>Update #6003</h4><ul><li class="success">ALTER TABLE {comments} ADD KEY status (status)</li></ul><h4>Update #6004</h4><ul><li class="none">No queries</li></ul><h4>Update #6005</h4><ul><li class="success">ALTER TABLE {url_alias} ADD language varchar(12) NOT NULL default ''</li><li class="success">ALTER TABLE {url_alias} DROP INDEX dst</li><li class="success">ALTER TABLE {url_alias} ADD UNIQUE dst_language (dst, language)</li></ul><h4>Update #6006</h4><ul><li class="success">ALTER TABLE {node_counter} DROP INDEX daycount</li><li class="success">ALTER TABLE {node_counter} DROP INDEX totalcount</li><li class="success">ALTER TABLE {node_counter} DROP INDEX timestamp</li></ul><h4>Update #6007</h4><ul><li class="success">UPDATE {watchdog} SET severity = 5 WHERE severity = 0</li><li class="success">UPDATE {watchdog} SET severity = 4 WHERE severity = 1</li><li class="success">UPDATE {watchdog} SET severity = 3 WHERE severity = 2</li></ul><h4>Update #6008</h4><ul><li class="success">UPDATE {system} SET owner = description</li><li class="success">ALTER TABLE {system} DROP description</li></ul><h4>Update #6009</h4><ul><li class="success">DELETE FROM {filter_formats} WHERE format = 2</li><li class="success">DELETE FROM {filters} WHERE format = 2</li><li class="success">UPDATE {system} SET status = 1 WHERE name = 'php' AND type = 'module'</li><li class="success">INSERT INTO {filter_formats} (name, roles, cache) VALUES ('PHP code', '', 0)</li><li class="success">UPDATE {filters} SET delta = 0, module = 'php' WHERE module = 'filter' AND delta = 1</li><li class="success">UPDATE {filters} SET delta = 1 WHERE module = 'filter' AND delta = 2</li><li class="success">UPDATE {filters} SET delta = 2 WHERE module = 'filter' AND delta = 3</li></ul><h4>Update #6010</h4><ul><li class="success">ALTER TABLE {watchdog} ADD `variables` MEDIUMTEXT DEFAULT NULL</li><li class="success">UPDATE {watchdog} SET variables = '%s' (N;)</li><li class="success">ALTER TABLE {watchdog} CHANGE variables `variables` MEDIUMTEXT NOT NULL</li></ul><h4>Update #6011</h4><ul><li class="success">ALTER TABLE {node} ADD language varchar(12) NOT NULL default ''</li></ul><h4>Update #6012</h4><ul><li class="none">No queries</li></ul><h4>Update #6013</h4><ul><li class="none">No queries</li></ul><h4>Update #6014</h4><ul><li class="none">No queries</li></ul><h4>Update #6015</h4><ul><li class="success">CREATE TABLE {cache_form} ( cid varchar(255) NOT NULL default '', data longblob, expire int NOT NULL default '0', created int NOT NULL default '0', headers text, serialized int(1) NOT NULL default '0', PRIMARY KEY (cid), INDEX expire (expire) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ </li></ul><h4>Update #6016</h4><ul><li class="success">ALTER TABLE {node} DROP PRIMARY KEY</li><li class="success">ALTER TABLE {node} ADD PRIMARY KEY (nid)</li><li class="success">ALTER TABLE {node} ADD UNIQUE KEY nid_vid (nid, vid)</li><li class="success">ALTER TABLE {blocks} ADD bid int NOT NULL AUTO_INCREMENT PRIMARY KEY</li><li class="success">ALTER TABLE {filters} ADD fid int NOT NULL AUTO_INCREMENT PRIMARY KEY</li><li class="success">ALTER TABLE {flood} ADD fid int NOT NULL AUTO_INCREMENT PRIMARY KEY</li><li class="success">ALTER TABLE {permission} ADD pid int NOT NULL AUTO_INCREMENT PRIMARY KEY</li><li class="success">ALTER TABLE {term_relation} ADD trid int NOT NULL AUTO_INCREMENT PRIMARY KEY</li><li class="success">ALTER TABLE {term_synonym} ADD tsid int NOT NULL AUTO_INCREMENT PRIMARY KEY</li></ul><h4>Update #6017</h4><ul><li class="none">No queries</li></ul><h4>Update #6018</h4><ul><li class="none">No queries</li></ul><h4>Update #6019</h4><ul><li class="success">ALTER TABLE {aggregator_feed} DROP KEY link</li><li class="success">ALTER TABLE {aggregator_feed} ADD UNIQUE KEY url (url)</li><li class="success">ALTER TABLE {boxes} CHANGE format `format` SMALLINT NOT NULL DEFAULT 0</li><li class="success">ALTER TABLE {comments} CHANGE format `format` SMALLINT NOT NULL DEFAULT 0</li><li class="success">ALTER TABLE {comments} DROP INDEX lid</li><li class="success">ALTER TABLE {comments} ADD INDEX nid (nid)</li><li class="success">ALTER TABLE {cache} CHANGE serialized `serialized` SMALLINT NOT NULL DEFAULT 0</li><li class="success">ALTER TABLE {cache_filter} CHANGE serialized `serialized` SMALLINT NOT NULL DEFAULT 0</li><li class="success">ALTER TABLE {cache_page} CHANGE serialized `serialized` SMALLINT NOT NULL DEFAULT 0</li><li class="success">ALTER TABLE {cache_form} CHANGE serialized `serialized` SMALLINT NOT NULL DEFAULT 0</li><li class="success">ALTER TABLE {files} CHANGE fid `fid` INT unsigned NOT NULL auto_increment</li><li class="success">SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO'</li><li class="success">ALTER TABLE {users} CHANGE uid `uid` INT unsigned NOT NULL auto_increment</li><li class="success">ALTER TABLE {node_revisions} CHANGE vid `vid` INT unsigned NOT NULL auto_increment</li><li class="success">ALTER TABLE {boxes} CHANGE bid `bid` INT NOT NULL auto_increment</li><li class="success">ALTER TABLE {batch} CHANGE bid `bid` INT unsigned NOT NULL auto_increment</li></ul><h4>Update #6020</h4><ul><li class="success">CREATE TABLE {menu_router} (`path` VARCHAR(255) NOT NULL DEFAULT '', `load_functions` VARCHAR(255) NOT NULL DEFAULT '', `to_arg_functions` VARCHAR(255) NOT NULL DEFAULT '', `access_callback` VARCHAR(255) NOT NULL DEFAULT '', `access_arguments` TEXT DEFAULT NULL, `page_callback` VARCHAR(255) NOT NULL DEFAULT '', `page_arguments` TEXT DEFAULT NULL, `fit` INT NOT NULL DEFAULT 0, `number_parts` SMALLINT NOT NULL DEFAULT 0, `tab_parent` VARCHAR(255) NOT NULL DEFAULT '', `tab_root` VARCHAR(255) NOT NULL DEFAULT '', `title` VARCHAR(255) NOT NULL DEFAULT '', `title_callback` VARCHAR(255) NOT NULL DEFAULT '', `title_arguments` VARCHAR(255) NOT NULL DEFAULT '', `type` INT NOT NULL DEFAULT 0, `block_callback` VARCHAR(255) NOT NULL DEFAULT '', `description` TEXT NOT NULL, `position` VARCHAR(255) NOT NULL DEFAULT '', `weight` INT NOT NULL DEFAULT 0, `file` MEDIUMTEXT DEFAULT NULL, PRIMARY KEY (path), INDEX fit (fit), INDEX tab_parent (tab_parent)) /*!40100 DEFAULT CHARACTER SET UTF8 */</li><li class="success">CREATE TABLE {menu_links} (`menu_name` VARCHAR(64) NOT NULL DEFAULT '', `mlid` INT unsigned NOT NULL auto_increment, `plid` INT unsigned NOT NULL DEFAULT 0, `link_path` VARCHAR(255) NOT NULL DEFAULT '', `router_path` VARCHAR(255) NOT NULL DEFAULT '', `link_title` VARCHAR(255) NOT NULL DEFAULT '', `options` TEXT DEFAULT NULL, `module` VARCHAR(255) NOT NULL DEFAULT 'system', `hidden` SMALLINT NOT NULL DEFAULT 0, `external` SMALLINT NOT NULL DEFAULT 0, `has_children` SMALLINT NOT NULL DEFAULT 0, `expanded` SMALLINT NOT NULL DEFAULT 0, `weight` INT NOT NULL DEFAULT 0, `depth` SMALLINT NOT NULL DEFAULT 0, `customized` SMALLINT NOT NULL DEFAULT 0, `p1` INT unsigned NOT NULL DEFAULT 0, `p2` INT unsigned NOT NULL DEFAULT 0, `p3` INT unsigned NOT NULL DEFAULT 0, `p4` INT unsigned NOT NULL DEFAULT 0, `p5` INT unsigned NOT NULL DEFAULT 0, `p6` INT unsigned NOT NULL DEFAULT 0, `p7` INT unsigned NOT NULL DEFAULT 0, `p8` INT unsigned NOT NULL DEFAULT 0, `p9` INT unsigned NOT NULL DEFAULT 0, `updated` SMALLINT NOT NULL DEFAULT 0, PRIMARY KEY (mlid), INDEX path_menu (link_path(128), menu_name), INDEX menu_plid_expand_child (menu_name, plid, expanded, has_children), INDEX menu_parents (menu_name, p1, p2, p3, p4, p5, p6, p7, p8, p9), INDEX router_path (router_path(128))) /*!40100 DEFAULT CHARACTER SET UTF8 */</li></ul><h4>Update #6021</h4><ul><li class="success">CREATE TABLE {menu_custom} (`menu_name` VARCHAR(255) NOT NULL DEFAULT '', `title` VARCHAR(255) NOT NULL DEFAULT '', `description` TEXT DEFAULT NULL, PRIMARY KEY (menu_name)) /*!40100 DEFAULT CHARACTER SET UTF8 */</li></ul><h4>Update #6022</h4><ul><li class="success">ALTER TABLE {files} DROP INDEX nid</li><li class="success">ALTER TABLE {files} CHANGE nid `uid` INT unsigned NOT NULL DEFAULT 0</li><li class="success">ALTER TABLE {files} ADD `status` INT NOT NULL DEFAULT 0</li><li class="success">ALTER TABLE {files} ADD `timestamp` INT unsigned NOT NULL DEFAULT 0</li><li class="success">ALTER TABLE {files} ADD INDEX uid (uid)</li><li class="success">ALTER TABLE {files} ADD INDEX status (status)</li><li class="success">ALTER TABLE {files} ADD INDEX timestamp (timestamp)</li><li class="success">ALTER TABLE {file_revisions} DROP INDEX vid</li><li class="success">ALTER TABLE {file_revisions} RENAME TO {upload}</li><li class="success">ALTER TABLE {upload} ADD `nid` INT unsigned NOT NULL DEFAULT 0</li><li class="success">ALTER TABLE {upload} ADD INDEX nid (nid)</li><li class="success">ALTER TABLE {upload} ADD INDEX vid (vid)</li><li class="success">UPDATE {files} f JOIN {node} n ON f.uid = n.nid SET f.uid = n.uid</li><li class="success">UPDATE {upload} u JOIN {node_revisions} r ON u.vid = r.vid SET u.nid = r.nid</li></ul><h4>Update #6023</h4><ul><li class="success">ALTER TABLE {node} DROP KEY nid_vid</li><li class="success">ALTER TABLE {node} DROP KEY vid</li><li class="success">ALTER TABLE {node} CHANGE vid `vid` INT unsigned DEFAULT 0</li><li class="success">ALTER TABLE {node} ADD UNIQUE KEY nid_vid (nid, vid)</li><li class="success">ALTER TABLE {node} ADD UNIQUE KEY vid (vid)</li><li class="success">ALTER TABLE {node_revisions} DROP INDEX nid</li><li class="success">ALTER TABLE {node_revisions} CHANGE nid `nid` INT unsigned NOT NULL DEFAULT 0</li><li class="success">ALTER TABLE {node_revisions} ADD INDEX nid (nid)</li></ul><h4>Update #6024</h4><ul><li class="success">ALTER TABLE {node} ADD `tnid` INT unsigned NOT NULL DEFAULT 0</li><li class="success">ALTER TABLE {node} ADD `translate` INT NOT NULL DEFAULT 0</li><li class="success">ALTER TABLE {node} ADD INDEX tnid (tnid)</li><li class="success">ALTER TABLE {node} ADD INDEX translate (translate)</li></ul><h4>Update #6025</h4><ul><li class="success">ALTER TABLE {node} DROP INDEX node_title_type</li><li class="success">ALTER TABLE {node} CHANGE title `title` VARCHAR(255) NOT NULL DEFAULT ''</li><li class="success">ALTER TABLE {node} ADD INDEX node_title_type (title, type(4))</li><li class="success">ALTER TABLE {node_revisions} CHANGE title `title` VARCHAR(255) NOT NULL DEFAULT ''</li></ul><h4>Update #6026</h4><ul><li class="success">CREATE TABLE {cache_update} (`cid` VARCHAR(255) NOT NULL DEFAULT '', `data` LONGBLOB DEFAULT NULL, `expire` INT NOT NULL DEFAULT 0, `created` INT NOT NULL DEFAULT 0, `headers` TEXT DEFAULT NULL, `serialized` SMALLINT NOT NULL DEFAULT 0, PRIMARY KEY (cid), INDEX expire (expire)) /*!40100 DEFAULT CHARACTER SET UTF8 */</li></ul><h4>Update #6027</h4><ul><li class="success">ALTER TABLE {blocks} ADD `cache` TINYINT NOT NULL DEFAULT 0</li><li class="success">CREATE TABLE {cache_block} (`cid` VARCHAR(255) NOT NULL DEFAULT '', `data` LONGBLOB DEFAULT NULL, `expire` INT NOT NULL DEFAULT 0, `created` INT NOT NULL DEFAULT 0, `headers` TEXT DEFAULT NULL, `serialized` SMALLINT NOT NULL DEFAULT 0, PRIMARY KEY (cid), INDEX expire (expire)) /*!40100 DEFAULT CHARACTER SET UTF8 */</li></ul><h4>Update #6028</h4><ul><li class="success">CREATE TABLE {cache_node} (`cid` VARCHAR(255) NOT NULL DEFAULT '', `data` LONGBLOB DEFAULT NULL, `expire` INT NOT NULL DEFAULT 0, `created` INT NOT NULL DEFAULT 0, `headers` TEXT DEFAULT NULL, `serialized` SMALLINT NOT NULL DEFAULT 0, PRIMARY KEY (cid), INDEX expire (expire)) /*!40100 DEFAULT CHARACTER SET UTF8 */</li></ul><h4>Update #6029</h4><ul><li class="none">No queries</li></ul><h3>comment module</h3><h4>Update #6001</h4><ul><li class="success">ALTER TABLE {comments} DROP score</li><li class="success">ALTER TABLE {comments} DROP users</li></ul></div> <span class="clear"></span> <!--partial--> </div></div></div></div> <!-- /.left-corner, /.right-corner, /#squeeze, /#center --> </div> <!-- /container --> </div><!-- /layout --> </body></html>