[support] FW: Upgrading Drupal from 5.19 to 6.13

[Metzler, David]

The answer is probably not, but you won't find out for sure until you
test.   

My Older sites often run into these problems as parallel paths may or
may not have the same update numbers with modules if theyre in different
branches.  This is especially true of sites that have been around since
the 4.7.x days.  I often do not see any ill effects for errors that
simply redefine objects that already exist in my schema. 

For example, suppose you have the actions module installed, and then the
actions module moves into core.  The core upgrade hook will need to
create the actions tables, but if you already had the 5.x actions module
installed, you're going to already have those tables.  It's technically
possible that the actions module tables were implemented differently,
but with the same names as what went into core, in which case you may
run into problems.  Hopefully the module developers thought of that and
a subsequent module upgrade will take the appropriate actions on the
core tables, but you can't be 100% sure of this.  Keep notes about the
messages.  

If you're really concerned, and you have a schema compare tool, you can
run a schema comparison between a fresh 6.x install and a 5.x upgrade
and see if there are any differences in the core tables definitions that
need to be corrected.  

Hope that helps shed light on this. 







-----Original Message-----
From: support-bounces at drupal.org [mailto:support-bounces at drupal.org] On
Behalf Of David Christensen
Sent: Tuesday, September 15, 2009 10:51 AM
To: support at drupal.org
Subject: Re: [support] FW: Upgrading Drupal from 5.19 to 6.13

Earnie Boyd wrote:
> You need to upgrade to the latest version of 5.x

Thank you for your reply.  :-)


I have already upgraded to the latest version of 5.x (5.19).


So, back to the original question -- 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/ ]