In my D6 I've turned off every module. I set the default theme to garland, I have site under maintenence - then i create a database dump of that. In my copy of the live database i now clean out alla caches and blocks.
In another folder, I have my d7 - it connect this to the database-copy of my d6 that I've made and start the upgrade.
186 pending updates
system module7000 - Rename blog and forum permissions to be consistent with other content types.
7001 - Generate a cron key and save it in the variables table.
7002 - Add a table to store blocked IP addresses.
7003 - Update {blocked_ips} with valid IP addresses from {access}.
7004 - Remove hardcoded numeric deltas from all blocks in core.
7005 - Remove throttle columns and variables.
7007 - Convert to new method of storing permissions.
7009 - Rename the variable for primary links.
7011 - Split the 'bypass node access' permission from 'administer nodes'.
7013 - Convert default time zone offset to default time zone name.
7015 - Change the user logout path.
7016 - Remove custom datatype _unsigned in PostgreSQL.
7017 - Change the theme setting 'toggle_node_info' into a per content type variable.
7018 - Shorten the {system}.type column and modify indexes.
7020 - Enable field and field_ui modules.
7021 - Change the PHP for settings permission.
7027 - Enable field type modules.
7029 - Add new 'view own unpublished content' permission for authenticated users. Preserves legacy behavior from Drupal 6.x.
7032 - Alter field hostname to identifier in the {flood} table.
7033 - Move CACHE_AGGRESSIVE to CACHE_NORMAL.
7034 - Migrate the file path settings and create the new {file_managed} table.
7036 - Split the 'access site in maintenance mode' permission from 'administer site configuration'.
7042 - Upgrade the {url_alias} table and create a cache bin for path aliases.
7044 - Drop the actions_aid table.
7045 - Add expiration field to the {flood} table.
7046 - Switch from the Minnelli theme if it is the default or admin theme.
7047 - Normalize the front page path variable.
7048 - Convert path languages from the empty string to LANGUAGE_NONE.
7049 - Rename 'Default' profile to 'Standard.'
7050 - Change {batch}.id column from serial to regular int.
7051 - make the IP field IPv6 compatible
7052 - Rename file to include_file in {menu_router} table.
7053 - Upgrade standard blocks and menus.
7054 - Remove {cache_}.headers columns.
7055 - Converts fields that store serialized variables from text to blob.
7057 - Increase the size of session-ids.
7058 - Remove cron semaphore variable.
7059 - Create the {file_usage} table.
7060 - Create fields in preparation for migrating upload.module to file.module.
7061 - Migrate upload.module data to the newly created file field.
7062 - Replace 'system_list' index with 'bootstrap' index on {system}.
7063 - Delete {menu_links} records for 'type' => MENU_CALLBACK which would not appear in a fresh install.
7064 - Remove block_callback field from {menu_router}.
7065 - Remove the default value for sid.
7066 - Migrate the 'file_directory_temp' variable.
7067 - Grant administrators permission to view the administration theme.
7068 - Update {url_alias}.language description.
7069 - Remove the obsolete 'site_offline' variable. @see update_fix_d7_requirements()
7070 - Remove the obsolete 'drupal_badge_color' and 'drupal_badge_size' variables.
7071 - Add index missed during upgrade, and fix field default.
7072 - Remove the obsolete 'site_offline_message' variable. @see update_fix_d7_requirements()
7073 - Add binary to {file_managed}, in case system_update_7034() was run without it.
7074 - This update has been removed and will not run.
7076 - Convert menu_links query strings into arrays.
7077 - Revert {file_managed}.filename changed to a binary column.fivestar module
7201 - Fixes the axis value stored for fivestar fields
7202 - Moves the field settings to field instance settings
7203 - Convert all existing fivestarnode_type settings into fields with exposed fivestar formatters
7204 - Preserve settings from fivestar_formatter_exposed_stars and convert to fivestar_formatter_default.
7205 - Rename fivestar 'select' widget to 'fivestar_select' @see http:drupal.orgnode1285456aggregator module
7000 - Add hash column to aggregator_feed table.
7001 - Add aggregator teaser length to settings from old global default teaser length
7002 - Add queued timestamp.
7003 - Increase the length of {aggregator_feed}.url.amazon module
7100 - Fix messed up type for currency code in update 6012.
7102 - Amazon has stopped providing customer review data; now we only get an iframe link where Amazon will provide the data, so we need to drop the table that was used for customer reviews and add the new iframe link.
7103 - Increase the length of the mpn field.
7104 - Move module config into Web Services section.amazon_media module
7002 - Set the weight on amazon_media to be higher than amazon. This allows amazon_media to override theme settings that amazon has done.
7003 - Update the "edition" field to a varchar since it can be many things provided by amazon.
7004 - Remove the Theatrical Release Date as Amazon no longer supports it.
7005 - Amazon seems not to require or always provide EAN.asin module
7000 - Fix the formatter machine names for asin field displays.
captcha module
7000 - Migrate form configuration for changed form ids in Drupal 7.
color module
7001 - Warn site administrator if unsafe CSS color codes are found in the database.
comment module
7000 - Rename comment display setting variables.
7001 - Change comment status from published being 0 to being 1
7002 - Rename {comments} table to {comment} and upgrade it.
7003 - Split {comment}.timestamp into 'created' and 'changed', improve indexing on {comment}.
7004 - Upgrade the {node_comment_statistics} table.
7005 - Create the comment_body field.
7006 - Migrate data from the comment field to field storage.
7007 - Add an index to the created column.
7008 - Update database to match Drupal 7 schema.
7009 - Change the last_comment_timestamp column description.contact module
7000 - Rename the threshold limit variable.
7001 - Rename the administer contact forms permission.
7002 - Enable the 'access user contact forms' for registered users by default.
7003 - Change the weight column to normal int.dblog module
7001 - Update the {watchdog} table.
faq module
7000 - Make'detailed_question' column nullable.
7001 - Delete obsolete variables.libraries module
7200 - Create the 'cache_libraries' table.
menu module
7000 - Migrate the "Default menu for content" setting to individual node types.
7001 - Rename "Primary Links" and "Secondary Links" to their Drupal 7 equivalents.
7002 - Rename the primarysecondary menu blocks to match previously renamed menus.
7003 - Add missing custom menus to active menus list.profile module
7001 - Rename {profile_fields} table to {profile_field} and {profile_values} to {profile_value}.
7002 - Change the weight column to normal int.search module
7000 - Replace unique keys in 'search_dataset' and 'search_index' by primary keys.
statistics module
7000 - Update the {accesslog}.sid column to match the length of {sessions}.sid
taxonomy module
7001 - Rename taxonomy tables.
7002 - Add {vocabulary}.machine_name column.
7003 - Remove the related terms setting from vocabularies. This setting has not been used since Drupal 6. The {taxonomy_relations} table itself is retained to allow for data to be upgraded.
7004 - Move taxonomy vocabulary associations for nodes to fields and field instances.
7005 - Migrate {taxonomy_term_node} table to field storage. @todo: This function can possibly be made much faster by wrapping a transaction around all the inserts.
7006 - Add {taxonomy_term_data}.format column.
7007 - Add index on {taxonomy_term_data}.name column to speed up taxonomy_get_term_by_name().
7008 - Change the weight columns to normal int.
7009 - Change {taxonomy_term_data}.format into varchar.
7010 - Change {taxonomy_index}.created to support signed int.text module
7000 - Change text field 'format' columns into varchar.
tracker module
7000 - Create new tracker_node and tracker_user tables.
update module
7000 - Create a queue to store tasks for requests to fetch available update data.
7001 - Recreates cache_update table. Converts fields that hold serialized variables from text to blob. Removes 'headers' column.video module
7201 - Update the video convertor to Zencoder.
7202 - Alter video_queue table to add video duration.
7203 - Alter video_queue table to add video duration.
7204 - Alter video_queue table to rename nid to entity_id and add entity_type.
7205 - Fix problems with Ogg and WebM videos. Change videos with file type audioogg to videoogg Change .webm videos from applicationoctet-stream to videowebm If using FFmpeg, update all presets to use ogv as extension instead of ogg.
7206 - Remove zencoder_username and agree_terms_zencoder variables.
7207 - Remove old video_thumbnails table and create a new one.
7208 - Add index on video_output.original_fid
7209 - Renames some variables. Renames variable video_metadata_path to video_ffmpeg_flvtool2_path video_metadata_dimensions to video_dimensions.
7210 - Scheduling variables and schema update. Renames variable video_queue_timeout to video_transcode_timeout, dividing by 60. The minimum value of this variable is set to 5. Sets video_queue_timeout to 60 minutes. Adds a field to video_queue to save the last time the status was updated. Sets this field to the current time for all videos.votingapi module
7201 - Renaming the 'content_type' and 'content_id' columns to entity_type and entity_id. Reduces confusion about 'content types' versus 'node types'.
7202 - Queue orphaned votes for deletion (nodes and comments)
7203 - Fix default values for entity_type columnscommunity_tags module
6002 - Update: convert vids used in CT settings to vocabulary machine names.
forum module
7000 - Add new index to forum table.
7001 - Create new {forum_index} table.
7002 - Add new index to forum_index table.
7003 - Rename field to 'taxonomy_forums'.
7011 - Update {forum_index} so that only published nodes are indexed.
7012 - Add 'created' and 'last_comment_timestamp' indexes.views module
7000 - Rename some system variables.
7001 - Fix missing items from Views administrative breadcrumb
7300 - Make sure the human_name field is added to the views_view table. If you updated from 6.x-2.x-dev to 7.x-3.x you already had schema version 6014, so update 6013 never was nor will be run. As a result, the human_name field is missing from the database. This will add the human_name field if it doesn't already exist.
7301 - Enlarge the name columnblock module
7000 - Set system.weight to a low value for block module. Block should go first so that other modules can alter its output during hook_page_alter(). Almost everything on the page is a block, so before block module runs, there will not be much to alter.
7002 - Rename {blocks} table to {block}, {blocks_roles} to {block_role} and {boxes} to {block_custom}.
7003 - Change the weight column to normal int.
7004 - Add new blocks to new regions, migrate custom variables to blocks.
7005 - Update the {block_custom}.format column.
7006 - Recreates cache_block table. Converts fields that hold serialized variables from text to blob. Removes 'headers' column.
7007 - Change {block_custom}.format into varchar.
7008 - Update database to match Drupal 7 schema.filter module
7000 - Upgrade the {filter_formats} table and rename it to {filter_format}.
7001 - Break out "escape HTML filter" option to its own filter.
7003 - Upgrade the {filter} table for core filters.
7005 - Integrate text formats with the user permissions system. This function converts text format role assignments to use the new text format permissions introduced in Drupal 7, creates a fallback (plain text) format that is available to all users, and explicitly sets the text format in cases that used to rely on a single site-wide default.
7008 - Grant usage of all text formats to user roles having the 'administer filters' permission.
7009 - Converts fields that store serialized variables from text to blob.
7010 - Change {filter_format}.format and {filter}.format into varchar.node module
7000 - Upgrade the node type table and fix node type 'module' attribute to avoid name-space conflicts.
7001 - Rename {node_revisions} table to {node_revision}.
7002 - Extend the node_promote_status index to include all fields required for the node page query.
7003 - Remove the node_counter if the statistics module is uninstalled.
7004 - Extend the existing default preview and teaser settings to all node types.
7005 - Add statuscommentpromote and sticky columns to the {node_revision} table.
7006 - Convert body and teaser from node properties to fields, and migrate statuscommentpromote and sticky columns to the {node_revision} table.
7007 - Remove column min_word_count.
7008 - Split the 'administer nodes' permission from 'access content overview'.
7009 - Convert node languages from the empty string to LANGUAGE_NONE.
7010 - Add the {block_node_type} table.
7011 - Update the database from Drupal 6 to match the schema.
7012 - Switches body fields to untranslatable while upgrading from D6 and makes them language neutral.
7013 - Change {node}.vid default value from 0 to NULL to avoid deadlock issues on MySQL.user module
7000 - Increase the length of the password field to accommodate better hashes. Also re-hashes all current passwords to improve security. This may be a lengthy process, and is performed batch-wise.
7001 - Remove the 'threshold', 'mode' and 'sort' columns from the {users} table. These fields were previously used to store per-user comment settings.
7002 - Convert user time zones from time zone offsets to time zone names.
7003 - Update user settings for cancelling user accounts. Prior to 7.x, users were not able to cancel their accounts. When administrators deleted an account, all contents were assigned to uid 0, which is the same as the 'user_cancel_reassign' method now.
7005 - Changes the users table to allow longer e-mail addresses.
7006 - Add module data to {role_permission}.
7007 - Add a weight column to user roles.
7008 - If 'user_register' variable was unset in Drupal 6, set it to be the same as the Drupal 6 default setting.
7009 - Converts fields that store serialized variables from text to blob.
7010 - Update the {user}.signature_format column.
7011 - Placeholder function. As a fix for user_update_7011() not updating email templates to use the new tokens, user_update_7017() now targets email templates of Drupal 6 sites and already upgraded sites.
7012 - Add the user's pictures to the {file_managed} table and make them managed files.
7013 - Add user module file usage entries.
7014 - Rename the 'post comments without approval' permission. In Drupal 7, this permission has been renamed to 'skip comment approval'.
7015 - Change {users}.signature_format into varchar.
7016 - Update the database to match the schema.
7017 - Update email templates to use new tokens. This function upgrades customized email templates from the old !token format to the new core tokens format. Additionally, in Drupal 7 we no longer e-mail plain text passwords to users, and there is no token for a plain text password in the new token system. Therefore, it also modifies any saved templates using the old '!password' token such that the token is removed, and displays a warning to users that they may need to go and modify the wording of their templates.
7018 - Ensure there is an index on {users}.picture.
The upgrade takes a sweet long time, roughly 20 minutes are spent on "updating the user module" alone as I have 80,000 users, and it fails. Every. Time.
These are the fail messages.
The following updates returned messages
user module
Update #7000User passwords rehashed to improve security
Update #7002
Migrated user time zones
Update #7014
Renamed the 'post comments without approval' permission to 'skip comment approval'.
Update #7017
The ability to send users their passwords in plain text has been removed in Drupal 7. Your existing email templates have been modified to remove it. You should review these templates to make sure they read properly.
forum module
Update #7000Failed: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'copy.forum' doesn't exist: SHOW INDEX FROM {forum} WHERE key_name = 'nid'; Array ( ) in db_drop_index() (line 2924 of /opt/bitnami/apps/drupal/htdocs/d7/includes/database/database.inc).
taxonomy module
Update #7005Failed: PDOException: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'created' at row 1: INSERT INTO {taxonomy_index} (nid, tid, sticky, created) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3); Array ( [:db_insert_placeholder_0] => 144380 [:db_insert_placeholder_1] => 51 [:db_insert_placeholder_2] => 0 [:db_insert_placeholder_3] => -365281200 ) in taxonomy_update_7005() (line 765 of /opt/bitnami/apps/drupal/htdocs/d7/modules/taxonomy/taxonomy.install).
comment module
Update #7002Failed: DatabaseSchemaObjectExistsException: Cannot add index last_comment_uid to table node_comment_statistics: index already exists. in DatabaseSchema_mysql->addIndex() (line 437 of /opt/bitnami/apps/drupal/htdocs/d7/includes/database/mysql/schema.inc).
system module
Update #7007Inserted into {role_permission} the permissions for role ID 1, Inserted into {role_permission} the permissions for role ID 2, Inserted into {role_permission} the permissions for role ID 4, Inserted into {role_permission} the permissions for role ID 8
Update #7061
Failed: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'public://alexwhite.jpg' for key 'uri': INSERT INTO {file_managed} (fid, uid, filename, uri, filemime, filesize, status, timestamp) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7); Array ( [:db_insert_placeholder_0] => 710 [:db_insert_placeholder_1] => 1 [:db_insert_placeholder_2] => alexwhite.jpg [:db_insert_placeholder_3] => public://alexwhite.jpg [:db_insert_placeholder_4] => image/jpeg [:db_insert_placeholder_5] => 95971 [:db_insert_placeholder_6] => 1 [:db_insert_placeholder_7] => 0 ) in system_update_7061() (line 2842 of /opt/bitnami/apps/drupal/htdocs/d7/modules/system/system.install).
video module
Update #72011
Update #7202
Failed: DatabaseSchemaObjectDoesNotExistException: Cannot add field video_queue.duration: table doesn't exist. in DatabaseSchema_mysql->addField() (line 325 of /opt/bitnami/apps/drupal/htdocs/d7/includes/database/mysql/schema.inc).
fivestar module
Update #7203Failed: FieldException: Attempt to create a field of unknown type fivestar. in field_create_field() (line 110 of /opt/bitnami/apps/drupal/htdocs/d7/modules/field/field.crud.inc).
amazon_media module
Update #7003Changed amazon_book 'edition' to a varchar
amazon module
Update #7100Updated currency code column types
Update #7102
Updated support for customer reviews
votingapi module
Update #7201Updated VotingAPI table structure.
faq module
Update #7000Detailed question field can now be null.
Update #7001
Deleted obsolete variables.
I know that video can be fixed by uninstalling the module, and then re-installing it, but what can I do about the system module fail? Has anyone been able to upgrade a D6 to D7 ?
I've been on Drupal since 4.7 and have never experienced an upgrade that fails as badly as this one does.
