[support] Upgrading Drupal from 5.19 to 6.13

[David Christensen]

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