drupal:
Does anybody know the answer to this question?
TIA,
David
-----Original Message----- From: David Christensen [mailto:dpchrist@holgerdanske.com] Sent: Friday, August 21, 2009 10:21 PM To: support@drupal.org Subject: RE: Upgrading Drupal from 5.19 to 6.13
support@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
Quoting David Christensen dpchrist@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@holgerdanske.com] Sent: Friday, August 21, 2009 10:21 PM To: support@drupal.org Subject: RE: Upgrading Drupal from 5.19 to 6.13
support@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/
Earnie Boyd wrote:
What steps did you did b4 the update.php?
Thank you for replying. :-)
The short answer is, "I follow UPGRADE.txt as best I can".
Unfortunately, step 6 is vague:
Remove all old files and directories from the Drupal installation directory.
I've never been certain as to which files and directories to remove. So when I've tried to follow the procedure to the letter, I've had to guess. :-O
I've run into issues both when attempting to upgrade/ update (broken site, locked out, operator error, etc.) and also when recovering from a failed upgrade/ update (notably restoring database images taken when Drupal was in offline mode). So, I've made adjustments to the procedure both to improve my chances of success and to simplify recovery should I fail:
- Steps 1, 2, 3, and 14 -- I login with user ID 1 (step 2), take the site off-line by adding the following lines to .htaccess (instead of step 3):
Order Allow,Deny Allow from 127.0.0.1/255.0.0.0 Allow from w.x.y.z/255.255.255.255
take backup/ archive images (files and database) (step 1), upgrade/ update per steps 4-13, take another set of backup/ archive images, and put the site online by commenting out the above lines (instead of step 14).
- Steps 6 and 7 -- my Apache DocumentRoot is a symbolic link which points to my current Drupal installation directory. Rather than hacking up my old Drupal installation directory, I unpack the Drupal 6.13 tarball into a new Drupal installation directory, add the above lines to .htaccess, and change the symbolic link.
The modified procedure seems to have worked for minor revision upgrades/ updates (e.g. 5.x -> 5.19).
I only recently read about uninstalling Drupal modules via the UI. In the past, I thought I had "uninstalled" several modules by disabling them via Administer -> Site Building -> Modules -> List and deleting their files. So, there may be (database?) leftovers from past modules that are causing problems now. I don't know how to check for this condition. I assume the fix would be to install the modules again and uninstall them properly (?).
David
Quoting David Christensen dpchrist@holgerdanske.com:
Earnie Boyd wrote:
What steps did you did b4 the update.php?
Thank you for replying. :-)
The short answer is, "I follow UPGRADE.txt as best I can".
Unfortunately, step 6 is vague:
Remove all old files and directories from the Drupal installation directory.
I satisfy that by never overwriting the older package with the new; I always setup a fresh new directory but copy the settings.php files I need from old to new. Run update.php only on the Drupal core first. Add the modules I need and execute update.php for the modules. This method will always deactivate any modules since they do not exist for the first update; Drupal core is smart enough to deactivate them for you.
I've never been certain as to which files and directories to remove. So when I've tried to follow the procedure to the letter, I've had to guess. :-O
I've run into issues both when attempting to upgrade/ update (broken site, locked out, operator error, etc.) and also when recovering from a failed upgrade/ update (notably restoring database images taken when Drupal was in offline mode). So, I've made adjustments to the procedure both to improve my chances of success and to simplify recovery should I fail:
- Steps 1, 2, 3, and 14 -- I login with user ID 1 (step 2), take the
site off-line by adding the following lines to .htaccess (instead of step 3):
Order Allow,Deny Allow from 127.0.0.1/255.0.0.0 Allow from w.x.y.z/255.255.255.255take backup/ archive images (files and database) (step 1), upgrade/ update per steps 4-13, take another set of backup/ archive images, and put the site online by commenting out the above lines (instead of step 14).
- Steps 6 and 7 -- my Apache DocumentRoot is a symbolic link which
points to my current Drupal installation directory. Rather than hacking up my old Drupal installation directory, I unpack the Drupal 6.13 tarball into a new Drupal installation directory, add the above lines to .htaccess, and change the symbolic link.
I use symlinks as well. My directory structure is /opt/drupal/drupal5/drupal-5.1, /opt/drupal/drupal6/drupal-6.1, etc. I also move the first instance of the sites directory to /opt/drupal/drupal[56] and symlink the sites directory, e.g. ln -s /opt/drupal/drupal6/sites /opt/drupal/drupal6/drupal-6.1/sites. This way upgrading each release of drupal6 becomes easier.
The difference here is that I don't modify .htaccess as you have. But that could be a requirement of your environment.
The modified procedure seems to have worked for minor revision upgrades/ updates (e.g. 5.x -> 5.19).
I only recently read about uninstalling Drupal modules via the UI. In the past, I thought I had "uninstalled" several modules by disabling them via Administer -> Site Building -> Modules -> List and deleting their files. So, there may be (database?) leftovers from past modules that are causing problems now. I don't know how to check for this condition. I assume the fix would be to install the modules again and uninstall them properly (?).
Well I would make sure to follow each modules instructions. Certainly deleting files that have been uploaded or needed for the site to work isn't desirable. I remember that I had an issue the first time I tried to update from 5 to 6. But then I decided to, first upgrade to the latest 5.x version. Upgrade to version 6 without contrib modules installed. Then install contrib modules and upgrade. These actions produced a working application. I don't remember if I noticed any errors from the update.php but it seems maybe there were some for a few modules.
You need to upgrade to the latest version of 5.x because the updates are not carried from version 5 to version 6. Perhaps that is the step you need to take.
-- Earnie -- http://r-feed.com/ -- http://for-my-kids.com/ -- http://www.4offer.biz/ -- http://give-me-an-offer.com/
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
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@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of David Christensen Sent: Tuesday, September 15, 2009 10:51 AM To: support@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/ ]
Metzler, David wrote:
The answer is probably not, but you won't find out for sure until you test.
Thank you for your reply. :-)
Unfortunately, it looks like Drupal regression testing is not stable yet:
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.
...
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. ... [Y]ou 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.
1. I'd call that a bug.
2. A Drupal user shouldn't have to deal with issues at that level.
Oh, well. I can't complain because I got what I paid for ($0).
David
drupal:
I fought my way through the upgrade from Drupal 5.19 to 5.20, to 6.14, yesterday:
1. Re-install all previously-installed modules and then uninstall them via Drupal interface.
2. Upgrade from Drupal 5.19 to 5.20 -- no errors or warnings; site seemed okay.
3. Upgrade from Drupal 5.20 to 6.14, study errors and warnings, restore back to Drupal 5.20, verify, and then use mysql client to drop problematic tables:
cache_block cache_form menu_router menu_links menu_custom upload actions_old_contrib actions_aid search_node_links
4. Upgrade to Drupal 6.14 -- no errors or warnings; site seems okay:
I'm going to wait a while before I attempt steps 3 and 4 on my other Drupal 5.x site.
HTH,
David
Quoting David Christensen dpchrist@holgerdanske.com:
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
If the site is working, no do not worry about them. These appear to have been executed because the system table didn't have the correct schema versions or because there is a bug in how hook_update_N is written. I do not know why your update.php tried to update tables that had already been updated.
-- Earnie -- http://r-feed.com/ -- http://for-my-kids.com/ -- http://www.4offer.biz/ -- http://give-me-an-offer.com/
-
David Christensen -
Earnie Boyd -
Metzler, David