[support] FW: Upgrading Drupal from 5.19 to 6.13

Earnie Boyd earnie at users.sourceforge.net
Mon Sep 14 13:44:30 UTC 2009 

Quoting David Christensen <dpchrist at holgerdanske.com>:

> drupal:
>
> Does anybody know the answer to this question?
>

What steps did you did b4 the update.php?

>
> TIA,
>
> David
>
>
>
> -----Original Message-----
> From: David Christensen [mailto:dpchrist at holgerdanske.com]
> Sent: Friday, August 21, 2009 10:21 PM
> To: support at drupal.org
> Subject: RE: Upgrading Drupal from 5.19 to 6.13
>
> support at drupal.org:
>
> I am attempting to upgrade Drupal from 5.19 to 6.13.  Do I need to worry
> about the following warning messages?
>
> First update.php page:
>
> user warning: Table 'cache_block' already exists query: 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 */ in /home/holger/drupal-6.13/includes/database.inc
> on line 517.
>
>
> Third update.php page:
>
> user warning: Table 'cache_form' already exists query: 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 */ in
> /home/holger/drupal-6.13/modules/system/system.install on line 1413.
>
> user warning: Table 'menu_router' already exists query: 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 */ in /home/holger/drupal-6.13/includes/database.inc on line 517.
>
> user warning: Table 'menu_links' already exists query: CREATE TABLE
> menu_links ( `menu_name` VARCHAR(32) 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 */ in
> /home/holger/drupal-6.13/includes/database.inc on line 517.
>
> user warning: Table 'menu_custom' already exists query: CREATE TABLE
> menu_custom ( `menu_name` VARCHAR(32) NOT NULL DEFAULT '', `title`
> VARCHAR(255) NOT NULL DEFAULT '', `description` TEXT DEFAULT NULL,
> PRIMARY KEY (menu_name) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in
> /home/holger/drupal-6.13/includes/database.inc on line 517.
>
> user warning: Duplicate entry 'navigation' for key 1 query: INSERT INTO
> menu_custom (menu_name, title, description) VALUES ('navigation',
> 'Navigation', 'The navigation menu is provided by Drupal and is the main
> interactive menu for any site. It is usually the only menu that contains
> personalized links for authenticated users, and is often not even
> visible to anonymous users.') in
> /home/holger/drupal-6.13/modules/system/system.install on line 1749.
>
> user warning: Table 'upload' already exists query: ALTER TABLE
> file_revisions RENAME TO upload in
> /home/holger/drupal-6.13/includes/database.mysql-common.inc on line 249.
>
> user warning: Duplicate column name 'nid' query: ALTER TABLE upload ADD
> `nid` INT unsigned NOT NULL DEFAULT 0 in
> /home/holger/drupal-6.13/includes/database.mysql-common.inc on line 298.
>
> user warning: Duplicate key name 'nid' query: ALTER TABLE upload ADD
> INDEX nid (nid) in
> /home/holger/drupal-6.13/includes/database.mysql-common.inc on line 434.
>
> user warning: Multiple primary key defined query: ALTER TABLE upload ADD
> PRIMARY KEY (vid, fid) in
> /home/holger/drupal-6.13/includes/database.mysql-common.inc on line 374.
>
> user warning: Duplicate key name 'fid' query: ALTER TABLE upload ADD
> INDEX fid (fid) in
> /home/holger/drupal-6.13/includes/database.mysql-common.inc on line 434.
> user warning: Table 'actions_old_contrib' already exists query: ALTER
> TABLE actions RENAME TO actions_old_contrib in
> /home/holger/drupal-6.13/includes/database.mysql-common.inc on line 249.
>
> user warning: Table 'actions' already exists query: CREATE TABLE actions
> ( `aid` VARCHAR(255) NOT NULL DEFAULT '0', `type` VARCHAR(32) NOT NULL
> DEFAULT '', `callback` VARCHAR(255) NOT NULL DEFAULT '', `parameters`
> LONGTEXT NOT NULL, `description` VARCHAR(255) NOT NULL DEFAULT '0',
> PRIMARY KEY (aid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in
> /home/holger/drupal-6.13/includes/database.inc on line 517.
>
> user warning: Table 'actions_aid' already exists query: CREATE TABLE
> actions_aid ( `aid` INT unsigned NOT NULL auto_increment, PRIMARY KEY
> (aid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in
> /home/holger/drupal-6.13/includes/database.inc on line 517.
>
> user warning: Table 'search_node_links' already exists query: CREATE
> TABLE search_node_links ( `sid` INT unsigned NOT NULL DEFAULT 0, `type`
> VARCHAR(16) NOT NULL DEFAULT '', `nid` INT unsigned NOT NULL DEFAULT 0,
> `caption` LONGTEXT DEFAULT NULL, PRIMARY KEY (sid, type, nid), INDEX nid
> (nid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in
> /home/holger/drupal-6.13/includes/database.inc on line 517.
>
> user warning: Duplicate column name 'weight' query: ALTER TABLE upload
> ADD `weight` TINYINT NOT NULL DEFAULT 0 in
> /home/holger/drupal-6.13/includes/database.mysql-common.inc on line 298.
>
>
> TIA,
>
> David
>
>
> --
> [ Drupal support list | http://lists.drupal.org/ ]
>




--
Earnie
-- http://r-feed.com/           -- http://for-my-kids.com/
-- http://www.4offer.biz/       -- http://give-me-an-offer.com/

More information about the support mailing list